ORA-06413 Connection not open error in Oracle - Complete Fix Guide

Error ORA-06413 Connection not open

Applies to:

            Windows 7 64bit

            Oracle Database 11.2.0.4

Description:

After re-install the windows 7 64-bit, I am unable to connect my Oracle Database instance using Toad 9.7.2.5. TNSNAMES.ora, SQLNET.ora and LISTENER.ora files are configured correctly. - When try to connect my database using Toad it shows the following error:

Error: ORA-06413 Connection not open

Solution:

            I have found that the error caused by the parenthesis in the path:

“C:\Program Files (x86)/..” where Toad install.

To fix the error execute the following command from command prompt to make a link:

C:>mklink /j “Program Files x86” “Program Files (x86)”

Now update shortcut of Toad with new path “C:\Program Files x86\..”

It’s working fine.

           

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

👉 Check our complete guide: Oracle Error Codes Guide

---

Your comments, especially which will help us improve the functionality, will be greatly appreciated. Do not forget to follow my Blog.

---

About the Author

Rana Abdul Wahid is an Oracle Database Administrator (DBA) with expertise in Oracle RMAN recovery, Oracle EBS administration, backup and recovery, performance tuning, database cloning, and troubleshooting critical Oracle database issues.