OraFAQ Forum: Server Administration » Ora-12540 : TNS:internal limit restriction exceeded

Home » RDBMS Server » Server Administration » Ora-12540 : TNS:internal limit restriction exceeded

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Ora-12540 : TNS:internal limit restriction exceeded [message #218854]

Sun, 11 February 2007 10:37

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

Report message to a moderator

Re: Ora-12540 : TNS:internal limit restriction exceeded [message #218857 is a reply to message #218854]

Sun, 11 February 2007 11:06

BlackSwan
Messages: 25578
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.

Report message to a moderator

Re: Ora-12540 : TNS:internal limit restriction exceeded [message #218858 is a reply to message #218854]

Sun, 11 February 2007 11:09

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

Report message to a moderator

Previous Topic:	Query Performance
Next Topic:	Question about Streams subset rules

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 22 00:40:39 CDT 2017

Total time taken to generate the page: 0.01452 seconds