How to add an entry to TNSNAMES.ORA?

From: A. Farber <>
Date: Wed, 5 Nov 2008 04:35:33 -0800 (PST)
Message-ID: <>


if I add the following entry to the TNSNAMES.ORA:

test1_10.121.34.56 =
(SID = test1)


how could I activate it please without rebooting.

I'm using Oracle 9i Release 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 - 06:35:33 CST

Original text of this message