Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS 2 names for 1 db
In article <h6og3t0mvmg9hudq550apv123tngkm2b99_at_4ax.com>,
AWizemann_at_fvvag.de wrote:
> Hi,
>
> can i have 2 "aliases" for one db without copying the full definition
> ?
>
> Normal i have the following definitions:
>
> APPL1PROD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(PORT = 1522)(HOST = 10.0.8.101))
> )
> (CONNECT_DATA =
> (SID = AP1P)
> )
> )
>
> Now i need to setup APPL2PROD which i would like to do in the same db
> as APPL1 but my clients need to be able to enter APPL2PROD as the
> alias.
> Andreas Wizemann
>
> E-Mail: AWizemann_at_fvvag.de
> Phone: +49 (0) 711 98889 835
> D2: +49 (0) 172 714 3105
> Fax: +49 (0) 711 98889 888
> Mail: Fahrlehrerversicherung VaG
> IT/RZ
> Mittlerer Pfad 5
> D-70499 Stuttgart
> Internet: http://www.fvvag.de
>
So you need to copy the full definition in your tnsnames.ora, only changing the service name. That's just the way it works.
Regards,
-- Sybrand Bakker, Oracle DBA All standard disclaimers apply ------------------------------------------------------------------------ Sent via Deja.com http://www.deja.com/Received on Thu Dec 14 2000 - 06:54:29 CST