problem in starting listener Service

[Former Member]

hello

we have Hp-UX, Oracle 10g.

My Database on one my Boxes has stopped. I checked the log file, it says cannot conect to the listner.

I am pasting the output for lnsrctl stop command

LSNRCTL> stop

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=IEP.WORLD))

The command completed successfully

LSNRCTL> stop

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=IEP.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

HPUX Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=IEP))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

HPUX Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=usstubw02)(PORT)

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

HPUX Error: 239: Connection refused

kindly help me , in resolving this

Points will be awarded.

-Thanks

Sam

[stefan_koehler]

Hello Sam,

the problem seems to be clear.

- At first you have stopped the listener twice. The first time it was i successful and the second stop command failed which is correct.

- You have to start the listener now -> command "lsnrctl start"

The only thing that looks a little bit strange is:

> Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=usstubw02)(PORT)

There is no port specified. Have you changed the listener.ora file?

If the "lsnrctl start" command fails, please post the listener.ora file and the error at startup.

Regards

Stefan

[Former Member]

Stefan is right. After stopping the listener, you try to stop it again. You should now start it. Before starting it, please rename the listener.log (mv listener.log listener.log.<DATE>) ($ORACLE_HOME/network/log) and create a new listener.log (touch listener.log). You will see the errors in the new listener.log.

[Former Member]

check please following SAP Notes:

_396873_ - UNIX: Error due to socket authorizations

_609332_ - Composite note: ORA-12541/ORA-12224

check please the listener like lsnrctl status <Listener Name> and also network configuration files under $ORACLE_HOME/network/admin.

[Former Member]

Hi saurabh,

Check the TNS listner service from OS level, restart the service & remount the database.

Hope this helps.

Regards,

Rajesh

[Former Member]

Hi Sam,

can u plz check localhost is ping properly? and check listner port number is proper in the host file in etc directory ....

Regards

Mark