Knowledge Article 61710

Return
  • Title

    Connection, "Can't initialize OCI. Error -1" on 64-bit operating system with 32-bit client
  • Description

    When trying to connect to a database using Toad for Oracle on a Windows 7 64-bit or Windows Server 2003 2008 64-bit operating system, the following error occurs:

    Can't initialize OCI. Error -1

    The Oracle client installed is a 32-bit Oracle client.

  • Resolution

    RESOLUTION 1:
    Right-click the Toad for Oracle shortcut and select "Run as Administrator" to avoid the error.

    RESOLUTION 2:
    Right-click the Toad for Oracle shortcut | Properties | Compatibility Tab | check mark "Run this program in compatibility mode for" | choose "Windows XP Service Pack 3" from the drop-down list.

    RESOLUTION 3:
    Right-click My Computer | Properties | Advanced tab | Environment Variables | under ‘System Variables’ (lower part) | check if you have an entry for ORACLE_HOME. If yes, rename it to ORACLE_HOME_OLD, and then re-test the issue.

    RESOLUTION 4:
    Upgrade your Oracle client to a version that is 10.2.0.4 or later, preferably 11g.

    RESOLUTION 5:
    Uninstall your Toad and re-install in  'C:\Quest Software\'  instead of the default folder location.

  • Additional Information

    For other common Oracle connection problems in Toad for Oracle 10.5 and above, please review SOL64853

Product(s):
Toad for Oracle
9.7.2, 9.6.1, 8.6.1, 7.6.0.1, 12.0, 11.6.1, 10.6.1

Topic(s):
Technical Solutions

Article History:
Created on: 3/19/2010
Last Update on: 7/3/2013

Feedback submitted.

Did this article help?

[Select Rating]

Thank you for your rating!

Close

Request or Create a KB Article »