Listener

[omegamark]

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 )

ra
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = megserv)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/oracle/8.1.6)
(PROGRAM = extproc)
)
)

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=megserv)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production
Start Date 05-SEP-2001 13:51:11
Uptime 1 days 19 hr. 17 min. 21 sec
Trace Level off
Security OFF
SNMP 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
Services Summary...
PLSExtProc has 1 service handler(s)
STANDBY has 1 service handler(s)
The command completed successfully
LSNRCTL> exit

[bkrish]

Hi RM

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.

BK

[julian]

I don't see anything wrong with your file.