ORA-06413 Connection not open

Mehmet Salih Deveci

3 years ago

I got ” ORA-06413 Connection not open ” error in Oracle database.

ORA-06413 Connection not open

Details of error are as follows.

ORA-06413 Connection not open.

Cause: Unable to establish connection.

Action: Use diagnostic procedures to ascertain exact problem.

Connection not open

This ORA-06413 error is related to Unable establishing connection.

Use diagnostic procedures to ascertain exact problem.

This error is caused by the parenthesis in the path of TOAD in my case

"C:\Program Files (x86)/.."

To solve this error, make a link again as follows.

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

Second case is as follows.

When attempting to configure the database connection via DBConfig.exe, the following error is encountered:

ERROR

Bad public user name or password. ORA-06413: Connection not open.

The folder path contains non-standard characters.

When the folder path contains non-standard characters, the reported error message will be received when attempting to configure the database connection via DBConfig.exe.

Examples: C:\Program Files (x86)\Primavera\Project Management\PM.exe OR C:\Program Files (x86)\Oracle\Primavera P6\P6 Professional\PM.exe

To correct this issue, perform the following steps:

Copy the entire “Primavera” or “Oracle” folder (depending on the P6 version) from the original location.

Examples: C:\Program Files (x86)\Primavera OR C:\Program Files (x86)\Oracle
Paste it to the root of C:\.
Launch the PM.exe from the new location
Examples: C:\Primavera\Project Management\PM.exe. OR C:\Oracle\Primavera P6\P6 Professional\PM.exe
Re-create any shortcuts to PM.exe to reflect the new location.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )