How to add an entry to TNSNAMES.ORA?
Date: Wed, 5 Nov 2008 04:35:33 -0800 (PST)
Message-ID: <1652e95d-33c9-4eca-a9b4-b4fb366ce215@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 - 06:35:33 CST