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