Re: Oracle SQLPLUS and IP addressing ....

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 4 Nov 1999 12:31:09 +0100
Message-ID: <7vrqsh$8se$1@oceanite.cybercable.fr>

Look at your tnsnames.ora file (in $ORACLE_HOME/network/admin dir), you surely have something like:

dbname.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = <your host>)


          (Port = 1521)


        )

    )
    (CONNECT_DATA = (SID = <your SID>)
    )
  )

Is there any IP address in the Host key? If not, check the IP address in your /etc/hosts at the entry corresponding to the Host key of your tnsnames.ora file.

--
Regards
Michel

Dominic Cribbin <dominic.cribbin_at_cognotecSTOPSPAM.com> a écrit dans le message : 7vrl37$iii$1_at_ezekiel.eunet.ie...

> I have a DB on a SUN Solaris machine using UNIX, the other day I changed the
> IP Address of this machine. Before the change I had a script file that ran
> every night it contained a line like the following: sqlplus
> usrname/usrpasswd_at_dbname.  After I changed this script failed I got
> ORA-12535 : TNS - operation timed out.
>
> Test this line of code manually I noticed that I could connect to the
> database using : sqlplus usrname/usrpasswd. But when I used "@dbname" it
> just hangs until it times out.
>
> My question : is there any setting/file in Oracle that relies on IP
> addresses ... or can any one tell me why this error would occur in this
> situation ??
>
> To me it appears to be a listener problem ... I did not stop and start the
> DB when the IP address was changed, as UNIX does not require a system reboot
> for this but does ORACLE need to be restarted ????
>
> Thanks
>
>

Received on Thu Nov 04 1999 - 05:31:09 CST