Home » RDBMS Server » Server Administration » TNS error
TNS error [message #55284] Wed, 15 January 2003 12:54 Go to next message
Mento
Messages: 6
Registered: January 2003
Junior Member
Hello,
I have been struggling with this TNS error and can't seem to figure out how to fix it. I have an Oracle 8i Database on my laptop and when trying to connect to it through sql plus, I get this error:
ORA-12500: TNS:listener failed to start a dedicated server process
So when I go to lsnrctl>services I get:
Services Summary...
testdb1 has 1 service handler(s)
DEDICATED SERVER established:0 refused:1

If anyone has any ideas of what I can do to fix this, I appreciate it
thanks,
Steve
Re: TNS error [message #55286 is a reply to message #55284] Wed, 15 January 2003 13:09 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try to increase
the value of processes in your init< sid >.ora
and
also try to kill unwanted process that are running in machine.
if both of these are not helping, we need to look inot OTRACE.
Previous Topic: What Port does ORACLE 9i database use?
Next Topic: Online redolog file lost
Goto Forum:
  


Current Time: Fri Sep 20 03:49:57 CDT 2024