Re: listener.ora, tnsnames.ora

From: Yong Huang <yong321_at_yahoo.com>
Date: 4 Mar 2002 10:56:15 -0800
Message-ID: <b3cb12d6.0203041056.6d9712b7@posting.google.com>

Or create a workstation-specific file called meonly.txt and COPY TNSNAMES.ORA+MEONLY.TXT MYTMP
DEL TNSNAMES.ORA
REN MYTMP TNSNAMES.ORA Or better
TYPE MEONLY.TXT >> TNSNAMES.ORA Or even better is to use IFILE directive in tnsnames.ora: IFILE=C:\MEONLY.TXT Yes, ifile works in tnsnames.ora and listener.ora, not just init.ora.

A minor correction to Sebastian's code: use %tnsnames% instead of $TNSNAMES under DOS.

Yong Huang

"Sebastian Rehm" <Sebastian.Rehm_at_de.bosch.com> wrote in message news:<a5vq6d$g6r$1_at_ns2.fe.internet.bosch.com>...
> For TNSNAMES.ORA
> you can use the ECHO command to add lines in the ASCII-File
>
> TNSNAMES=c:\orant\network\admin\tnsnames.ora
>
> echo #New Database Comment >>$TNSNAMES
> echo SEBASTIAN.world = >>$TNSNAMES
> echo (DESCRIPTION = >>$TNSNAMES
> echo (ADDRESS_LIST = (ADDRESS = (COMMUNITY =
> TCP.world)(PROTOCOL=TCP)(Host=151.1.3.102)(Port=1521))) >>$TNSNAMES
> echo (CONNECT_DATA = (SID=O10A))) >>$TNSNAMES
>
>
> Sebastian
Received on Mon Mar 04 2002 - 12:56:15 CST