Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: listener.ora, tnsnames.ora

Re: listener.ora, tnsnames.ora

From: Sebastian Rehm <Sebastian.Rehm_at_de.bosch.com>
Date: Mon, 4 Mar 2002 13:43:56 +0100
Message-ID: <a5vq6d$g6r$1@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

"Ivan Andonov" <iandonov_at_netscape.net> wrote in message news:55f9b64.0203040138.73e54d0b_at_posting.google.com...
> How can I add entries for new database in listener.ora and tnsname.ora
> with command line tool??
>
> I am building Installshield setup for database for Oracle 9.
> I can create instance with .bat file using ORADIM, and I can create
> the database with SQLPLUS scripts, but I cannot add entries in
> LISTENER.ORA and TNSNAMES.ORA
>
> Please HELP!!
>
> Thanks
> Ivan Andonov
Received on Mon Mar 04 2002 - 06:43:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US