Oracle SQLPLUS and IP addressing ....

From: Dominic Cribbin <dominic.cribbin_at_cognotecSTOPSPAM.com>
Date: Thu, 4 Nov 1999 09:52:08 -0000
Message-ID: <7vrl37$iii$1@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 - 03:52:08 CST