Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    76

    Unanswered: ORA-01010: invalid OCI operation

    I have two installations of Oracle 7.3.2.2.1 and am trying to connect them via JDBC (Ojdbc.jar). One installation is getting connected, but another connection throws "ORA-01010: invalid OCI operation". I searched through this forums and google but with no success. Any pointers.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    This is the explanation of the error, but I'm not able to help you any further:
    ORA-01010 invalid OCI operation

    Cause: One of the following:

    You attempted an invalid OCI operation.

    You are using an Oracle client application linked version 7.1, or higher libraries, the environment ORA_ENCRYPT_LOGIN is set to TRUE, and you attempted to connect to a version 7.0, or lower, Oracle Server.

    You are connected to a version 7.1, or higher, Oracle Server, the initialization parameter DBLINK_ENCRYPT_LOGIN is set to TRUE, and you attempted to use a database link pointing to a version 7.0, or lower, Oracle Server.

    Action: For the above causes:

    Do not use the invalid OCI operation.

    If you do not wish to use encrypted connect passwords in your distributed database, set ORA_ENCRYPT_LOGIN to FALSE. If you wish to use encrypted connect passwords, you must upgrade all Oracle Servers to version 7.1, or higher.

    If you do not wish to use encrypted database links in your distributed database, set DBLINK_ENCRYPT_LOGIN to FALSE. If you wish to use encrypted database links, you must upgrade all Oracle Servers to version 7.1, or higher.



    Cause: An attempt was made to use Oracle7 compatibility mode when accessing Oracle Version 6.

    Action: Use V6 SQL language type. You may need to use the SET COMPATIBILITY V6 command.

  3. #3
    Join Date
    Aug 2004
    Posts
    76
    Thanks Littlefoot for your effort. I've already gone through the info but could not extract the jist out of it. I dont not know how to reset the ORA_ENCRYPT_LOGIN and DBLINK_ENCRYPT_LOGIN parameters.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As its name says, "initialization parameter", it might be either in the INIT.ORA or as a key in Windows Registry (if your OS is MS Windows; don't know about other operating systems).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •