How to fix ORA-12547 TNS lost contact when try to connect to Oracle | DaDBm

We lost the whole day because some DBA changed permissions on the Oracle directory and didn’t tell others. We simply could not login with sqlplus after setting (exporting) ORACLE_SID environment variable. The error we were getting were all pointing to various TNS related issue(s).

Some of us were able to connect, and we were able to work with it, if we used Oracle id. This sort of pointed to permission issue. But where? Turned out to be Below post clearly specifies the remedy:

Solution for ORA-12547 issue on Oracle database – TNS lost contact when try to connect to Oracle

Source: How to fix ORA-12547 TNS lost contact when try to connect to Oracle | DaDBm

I wish I saw the below post earlier. Hope it helps anyone else going through similar issue.

Advertisements

Comments, please?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s