Re: ORA-12500: TNS:listener failed to start a dedicated server process

hari_om_at_hotmail.com (Hari Om) wrote in message news:<d1d5ebe4.0212051543.26991ea3_at_posting.google.com>...
> Hi:
>
> I have my Oracle DB on IBM AIX Server. I have installed my Client on
> WIn XP machine and I used to access my DB Server from my Win XP mc and
> it used to work fine.
>
> Today, all of a sudden - I could not log in to my Oracle DB Server -
> wonder why? It keeps on giving me "ORA-12500: TNS:listener failed to
> start a dedicated server process" Error" I have READ ALL the posting
> but still could'nt figure out.
>
> My LISTENER.ORA file is:
> ---------------------------------------------------------------------
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = C:\oracle\ora92)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = mk)
> (ORACLE_HOME = C:\oracle\ora92)
> (SID_NAME = mk)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = test)
> (ORACLE_HOME = C:\oracle\ora92)
> (SID_NAME = test)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = GAURI)
> (ORACLE_HOME = C:\oracle\ora92)
> (SID_NAME = GAURI)
> )
> )
>
> ---------------------------------------------------------------------
>
> My TNSNAMES.ORA is
> ---------------------------------------------------------------------
> MK =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = MK)
> )
> )
>
> TEST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = test)
> )
> )
>
> ---------------------------------------------------------------------
>
> My SQLNET.ORA is
> ---------------------------------------------------------------------
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
> TRACE_LEVEL_CLIENT = ADMIN
> ---------------------------------------------------------------------
>
> My LISTENER.LOG file shows:
> ---------------------------------------------------------------------
> 05-DEC-2002 16:36:37 *
> (CONNECT_DATA=(SERVICE_NAME=MK)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplusw.exe)(HOST=localhost)(USER=manu)))
> * (ADDRESS=(PROTOCOL=tcp)(HOST=DB_SERVER_IP_ADDR)(PORT=2041)) *
> establish * MK * 12500
> TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12560: TNS:protocol adapter error
> TNS-00530: Protocol adapter error
> 32-bit Windows Error: 126: Unknown error
> ---------------------------------------------------------------------
>
>
> Can anyone give some information on above ERROR?
>
> THANKS!
Hari

It looks like you have a names resolutio problem.

I will make the following assumptions:
1. LISTENER.ORA has been taken from the DB server (AIX box) 2. TNSNAMES.ORA is on your windows client.

Assuming this, change the (HOST = localhost) definition in the TNSNAMES.ORA to (HOST = ip_of_the_server).

Let me know how it goes.

Regards

Alex Blyth
Oracle DBA Received on Tue Dec 10 2002 - 03:06:05 CET