RE: Question about database and service name

[Karniotis, Stephen]

Ramon:     Let me try these one at a time.   1.                   True.  To a client desktop or device, a database environment is presented as a service (flooky name).  The service is a TNS Service via Net8/Oracle*Net. 2.                  Using multiple service names within the tnsnames.ora file and multiplexing within the listener.ora file, a database can have multiple service names point to it.  This is common where application-specific code names are used as TNS Service Names.  This is also useful for failover whereas services are on different machines. 3.                  This one sounds like RAC or OPS where the database can be implemented as multiple services and a service is implemented as multiple instances.  In either case, a database instance can only represent one database at a time.  That is why service names must be unique within a specific server.     Hope this helps.   Thank You   Stephen P. Karniotis Product Architect Compuware Corporation Direct:                   (248) 865-4350 Mobile:                  (248) 408-2918 Email:                      [EMAIL PROTECTED] Web:                        www.compuware.com   -----Original Message----- From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: Question about database and service name   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   The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.