Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2010
    Posts
    81

    Unanswered: Listener protocol and adapter errors

    Hello,

    When I issue a lsnrctl status I notice the protocol and adaptor throws up an error. I wondered
    what causes this error and how do I resolve. Remote users can connect to the databases,
    but on my other server there are no protocol or adapator errors. Many thanks in advance

    bash-3.00$ lsnrctl status

    LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 23-JUN-2010 09:03:56

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)) )
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Solaris Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=actarcua tdatg01)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
    Start Date 23-JUN-2010 09:01:27
    Uptime 0 days 0 hr. 2 min. 28 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=actarcua tdatg01)(PORT=1521)))
    Services Summary...
    Service "arintdb" has 1 instance(s).
    Instance "arintdb", status READY, has 1 handler(s) for this service...
    Service "arintdbXDB" has 1 instance(s).
    Instance "arintdb", status READY, has 1 handler(s) for this service...
    Service "arintdb_XPT" has 1 instance(s).
    Instance "arintdb", status READY, has 1 handler(s) for this service...
    Service "arrepos" has 1 instance(s).
    Instance "arrepos", status READY, has 1 handler(s) for this service...
    Service "arreposXDB" has 1 instance(s).
    Instance "arrepos", status READY, has 1 handler(s) for this service...
    Service "arrepos_XPT" has 1 instance(s).
    Instance "arrepos", status READY, has 1 handler(s) for this service...
    The command completed successfully

  2. #2
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Looks like this is the problem:
    Code:
    (HOST=actarcua tdatg01)
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  3. #3
    Join Date
    Jun 2010
    Posts
    81
    Hello,

    I believe that is some kind of format issues at dbforums.com. I checked the listener
    and it is the same as the hostname. Reposted the status of the listener. I also
    noticed there is no path to the listener.log or the listener parameter file

    lsnrctl status

    LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 23-JUN-2010 11:52:43

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)) )
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Solaris Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)

    (HOST=actarcuatdatg01)(PORT=15 21)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
    Start Date 23-JUN-2010 09:01:27
    Uptime 0 days 2 hr. 51 min. 16 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=actarcua tdatg01)(PORT=1521)))
    Services Summary...
    Service "arintdb" has 1 instance(s).
    Instance "arintdb", status READY, has 1 handler(s) for this service...
    Service "arintdbXDB" has 1 instance(s).
    Instance "arintdb", status READY, has 1 handler(s) for this service...
    Service "arintdb_XPT" has 1 instance(s).
    Instance "arintdb", status READY, has 1 handler(s) for this service...
    Service "arrepos" has 1 instance(s).
    Instance "arrepos", status READY, has 1 handler(s) for this service...
    Service "arreposXDB" has 1 instance(s).
    Instance "arrepos", status READY, has 1 handler(s) for this service...
    Service "arrepos_XPT" has 1 instance(s).
    Instance "arrepos", status READY, has 1 handler(s) for this service...
    The command completed successfully
    bash-3.00$ hostname
    actarcuatdatg01
    bash-3.00$
    Last edited by newdbaxchange; 06-23-10 at 09:35.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    do the following steps

    lsnrctl stop
    rename listener.ora file to a new/different name
    lsnrctl start
    lsnrctl status

    Do errors still exist?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2010
    Posts
    81
    Hi,

    I moved the listener.ora file to a new file.ora, stopped and restarted the listener, however I
    now do not see any databases connected as before. I take it that users will not be able to
    access the databases remotely? This time I do not see any protocol or adapter errors,
    but at the bottom you can see the listener supports no services. But what happens to the databases?

    ================================================== ===
    bash-3.00$ lsnrctl start

    LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 23-JUN-2010 15:42:02

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Starting /u01/app/oracle/product/10.2.0/Db_1/bin/tnslsnr: please wait...

    TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
    Log messages written to /u01/app/oracle/product/10.2.0/Db_1/network/log/listener .log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=actarcua tdatg01)(PORT=15 21)))

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
    Start Date 23-JUN-2010 15:42:02
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File /u01/app/oracle/product/10.2.0/Db_1/network/log/listen er.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=actarcua tdatg01)(PORT=1521)))
    The listener supports no services
    The command completed successfully
    bash-3.00$ lsnrctl status

    LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 23-JUN-2010 15:42:10

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
    Start Date 23-JUN-2010 15:42:02
    Uptime 0 days 0 hr. 0 min. 7 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File /u01/app/oracle/product/10.2.0/Db_1/network/log/listen er.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=actarcua tdatg01)(PORT=1521)))
    The listener supports no services
    The command completed successfully

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    old listener.ora file contained error

    lsnrctl status will now show DB.
    V10+ DB "register" every minute with listener
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2010
    Posts
    81

    Seems like a fix

    From the previous post, I copied the filename.ora back to listener.ora

    stopped the listener

    restarted the listener

    And now the listener comes up working OK with the required databases and no errors.
    This time I see no protocol or adaptor errors. I can see a path for the listener.log file
    and the parameter file. Very strange or was it something I did?

    lsnrctl status

    LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 23-JUN-2010 15:49:30

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)) )
    STATUS of the LISTENER
    ------------------------
    Alias listener
    Version TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
    Start Date 23-JUN-2010 15:49:20
    Uptime 0 days 0 hr. 0 min. 10 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/app/oracle/product/10.2.0/Db_1/network/admin/listener.ora
    Listener Log File /u01/app/oracle/product/10.2.0/Db_1/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)) )
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=actarcua tdatg01)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "arintdb" has 1 instance(s).
    Instance "arintdb", status UNKNOWN, has 1 handler(s) for this service...
    Service "arrepos" has 1 instance(s).
    Instance "arrepos", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

Posting Permissions

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