TNS: Listener failed to start dedicated process
410544Jun 30 2004 — edited Jun 30 200430-JUN-2004 14:56:53 * (CONNECT_DATA=(SERVICE_NAME=vddev13)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=SB-TDAY-WIN2K)(USER=jsmyth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.101.62)(PORT=3609)) * establish * vddev13 * 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
----------------------------------------------------------
This database has two SIDs. One works fine, the other (vddev13) does not. All of the .ora files look fine. I turned on the listener trace and can find the following difference between the two instances:
----------------GOOD-----------------------
[30-JUN-2004 14:58:58] nsbeqaddr: entry
[30-JUN-2004 14:58:58] nsbeqaddr: connecting...
[30-JUN-2004 14:58:58] ntpcon: entry
[30-JUN-2004 14:58:58] ntpcon: toc = 1
[30-JUN-2004 14:58:58] sntpcall: entry
[30-JUN-2004 14:58:58] snlpcss: entry
[30-JUN-2004 14:58:58] snlpcss: exit
[30-JUN-2004 14:58:58] sntpcall: Attempting to open pipe \\.\PIPE\ORANTPD54.7FC
[30-JUN-2004 14:58:58] sntpcall: Successfully established pipe 292 to child
[30-JUN-2004 14:58:58] sntpcall: exit
[30-JUN-2004 14:58:58] ntpcon: NT layer IPC connection has been established
[30-JUN-2004 14:58:58] ntpcon: exit
[30-JUN-2004 14:58:58] nttaddr2bnd: entry
[30-JUN-2004 14:58:58] nttaddr2bnd: exit
[30-JUN-2004 14:58:58] nsbeqaddr: doing connect handshake...
[30-JUN-2004 14:58:58] nsbequeath: doing connect handshake...
-----------BAD-------------------------------------
[30-JUN-2004 14:54:54] nsbeqaddr: entry
[30-JUN-2004 14:54:54] nsbeqaddr: connecting...
[30-JUN-2004 14:54:54] ntpcon: entry
[30-JUN-2004 14:54:54] ntpcon: toc = 1
[30-JUN-2004 14:54:54] sntpcall: entry
[30-JUN-2004 14:54:54] snlpcss: entry
[30-JUN-2004 14:54:54] ntpcon: exit
[30-JUN-2004 14:54:54] nserror: entry
[30-JUN-2004 14:54:54] nserror: nsres: id=6, op=72, ns=12560, ns2=0; nt[0]=530, nt[1]=2, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[30-JUN-2004 14:54:54] nsbeqaddr: error exit
[30-JUN-2004 14:54:54] nsbequeath: error exit
[30-JUN-2004 14:54:54] nsrefuse: entry
[30-JUN-2004 14:54:54] nsdo: entry
[30-JUN-2004 14:54:54] nsdo: cid=6, opcode=67, bl=211, what=10, uflgs=0x0, cflgs=0x3
[30-JUN-2004 14:54:54] nsdo: rank=64, nsctxrnk=0
[30-JUN-2004 14:54:54] nsdo: nsctx: state=2, flg=0x4204, mvd=0
[30-JUN-2004 14:54:54] nsdo: gtn=260, gtc=260, ptn=10, ptc=8163
[30-JUN-2004 14:54:54] nscon: entry
[30-JUN-2004 14:54:54] nscon: sending NSPTRF packet
[30-JUN-2004 14:54:54] nspsend: entry
[30-JUN-2004 14:54:54] nspsend: plen=223, type=4
[30-JUN-2004 14:54:54] nttwr: entry
[30-JUN-2004 14:54:54] nttwr: socket 264 had bytes written=223
[30-JUN-2004 14:54:54] nttwr: exit
[30-JUN-2004 14:54:54] nspsend: 223 bytes to transport
[30-JUN-2004 14:54:54] nspsend: packet dump
[30-JUN-2004 14:54:54] nspsend: 00 DF 00 00 04 00 00 00 |........|
[30-JUN-2004 14:54:54] nspsend: 22 00 00 D3 28 44 45 53 |"...(DES|
[30-JUN-2004 14:54:54] nspsend: 43 52 49 50 54 49 4F 4E |CRIPTION|
[30-JUN-2004 14:54:54] nspsend: 3D 28 54 4D 50 3D 29 28 |=(TMP=)(|
[30-JUN-2004 14:54:54] nspsend: 56 53 4E 4E 55 4D 3D 31 |VSNNUM=1|
[30-JUN-2004 14:54:54] nspsend: 33 35 32 39 34 39 37 36 |35294976|
[30-JUN-2004 14:54:54] nspsend: 29 28 45 52 52 3D 31 32 |)(ERR=12|
[30-JUN-2004 14:54:54] nspsend: 35 30 30 29 28 45 52 52 |500)(ERR|
[30-JUN-2004 14:54:54] nspsend: 4F 52 5F 53 54 41 43 4B |OR_STACK|
[30-JUN-2004 14:54:54] nspsend: 3D 28 45 52 52 4F 52 3D |=(ERROR=|
[30-JUN-2004 14:54:54] nspsend: 28 43 4F 44 45 3D 31 32 |(CODE=12|
[30-JUN-2004 14:54:54] nspsend: 35 30 30 29 28 45 4D 46 |500)(EMF|
[30-JUN-2004 14:54:54] nspsend: 49 3D 34 29 29 28 45 52 |I=4))(ER|
[30-JUN-2004 14:54:54] nspsend: 52 4F 52 3D 28 43 4F 44 |ROR=(COD|
[30-JUN-2004 14:54:54] nspsend: 45 3D 31 32 35 36 30 29 |E=12560)|
[30-JUN-2004 14:54:54] nspsend: 28 45 4D 46 49 3D 34 29 |(EMFI=4)|
[30-JUN-2004 14:54:54] nspsend: 29 28 45 52 52 4F 52 3D |)(ERROR=|
[30-JUN-2004 14:54:54] nspsend: 28 43 4F 44 45 3D 35 33 |(CODE=53|
[30-JUN-2004 14:54:54] nspsend: 30 29 28 45 4D 46 49 3D |0)(EMFI=|
[30-JUN-2004 14:54:54] nspsend: 34 29 29 28 45 52 52 4F |4))(ERRO|
[30-JUN-2004 14:54:54] nspsend: 52 3D 28 42 55 46 3D 27 |R=(BUF='|
[30-JUN-2004 14:54:54] nspsend: 33 32 2D 62 69 74 20 57 |32-bit W|
[30-JUN-2004 14:54:54] nspsend: 69 6E 64 6F 77 73 20 45 |indows E|
[30-JUN-2004 14:54:54] nspsend: 72 72 6F 72 3A 20 32 3A |rror: 2:|
[30-JUN-2004 14:54:54] nspsend: 20 4E 6F 20 73 75 63 68 | No such|
[30-JUN-2004 14:54:54] nspsend: 20 66 69 6C 65 20 6F 72 | file or|
[30-JUN-2004 14:54:54] nspsend: 20 64 69 72 65 63 74 6F | directo|
[30-JUN-2004 14:54:54] nspsend: 72 79 27 29 29 29 29 00 |ry')))).|
Thanks in advance!!!