How to add an entry to TNSNAMES.ORA?

From: A. Farber <Alexander.Farber_at_gmail.com>
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

Original text of this message