ORA-06413 Connection not open

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:

  1. 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
  2. Paste it to the root of C:\.
  3. Launch the PM.exe from the new location
    Examples: C:\Primavera\Project Management\PM.exe. OR C:\Oracle\Primavera P6\P6 Professional\PM.exe
  4. 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 )

 

 978 views last month,  4 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply