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

On Nov 5, 1:48 pm, Palooka <nob..._at_nowhere.com> wrote:
> 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

Maybe it is just me, but every version at least back to 7 I've found reason to toss dbstart/dbshut, or at least have to fix it (syntax error in 10.2.0.x on hp-ux, bogus [ -e command). Usually the problems revolve around hangs because of the default shutdown command, or a need to be able to differentiate between the entries in oratab. Agents sure don't help matters.

jg

--
@home.com is bogus.
"BLOCK HEADED TO SACRAMENTO WITH TODO LIST" - headline about winner of
California Assembly race, Marty Block.  They shoulda used Assembly
instead of Sacramento...