I have created a standby .I have not put the STANDBY database in the read only mode .Everything works fine .I have not added the sid to the listener.ora .But when i saw the status of the listener it show the sid is having one handler.
Now should I add the sid to the listener.ora or should I leave as it is (There is no entry now )
# Generated by Oracle configuration tools.
(ADDRESS = (PROTOCOL = TCP)(HOST = megserv)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/oracle/8.1.6)
(PROGRAM = extproc)
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=megserv)(PORT=1521)))
STATUS of the LISTENER
Version TNSLSNR for Solaris: Version 18.104.22.168.0 - Production
Start Date 05-SEP-2001 13:51:11
Uptime 1 days 19 hr. 17 min. 21 sec
Trace Level off
Listener Parameter File /opt/app/oracle/8.1.6/network/admin/listener.ora
Listener Log File /opt/app/oracle/8.1.6/network/log/listener.log
PLSExtProc has 1 service handler(s)
STANDBY has 1 service handler(s)
The command completed successfully
In the listener status info I see STANDBY. Is that the SID of the standby instance. If so you do not have add the new entry.
I don't see anything wrong with your file.
Click Here to Expand Forum to Full Width