RE: Question about database and service name

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:                      Stephen.Karniotis@Compuware.com

Web:                        www.compuware.com

 

-----Original Message-----
From: Ramon E. Estevez [mailto:com.banilejas@codetel.net.do]
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
com.banilejas@codetel.net.do
809-565-3121

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.com

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: ListGuru_at_fatcity.com (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).