Google IT Solutions: How to solve ora-06413

Thursday 29 May 2014

How to solve ora-06413

Unable to open oracle connection (ora-06413)

Cause:
The problem scenario: some time oracle 10g could not open connection with applications like Microsoft Access, Visual Studio, and ODBC connections etc. Those applications are installed in C:\Program Files (x86). And cause is that oracle do not make connection with such these applications due to parentheses.

Solution:
Here's the real trick to making this all work; Set up a symlink to the c:\Program Files (x86) folder without the parentheses.
Open Command Prompt and "Run as administrator" At the command prompt, enter the following command;

mklink /D "C:\Program Files x86" "C:\Program Files (x86)”



Now to onwards run applications from C:\Program Files x86.

8 comments:

  1. good really it solve my problem thanks

    ReplyDelete
  2. Very good trick,
    Thank you very much
    god bless you

    ReplyDelete
  3. You have got excellent brain. Thank you it works.

    God Bless U.

    ReplyDelete
  4. after doing this while running macro the excel is in not responding mode

    ReplyDelete
  5. I have a better solution here: http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error/33007863#33007863

    ReplyDelete
  6. it not worked plzz give me other solution

    ReplyDelete