Re: How to add an entry to TNSNAMES.ORA?

From: ddf <oratune_at_msn.com>
Date: Wed, 5 Nov 2008 07:33:52 -0800 (PST)
Message-ID: <f6f3df92-e40d-49fd-bf99-2a9f79d05791@o40g2000prn.googlegroups.com>


On Nov 5, 6:35 am, "A. Farber" <Alexander.Far..._at_gmail.com> wrote:
> 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.
>

You do not need to 'reboot' anytime you change the tnsnames.ora file, as the next 'call' for a networked database connection will read the updated file.

> 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.

Presuming you do have an oratab file you should be able to run dbstart to start all instances on your machine, and dbshut to stop them all. There are numerous examples of an Sxxoracle script oh the internet; use google.com to find one.

>
> Thank you
> Alex

David Fitzjarrell Received on Wed Nov 05 2008 - 09:33:52 CST

Original text of this message