Some additional info:

My Listener.ora file contains

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = serv1)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle9i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL9.DOM1)
(ORACLE_HOME = D:\Oracle9i)
(SID_NAME = ORCL9)
)
(SID_DESC =
(GLOBAL_DBNAME = TDI)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = TDI)
)
)

Tracing gives me ..
27-NOV-2003 18:18:39 * (CONNECT_DATA=(SERVICE_NAME=TDI)(CID=(PROGRAM=D:
\Oracle9i\bin\sqlplus.exe)(HOST=SERV1)(USER=bagavath.kumar))) * (ADDRESS
=(PROTOCOL=tcp)(HOST=serv1)(PORT=1067)) * establish * TDI * 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: 2: No such file or directory



I have installed 9i on a win2k server which already had a 8i Instance. I
have added the 8i SID to the Listener of 9i.
I could start the 9i listener and connect to 9i Instance.
When I try connecting to the 8i Instance, I get this error.

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


any suggestions ?


Oracle LazyDBA home page