'TNS-12540' ERROR WHEN RUNNING DATA EXTRACT VIEWS. (Doc ID 112116.1)

Last updated on FEBRUARY 04, 2011

Applies to:

Oracle Clinical - Version: 3.2 to 4.5.1 - Release: 3 to 4.5
Information in this document applies to any platform.
=================================
***Checked for relevance on 02-SEP-2009***
=================================
***Checked for relevance on 04-FEB-2011***
=================================

Symptoms

The following errors appear in the out file when running the Data Extract View
Creation job :

Build in study unions succeeded for account V_STUDY$CURRENT type CURRENT
ERR level 1
connect_as_user
Error connecting as /. SQL Error ORA-12540: TNS:internal limit restriction exceeded

ERROR: Cannot connect to ORACLE as user /.
SQLCODE=-12540.
Error using oracle_connect for RXC_MAA
ORA-12540: TNS:internal limit restriction exceeded

Error revoking connect from V_STUDY$CURRENT
ORA-12540: TNS:internal limit restriction exceeded

RXCDXBVB EXIT WITH FAILURE




The sqlnet.ora file contains :

Fatal NI connect error 12540, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u00/oracle/product/8.1.5/bin/oracle)(ARGV0=oracleclinprod)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=stellar)(USER=test))))


VERSION INFORMATION:
TNS for HPUX: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 8.1.5.0.0 -
Production
Time: 06-JUN-00 13:51:38
Tracing not turned on.
Tns error struct:
nr err code: 0
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms