This discussion is archived
3 Replies Latest reply: Oct 21, 2011 5:44 AM by vasileios RSS

opatch error

Vikash Jain (DBA ) Newbie
Currently Being Moderated
Hi Experts,

i have oracle database lite version 10.3.0.2.0 installed in windows 2003 R2 server.while applying Opatch for 10.3.0.3.0 , i got error. when i checked that opatch applied successfully or not .
when i checked through opatch lsinventory i got the below error..

C:\Documents and Settings\Administrator>SET PERL_HOME= D:\oracle\product\10.2.0\db_1

C:\Documents and Settings\Administrator>set PATH=%PERL_HOME%\perl\*5.8.3*\bin\MSWin32-x86-multi-thread;%PATH%

C:\Documents and Settings\Administrator>set PERL5LIB=D:\oracle\product\10.2.0\db_1\perl\*5.8.3*\lib;D:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86-multi-thread

C:\Documents and Settings\Administrator>set ORACLE_HOME=D:\Olite10g_1

C:\Documents and Settings\Administrator>D:

D:\>CD Olite10g_1
D:\Olite10g_1>CD OPatch
D:\Olite10g_1\OPatch>opatch lsinventory

"OPatch could not detect Perl. Please set PERL5LIB appropriately and invoke Perl."
"OPatch is certified with Perl Version 5.6.1."
"Invoke OPatch manually using the following command format:"
" <path to Perl>/perl <path to OPatch>/opatch.pl <patch command> [options]"
"You can use the following command format to view help information:"
" <path to Perl>/perl <path to OPatch>/opatch.pl [<patch command>] -help"


OPatch returns with error code = 1

D:\Olite10g_1\OPatch>


please any one help me to resolve this issue.

Thanks and regards,
Vikash Chauradia(Junir DBA)
  • 1. Re: opatch error
    vasileios Explorer
    Currently Being Moderated
    first of all i have the impression that if you have 10.3.0.2.0 you must install patches for that version and not for 10.3.3.0. it might work installing one but it might give you errors, better is that you upgrade your olite and then install the patches.

    concerning you error i see that opatch cant find perl. check where perl is installed .mine is in for example
    C:\app\Administrator\product\11.1.0\db_1\perl\5.8.3\bin\MSWin32-x86-multi-thread (im also using win 2003 server). add that to the path environmental variable (might need server restart to take effect). then you should be just fine

    your path D:\oracle\product\10.2.0\db_1\perl\*5.8.3*\lib;D:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86-multi-thread is valid? does it have perl there? set it to the path variable not perl_home
    let me know if it works
  • 2. Re: opatch error
    Vikash Jain (DBA ) Newbie
    Currently Being Moderated
    thanks for replying ..

    i tried as you mentioned bt same error i m getting.
    is there any other way to find , what are the patches applied so far ?
  • 3. Re: opatch error
    vasileios Explorer
    Currently Being Moderated
    from oracle support
    for 10.3.0.3 tha patches so far are:

         Patch Name      Description      Release      Platform (Language)      Classification      Product/Family      Updated      Size
    1.      13063865      103030 CONSOLIDATED CAB ONEOFF FOR CUSTOMER BUGS TILL OCT 05 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Oct 11, 2011      405.1 MB
    2.      13063589      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL OCT 05 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Oct 11, 2011      136.8 MB
    3.      12812978      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JULY 29 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Aug 1, 2011      136.5 MB
    4.      12677282      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JUNE 21 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Jun 21, 2011      136.1 MB
    5.      12332599      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL APRIL 7 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Apr 8, 2011      136.1 MB
    6.      11880517      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL MARCH 17 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Mar 21, 2011      136.1 MB
    7.      11671293      PATCH TO SUPPORT BDB CLIENT ON TOP OF 10.3.0.3.0 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Mar 8, 2011      145.8 MB
    8.      11837664      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL MARCH 05 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Mar 8, 2011      130.0 MB
    9.      11794386      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL FEB 21 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Feb 28, 2011      129.8 MB
    10.      10348807      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL NOV 29 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Feb 17, 2011      129.3 MB
    11.      11058713      103030 CONSOLIDATED CAB ONEOFF FOR CUSTOMER BUGS TILL JAN 10 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Jan 13, 2011      403.6 MB
    12.      11058333      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JAN 10 2011 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Jan 13, 2011      129.7 MB
    13.      10238621      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL OCT 27 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Oct 27, 2010      130.0 MB
    14.      10220631      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL OCT 21 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Oct 25, 2010      129.9 MB
    15.      10151434      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL SEP 28 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Oct 12, 2010      129.9 MB
    16.      9953484      103030 CONSOLIDATED CAB ONEOFF FOR CUSTOMER BUGS TILL JULY 29 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Aug 24, 2010      407.7 MB
    17.      9882923      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JULY 29 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Aug 24, 2010      129.6 MB
    18.      9941330      MOBILE SERVER INSTALLATION FAILS ON WINDOWS 7 (Patch)      10.3.0.3.0      Microsoft Windows (32-bit) (American English)      General      Oracle Database Lite      Aug 19, 2010      3.1 KB
    19.      9860641      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JUNE 29 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Jul 2, 2010      88.9 MB
    20.      9767562      103030 CONSOLIDATED CAB ONEOFF FOR CUSTOMER BUGS TILL MAY 24 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Jun 24, 2010      237.0 MB
    21.      9826651      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JUNE 17 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      Jun 24, 2010      88.9 MB
    22.      9743448      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL MAY 24 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      May 27, 2010      74.9 MB
    23.      9574814      103030 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL APRIL 12 2010 (Patch)      10.3.0.3.0      Generic Platform (American English)      General      Oracle Database Lite      May 10, 2010      54.4 MB

    for 10.3.0.2 are :
         Patch Name      Description      Release      Platform (Language)      Classification      Product/Family      Updated      Size
    1.      11811505      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL FEB 25, 2011 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Mar 3, 2011      91.1 MB
    2.      10381756      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL DEC 08, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Dec 13, 2010      91.1 MB
    3.      10156196      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL SEP 29, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Sep 30, 2010      91.6 MB
    4.      10069547      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL AUG 30, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Sep 1, 2010      91.6 MB
    5.      10011984      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL AUG 10, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Aug 13, 2010      91.6 MB
    6.      9958080      TRACKING BUG FOR UPLOADING ORACLE LITE 10.3.0.2 AIX RELEASE ON ARU (Patch)      10.3.0.2.0      IBM AIX on POWER Systems (32-bit) (American English)      General      Oracle Database Lite      Jul 30, 2010      530.2 MB
    7.      9957963      TRACKING BUG FOR UPLOADING ORACLE LITE 10.3.0.2 HPUX RELEASE ON ARU (Patch)      10.3.0.2.0      HP-UX PA-RISC (32-bit) (American English)      General      Oracle Database Lite      Jul 30, 2010      475.8 MB
    8.      9957958      TRACKING BUG FOR UPLOADING ORACLE LITE 10.3.0.2 SOLARIS RELEASE ON ARU (Patch)      10.3.0.2.0      Oracle Solaris on SPARC (32-bit) (American English)      General      Oracle Database Lite      Jul 30, 2010      449.5 MB
    9.      9935702      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JULY 23, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jul 23, 2010      91.6 MB
    10.      9891767      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JULY 09, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jul 15, 2010      91.6 MB
    11.      9868031      103020 CONSOLIDATED CAB ONEOFF FOR CUSTOMER BUGS TILL JUNE 30, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jul 6, 2010      222.0 MB
    12.      9864602      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JUNE 30, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jul 6, 2010      91.6 MB
    13.      9768286      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JUNE 01, 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jun 7, 2010      83.7 MB
    14.      9535503      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL MARCH 30 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Apr 8, 2010      82.3 MB
    15.      8536828      103020 CONSOLIDATED CAB ONEOFF FOR CUSTOMER BUGS TILL MAY 21 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Apr 7, 2010      222.0 MB
    16.      9390695      TRACKING BUG FOR UPLOADING ORACLE LITE 10.3.0.2 WIN32 RELEASE ON ARU (Patch)      10.3.0.2.0      Microsoft Windows (32-bit) (American English)      General      Oracle Database Lite      Feb 18, 2010      589.3 MB
    17.      9390709      TRACKING BUG FOR UPLOADING ORACLE LITE 10.3.0.2 LINUX RELEASE ON ARU (Patch)      10.3.0.2.0      Linux x86 (American English)      General      Oracle Database Lite      Feb 18, 2010      450.4 MB
    18.      9322792      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JANUARY 28 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Feb 9, 2010      67.1 MB
    19.      9265091      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JANUARY 07 2010 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jan 15, 2010      59.7 MB
    20.      9165162      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL NOVEMBER 30 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Dec 3, 2009      59.5 MB
    21.      9079839      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL NOVEMBER 03 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Nov 10, 2009      59.5 MB
    22.      9034581      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL OCTOBER 20 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Oct 28, 2009      50.5 MB
    23.      8947919      MERGE REQUEST ON TOP OF 10.2.0.4.0 FOR BUGS 6642692 8282992 (Patch)      10.3.0.2.0      Linux x86-64 (American English)      General      Oracle Database Family      Oct 22, 2009      102.4 KB
    24.      8915800      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL SEPTEMBER 16 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Sep 22, 2009      50.4 MB
    25.      8774781      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL AUGUST 07 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Aug 21, 2009      34.3 MB
    26.      8756625      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL AUGUST 03 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Aug 6, 2009      34.3 MB
    27.      8659144      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JULY 06 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jul 23, 2009      34.1 MB
    28.      8651465      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JULY 02 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jul 6, 2009      32.6 MB
    29.      8630947      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JUNE 25 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jun 29, 2009      22.3 MB
    30.      8590570      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL JUNE 10 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Jun 17, 2009      22.3 MB
    31.      8532807      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL MAY 20 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      May 26, 2009      15.1 MB
    32.      8501447      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL MAY 08 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      May 14, 2009      13.4 MB
    33.      8435145      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL APRIL 15 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Apr 30, 2009      13.4 MB
    34.      8434694      103020 CONSOLIDATED CAB ONEOFF FOR CUSTOMER BUGS TILL APRIL 15 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Apr 30, 2009      153.1 MB
    35.      8314936      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL MARCH 06 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Apr 2, 2009      9.2 MB
    36.      7570494      CAC FEATURE (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Feb 9, 2009      102.6 MB
    37.      7584159      103020 CONSOLIDATED ONEOFF FOR CUSTOMER BUGS TILL NOV 20 2008 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Nov 24, 2008      8.7 MB
    38.      7366682      DMAGENT.EXE AND UPDATE.EXE CRASHE ON PPC 50 INTERNEC CN3 (Patch)      10.3.0.2.0      Generic Platform (American English)      General      Oracle Database Lite      Nov 21, 2008      136.0 MB


    they are diffrent as you can see, i dont know if that is the problem here but installing the right patch i guess is important because even if it is installed successfully it might malfunction something else.of course always bare in mind that you
    dont have to install all patches , just the latest, this is why it says consolidated oneoff which means that the latest patch includes all the previous. you do have to install the cab one off (that includes the new cab files for the wince platform) and the normal consolidated one off for the other server features.

    now concerning your problem with perl :
    1) you set the right path in the windows environmental variables, you restarted to make sure it took effect
    2) and you made sure that it is the correct folder, it should include perl5.8.3.exe,perl58.dll perl.exe and perhaps a couple more exes. you also do have the java installed, the correct version and the java path is set correct when you type java -version you see the right version (e.g. i use 1.5 for the patches and it is just fine but im sure other versions will work also,im not sure which one is the minimum though)
    3)you followed the instructions to install opatch, copied opatch rar unzipped and then execute the install patch command .if you didnt have perl you downloaded as it says from http://metalink.oracle.com using bug#2417872 in the patch notes
    you did all these and still get the same perl not found error?


    btw check also when you have time
    http://download.oracle.com/docs/cd/E12095_01/doc.10303/e12080/upgrade.htm#BABBIDCC
    5.2 Upgrade Your Oracle Database Lite from 10g Release 1 or 2 to 10g Release 3

    just as information the olite new version was released like a week ago (olite 11g).

Legend

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