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 :: Polls :: Message Navigator
E-mail to friend

ORA-12540 TNS:Internal Limit Restriction Exceeded [message #57363]

Mon, 09 June 2003 06:56

Andrew
Messages: 144
Registered: March 1999

Senior Member

I came across the following error when trying to establish a connection with my database: -

ORA-12540 TNS:Internal Limit Restriction Exceeded

On re-booting my PC all was ok.

Is it possible that 0040 caused the problem?

The reason I ask is beacause I have some Excel reports that connect to the DB using 0040 and after having the error I noticed that in parts of the code I didn't have

 Set objOraSession = Nothing

, plus the same for the Database or Dynaset.

Would the coonection still be in the memory even after closing Excel?

Regards,

Andrew

Report message to a moderator

Re: ORA-12540 TNS:Internal Limit Restriction Exceeded [message #57364 is a reply to message #57363]

Mon, 09 June 2003 08:15

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

usually it is an OS limitation.
have a look in the log files (sqlnet.log / listener.log etc).
if possible enable tracing for a detailed stack.

Report message to a moderator

Previous Topic:	Host Name
Next Topic:	calculation of storage space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 17:03:18 CST 2024