Home » Other » Client Tools » "ORA-06413: Connection not open" error Oracle on 64-bit windows (11g R2,)
"ORA-06413: Connection not open" error Oracle on 64-bit windows [message #589835] Thu, 11 July 2013 05:23 Go to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

I have newly installed Oracle 11g R2 64 bits to window 8 PRo 64 bits.
Able to connection successfully Oracle NEt Configuration Assistant service name.

But when I try to connect it Toad 9.6 32 bits its show error message
ORA-06413: Connection not open


Please guide and help.

Thanks
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #589836 is a reply to message #589835] Thu, 11 July 2013 05:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-06413: Connection not open.
 *Cause:  Unable to establish connection.
 *Action: Use diagnostic procedures to ascertain exact problem.

Can you connect with SQL*Plus?

Regards
Michel
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #589837 is a reply to message #589836] Thu, 11 July 2013 05:41 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

Yes I can connect through SQL*plus.
Please what I step i have to follow.?

Thanks

[Updated on: Thu, 11 July 2013 05:59]

Report message to a moderator

Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #589842 is a reply to message #589837] Thu, 11 July 2013 06:19 Go to previous messageGo to next message
cookiemonster
Messages: 13915
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'm pretty sure your version of toad isn't compatible with 64 bit oracle.
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #590272 is a reply to message #589842] Tue, 16 July 2013 09:08 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
Toad 12 is out with support for win 8
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #594343 is a reply to message #590272] Tue, 27 August 2013 11:40 Go to previous messageGo to next message
usuariodenews
Messages: 1
Registered: August 2013
Junior Member
For Windows 7 , 64 bit edition; the solution is simple; copy this (Toad for Oracle 10.6) from here: C:\Program Files (x86)\Quest Software\Toad for Oracle 10.6 and move it to here or your preferable directory: C:\Program Files\Quest Software\Toad for Oracle 10.6
And then run toad.exe;
And it will work.
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #604324 is a reply to message #594343] Sat, 28 December 2013 10:09 Go to previous messageGo to next message
oranisman
Messages: 1
Registered: December 2013
Junior Member
worked gracefully! thanks.
icon14.gif  Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #626665 is a reply to message #594343] Thu, 30 October 2014 06:52 Go to previous messageGo to next message
manojpadhyar88
Messages: 1
Registered: July 2013
Location: PUNE
Junior Member
IT'S WORKING...

THANK YOU VERY MUCH.
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #643729 is a reply to message #594343] Fri, 16 October 2015 06:47 Go to previous messageGo to next message
harishns
Messages: 1
Registered: October 2015
Location: Banglore
Junior Member
IT WORKED FOR ME , THANK YOU VERY MUCH

[Updated on: Fri, 16 October 2015 08:14] by Moderator

Report message to a moderator

Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #643733 is a reply to message #594343] Fri, 16 October 2015 08:17 Go to previous messageGo to next message
gazzag
Messages: 1116
Registered: November 2010
Location: Bedwas, UK
Senior Member
Most successful first post ever? Shocked
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #644306 is a reply to message #643733] Tue, 03 November 2015 03:37 Go to previous messageGo to next message
shareef.hiasat
Messages: 4
Registered: November 2012
Location: Jordan
Junior Member

it worked alot of thanks
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #663632 is a reply to message #644306] Mon, 12 June 2017 02:11 Go to previous messageGo to next message
nido143
Messages: 7
Registered: February 2017
Junior Member
i have toad connection problem when I enter database 'locals' user name 'sys' password 'abc' connected as 'SYSDBA' it gives an error ora-06413 connection not open. I have attached the snapshot of error.

kindly suggest me any solution.
  • Attachment: error.JPG
    (Size: 55.60KB, Downloaded 1993 times)

[Updated on: Mon, 12 June 2017 02:13]

Report message to a moderator

Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #663633 is a reply to message #663632] Mon, 12 June 2017 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you read and apply the solution mentioned in this topic?

Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #663634 is a reply to message #663633] Mon, 12 June 2017 02:23 Go to previous messageGo to next message
nido143
Messages: 7
Registered: February 2017
Junior Member
where is solution mentioned?
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #663635 is a reply to message #663634] Mon, 12 June 2017 02:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just before the "thanks" and "it works".

Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #663636 is a reply to message #663635] Mon, 12 June 2017 02:50 Go to previous messageGo to next message
nido143
Messages: 7
Registered: February 2017
Junior Member
I have windows XP.
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #663639 is a reply to message #663636] Mon, 12 June 2017 03:26 Go to previous messageGo to next message
cookiemonster
Messages: 13915
Registered: September 2008
Location: Rainy Manchester
Senior Member
That doesn't necessarily mean the solution won't work. Have you tried it?
Re: "ORA-06413: Connection not open" error Oracle on 64-bit windows [message #663644 is a reply to message #663636] Mon, 12 June 2017 11:21 Go to previous message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
nido143 wrote on Mon, 12 June 2017 09:50
I have windows XP.
And how are we supposed to know that? As well as your TOAD version?

Previous Topic: SDCLI : NullPointerException while converting db from Sql Server to Oracle
Next Topic: sqlpptool SQL logging
Goto Forum:
  


Current Time: Tue Mar 19 06:31:42 CDT 2024