DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Listener

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    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
    Radhakrishnan.M

  2. #2
    Join Date
    Sep 2001
    Location
    Dallas, TX
    Posts
    27
    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

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I don't see anything wrong with your file.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width