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

Thread: listenere - prob

  1. #1
    Join Date
    Oct 2000
    Posts
    9

    Red face

    Hi gurus

    I have 2 instanse having same oracle home but independent database. I am trying to have a listener first I tried with one listener file with different listener and then I tried with independent listener file with different name (started after renaming the listener.ora file) but I am getting the below result and I am unable to connect from windows client machine my tnsnames is working fine that I know notice that result and tell me what is wrong or give me different example if possible


    FIRST listener dev

    # cat listdev.ora
    # LISTENER.ORA Configuration File:/oracle/app/product/8.1.5/network/admin/li
    er.ora
    # Generated by Oracle Net8 Assistant

    DEV=
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCPROD))
    (ADDRESS = (PROTOCOL = TCP)(HOST = appdev)(PORT = 1521))
    )

    #STARTUP_WAIT_TIME_LISTENER = 0
    #CONNECT_TIMEOUT_LISTENER = 10
    #TRACE_LEVEL_LISTENER = 0

    SID_LIST_DEV=
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME=DEV)
    (SID_NAME=DEV)
    (ORACLE_HOME = /oracle/app/product/8.1.5)
    )
    (SID_DESC =
    (SID_NAME=PLSExtProc)
    (ORACLE_HOME = /oracle/app/product/8.1.5)
    (PROGRAM =extproc)
    )

    )

    SECOND LISTENER DEV2

    # LISTENER.ORA Configuration File:/oracle/app/product/8.1.5/network/admin/list
    er.ora
    # Generated by Oracle Net8 Assistant


    DEV2=

    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
    (ADDRESS = (PROTOCOL = TCP)(HOST = appdev)(PORT = 1599))
    )

    #STARTUP_WAIT_TIME_LISTENER = 0
    #CONNECT_TIMEOUT_LISTENER = 10
    #TRACE_LEVEL_LISTENER = 0

    SID_LIST_DEV2=
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME=DEV2)
    (SID_NAME=DEV2)
    (ORACLE_HOME = /oracle/app/product/8.1.5)
    )


    (SID_DESC =
    (SID_NAME=PLSExt2)
    (ORACLE_HOME = /oracle/app/product/8.1.5)
    (PROGRAM =extproc)
    )
    )
    #

    LSNRCTL> start dev (before starting dev2)
    Starting /oracle/app/product/8.1.5/bin/tnslsnr: please wait...

    TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
    System parameter file is /oracle/app/product/8.1.5/network/admin/listener.ora
    Log messages written to /oracle/app/product/8.1.5/network/log/dev.log
    Listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
    Listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=appdev)(PORT=1521))

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
    STATUS of the LISTENER
    ------------------------
    Alias dev
    Version TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
    Start Date 26-JAN-02 16:21:12
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /oracle/app/product/8.1.5/network/admin/listener.ora
    Listener Log File /oracle/app/product/8.1.5/network/log/dev.log
    Services Summary...
    DEV has 1 service handler(s)
    PLSExtProc has 1 service handler(s)
    The command completed successfully
    -------------------------------------------------------------------------------

    $ lsnrctl start dev2

    LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 26-JAN-02 16:20:48

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Starting /oracle/app/product/8.1.5/bin/tnslsnr: please wait...

    TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
    System parameter file is /oracle/app/product/8.1.5/network/admin/listener.ora
    Log messages written to /oracle/app/product/8.1.5/network/log/dev2.log
    Listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2))
    Listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=appdev)(PORT=1599))

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2))
    STATUS of the LISTENER
    ------------------------
    Alias dev2
    Version TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
    Start Date 26-JAN-02 16:20:48
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /oracle/app/product/8.1.5/network/admin/listener.ora
    Listener Log File /oracle/app/product/8.1.5/network/log/dev2.log
    Services Summary...
    DEV2 has 1 service handler(s)
    PLSExt2 has 1 service handler(s)
    The command completed successfully

    $ lsnrctl status dev

    LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 26-JAN-02 16:40:46

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.198.10)(PORT=15
    1))(CONNECT_DATA=(SID=dev)))
    STATUS of the LISTENER
    ------------------------
    Alias dev
    Version TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
    Start Date 26-JAN-02 16:21:12
    Uptime 0 days 0 hr. 19 min. 34 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /oracle/app/product/8.1.5/network/admin/listener.ora
    Listener Log File /oracle/app/product/8.1.5/network/log/dev.log
    Services Summary...
    DEV has 3 service handler(s)
    PLSExtProc has 1 service handler(s)
    dev2 has 2 service handler(s)
    The command completed successfully

    ---------------------------------
    $ lsnrctl services dev

    LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 26-JAN-02 16:42:10

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.198.10)(PORT=152
    1))(CONNECT_DATA=(SID=dev)))
    Services Summary...
    DEV has 3 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:254 state:ready
    D000
    (ADDRESS=(PROTOCOL=tcp)(HOST=appdev)(PORT=44905))
    Presentation: oracle.aurora.server.SGiopServer
    PLSExtProc has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    dev2 has 2 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:254 state:ready
    D000
    (ADDRESS=(PROTOCOL=tcp)(HOST=appdev)(PORT=44956))
    Presentation: oracle.aurora.server.SGiopServer
    The command completed successfully
    $ lsnrctl services dev2

    LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 26-JAN-02 16:42:23

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2))
    Services Summary...
    DEV2 has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    PLSExt2 has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    The command completed successfully



  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    As far as ur listener status,everything is fine.How r u trying to connect to the database.please give details...

    cheese
    anandkl
    anandkl

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