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

From: Hari Om <hari_om_at_hotmail.com>
Date: 5 Dec 2002 15:42:53 -0800
Message-ID: <d1d5ebe4.0212051542.b171da6@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! Received on Thu Dec 05 2002 - 17:42:53 CST