Hi,
Please help me in resoving the issues I’m facing with Toad.
I’m using Toad ver. 9.0.0.160 for Oracle 10g on Windows 7 Home Premium.
Oracle 10g and Toad both are installed on same machine.
My problem is that after startup of Toad when I try to establish a connection to the oracle it gives me the error
Can’t initialize OCI. Error -1
I did some googleing to resolve this issue and tried following solution
Added ocidll=C:\oracle\product\10.2.0\db_1\BIN\oraclient10.dll parameter to startup, in the shortcut of the Toad.
Added ocidll=C:\oracle\product\10.2.0\db_1\BIN\oci.dll parameter to startup, in the shortcut of the Toad.
I tried with both the options mentioned above seperately, but that couldn’t help.
Can sombody please help me to resolve this issue.
Thanks in Advance.
Vicky…
Hi,
Please help me in resoving the issues I’m facing with Toad.
I’m using Toad ver. 9.0.0.160 for Oracle 10g on Windows 7 Home Premium.
Oracle 10g and Toad both are installed on same machine.
My problem is that after startup of Toad when I try to establish a connection to
the oracle it gives me the error
Can’t initialize OCI. Error -1
I did some googleing to resolve this issue and tried following solution
Added ocidll=C:\oracle\product\10.2.0\db_1\BIN\oraclient10.dll parameter to
startup, in the shortcut of the Toad.
Added ocidll=C:\oracle\product\10.2.0\db_1\BIN\oci.dll parameter to startup,
in the shortcut of the Toad.
I tried with both the options mentioned above seperately, but that couldn’t
help.
that error usually indicates that you are attempting to use Toad with a
64 bit Oracle client. At present, Toad is 32 bit and as such, requires a
32 bit Oracle client.
HTH
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
It does not matter what version of Windows (32 or 64). But you need to verify
that you have installed the 32-bit version of oracle tools. You say it’s the
same as you did on 32-bit XP – then it should simply work. That is no
difference. You will get this error message if you install the 64-bit version of
Oracle tools. Can you please recheck your oracle client install – cause 99%
likely you somehow grabbed the wrong one ….
that error usually indicates that you are attempting to use Toad with a
64 bit Oracle client. At present, Toad is 32 bit and as such, requires a
32 bit Oracle client.
HTH
Cheers,
Norm. [TeamT]
Hmmm...there's nothing on AskToad.com about this. Any takers? I don't have
access to such a client to be able to speak to it myself...
So the key lesson or conclusion to take away from this blog is as follows: TOAD
can connect to Oracle databases and it works 99.99% of the time. If you have a
problem and get some Oracle connection error message, odds are that you have one
of the following problems: a bad SQL*net install, are pointing to the wrong
Oracle Home, have a Windows PATH environment ordering problem, or some other
user setup and configuration problem related to your Windows and/or Oracle home.
When you download the oracle client – you choose which version – not during
install. If it’s off the CD or DVD – it may auto detect – I cannot sat
cause I do not use this method. I always download exactly what I need. The
simple test is easy – where did the oracle get installed – under programs or
programs (86). The latter is the 32-bit version. So if it’s under programs –
then you installed the 64-bit – which won’t work ….
Basically, you have to create a ORACLE_HOME for your instant client.
Hi Dev(s) this is your old Buddy Matthew :). Hey is it possible to add an ER for this in Toad? Perhaps that’s a bit much to have this Environment Variable created on the fly… At least doc’ed in the Release notes? Checked didn’t see it there.
