Oracle Listener

[Former Member]

Dear All,

We are unable to bring up the SAP as the Oracle Listener is not starting up. We are able to start our database but unable to start the listener.

The following is the error message we see when we start the oracle listener.

TNS-12547:TNS:LOST CONTACT

TNS-12560:TNS:PROTOCOL ADAPTER ERROR

TNS-00517: LOST CONTACT

LINUX ERROR : 104 : CONNECTIONS RESET BY PEER

CONNECTING TO (ADDRESS=(PROTOCOL=IPC)(KEY=PRD)

TNS-12541:TNS:NO LISTENER

TNS-12560:TNS:PROTOCOL ADAPTER ERROR

TNS-00511: NO LISTENER

LINUX ERROR:111:CONNECTION REFUSED

CONNECTING TO (ADDRESS=(COMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=VIVPRD)(pORT=1527)

TNS-12541:TNS:NO LISTENER

TNS-12560:TNS:PROTOCOL ADAPTER ERROR

TNS-00511: NO LISTENER

LINUX ERROR:111:CONNECTION REFUSED

SAP = ECC6.0

O/S = RHEL 5.0

DB = Oracle 10.2

Please update us as what needs to be done.

Best Regards

Sumanth

[martin_juen2]

maybe the listener port is already in use...

[Former Member]

The Listener is not up...the LISTENER fails with an error message...MISSING LISTENER NAME.when i see the LISTERNER.ORA file i see that the listener name exists.

In order to start the SAP i need to start the LISTERNER...as i'm on RHEL 5.0

Regards

Sumanth

[Former Member]

hi sumanth,

the problem is due to the network settings.

restart your network service as root user

> service network restart

start the listener in ora<sid>.

If still the listener is not running then

reconfigure your network (ethernet) connection and check it

regards

chandru

[Former Member]

Hi,

did u start it? "lsnrctl start" command of ora<sid> user.

Regs.

FS

[Former Member]

login to your DB server which oracle located using ora[sid] user.

start your listener using command like this :

$lsnr start

to check whether your Oracle listener had been start, use command :

$lsnr status

ardhian

http://sapbasis.wordpress.com

[Former Member]

I have logged in with ORASID and started the Listener as

LSNRCTL>START

for which i get the above error message.

I can start the Database with out any ssues..however when i try to start the Listener i get the above error message.

Help in resolving the issue.

Regards

Sumanth

[former_member227600]

Hi,

Please paste your listner log .And when you give command lsnrctl status ,whats the output.please paste here.

Karan

[Former Member]

The following is the error message we see when we start the oracle listener.

TNS-12547:TNS:LOST CONTACT

TNS-12560:TNS:PROTOCOL ADAPTER ERROR

TNS-00517: LOST CONTACT

LINUX ERROR : 104 : CONNECTIONS RESET BY PEER

CONNECTING TO (ADDRESS=(PROTOCOL=IPC)(KEY=PRD)

TNS-12541:TNS:NO LISTENER

TNS-12560:TNS:PROTOCOL ADAPTER ERROR

TNS-00511: NO LISTENER

LINUX ERROR:111:CONNECTION REFUSED

CONNECTING TO (ADDRESS=(COMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=VIVPRD)(pORT=1527)

TNS-12541:TNS:NO LISTENER

TNS-12560:TNS:PROTOCOL ADAPTER ERROR

TNS-00511: NO LISTENER

LINUX ERROR:111:CONNECTION REFUSED

SAP = ECC6.0

O/S = RHEL 5.0

DB = Oracle 10.2

Please update us as what needs to be done.

[former_member227600]

Hi,

I am telling about listner log .you can find tham in oracle_home/network/admin/log

And please check the owner & permision of listner.ora file.

karan

[Former Member]

Check you hosts settings. make sure IP address is setup correctly in /etc/hosts and you are able to ping to it.

Also, ensure that port 1527 is not used by any other process, you can change it and try to restart the listener to ensure that there is no clash with Port number.

Cheers,

Nisch