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

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 - Prod

uction
  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.com    

Received on Thu Nov 30 1995 - 00:00:00 CET