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