on 08-16-2010 9:31 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.