Re: How to add an entry to TNSNAMES.ORA?
From: Palooka <nobody_at_nowhere.com>
Date: Wed, 05 Nov 2008 21:48:33 +0000
Message-ID: <RwoQk.179498$AO4.51558@newsfe16.ams2>
>
> 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.
>
>
> 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.
>
>
>
> David Fitzjarrell
Date: Wed, 05 Nov 2008 21:48:33 +0000
Message-ID: <RwoQk.179498$AO4.51558@newsfe16.ams2>
ddf wrote:
> 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
As ddf said. By the way, on my Linux system the file in /etc/init.d is dboraz. Not that I ever use it. What on earth is wrong with having custom scripts to start your listeners, instances and whatever else you need?
Palooka Received on Wed Nov 05 2008 - 15:48:33 CST