listener services not starting

[former_member205110]

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,

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi, I am facing similar problem while starting TNSLSNR.

here is the Content from listener.ora.

#############################

LISTENERAB1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = mb1es1022)(PORT = 1541))

)

)

SID_LIST_LISTENERAB1 =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = AB1)

(ORACLE_HOME = i:\oracle\AB1\102)

(SID_NAME = AB1)

)

(SID_DESC =

(GLOBAL_DBNAME = LISTENERAB1)

(PROGRAM = Oracle)

(ARGV0 = AB1)

(SID_NAME = AB1)

(ORACLE_HOME = I:\oracle\AB1\102)

)

)

#############################

But service is not starting.

Kindly suggest with some hints / oss notes.

Thanks in advance.

Swapnil

[Former Member · Accepted solution]

Ok,

what's the error messages

Have you just one DB on server

Need to have a look at tnsnames.ora

Need as much info to help.

Mark

[Former Member]

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

[Former Member]

Multiple posts by mistake.

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

[Former Member]

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.

[sivakumar_kilari3]

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

[sunny_pahuja2]

Hi,

Check SAP Note 441518 - ORA-12560 composite SAP Note

Thanks

Sunny