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" <com.banilejas_at_codetel.net.do> 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
> com.banilejas_at_codetel.net.do
> 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: treegarden_at_yahoo.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).
Received on Thu Sep 05 2002 - 12:13:34 CDT
