Re: HELP, OpenVMS, TNS-12545 error

From: <gtran_at_karavela.com>
Date: 6 Feb 1999 08:29:05 -0600
Message-ID: <36bc4f46.90118393@news2.newscene.com>

> I had a problem similar to this which turned out to be the use
>of logical names in file specifications ( like your "DISK2:" reference
>below ). Oracle recommended changing all parameter file entries to
>contain a physical disk name instead. This fixed the problem.

I changed all the logical names to physical names but no success. I think that most important are the lines below which are from LISTENER.TRC trace file. I only need real explanation for line with "Validnode Table IN use" error.

(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=TCP)(Host=192.168.16.66)(port=1521))) port resolved to 1521
using host IP address: 192.168.16.66
opening transport...
No PROTOCOL.ORA file is found

Validnode Table IN use; err 0x0     <<<<<<<<<<<<<<<<<<<<<

-<ERROR>-
soc -1 error - operation=3, ntresnt[0]=515, ntresnt[1]=49, ntresnt[2]=5
-<ERROR>-
nsres: id=0, op=65, ns=12545, ns2=12560; nt[0]=515, nt[1]=49, nt[2]=5 -<ERROR>-
unable to open transport
Deallocating cxd 0x28cd70.
-<ERROR>-
Reporting the following error stack:
TNS-12545: Connect failed because target host or object does not exist  TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist

   VMS Error: 5: i/o error

In CONFIG.ORA file from <Oracle7.Netconfig> directory there is line with VALIDNODE parameter:

REM
SQLNET SIDMAP TKK8 = DKA200:[ORACLE7.DB_TKK8]ORAUSER_TKK8 REM
SQLNET SIDMAPDFLT = TKK8
REM

SQLNET VALIDNODE = *     <<<<<<<<<<<<<<<<<<<<<

REM
SQLNET USERNAMEMAP * = *
REM
SQLNET TCPSRV_MAXCON = 128
SQLNET ORASRV_PROXY_LOGIN = YES Thank you for being patient.

gt Received on Sat Feb 06 1999 - 08:29:05 CST