ORA-12500: TNS:listener failed to start a dedicated server process
Date: 5 Dec 2002 15:43:40 -0800
Message-ID: <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:
SID_LIST_LISTENER =
My TNSNAMES.ORA is
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
(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)
)
)
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 Fri Dec 06 2002 - 00:43:40 CET