IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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.
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 locationExamples: 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 )
