Re: How to add an entry to TNSNAMES.ORA?
Date: Wed, 5 Nov 2008 15:34:25 +0200
Message-ID: <ges7db$onc$1@zcars129.ca.nortel.com>
you dont need to reboot when you add any entry to the tnsnames.ora,
just check tnsname via tnsping in the command promt
tnsping test1_10.121.34.56
"A. Farber" <Alexander.Farber_at_gmail.com> wrote in message
news:1652e95d-33c9-4eca-a9b4-b4fb366ce215_at_f40g2000pri.googlegroups.com...
> Hello,
>
> if I add the following entry to the TNSNAMES.ORA:
>
> test1_10.121.34.56 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.121.34.56)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = test1)
> (SERVER = DEDICATED)
> )
> )
>
> how could I activate it please without rebooting.
>
> I'm using Oracle 9i Release 9.2.0.8.0 at CentOS 4.7
> Linux machine (which is compatible to RHEL 4.7).
>
> Also I wonder what are the commands to startup
> and shutdown Oracle, the installation CD hasn't
> created the /etc/init.d/oracle script for some reason.
> Currently I have to "lsnrctl start" and then set ORACLE_SID
> and sqlplus as sysdba to startup every instance.
>
> Thank you
> Alex
Received on Wed Nov 05 2008 - 07:34:25 CST