Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about database and service name

RE: Question about database and service name

From: Karniotis, Stephen <>
Date: Thu, 05 Sep 2002 10:35:11 -0800
Message-ID: <>



  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




-----Original Message-----
From: Ramon E. Estevez []
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   



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


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.

Please see the official ORACLE-L FAQ:
Author: Karniotis, Stephen

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: (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).
Received on Thu Sep 05 2002 - 13:35:11 CDT

Original text of this message