Toad World® Forums

Can't initialize OCI. Error -1


#1

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

  1. Added ocidll=C:\oracle\product\10.2.0\db_1\BIN\oraclient10.dll parameter to startup, in the shortcut of the Toad.
  2. 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

  1. Added ocidll=C:\oracle\product\10.2.0\db_1\BIN\oraclient10.dll parameter to
    startup, in the shortcut of the Toad.

  2. 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…

--static--bg_bouquetpink_1.gif


#2

Hi Vicky,

Can’t initialize OCI. Error -1

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


#3

#4

Thanks for the quick reply, Yes I’m using 64 bit windows…

And I installed Oracle 10g with the same installer which I used on 32 bit
Windows XP.

Can you please let me know what steps I need to take so that Toad could work in
this env.

Vicky…


#5

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 ….


#6

Yea seems the same issue… but at time of oracle installation it didn’t ask me
about which version need to install… I guess its done automatically…

So can you suggest me the way

  1. How to find which version of oracle (32 bit or 64bit) is installed on my
    machine.

  2. How can I move to 32 bit version in a scenario where oracle installer doesn’t
    ask anything about this.

Vicky…


#7

Hi Vicky,

Can’t initialize OCI. Error -1

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…

Rich – [TeamT]

Disclaimer: I own a “Toyota”, not a “Toyoda”.


#8

I did write a blog on toad world about connection problems which covers this
scenario:

http://www.toadworld.com/BLOGS/tabid/67/EntryID/488/Default.aspx

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.


#9

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 ….


#10

Try to execute the “tnsping” command on the command prompt to see the version (32 bit or 64bit) installed on the machine.

Karthi


#11

Karthi,

Here is the solution:

http://www.dbmotive.com/oracle_howto.php?howto=5

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.

Happy coding:)

-Matthew


#12

Or you can actually do more than simply unzipping the instant client –
which the instant client docs spell out:

You need to perform two other steps with instant client install: