13 Replies Latest reply: Jul 1, 2012 2:28 PM by 946857 RSS

    Oracle Instant Client installation

    S S K
      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
          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
            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
              Did you try with 64-bit version? I suggest you try 32-bit version instead.
              • 4. Re: Oracle Instant Client installation
                S S K
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                Yes.. I too agree with you but not able to figure out where is the exact issue..
                                • 13. Re: Oracle Instant Client installation
                                  946857
                                  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.