Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Listener fail to start a dedicated server process
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"