This discussion is archived
13 Replies Latest reply: Jul 1, 2012 12:28 PM by 946857 RSS

Oracle Instant Client installation

S S K Newbie
Currently Being Moderated
Hi All,

What is the difference between installing oracle instant client using OUI(as part of oracle client) and download only Oracle instant client zip , extract in one folder.

OCCI Application working fine when I installed oracle client through OUI, but it is not working for other case.

Could you please tell me what is the exact difference.

Thanks
SK
  • 1. Re: Oracle Instant Client installation
    HuaMin Chen Pro
    Currently Being Moderated
    Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle.
  • 2. Re: Oracle Instant Client installation
    S S K Newbie
    Currently Being Moderated
    Thank you very much.

    Application working fine with Oracle Instant client but I installed Oracle client using OUI , Option of Oracle client installation.

    Where as if I download Oracle instant client zip and extract application is not working.

    Is there any difference installing Instant client with OUI and zip file.?
  • 3. Re: Oracle Instant Client installation
    HuaMin Chen Pro
    Currently Being Moderated
    Did you try with 64-bit version? I suggest you try 32-bit version instead.
  • 4. Re: Oracle Instant Client installation
    S S K Newbie
    Currently Being Moderated
    32 Bit, Windows XP-SP3 OS , 11.2.0.2 Instant Client.

    Edited by: S S K on Jun 7, 2012 1:33 AM
  • 5. Re: Oracle Instant Client installation
    HuaMin Chen Pro
    Currently Being Moderated
    Can you try 10 Instant client like

    instantclient-basic-win32-10.2.0.5.zip (34,846,661 bytes)

    in your Win XP? Thanks

    Edited by: HuaMin Chen on Jun 7, 2012 4:48 PM
  • 6. Re: Oracle Instant Client installation
    942233 Newbie
    Currently Being Moderated
    I tried with 10.2.0.5 Instant Client. But there is no luck.

    Still I am wondering If I install Oracle Instant Client with OUI application working fine.. but if I download only Instant client zip from OTN and unzip ( Set the path and TNS_ADMIN) application not able to connect.
  • 7. Re: Oracle Instant Client installation
    LaurenzAlbe Journeyer
    Currently Being Moderated
    It must be a setup problem of some kind.

    Could you detail how it "is not working"?
    What you do, exact error messages and the like.

    What Oracle software is installed on the machine?
    What are the values of the environment variables ORACLE_HOME, TNS_ADMIN, LDAP_ADMIN, NLS_* and ORA_*?
    What other software is used?

    Yours,
    Laurenz Albe
  • 8. Re: Oracle Instant Client installation
    942233 Newbie
    Currently Being Moderated
    Hi,

    Thank you very much for response.

    SW Details : Oracle 11.2.0.2 Instant client.zip for windows xp-sp3 -- With its not working
    Oracle 11.2.0.2 Client OUI using If I install Instant Client - it is working

    ORACLE_HOME = F:\app\oracle\instantclient_11_2 (not required for Oracle Instant Client)
    path = F:\app\oracle\instantclient_11_2 (added in path)
    TNS_ADMIN = F:\app\oracle\instantclient_11_2


    I am unable to execute my OCCI application in a target system.

    I have done the following deployment steps in the target system.
    1) Downloaded "Oracle Instant Client Basic" and "SQLPlus" packages.
    2) Added the unzipped location to the system PATH variable.
    3) I am able to connect Oracle Server Database using "sqlplus" command.

    Problem:
    While executing my OCCI application, the oracle environment is not creating. It is giving exception with junk error codes.

    "Unable to Create Oracle Environment, *└±↕"*

    Code:
    bool CConnection::CreateEnvironment()
    {
         try{
              /* create oracle environment */
              m_oOracleEnvironment = oracle::occi::Environment::createEnvironment(oracle::occi::Environment::DEFAULT);
         }catch(oracle::occi::SQLException &e){
              m_StrError = "Unable to Create Oracle Environment, ";
              m_StrError += e.getMessage();
              return false;
         }
         return true;
    }

    Note: When i am installing "Instant Client" package from the Oracle Client UI setup, it is working fine.
  • 9. Re: Oracle Instant Client installation
    LaurenzAlbe Journeyer
    Currently Being Moderated
    This could be an environment variable problem.

    Could you post all anvironment variables at the time the code is executed?

    Also, when you get the error with the Instant Client from the ZIP file, is the other Instant Client or any other Oracle software still installed? If yes, where?

    Yours,
    Laurenz Albe
  • 10. Re: Oracle Instant Client installation
    942233 Newbie
    Currently Being Moderated
    Please find below all env details


    ALLUSERSPROFILE=C:\Documents and Settings\All Users
    APPDATA=C:\Documents and Settings\Administrator\Application Data
    CLASSPATH=C:\Program Files\Oracle\Berkeley DB 11gR2 5.3.15\jar\db.jar;C:\Program Files\Oracle\Berkeley DB 11gR2 5.3.15\jar\jdbc.jar
    CLIENTNAME=Console
    CommonProgramFiles=C:\Program Files\Common Files
    COMPUTERNAME=KRISHNAR
    ComSpec=C:\WINDOWS\system32\cmd.exe
    DIALOGICDIR=C:\Program Files
    DIALOGICDRV=C:
    DIALOGIC_CFG_INTERNAL=C:\Program Files\Dialogic\HMP\cfg
    DIALOGIC_FWL_BIN=C:\Program Files\Dialogic\HMP\data
    DIALOGIC_USERDATA_DIR=C:\Program Files\Dialogic\HMP
    DLCFGPATH=C:\Program Files\Dialogic\HMP\cfg
    DLFWLPATH=C:\Program Files\Dialogic\HMP\data
    DLGCDESTDIR=C:
    DLG_TRACE_LEVEL=2
    DLINFPATH=C:\Program Files\Dialogic\HMP\inf
    DNASDKDIR=C:\Program Files\Dialogic\HMP\bin
    FP_NO_HOST_CHECK=NO
    HOMEDRIVE=C:
    HOMEPATH=\Documents and Settings\Administrator
    include=C:\Program Files\Microsoft Visual Studio\VC98\atl\include;C:\Program Files\Microsoft Visual Studio\VC98\mfc\include;C:\Program Files\Microsoft Visual Studio\VC98\include
    INTEL_DIALOGIC_BASE=C:\Program Files
    INTEL_DIALOGIC_BIN=C:\Program Files\Dialogic\HMP\bin
    INTEL_DIALOGIC_CFG=C:\Program Files\Dialogic\HMP\cfg
    INTEL_DIALOGIC_DIR=C:\Program Files\Dialogic\HMP
    INTEL_DIALOGIC_FWL=C:\Program Files\Dialogic\HMP\data
    INTEL_DIALOGIC_INC=C:\Program Files\Dialogic\HMP\inc
    INTEL_DIALOGIC_LIB=C:\Program Files\Dialogic\HMP\lib
    INTEL_DIALOGIC_NAME=Dialogic\HMP
    INTEL_DIALOGIC_QSCRIPT=C:\Program Files\Dialogic\HMP\qscript
    INTEL_DIALOGIC_SUPPORTED_TECH=4
    lib=C:\Program Files\Microsoft Visual Studio\VC98\mfc\lib;C:\Program Files\Microsoft Visual Studio\VC98\lib
    LOGONSERVER=\\KRISHNAR
    NSSSVRSDK=C:\Program Files\Nuance\Speech Server\Server
    NUANCE_LICMGR=C:\Program Files\Nuance\license_manager\
    NUANCE_VERSION=C:\PROGRA~1\COMMON~1\NUANCE~1
    NUMBER_OF_PROCESSORS=4
    ORACLE_HOME=F:\praveen\oracle\instantclient_11_2
    ORBACUS_CONFIG=C:\Program Files\Dialogic\HMP\cfg\dlgadmin.config
    OS=Windows_NT
    Path=F:\praveen\oracle\instantclient_10_2;C:\Program Files\Dialogic\HMP\bin;C:\Program Files\Dialogic\HMP\lib;C:\Program Files\Dialogic\HMP\ooc\bin;C:\Program Files\Dialogic\HMP\ooc\lib;C:\Program Files\Nuance\Speech Server\Server\bin;C:\Program Files\Nuance\Nuance Vocalizer for Network 5.0\common\speech\components;C:\Program Files\Common Files\SpeechWorks\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\DMIX;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\TortoiseSVN\bin;C:\PROGRA~1\COMMON~1\NUANCE~1\bin;C:\Program Files\Oracle\Berkeley DB 11gR2 5.3.15\bin;C:\Program Files\Microsoft Visual Studio\Common\Tools\WinNT;C:\Program Files\Microsoft Visual Studio\Common\MSDev98\Bin;C:\Program Files\Microsoft Visual Studio\Common\Tools;C:\Program Files\Microsoft Visual Studio\VC98\bin
    PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
    PROCESSOR_ARCHITECTURE=x86
    PROCESSOR_IDENTIFIER=x86 Family 6 Model 37 Stepping 5, GenuineIntel
    PROCESSOR_LEVEL=6
    PROCESSOR_REVISION=2505
    ProgramFiles=C:\Program Files
    PROMPT=$P$G
    QSCRIPT_DIR=C:\Program Files\Dialogic\HMP\qscript
    SESSIONNAME=RDP-Tcp#1
    SystemDrive=C:
    SystemRoot=C:\WINDOWS
    TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
    TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
    TNS_ADMIN=F:\praveen\oracle\instantclient_10_2
    USERDOMAIN=KRISHNAR
    USERNAME=Administrator
    USERPROFILE=C:\Documents and Settings\Administrator
    VNETWORKV5_SDK=C:\Program Files\Nuance\Nuance Vocalizer for Network 5.0\
    VS80COMNTOOLS=C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\
    windir=C:\WINDOWS
  • 11. Re: Oracle Instant Client installation
    LaurenzAlbe Journeyer
    Currently Being Moderated
    Hm, that looks ok.

    No idea what might be the problem, but I am fairly certain it is a setup problem.

    Yours,
    Laurenz Albe
  • 12. Re: Oracle Instant Client installation
    942233 Newbie
    Currently Being Moderated
    Yes.. I too agree with you but not able to figure out where is the exact issue..
  • 13. Re: Oracle Instant Client installation
    946857 Newbie
    Currently Being Moderated
    What download did you have to install the Instant Client using the OUI? Have yet get the Instant Client installed at all, using OUI or not. Any help would be appreciated.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points