Skip to Content

listener services not starting

Hi Friends

we have installed our solution manager on same host(windows 2003) as our IDES system.Now IDES is still on oracle 9i and solution manager is on oracle 10g.Now when i am trying to start my solution manager its not getting started and i found ' ***LOG BY0=> ORA-12541: TNS:no listener [dbsh#2 @ 1208] [dbsh 1208 ]' in the dev_w0 trace file.

then when i try to start the listener from services i am getting the following message:

'the oracleSID10gTNSListener service on local computer started and stopped.Some services stop automatically if they have no work to do, for example, the performance logs and Alerts service.'

I have checked the listener.ora and tnsnames.ora file and both IDES and SOLUTION MANAGER have been assigned different ports.Also, when i try to start the listener from command prompt 'lsnrctl start' i get the following message:

'TNS-12560: TNS:protocol adapter error'

Please note that my IDES system is working fun its just my solution manager not starting due to the listener issue.

could you please advice how to start the listener services again.

Regards,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    Posted on Mar 11, 2011 at 04:48 AM

    Hi,

    Well i had the similar problem and i tried the solutions below, This may help:

    ============

    Solution: Using Windows CMD:

    oradim -delete -sid ORCL

    oradim -new -sid ORCL -startmode AUTO

    To remove and recreate the listener service.

    You can use our free tool "Oracle Listener Remover" to remove the listener.

    next recreate the listener service by typing:

    lsnrctl start

    All Services should then be Restarted.

    ============

    Solution: Reconfigure Listener with Net Configuration Assistant,

    Confirm the Same Ports Specified for Listener from Oracle Net Manager and (tsnames.ora, listener.ora):

    1. E:\oracle\TST\102\NETWORK\ADMIN

    2. E:\usr\sap\TST\SYS\profile\oracle

    -


    Reconfigure the Protocols in the utility.

    Restart the Oracle Services.

    ============

    Also check Oracle Services in services.msc (if u r running windows) whether theya re running or not.

    ============

    Please post listener.log for further inspection aswell.

    [request deleted]

    Regards.

    Edited by: Eric Brunelle on Mar 11, 2011 2:50 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 10, 2011 at 05:08 AM

    Hi,

    Start the default TNS Listener at the database server side through the use of the LSNRCTL utility which is installed with Oracle. Perform the following steps:

    1. Click to Start > Run.

    2. Type "cmd". A command window appears.

    3. In the command prompt type "lsnrctl". This starts the utility to configure the Listener.

    4. Type "start". This starts the default Listener.

    5. Check the status of the start command. If you get a message saying "The command completed successfully", then the Listener is successfully started at the database server side.

    6. Confirm the connectivity between Client and Server.

    Possible fixes for the TNS-12560 include:

    1- Get the latest patches for the SQL *Net client software

    2- Check your $ORACLE_HOME and $PATH variables

    3- Check file permissions on the PC client

    4- Ensure that TNS_ADMIN IS set properly

    5- Check for network firewall issues

    6- In windows, Verify that the database service is started.

    Verify that ORACLE_SID parameter is correctly set in the registry.

    Regards,

    Siva

    Edited by: Siva K Kumar on Mar 10, 2011 6:10 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 10, 2011 at 05:26 AM

    Hi,

    1. Since you have multiple homes set for Oracle 9i and Oracle 10g, go to universal installer->Environment tab

    and change the home to Oracle 10g, i.e., 10g would go up and 9i would come down.

    Logoff from the server and relogin and start the listener for 10g.

    2. You can also check the eventviewer logs to get more information as to why the listener service is not starting up.

    Just enter eventvwr.msc in run and look for logs under application and system.

    Regards,

    Vishnu.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 09, 2011 at 05:47 PM

    Hi,

    Check SAP Note 441518 - ORA-12560 composite SAP Note

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 10, 2011 at 05:27 AM

    Multiple posts by mistake.

    Edited by: vishnuarigela on Mar 10, 2011 10:57 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 10, 2011 at 10:33 AM

    Hi,

    Remove both Oracle paths out of the system variable PATH and restart for starters.

    Try again.

    now if this has not worked get a command prompt up and go into the listerner I.E lsnrctl

    Check the status.

    See how you get on and then post any more errors...

    Mark

    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.