cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to start listener after upgrade to 10.2.0.4

Former Member
0 Kudos

Hi,

We have oracle 10g on HP-UX 11.31.

After upgrade of oracle 10.2.0.2 to 10.2.0.4 I am not able to start the listener, and getting the below error.

LSNRCTL> start

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

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

HPUX Error: 29: Illegal seek

LSNRCTL> exit

As per the oracle metalink note 315720.1 I check the /etc/hosts file and it has the following entry

127.0.0.1 localhost loopback

Also, I set parameter SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFF in listener.ora file, but not worked.

Please suggest the solution.

Regards

Rajesh

Accepted Solutions (1)

Accepted Solutions (1)

former_member524429
Active Contributor
0 Kudos

Hi,

I hope You must have performed all the Pre & Post steps properly as mentioned in readme file of Oracle 10.2.0.4 Patch source.

Please analyze the error contents written in listener.log & sqlnet.log files (located at $ORACLE_HOME/network/log) to get more information. Post the possible contents of the above mentioned file, if you found any error(s).

Regards,

Bhavik G. Shroff

Former Member
0 Kudos

Hi,

Thanks for your reply.

I performed all the pre & postinstalltion steps, the output of listener.log is as follows.

TNSLSNR for HPUX: Version 10.2.0.4.0 - Production on 16-AUG-2010 14:19:00

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

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

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

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

Trace level is currently 0

Started with pid=1582

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

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

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

TNSLSNR for HPUX: Version 10.2.0.4.0 - Production on 16-AUG-2010 14:30:36

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

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

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

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

Trace level is currently 0

Started with pid=3451

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

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

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

TNSLSNR for HPUX: Version 10.2.0.4.0 - Production on 16-AUG-2010 14:57:07

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

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

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

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

Trace level is currently 0

Started with pid=3922

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmmock2)(PORT=1521)))

Please suggest.

Regards,

Rajesh

Former Member
0 Kudos

Hi,

Check the permission of listener file which are locate on 3 locations.

Check the listener port **** are open.

Have u change the any parameter related to listener?

Regards

Amit

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Rajesh,

Before doing the patch upgrade, did you read the readme.html file from the patch set.

it will have the exact steps for the oracle patch upgrade.

please try the below steps also ( IF its standalone DB).

1. Did you run the root.sh while doing patch upgrade?

2.check whether you have given right oracle home and all.

try to start the DB from sql mode. sometimes it will help.

if you cant bring the the DB then try to remove the latestpatch. make sure that you have perfect DB backup.

With Regards,

Senthil Kumar.C

Former Member
0 Kudos

Thanks for your reply.

Yes, it is standalone DB.

DB is open only problem is with listener, I am getting error while trying to start the listener.

Regards,

Rajesh

Former Member
0 Kudos

Hi Rajesh,

check your listener.trc.

paste here listener log and trc file.

FYI : check the whether you starting listener from ora<sid>.

With Regards,

CSK