Oracle connection only once

From: Andreas Boehm <andreas_at_andiboehm.de>
Date: Tue, 11 Apr 2006 09:16:47 +0200
Message-ID: <443B57DF.9080003@andiboehm.de>

Hi there,

I have an obscure problem.
I moved my oracle instance (8.1.7) from one subnet to another (changed on server tnsnames.ora, listener.ora, tnsnames on clients) and now only a few seconds after startup, sqlplus and other clients can connect. After some seconds, I get errors on client side, but tnsping reports no errors.

The error messages are :
client:
ORA-12545: Connect failed because target host or object does not exist

sqlnet.log (client):

Fatal NI connect error 12545, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=132.187.167.132)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBMSPEC)(CID=(PROGRAM=)(HOST=wviz036)(USER=sunny))))

VERSION INFORMATION:

         TNS for Linux: Version 9.2.0.1.0 - Production
         TCP/IP NT Protocol Adapter for Linux: Version 9.2.0.1.0 -

Production

   Time: 11-APR-2006 08:25:11
   Tracing not turned on.
   Tns error struct:

     nr err code: 0
     ns main err code: 12545
     TNS-12545: Connect failed because target host or object does not exist
     ns secondary err code: 12560
     nt main err code: 515
     TNS-00515: Connect failed because target host or object does not exist
     nt secondary err code: 2
     nt OS err code: 0


Server - oracle instance:
     no messages

Server - listener:
1-APR-2006 08:25:12 *
(CONNECT_DATA=(SERVICE_NAME=DBMSPEC)(CID=(PROGRAM=)(HOST=wviz036)(USER=sunny)))

(ADDRESS=(PROTOCOL=tcp)(HOST=132.187.167.36)(PORT=40563)) * establish
DBMSPEC * 0

Whats wrong and how can I fix it? BTW: we do not want to upgrade from this version, if there is a solution for the reported problem.

thanks in advance.

regards,
Andreas Received on Tue Apr 11 2006 - 02:16:47 CDT