This is a quick note to cover ORA-12547: TNS:lost contact error, I would try to include all possible causes of ORA-12547: TNS:lost contact error so that this post itself could assist you in sorting the issue. ORA-12547: TNS:lost contact error could be due to any of the following reasons:- Incorrect permissions on the ORACLE executable.…
There are several requests to a DBA for changing the Database Name & DBID of a database, suppose user wants to clone one his env. (say PROD01) to make it a dev or test instance, so he clones the VM but this would give a database with the same Database Name as that of the…
This post details how to resolve listener connection issues when DB & listener are started but still connect fails with following errors:- ORA-12505 TNS:listener could not resolve SID given in connect descriptor TNS-12505 TNS:listener could not resolve SID given in connect descriptor ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor TNS-12514 TNS:listener could…
Oracle Database Internal Mechanism 