Skip to Content
author's profile photo Former Member
Former Member

listener fails after upgrade to 10.2.0.5

Hello,

I'm facing a problem with listener, I'm unable to execute lsnrctl start

I've upgraded oracle from 10.2.0.2 to 10.2.0.5 with package downloaded from service.sap.com (no errors during patching) and I cannot start listener

Sys op = SuSE11SP1 X86_64

I have an error:

Starting /oracle/DEV/102_64/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

Best regards,

Michal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Apr 04, 2011 at 12:36 AM

    > I've upgraded oracle from 10.2.0.2 to 10.2.0.5 with package downloaded from service.sap.com (no errors during patching) and I cannot start listener

    >

    > Sys op = SuSE11SP1 X86_64

    >

    > I have an error:

    >

    > Starting /oracle/DEV/102_64/bin/tnslsnr: please wait...

    >

    > TNS-12537: TNS:connection closed

    > TNS-12560: TNS:protocol adapter error

    > TNS-00507: Connection closed

    > Linux Error: 29: Illegal seek

    It seems there went something wrong during the upgrade.

    Did you follow the upgrade guide and made all necessary steps (like copying tnsnames.ora and changing ORACLE_HOME in the files etc.?

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      1. Remove LISTENER_NEW from the configuration (If it still exists)

      2. Shutdown the database.

      3. In user ora<sid>, browse to $ORACLE_HOME\bin

      4. Issue the command "relink all" (without the quotes).

      5. Start database and then listener.

      Hope this helps.

      Regards,

      Anish

  • author's profile photo Former Member
    Former Member
    Posted on Apr 04, 2011 at 09:09 AM
    I have an error:
    
    Starting /oracle/DEV/102_64/bin/tnslsnr: please wait...
    
    TNS-12537: TNS:connection closed
    TNS-12560: TNS:protocol adapter error
    TNS-00507: Connection closed
    Linux Error: 29: Illegal seek

    It seems there is some issue with your listener.ora or tnsnames.ora file. Please check if it is refering to correct hostname and port.Also there are many other ways described in oracle metalink also.Please check at oracle metalink as well.

    Thanks..

    Mohit

    Edited by: mohit gupta on Apr 4, 2011 11:10 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2011 at 11:29 AM

    OSS solved a problem. There was a incorrect library in sap kernel which cause a erorrs.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.