on 01-06-2016 6:12 AM
Hi All,
We are facing ORA-12547 TNS:Lost Contact issue after upgrading the Oracle DB from 11.2.0.3 to 11.2.0.4.
When we try to connect Database from $ORACLE_HOME/<SID>112_64 , we are facing the issue..
But, if we set the $ORACLE_HOME to /oracle/<SID>/11204 , then it is connecting fine to DB.
We have checked the all the causes mentioned in ORA-12547 TNS: Lost Contact | ORACLE DBA BLOG and all are set correctly.All oracle environmental parameters are set properly.Oracle executable file permissions are set correctly. Eventhough we Relinked and checked. But, the issue still exists.
Could you please help on this..
Thanks & Regards,
R Gowtham Kumar.
Hi Prasad/Anil,
The issue was due to the previous version proceses are still running along with current oracle.
The issue got resolved after rebooting the server.
Regards,
Gowtham.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Gowtham,
11204 is the physical folder.
Create softlink to 112_64 as follows
Login to oracle account i.e. ora<sid>
cd /oracle/<SID>
ln -s 11204 112_64
Then switch to network/admin folder as follows
cd $ORACLE_HOME/network/admin
edit listener.ora file
Replace 11204 with 112_64.
Then save the file.
Also edit tnsnames.ora file
Replace 11204 with 112_64
save the file.
then switch to Oracle Home folder
stop listener process
lsnrctl stop
Make sure envuronment variable ORACLE_HOME should be set to /oracle/SID>/112_64
Start listener process
lsnrctl start
Hope this works in your system.
Regards
Prasad A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Gowtham,
Which is your physical folder and which is your softlink folder.
112_64 or 11204
Regards,
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Regarding this issue, you can also refer to SAP Note 505630 - "Composite SAP Note ORA-12547" for troubleshooting.
Regards,
Bíborka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.