ORA-12560 when testing connection in Net8 Assistant

From: Michael Helmich <michael.helmich_at_entory.com>
Date: 16 Jan 2003 06:48:31 -0800
Message-ID: <6dbfc615.0301160648.7eddccf8@posting.google.com>

Hi there!

I'm trying to create a database connection with the Net8 Assistant between an NT4 Oracle client 8.1.6.0 and an ORACLE 8.1.6 Server DB under SUN Solaris. When testing the connection I get the the ORACLE error ORA-12560.

I have verified the following facts:
- the database on the server is active and can be reached from other
clients
- entries in tnsnames.ora are the same as on a working client

• the server can be pinged from the client
• tnsping also gets error ORA-12560

sqlnet.log contains the following entries:

---

Fatal NI connect error 12560, connecting to:  (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.30.11.173)(PORT=1521))(CONNECT_DATA=(SID=RPMS)(CID=(PROGRAM=C:\Programme\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=KBZ00W015)(USER=mi_he))))

  VERSION INFORMATION:

	TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
	Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version

8.1.6.0.0 - Production
  Time: 16-JAN-2003 15:01:59
  Tracing to file: D:\Oracle\Ora81\network\tools\cli.trc   Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS: Protokolladapterfehler     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protokolladapter-Fehler
    nt secondary err code: 50
    nt OS err code: 0

---

Fatal NI connect error 12560, connecting to:  (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Programme\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=KBZ00W015)(USER=mi_he))))

  VERSION INFORMATION:

	TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version

8.1.6.0.0 - Production
  Time: 16-JAN-2003 15:01:59
  Tracing to file: D:\Oracle\Ora81\network\tools\cli.trc   Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS: Protokolladapterfehler     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protokolladapter-Fehler
    nt secondary err code: 126
    nt OS err code: 0

The first entry (with HOST=172.30.11.173) has my connection parameters, I don't know where the second comes from. The client trace I produced seems to contain only the data for the second connection and is therefor not included here.

Does anyone have an idea what is going wrong here?

Thank you
Michael Helmich Received on Thu Jan 16 2003 - 08:48:31 CST