Listener not started after installing patchset 10.2.0.4

[Former Member]

Dear All,

I've just patched my Oracle 10.2.0.2 to 10.2.0.4. We run the Oracle on SuSE Linux 10 SP2 on IA64.

The patch went smoothly, no errors. I also applied the PSU 2010.05 without any error.

After patching the database starts, but the listener not:

orabc6 51> lsnrctl start

LSNRCTL for Linux IA64: Version 10.2.0.4.0 - Production on 13-JUL-2010 18:12:07

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /oracle/BC6/102_64/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux IA64 Error: 29: Illegal seek

The listener.log is as follows:

TNSLSNR for Linux IA64: Version 10.2.0.4.0 - Production on 13-JUL-2010 18:12:11

Copyright (c) 1991, 2007, Oracle. All rights reserved.

System parameter file is /oracle/BC6/102_64/network/admin/listener.ora

Log messages written to /oracle/BC6/102_64/network/log/listener.log

Trace information written to /oracle/BC6/102_64/network/trace/listener.trc

Trace level is currently 0

Started with pid=22359

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=BC6.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=BC6)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.5.55)(PORT=1527)))

No process with pid 22359...

I tried to "relink all", it ended without error, but did not solve the issue.

I also try to include the following entry into the hosts file, but this did not helped me, either.

127.0.0.1 localhost.localdomain localhost

(proposed at " )

Do you have an idea why this happen?

Thanks in advance.

Gábor

Edited by: Gábor Szécsi on Jul 13, 2010 6:26 PM

[Former Member]

dear Orkun and M.Abdu

Listener start..

SANDBOX:sbxadm 3> lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 29-APR-2013 17:21:55

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /oracle/SBX/102_64/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production

System parameter file is /oracle/SBX/102_64/network/admin/listener.ora

Log messages written to /oracle/SBX/102_64/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SBX.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SBX)))

Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=SANDBOX)(PORT=1527))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

  TNS-00515: Connect failed because target host or object does not exist

Listener failed to start. See the error message(s) above...

Can help me again..?

[former_member206552]

hi,

try using the ip address instead of the hostname

regards

marius

[Former Member]

To start the listener in an AIX environment you should be logged on as orasid (orasbx).

Best regards

Mark

[Reagan]

Hello

Please provide the contents of the listener.ora and tnsnames.ora

Also what is the output when you ping SANDBOX ?

Cheers

RB

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

where i can setup the Ipaddress?

best regard

[Former Member]

I fin ping and reply that server..

ping 172.16.0.105

PING 172.16.0.105: (172.16.0.105): 56 data bytes

64 bytes from 172.16.0.105: icmp_seq=0 ttl=255 time=0 ms

64 bytes from 172.16.0.105: icmp_seq=1 ttl=255 time=0 ms

64 bytes from 172.16.0.105: icmp_seq=2 ttl=255 time=0 ms

64 bytes from 172.16.0.105: icmp_seq=3 ttl=255 time=0 ms

[Former Member]

Hii guy,

i have problem at my listener..

this my error if I will lsnrctl start":

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 09-APR-2013 02:59:37

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /oracle/SBX/102_64/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production

System parameter file is /oracle/SBX/102_64/network/admin/listener.ora

Log messages written to /oracle/SBX/102_64/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SBX.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SBX)))

Error listening on: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=SANDBOX)(PORT=1527))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

  TNS-00515: Connect failed because target host or object does not exist

Listener failed to start. See the error message(s) above...

______________________________________ Can help me..

[Former Member]

Hi,

>> TNS-12545: Connect failed because target host or object does not exist

This error can be caused by network or authorization problems. I suggest you check whether tnsnames.ora entries are correct.

Read the notes below for the further informations;

Note 723641 - Composite SAP Note: ORA-12545

Note 384839 - ora-12540, tns-12560, tns-12500, tns-12546

Best regards,

Orkun Gedik

[former_member182034]

Dear B000 and Gabor,

please make the oracle Environmental Variable are configured correctly and check the below link.

illegal seek/

TNS-12545:

please make sure the entry of host name with IP is correctly configured in host file and  Ping and Telnet should be working.

Regards,

[Former Member]

I need solve the my problem.

I need step by step because I am newbie at SAP and Unix system.

best regard

[Former Member]

hii guy,

I have the same problem like you?

[Former Member]

Check if there is already some process listening on port 1527 with netstat -an |grep 1527

And increase the trace level of the listener and start it again. Post the logfile of this trace.

Kind regards,

Mark

[Former Member]

I believe your lsnrctl command is wrong. Try this: lsnrctl start lsnr_<SID> (in which case <SID> is your DB SID - BC6 for example). If this works check via tnsping <SID> that your listener is reachable.