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.
very good dear
ReplyDeletegood really it solve my problem thanks
ReplyDeleteI tried, it worked.
ReplyDeleteVery good trick,
ReplyDeleteThank you very much
god bless you
You have got excellent brain. Thank you it works.
ReplyDeleteGod Bless U.
after doing this while running macro the excel is in not responding mode
ReplyDeleteI have a better solution here: http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error/33007863#33007863
ReplyDeleteit not worked plzz give me other solution
ReplyDelete