Question about database and service name

2002-09-05 Thread Ramon E. Estevez
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

Re: Question about database and service name

2002-09-05 Thread Paul Baumgartel
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]

Re: Question about database and service name

2002-09-05 Thread Reginald . W . Bailey
Mr. Estevez: The service names are defined in the init.ora using the service_names parameter. You can have several names separated by commas and white space to represent service names. The Listener can listen for a specific service name if you list it in the listener.ora file. Oracle8, 8i

RE: Question about database and service name

2002-09-05 Thread Karniotis, Stephen
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

Re: Question about database and service name

2002-09-05 Thread Jared . Still
: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

RE: Question about database and service name

2002-09-05 Thread Bob Metelsky
Couldn't this also be somealias_or_servicename1 eg mydb= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP) (HOST=dbserver.yourdomain.com_or_IPADDRESS) (PORT=1521_or_port_matching_in_listener.ora) ) )

Re: Question about database and service name

2002-09-05 Thread Ramon E. Estevez
Thanks a lot, Paul, Stephen, Reginald, Jared and Bob, for clearing my doubts, did the Jared's test and it worked, something new for me I will keep reading the FM, Tks Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday,