Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> listener cannot start server process
Hi there!!
Could anyone help me with this problem.
I'm trying to establish a tcp connection to Oracle7 Server and have to struggle with the following situation:
When I try to connect with sql plus or any other client program from the client machine (Windows NT), I get the error message
ORA-12500 "TNS: Listener failed to start a dedicated server process"
But in fact, we have 5 prespawned dedicated server processes configured. The problem is, that I am not the person who installed the server and therefore am not so well informed about all config files.
We have the following configuration:
Oracle7 Server 7.3.2.1.0
TNSLSNR Version 2.3.2.1.0 - Production
SQLNet Client Software 7.3.2.2.0 for Windows NT
we use sqlnet easy configuration for configuring sqlnet on the client machine.
This is a logfile-entry for such a refused connection:
12-JUN-98 15:49:08 *
(CONNECT_DATA=(SID=ein_test)(CID=(PROGRAM=PLUS33W.EXE)(HOST=Windows NT
PC)(USER=quitzsch)
)) * (ADDRESS=(PROTOCOL=tcp)(HOST=139.18.2.118)(PORT=1057)) * establish *
ein_test * 0
i.e. there is a connection between the client and server machine, but the listener somehow can't connect to the server. This is not understandable, because the servermanager and a local sqlplus have no difficulties with connecting to the server process and even a tnsping from the client machine does quite well.
Any help would be greatly appreciated. Thank you in advance!!
Stephan
You find the listeners trace file (admin mode) attached and here is our listener.ora
################
# Filename......: listener.o
# Name..........: leipzig.world
# Date..12-JUN-98 15:49:08 *
################
SQLNET.AUTHENTICATION_SERVICES = (NONE)
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= oraclient.world)
) (ADDRESS=
(PROTOCOL=IPC)
(KEY= ein_test)
) (ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = leipzig.informatik.uni-leipzig.de)
(Port = 1521)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oraclient.world) (SID_NAME = ein_test) (ORACLE_HOME = /dargb/oracle/app/oracle/product/7.3.2) (PRESPAWN_MAX = 99) (PRESPAWN_LIST = (PRESPAWN_DESC =
(PROTOCOL = TCP)
(POOL_SIZE = 5)
(TIMEOUT = 2)
) )
sending NSPTRF packet
147 bytes to transport
no timer allocated
closing transport
global context check-out (from slot 5) complete
connect string inst->lcxd[0]: (ADDRESS=(PROTOCOL=ipc)(DEV=5)(KEY=oraclient.world)) connect string inst->lcxd[1]: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=ein_test)) connect string inst->lcxd[2]: (ADDRESS=(PROTOCOL=tcp)(DEV=12)(HOST=139.18.13.21)(PORT=1521))opening transport...
connect string inst->lcxd[0]: (ADDRESS=(PROTOCOL=ipc)(DEV=5)(KEY=oraclient.world)) connect string inst->lcxd[1]: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=ein_test)) connect string inst->lcxd[2]: (ADDRESS=(PROTOCOL=tcp)(DEV=12)(HOST=139.18.13.21)(PORT=1521))opening transport...