Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS Listener failed to Start dedicated server process on standby server

Vijayaraghavan KrishnanDec 9 2008 — edited Dec 9 2008
Hi,

I am facing a problem on a standby server. Listener faild to start the dedicated server process.

My Primary Server Instance Name is JSL and the Standby Server Instance Name is also JSL. Now we have restarted the Standby server and try to put the standby database into the recovery mode. But I'm getting the Listener failed to start the dedicated server process when connecting to database.

Alert Log on standby server after the error poped up

RFS: error in standby_archive_dest 'H:\oracle9i\archive\'
RFS: Forced Shutdown due to RFS_ERROR state
RFS: error in standby_archive_dest 'H:\oracle9i\archive\'
RFS: Forced Shutdown due to RFS_ERROR state
Thu Dec 09 11:40:29 2008
RFS: error in standby_archive_dest 'H:\oracle9i\archive\'
RFS: Forced Shutdown due to RFS_ERROR state
Thu Dec 09 11:40:29 2008
RFS: error in standby_archive_dest 'H:\oracle9i\archive\'
RFS: Forced Shutdown due to RFS_ERROR state
RFS: error in standby_archive_dest 'H:\oracle9i\archive\'
RFS: Forced Shutdown due to RFS_ERROR state
RFS: error in standby_archive_dest 'H:\oracle9i\archive\'
RFS: Forced Shutdown due to RFS_ERROR state
RFS: error in standby_archive_dest 'H:\oracle9i\archive\'
RFS: Forced Shutdown due to RFS_ERROR state

Listener Log File

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 09-DEC-2008 11:42:13

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is D:\oracle\ora92\network\admin\listener.ora
Log messages written to D:\oracle\ora92\network\log\listener.log
Trace information written to D:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0

Started with pid=3088
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.201)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
09-DEC-2008 11:42:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0
09-DEC-2008 11:42:18 * service_register * testing * 0
09-DEC-2008 11:43:27 * (CONNECT_DATA=(SERVICE_NAME=JSL)(CID=(PROGRAM=D:\oracle\ora92\bin\sqlplus.exe)(HOST=STANDBYSERVER)(USER=administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.201)(PORT=3250)) * establish * JSL * 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
09-DEC-2008 11:43:59 * (CONNECT_DATA=(SERVICE_NAME=JSL)(CID=(PROGRAM=D:\oracle\ora92\bin\sqlplus.exe)(HOST=STANDBYSERVER)(USER=administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.201)(PORT=3271)) * establish * JSL * 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
09-DEC-2008 11:44:57 * service_update * testing * 0
09-DEC-2008 11:45:30 * service_update * testing * 0
09-DEC-2008 11:46:44 *


Thanks & Regards
Vijayaraghavan K
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2009
Added on Dec 9 2008
2 comments
385 views