Home » RDBMS Server » Server Administration » ORA-12500: TNS:listener failed to start a dedicated server [merged]
ORA-12500: TNS:listener failed to start a dedicated server [merged] [message #381894] Tue, 20 January 2009 04:16 Go to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
15:39:06 SQL> select global_name from global_name;

GLOBAL_NAME
-------------------------------------------------------
SRIRAM


15:39:14 SQL> select name from v$database;

NAME
---------
SRIRAM


15:40:28 SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
sriram


and my problem is
15:42:33 SQL> conn scott/appowner123
Connected.
15:42:59 SQL> disconnect
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
15:43:06 SQL> conn scott/appowner123@sriram
ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process

why it is an error while connecting using identifier? i have some old tns entries in my computer in a different directory.
Thanks
SRIRAM
Re: ORA-12500: TNS:listener failed to start a dedicated server [message #381900 is a reply to message #381894] Tue, 20 January 2009 04:22 Go to previous message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12500: TNS:listener failed to start a dedicated server process
 *Cause:  The process of starting up a dedicated server process failed.
 The executable could not be found or the environment may be set up
 incorrectly.
 *Action: Turn on tracing at the ADMIN level and reexecute the operation.
 Verify that the ORACLE Server executable is present and has execute
 permissions enabled. Ensure that the ORACLE environment is specified
 correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being
 called may not be installed on the local hard drive.  Please check that
 the correct Protocol Adapter are successfully linked.
 If error persists, contact Oracle Customer Support.

Regards
Michel
Previous Topic: Unable to DROP a logfile member
Next Topic: Database links
Goto Forum:
  


Current Time: Mon Nov 04 04:49:30 CST 2024