ORA-12547 TNS: Lost Contact

[gowtham_raparthi]

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.

[gowtham_raparthi]

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.

[former_member299258]

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

[former_member227283]

Dear Gowtham,

Which is your physical folder and which is your softlink folder.

112_64 or 11204

Regards,

Anil

[former_member207186]

Hi,

Regarding this issue, you can also refer to SAP Note 505630 - "Composite SAP Note ORA-12547" for troubleshooting.

Regards,

Bíborka

[Mofizur]

Hi,

Please check . This can give you some idea.

Thanks,

Mofizur