Topic
11 replies Latest Post - ‏2014-02-25T13:09:35Z by R2HJ_Robert_Phillips
SystemAdmin
SystemAdmin
304 Posts
ACCEPTED ANSWER

Pinned topic External Code:20 Win32 Open Failed

‏2010-05-20T18:03:50Z |
Hi,
I'm installing a fresh Optim 7.2.1 and face this issue when I'm trying to configuring my first workstation with an Oracle remote server:
1) I entered "OPTIMDIR" as my optim directory name
2) I specified my DBMS Specifications

Type: ORACLE
Version: 10.2

3) I selected the following Option:

"Keep Optim Directory Data in Unicode Format (UTF-8)

4) I checked the check box called "I Acknowledge the DBMS Character Set Requirements"

5) I typed the Database connection parameters correctly (user, passw & Connection String)
6.- Finally I clicked on the "Proceed" button in order that optim configuration program creates the Packages the must use to access the Optim Directory Tables.
Configuration starting - 05/20/10 12:25:42 . Build 3125.
Configure the First Workstation
Starting the Configure First Workstation process.
The Specify Product License function was successful.
The Specify Optim Directory function was successful.
The Specify Optim Directory DBMS function was successful.
The Specify Character Set of Optim Directory Data was acknowledged.
The Information on Unicode Format (UTF-8) for an Optim Directory was acknowledged.
Connection to database 9.7.84.146:1521/ORCL successful for user OPTIM.
The Connect to the Oracle Optim Directory OPTIMDIR function was successful.
The Create Optim Directory function was successful.
Procedures in file SP\ORA073\DSSCRAUP.SQL created.
Procedures in file SP\ORA073\DSSCRAUP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAUB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAVP.SQL created.
Procedures in file SP\ORA073\DSSCRAVP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAVB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAWP.SQL created.
Procedures in file SP\ORA073\DSSCRAWP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAWB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRCLP.SQL created.
Procedures in file SP\ORA073\DSSCRCLP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRCLB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRDBP.SQL created.
Procedures in file SP\ORA073\DSSCRDBP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRDBB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCROBP.SQL created.
Procedures in file SP\ORA073\DSSCROBP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCROBB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPKP.SQL created.
Procedures in file SP\ORA073\DSSCRPKP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPKB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPTP.SQL created.
Procedures in file SP\ORA073\DSSCRPTP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPTB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRREP.SQL created.
Procedures in file SP\ORA073\DSSCRREP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRREB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRSCP.SQL created.
Procedures in file SP\ORA073\DSSCRSCP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRSCB.SQL created.
Transaction committed.
The Create/Drop Packages for the Optim Directory function was successful.
Database 9.7.84.146:1521/ORCL successfully disconnected.
Unexpected response from internal component, RC:-1
External Code:20 Win32 Open Failed
The Write Signature Record to the Optim Directory OPTIMDIR function failed.

Configure the First Workstation
Starting the Configure First Workstation process.
The Specify Product License function was successful.
The Specify Optim Directory function was successful.
The Specify Optim Directory DBMS function was successful.
The Specify Character Set of Optim Directory Data was acknowledged.
The Information on Unicode Format (UTF-8) for an Optim Directory was acknowledged.
Connection to database 9.7.84.146:1521/ORCL successful for user OPTIM.
The Connect to the Oracle Optim Directory OPTIMDIR function was successful.
The Create Optim Directory function was successful.
Procedures in file SP\ORA073\DSSCRAUP.SQL created.
Procedures in file SP\ORA073\DSSCRAUP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAUB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAVP.SQL created.
Procedures in file SP\ORA073\DSSCRAVP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAVB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAWP.SQL created.
Procedures in file SP\ORA073\DSSCRAWP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAWB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRCLP.SQL created.
Procedures in file SP\ORA073\DSSCRCLP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRCLB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRDBP.SQL created.
Procedures in file SP\ORA073\DSSCRDBP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRDBB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCROBP.SQL created.
Procedures in file SP\ORA073\DSSCROBP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCROBB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPKP.SQL created.
Procedures in file SP\ORA073\DSSCRPKP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPKB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPTP.SQL created.
Procedures in file SP\ORA073\DSSCRPTP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPTB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRREP.SQL created.
Procedures in file SP\ORA073\DSSCRREP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRREB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRSCP.SQL created.
Procedures in file SP\ORA073\DSSCRSCP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRSCB.SQL created.
Transaction committed.
The Create/Drop Packages for the Optim Directory function was successful.
Database 9.7.84.146:1521/ORCL successfully disconnected.
Unexpected response from internal component, RC:-1
External Code:20 Win32 Open Failed
The Write Signature Record to the Optim Directory OPTIMDIR function failed.

Configure the First Workstation
Starting the Configure First Workstation process.
The Specify Product License function was successful.
The Specify Optim Directory function was successful.
The Specify Optim Directory DBMS function was successful.
The Specify Character Set of Optim Directory Data was acknowledged.
The Information on Unicode Format (UTF-8) for an Optim Directory was acknowledged.
Connection to database 9.7.84.146:1521/ORCL successful for user OPTIM.
The Connect to the Oracle Optim Directory OPTIMDIR function was successful.
The Create Optim Directory function was successful.
Procedures in file SP\ORA073\DSSCRAUP.SQL created.
Procedures in file SP\ORA073\DSSCRAUP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAUB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAVP.SQL created.
Procedures in file SP\ORA073\DSSCRAVP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAVB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAWP.SQL created.
Procedures in file SP\ORA073\DSSCRAWP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAWB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRCLP.SQL created.
Procedures in file SP\ORA073\DSSCRCLP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRCLB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRDBP.SQL created.
Procedures in file SP\ORA073\DSSCRDBP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRDBB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCROBP.SQL created.
Procedures in file SP\ORA073\DSSCROBP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCROBB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPKP.SQL created.
Procedures in file SP\ORA073\DSSCRPKP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPKB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPTP.SQL created.
Procedures in file SP\ORA073\DSSCRPTP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPTB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRREP.SQL created.
Procedures in file SP\ORA073\DSSCRREP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRREB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRSCP.SQL created.
Procedures in file SP\ORA073\DSSCRSCP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRSCB.SQL created.
Transaction committed.
The Create/Drop Packages for the Optim Directory function was successful.
Database 9.7.84.146:1521/ORCL successfully disconnected.
Unexpected response from internal component, RC:-1
External Code:20 Win32 Open Failed
The Write Signature Record to the Optim Directory OPTIMDIR function failed.

Configure the First Workstation
Starting the Configure First Workstation process.
The Specify Product License function was successful.
The Specify Optim Directory function was successful.
The Specify Optim Directory DBMS function was successful.
The Specify Character Set of Optim Directory Data was acknowledged.
The Information on Unicode Format (UTF-8) for an Optim Directory was acknowledged.
Connection to database 9.7.84.146:1521/ORCL successful for user OPTIM.
The Connect to the Oracle Optim Directory OPTIMDIR function was successful.
The Create Optim Directory function was successful.
Procedures in file SP\ORA073\DSSCRAUP.SQL created.
Procedures in file SP\ORA073\DSSCRAUP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAUB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAVP.SQL created.
Procedures in file SP\ORA073\DSSCRAVP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAVB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAWP.SQL created.
Procedures in file SP\ORA073\DSSCRAWP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRAWB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRCLP.SQL created.
Procedures in file SP\ORA073\DSSCRCLP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRCLB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRDBP.SQL created.
Procedures in file SP\ORA073\DSSCRDBP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRDBB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCROBP.SQL created.
Procedures in file SP\ORA073\DSSCROBP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCROBB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPKP.SQL created.
Procedures in file SP\ORA073\DSSCRPKP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPKB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPTP.SQL created.
Procedures in file SP\ORA073\DSSCRPTP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRPTB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRREP.SQL created.
Procedures in file SP\ORA073\DSSCRREP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRREB.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRSCP.SQL created.
Procedures in file SP\ORA073\DSSCRSCP.SQL created.
Transaction committed.
Procedures in file SP\ORA073\DSSCRSCB.SQL created.
Transaction committed.
The Create/Drop Packages for the Optim Directory function was successful.
Database 9.7.84.146:1521/ORCL successfully disconnected.
Unexpected response from internal component, RC:-1
External Code:20 Win32 Open Failed
The Write Signature Record to the Optim Directory OPTIMDIR function failed.
can anyone help with this problem?
Updated on 2012-08-28T19:13:10Z at 2012-08-28T19:13:10Z by deaoptim
  • LMDBA
    LMDBA
    1 Post
    ACCEPTED ANSWER

    Re: External Code:20 Win32 Open Failed

    ‏2010-07-14T19:41:39Z  in response to SystemAdmin
    Did you solve this? I'm having the same problem.
  • santoshsk
    santoshsk
    6 Posts
    ACCEPTED ANSWER

    Re: External Code:20 Win32 Open Failed

    ‏2011-11-25T03:52:33Z  in response to SystemAdmin
    The thread is quite old, but thought of sharing my problem as well.
    Me too facing similar issue. In fact i tried to create DB character set with UTF8 and ASCII, in both cases error is same.

    Unexpected response from internal component, RC:-1
    External Code:20 Win32 Open Failed
    The Write Signature Record to the Optim Directory OPTIMDIR function failed.

    It would be great if someone can help on this..The OS and DB is - windows xp and oracle 10g (10.1.0.2)
    • SystemAdmin
      SystemAdmin
      304 Posts
      ACCEPTED ANSWER

      Re: External Code:20 Win32 Open Failed

      ‏2012-08-08T18:31:37Z  in response to santoshsk
      Can you please attach the Optim trace file. You can find this file either in the Optim configured Temp folder or in windows temp( %TEMP% ) folder.
      • SystemAdmin
        SystemAdmin
        304 Posts
        ACCEPTED ANSWER

        Re: External Code:20 Win32 Open Failed

        ‏2012-08-14T16:58:20Z  in response to SystemAdmin
        Please look at the attached trace file.
        • deaoptim
          deaoptim
          1 Post
          ACCEPTED ANSWER

          Re: External Code:20 Win32 Open Failed

          ‏2012-08-28T19:13:10Z  in response to SystemAdmin
          Based on your log, Optim is looking for the following file which it either can't find or cannot access: c:\Oracle\Ora92\bin\oracle.key

          Perhaps re-installing the full oracle client will clear this up for you.
  • ezrarze
    ezrarze
    1 Post
    ACCEPTED ANSWER

    Re: External Code:20 Win32 Open Failed

    ‏2012-01-05T16:17:41Z  in response to SystemAdmin
    I get the same error as well after installing Optim 7.3.1. The install completes successfully, but every time I start Optim I get the error:
    Unexpected response from internal component, RC:-1
    External Code:20 Win32 Open Failed

    I am running Windows 7.
    • KaoriN
      KaoriN
      5 Posts
      ACCEPTED ANSWER

      Re: External Code:20 Win32 Open Failed

      ‏2012-01-06T02:14:04Z  in response to ezrarze
      Hi Ezra,

      It looks Optim fails to write Windows registry. You need to start Optim via "Run as Administrator" context menu.

      Thanks,
      Kaori
    • NGura
      NGura
      2 Posts
      ACCEPTED ANSWER

      Re: External Code:20 Win32 Open Failed

      ‏2014-02-24T21:37:20Z  in response to ezrarze

      We're you able to get this resolved? I am also have this issue when Configuring the First Workstation:

       

      Configuration starting - 02/24/14  15:33:41 . Build 3638.
      [Configure the First Workstation]
      Starting the Configure First Workstation process.
      The Specify Product License function was successful.
      The Specify Optim Directory function was successful.
      The Specify Optim Directory DBMS function was successful.
      The Specify Character Set of Optim Directory Data was acknowledged.
      The Information on Unicode Format (UTF-8) for an Optim Directory was acknowledged.
      Connection to database sbsp11 successful for user OPTM.
      The Connect to the Oracle Optim Directory OPTIMDIR function was successful.
      The Create Optim Directory function was successful.
      Procedures in file SP\ORA073\DSSCRAUP.SQL created.
      Procedures in file SP\ORA073\DSSCRAUP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAUB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAVP.SQL created.
      Procedures in file SP\ORA073\DSSCRAVP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAVB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAWP.SQL created.
      Procedures in file SP\ORA073\DSSCRAWP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAWB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRCLP.SQL created.
      Procedures in file SP\ORA073\DSSCRCLP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRCLB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRDBP.SQL created.
      Procedures in file SP\ORA073\DSSCRDBP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRDBB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCROBP.SQL created.
      Procedures in file SP\ORA073\DSSCROBP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCROBB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRPKP.SQL created.
      Procedures in file SP\ORA073\DSSCRPKP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRPKB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRPTP.SQL created.
      Procedures in file SP\ORA073\DSSCRPTP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRPTB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRREP.SQL created.
      Procedures in file SP\ORA073\DSSCRREP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRREB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRSCP.SQL created.
      Procedures in file SP\ORA073\DSSCRSCP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRSCB.SQL created.
      Transaction committed.
      The Create/Drop Packages for the Optim Directory function was successful.
      Database sbsp11 successfully disconnected.
      Unexpected response from internal component, RC:-1
      External Code:20 Win32 Open Failed
      The Write Signature Record to the Optim Directory OPTIMDIR function failed.

    • NGura
      NGura
      2 Posts
      ACCEPTED ANSWER

      Re: External Code:20 Win32 Open Failed

      ‏2014-02-24T21:56:13Z  in response to ezrarze

      I know this is an old issue, but I am also having this issue:

      Configuration starting - 02/24/14  15:33:41 . Build 3638.
      [Configure the First Workstation]
      Starting the Configure First Workstation process.
      The Specify Product License function was successful.
      The Specify Optim Directory function was successful.
      The Specify Optim Directory DBMS function was successful.
      The Specify Character Set of Optim Directory Data was acknowledged.
      The Information on Unicode Format (UTF-8) for an Optim Directory was acknowledged.
      Connection to database sbsp11 successful for user OPTM.
      The Connect to the Oracle Optim Directory OPTIMDIR function was successful.
      The Create Optim Directory function was successful.
      Procedures in file SP\ORA073\DSSCRAUP.SQL created.
      Procedures in file SP\ORA073\DSSCRAUP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAUB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAVP.SQL created.
      Procedures in file SP\ORA073\DSSCRAVP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAVB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAWP.SQL created.
      Procedures in file SP\ORA073\DSSCRAWP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRAWB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRCLP.SQL created.
      Procedures in file SP\ORA073\DSSCRCLP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRCLB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRDBP.SQL created.
      Procedures in file SP\ORA073\DSSCRDBP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRDBB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCROBP.SQL created.
      Procedures in file SP\ORA073\DSSCROBP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCROBB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRPKP.SQL created.
      Procedures in file SP\ORA073\DSSCRPKP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRPKB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRPTP.SQL created.
      Procedures in file SP\ORA073\DSSCRPTP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRPTB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRREP.SQL created.
      Procedures in file SP\ORA073\DSSCRREP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRREB.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRSCP.SQL created.
      Procedures in file SP\ORA073\DSSCRSCP.SQL created.
      Transaction committed.
      Procedures in file SP\ORA073\DSSCRSCB.SQL created.
      Transaction committed.
      The Create/Drop Packages for the Optim Directory function was successful.
      Database sbsp11 successfully disconnected.
      Unexpected response from internal component, RC:-1
      External Code:20 Win32 Open Failed
      The Write Signature Record to the Optim Directory OPTIMDIR function failed.

  • SystemAdmin
    SystemAdmin
    304 Posts
    ACCEPTED ANSWER

    Re: External Code:20 Win32 Open Failed

    ‏2012-08-08T14:13:32Z  in response to SystemAdmin
    First thing you should do is look at the trace file in folder IBM Optim\Temp and look for an error message just preceding 'Win32 Open Failed' error message. In my case it was complaining about c:\Oracle\Ora92\bin\oracle.key file. When I tried to access this file in windows explorer, I found that I don't have access to the folder c:\Oracle\Ora92. Once I got access to this folder 'Win32 Open Failed' error went away.
  • R2HJ_Robert_Phillips
    5 Posts
    ACCEPTED ANSWER

    Re: External Code:20 Win32 Open Failed

    ‏2014-02-25T13:09:35Z  in response to SystemAdmin

    As SystemAdmin noted, lack of access to the Oracle installation folder can cause a problem.

    Optim is looking for the current Oracle character set, which looks something like this: AMERICAN_AMERICA.WE8ISO8859P1

    Oracle has changed the way it stores information regarding the arrangement of the Oracle installation folder in many releases, so there are a number of permutations that are checked.

     

    The easiest way to bypass this problem is to set an environment variable, NLS_LANG to the current Oracle character set (assuming you know it).

    For the character set above, the Windows command would be:

    set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

    Add this to your Windows environment before running Optim or the Optim Configuration program, and you should experience no problems.