Connection-Problems with Pro*C - Need Help
From: oks <oks_at_oks.s.eunet.de>
Date: 1997/05/10
Message-ID: <3374AB6B.725A_at_oks.s.eunet.de>#1/1
Fatal OSN connect error 12203, connecting to:
Production
Time: 10-MAY-97 09:57:38
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination ns main err code: 12538
TNS-12538: TNS:no such protocol adapter ns secondary err code: 12560
nt main err code: 508
TNS-00508: No such protocol adapter
nt secondary err code: 0
nt OS err code: 0 Received on Sat May 10 1997 - 00:00:00 CEST
Date: 1997/05/10
Message-ID: <3374AB6B.725A_at_oks.s.eunet.de>#1/1
Hey,
we are programming Pro*C on Oracle Workgroup Server with SQL*NET 2.x. But the simplest connection would not successful. We connect with EXEC SQL CONNECT :uid; uid was "username/password_at_dbname" via SQL*NET 2.x. Our tnsnames.ora have the correct entries, because tnsping dbname give correct results. We do not understand what we are doing wrong. At the bottom we have appended sqlnet.log. Please mail me your informations !
Thanks a lot
Oliver
sqlnet.log says:
Fatal OSN connect error 12203, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SID=WG73)(CID=(PROGRAM=)(HOST=okssun)(USE R=oracle7)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=okssun_tcp_WG73))(A DDRESS=(PROTOCOL=TCP)(HOST=okssun)(PORT=1521))))
VERSION INFORMATION:
TNS for Solaris: Version 2.3.2.1.0 - Production Unix Domain Socket IPC NT Protocol Adaptor for Solaris: Version2.3.2.1.0 -
Production
Time: 10-MAY-97 09:57:38
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination ns main err code: 12538
TNS-12538: TNS:no such protocol adapter ns secondary err code: 12560
nt main err code: 508
TNS-00508: No such protocol adapter
nt secondary err code: 0
nt OS err code: 0 Received on Sat May 10 1997 - 00:00:00 CEST