You can easily create more than one service name for a database in TNSNAMES.ORA: just create different names with the same definition.
I'm aware that a service can consist of multiple databases, but I've never implemented it and am not sure how it's done. --- "Ramon E. Estevez" <[EMAIL PROTECTED]> wrote: > Hi list, > > Reading the OU manuals Oracle 9i DBA Fundamentals II , in chapter 2 > page 12, found > > 1-) An oracle database is represented to clients as a service. > > 2-) A database can have one or more services associated with it. > > 3-) A database can be presented as multiple services and a service > can be implemented as multiple database > instances. > > For the No. 2 : > I interpret that I can have 2 or 3 or 4 services for just ONE > DB. Is that correct ?. How can I do that ? > > For the No. 3: > I interpret that I can refer to the same DB with differents > names. > > As far as I understand, the DB instance name is unique, it can't be > changed. So how can I create several services names for one DB. > > Or is just a trick in the TNSNAMES.ORA and LISTENER.ORA files. > > Please can anyone give some light in that, I am totally confused !!! > > > Ramon E. Estevez > [EMAIL PROTECTED] > 809-565-3121 > > __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
