ora-06413 connection not open error with Toad

Follow / 4 Jun 2010 at 12:36am
tnsnames.ora
ora-06413 connection not open error with Toad 10.5.0.41 while connecting to Oracle XE

Hi,

I've installed Oracle XE and Toad 10.5.0.41 on Windows Vista. I am able to connect to database from the command line interface provided by Oracle. But when connecting from  TOAD i am getting ora-06413 connection not open error.

Refer to my tnsnames.ora file attached.

Please help me resolve this problem.

tnsnames.ora

Replies

  • Follow / 4 Jun 2010 at 12:41am

    Is polani-PC defined in your Windows hosts file ?

  • Follow / 4 Jun 2010 at 1:18am

    Hi,

    Thanks for the quick response!

    I tried adding it to hosts file, but no luck :-(

    Regards,
    Jyothi

  • Follow / 4 Jun 2010 at 1:18am

    You might try making that hosts entry read

    127.0.0.1             
    polani-PC                   localhost

  • Follow / 7 Jun 2010 at 1:08am

    I've added host name to hosts file as you suggested. But that didn't resolve my problem. Any other suggestions?

  • Follow / 15 Jun 2010 at 11:23pm

    Finaylly, I had to install TOAD for Oracle base edition to come out of this problem.

    Thanks,
    Jyothi