Re: How to add an entry to TNSNAMES.ORA?
Date: Wed, 5 Nov 2008 15:34:25 +0200
you dont need to reboot when you add any entry to the tnsnames.ora, just check tnsname via tnsping in the command promt
"A. Farber" <Alexander.Farber_at_gmail.com> wrote in message
> 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 220.127.116.11.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
Received on Wed Nov 05 2008 - 07:34:25 CST