Connecting to oracle
The following message is diaplayed when i am connecting to Oracle on Sun Solaris 5.8 , Oracle 8.1.6 .
It connects sometimes and when you come out and try again it displays the same error message shown below.
The Oracle env variables like ORACLE_HOME , TNS_ADMIN , NLS_LANG etc... have been set before.
Can somebody tell me why it is behaving like this.
[eco4]-/u01/oracle/product/8.1.6/network/admin> sqlplus dd/dd
SQL*Plus: Release 126.96.36.199.0 - Production on Mon Jan 6 20:06:18 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
ORA-12500: TNS:listener failed to start a dedicated server process
Thanks in advance
I have seen this error when there are resource (memory) issues on the server.
Your server may have been set as 'shared process' but your client tries to use (SERVER = DEDICATED) in tnsnames.ora.
Did you try restarting the listener?
This can be seen if there is a resource issue (as someone else has said) I've check the number of sessions in v$session as it sounds like oracle cant get the resources it needs for the session. Have a search for TNS-12500 on metalink.
I believe it is a bug in 8.1.6. If you set database in dedicated server rather than MTS, the problem disappear.
Click Here to Expand Forum to Full Width