Connect Error
From: Satish Mali <satish_at_ltis.loral.com>
Date: 1995/11/30
Message-ID: <49kvp1$h3_at_frank.ltis.loral.com>#1/1
Fatal OSN connect error 12223, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/usr2/oracle/orahome/bin/oracle)( ARGV0=oracleemr)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETA CH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=kirk)(USER=emr))))
Time: 13-NOV-95 18:14:01
Tracing not turned on.
Tns error struct:
nr err code: 12223
TNS-12223: TNS:internal limit restriction exceeded ns main err code: 12540
TNS-12540: TNS:internal limit restriction exceeded ns secondary err code: 12560
nt main err code: 510
TNS-00510: Internal limit restriction exceeded nt secondary err code: 12
nt OS err code: 0
Date: 1995/11/30
Message-ID: <49kvp1$h3_at_frank.ltis.loral.com>#1/1
I am running
ORACLE V7.2.2.3.0 for Sun SPARC OS 4.1/4.1.4. Single use license.
I have a single program which cannot seem to connect to oracle. The connect string is "/" (automatic log on).
Running "sqlplus /", I'm able to connect.
If I strip out all the procedures except the routine that actually does the sql call, I'm also able to connect.
What internal limit is being exceeded? I'd appreciate any suggestions-- being new to oracle installation procedures.
The call generates the following sqlnet.log file:
Fatal OSN connect error 12223, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/usr2/oracle/orahome/bin/oracle)( ARGV0=oracleemr)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETA CH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=kirk)(USER=emr))))
VERSION INFORMATION:
TNS for SunOS: Version 2.2.2.0.0 - Production Oracle Bequeath NT Protocol Adapter for SunOS: Version 2.2.2.0.0 - Production
Time: 13-NOV-95 18:14:01
Tracing not turned on.
Tns error struct:
nr err code: 12223
TNS-12223: TNS:internal limit restriction exceeded ns main err code: 12540
TNS-12540: TNS:internal limit restriction exceeded ns secondary err code: 12560
nt main err code: 510
TNS-00510: Internal limit restriction exceeded nt secondary err code: 12
nt OS err code: 0
Erich Warkentine erich_at_ltis.loral.comReceived on Thu Nov 30 1995 - 00:00:00 CET