Home » RDBMS Server » Server Administration » Ora-12540 : TNS:internal limit restriction exceeded
Ora-12540 : TNS:internal limit restriction exceeded [message #218854] Sun, 11 February 2007 10:37 Go to next message
clioteux
Messages: 5
Registered: February 2007
Location: algiers
Junior Member

Hi,
please help;

I created a new user identified by the OS using the following SQL command :
Create user xxx identified externally ... ;
Grant connect,resource to xxx;

The user exits in the OS level;

I logged into the OS by using the xxx user; when i tried to connect to the DB by using : Connect /, i've got the error message : Ora-12540 : TNS:internal limit restriction exceeded.

I modified the user authentification method as bellow :
Alter user xxx identified by yyy;

In this time, the "Connect xxx/yyy" was successful (user connected);

Help!!!
Re: Ora-12540 : TNS:internal limit restriction exceeded [message #218857 is a reply to message #218854] Sun, 11 February 2007 11:06 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Help!!!
We (TINW) don't know:
1) OS name or version
2) Oracle version to 4 decimal places.

We do know:
12540, 00000, "TNS:internal limit restriction exceeded"
// *Cause: Too many TNS connections open simultaneously.
// *Action: Wait for connections to close and re-try.
Re: Ora-12540 : TNS:internal limit restriction exceeded [message #218858 is a reply to message #218854] Sun, 11 February 2007 11:09 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
Try below procedure.
SQL> select profile from dba_users where username = 'SCOTT';

PROFILE
------------------------------
DEFAULT

#first know which profile is assign to users through above query.

SQL> alter profile default
  2  limit SESSIONS_PER_USER  10;

Profile altered.

alter SESSION_PER_USER limit through above command.
and try to connect.


regards
Taj
Previous Topic: Query Performance
Next Topic: Intelligent agent on 9i HP-UX
Goto Forum:
  


Current Time: Sat Dec 10 13:01:34 CST 2016

Total time taken to generate the page: 0.13012 seconds