Listener fail to start a dedicated server process
From: gordon <ryoden2_at_ms4.hinet.net>
Date: Mon, 21 Sep 1998 19:17:39 +0800
Message-ID: <6u5cdj$m3u_at_netnews.hinet.net>
I can't connect to database server .(I have system privileges and LISTENER.ORA , TNSNAMES.ORA file is correct) 1. connect error message:
ERROR:ORA-12500 TNS:Listener fail to start a dedicated server process. 2. Listener Trace message:
transport is open
global context check-in (to slot 3) complete doing connect handshake...
50 bytes from transport
got NSPTCN packet
recving connect data
255 bytes from transport
245 bytes from NS buffer
command = establish
(ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ENVS=)(ARGV0=oracleTPISIS)(ARGS='(LO CAL=NO)')(SID_NAME=TPISIS)(ORACLE_HOME=/home/oracle)(ENVS='ORACLE_HOME=/home /oracle,
PATH=/home/oracle/bin/,TZ=ROC,TNS_ADMIN=/home/oracle/network/admin,ORACLE_SI D=TP
ISIS,'))
connecting...
About to exec oracle:
detaching from parent with additional fork result string is NTP0 3988
added pid 3988
hdl[IR]=15, hdl[IW]=14
NT layer IPC connection has been established. doing connect handshake...
NSE=12538
-<ERROR>- nsres: id=3, op=72, ns=12538, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0 sending NSPTRF packet
130 bytes to transport
no timer allocated
closing transport
global context check-out (from slot 3) complete Deallocating cxd 0x1a1dd8. Received on Mon Sep 21 1998 - 13:17:39 CEST
Date: Mon, 21 Sep 1998 19:17:39 +0800
Message-ID: <6u5cdj$m3u_at_netnews.hinet.net>
I can't connect to database server .(I have system privileges and LISTENER.ORA , TNSNAMES.ORA file is correct) 1. connect error message:
ERROR:ORA-12500 TNS:Listener fail to start a dedicated server process. 2. Listener Trace message:
transport is open
global context check-in (to slot 3) complete doing connect handshake...
50 bytes from transport
got NSPTCN packet
recving connect data
255 bytes from transport
245 bytes from NS buffer
command = establish
(ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ENVS=)(ARGV0=oracleTPISIS)(ARGS='(LO CAL=NO)')(SID_NAME=TPISIS)(ORACLE_HOME=/home/oracle)(ENVS='ORACLE_HOME=/home /oracle,
PATH=/home/oracle/bin/,TZ=ROC,TNS_ADMIN=/home/oracle/network/admin,ORACLE_SI D=TP
ISIS,'))
connecting...
About to exec oracle:
environ[0] = "ORACLE_HOME=/home/oracle" environ[1] = "PATH=/home/oracle/bin/" environ[2] = "TZ=ROC" environ[3] = "TNS_ADMIN=/home/oracle/network/admin" environ[4] = "ORACLE_SID=TPISIS" environ[5] = "ORA_NLS=/home/oracle/ocommon/nls/admin/data" environ[6] = "NLS_LANG=american_america.zht16big5" environ[7] = "HOME=/home/oracle"
detaching from parent with additional fork result string is NTP0 3988
added pid 3988
hdl[IR]=15, hdl[IW]=14
NT layer IPC connection has been established. doing connect handshake...
NSE=12538
-<ERROR>- nsres: id=3, op=72, ns=12538, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0 sending NSPTRF packet
130 bytes to transport
no timer allocated
closing transport
global context check-out (from slot 3) complete Deallocating cxd 0x1a1dd8. Received on Mon Sep 21 1998 - 13:17:39 CEST