Re: Question about database and service name

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" <ORACLE-L_at_fatcity.com> Sent: Thursday, September 05, 2002 12:13 PM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

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).