-
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 8.1.6.0.0 - Production on Mon Jan 6 20:06:18 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process
Enter user-name:
Thanks in advance
Sridhar
-
I have seen this error when there are resource (memory) issues on the server.
Jeff Hunter
-
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?
Agasimani
OCP(10g/9i/8i/8)
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|