Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Upgrade VirtualBox Oracle VM to APEX 5.0 (Oracle Linux 7, Oracle 12.1.0.2.0, APEX 4.2.5.00.08)
Upgrade VirtualBox Oracle VM to APEX 5.0 [message #636317] Tue, 21 April 2015 07:35 Go to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Here are the facts.
- I have a Virtualbox Oracle VM up and running (4.3.26) with an Oracle provided VM (Oracle_DB_Developer_VM_new.ova). It has an Oracle APEX environment (rel 4.2.5.00.08).
- I downloaded APEX 5.0
- The OS is Oracle Linux 7.
- The database version is 12.1.0.2.0 and it is a multitenant database environment.

This is what I want to do: upgrade APEX to version 5.0.

According to this document I have to apply patch 20618595 first. I have also this document as a reference.

I updated opatch (patch number 6880880 has been applied, replacing opatch) and try to apply patch 20618595. After bringing down the listener and the database the patch exits without updating the database. I find this in the log file:
[Apr 21, 2015 3:14:55 AM]    OPatch invoked as follows: 'apply -invPtrLoc /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc '
[Apr 21, 2015 3:14:55 AM]    OUI-67077:
                             Oracle Home       : /home/oracle/app/oracle/product/12.1.0/dbhome_1
                             Central Inventory : /home/oracle/app/oraInventory
                                from           : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
                             OPatch version    : 12.1.0.1.7
                             OUI version       : 12.1.0.2.0
                             OUI location      : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oui
                             Log file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/20618595_Apr_21_2015_03_14_54/apply2015-04-21_03-14-54AM_1.log
[Apr 21, 2015 3:14:55 AM]    Patch history file: /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
[Apr 21, 2015 3:14:55 AM]    Starting ApplySession at Tue Apr 21 03:14:55 PDT 2015
[Apr 21, 2015 3:14:55 AM]    Starting Apply Session at Tue Apr 21 03:14:55 PDT 2015
[Apr 21, 2015 3:14:55 AM]    OPatch will do the following:
[Apr 21, 2015 3:14:55 AM]    [Oracle Home discovery]                      : Configure and Validate Oracle Home info.
[Apr 21, 2015 3:14:55 AM]    [Prerequisite for apply]                     : Invoke prerequisites to see if patch can be applied.
[Apr 21, 2015 3:14:55 AM]    [Patch conflict detection for apply patch]   : Check if any conflict with already installed patches in Oracle Home.
[Apr 21, 2015 3:14:55 AM]    --------------------- Oracle Home discovery ---------------------
[Apr 21, 2015 3:14:55 AM]    OUI-67086:ApplySession applying interim patch '20618595' to OH '/home/oracle/app/oracle/product/12.1.0/dbhome_1'
[Apr 21, 2015 3:14:55 AM]    Applying interim patch '20618595' to OH '/home/oracle/app/oracle/product/12.1.0/dbhome_1'
[Apr 21, 2015 3:14:55 AM]    Starting to apply patch to local system at Tue Apr 21 03:14:55 PDT 2015
[Apr 21, 2015 3:14:55 AM]    Verifying environment and performing prerequisite checks...
[Apr 21, 2015 3:14:57 AM]    Start the Apply initScript at Tue Apr 21 03:14:57 PDT 2015
[Apr 21, 2015 3:14:57 AM]    Finish the Apply initScript at Tue Apr 21 03:14:57 PDT 2015
[Apr 21, 2015 3:14:57 AM]    --------------------- Prerequisite for apply ---------------------
[Apr 21, 2015 3:14:57 AM]    Running prerequisite checks...
[Apr 21, 2015 3:14:57 AM]    Check if patch "20618595"  is a no-op patch.
[Apr 21, 2015 3:14:57 AM]    Opt. comp. not in OH inventory: oracle.rdbms, 12.1.0.2.0
[Apr 21, 2015 3:14:57 AM]    Opt. comp. not in OH inventory: oracle.rdbms.dbscripts, 12.1.0.2.0
[Apr 21, 2015 3:14:57 AM]    [ oracle.rdbms, 12.1.0.2.0 ] , [ oracle.rdbms.dbscripts, 12.1.0.2.0 ]
[Apr 21, 2015 3:14:57 AM]    OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.
                             You will be still able to rollback patches after this cleanup.
                             Do you want to proceed? [y|n]
[Apr 21, 2015 3:15:00 AM]    Y (auto-answered by -silent)
[Apr 21, 2015 3:15:00 AM]    User Responded with: Y
[Apr 21, 2015 3:15:00 AM]    Size of directory "/home/oracle/app/oracle/product/12.1.0/dbhome_1/.patch_storage" before cleanup is 56 bytes.
[Apr 21, 2015 3:15:00 AM]    Deleting the directory "/home/oracle/app/oracle/product/12.1.0/dbhome_1/.patch_storage/20618595_Apr_9_2015_15_28_51/backup"
[Apr 21, 2015 3:15:00 AM]    Deleted the directory "/home/oracle/app/oracle/product/12.1.0/dbhome_1/.patch_storage/20618595_Apr_9_2015_15_28_51/backup"
[Apr 21, 2015 3:15:00 AM]    Size of directory "/home/oracle/app/oracle/product/12.1.0/dbhome_1/.patch_storage" after cleanup is 56 bytes.
[Apr 21, 2015 3:15:00 AM]    UtilSession: Backup area for restore has been cleaned up. For a complete list of files/directories
                             deleted, Please refer log file.
[Apr 21, 2015 3:15:00 AM]    OUI-67005:OPatch system modification phase did not start: 
                             Patch "20618595" is not needed since it has no fixes for this Oracle Home. Please see log file for details.
[Apr 21, 2015 3:15:00 AM]    OUI-67035:System is intact, OPatch will not restore the system
[Apr 21, 2015 3:15:00 AM]    Finishing ApplySession at Tue Apr 21 03:15:00 PDT 2015
[Apr 21, 2015 3:15:00 AM]    Total time spent waiting for user-input is 0 seconds.  Finish at Tue Apr 21 03:15:00 PDT 2015
[Apr 21, 2015 3:15:00 AM]    Log file location: /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/20618595_Apr_21_2015_03_14_54/apply2015-04-21_03-14-54AM_1.log
[Apr 21, 2015 3:15:00 AM]    Stack Description: oracle.opatch.ExitOPatchException: 
                             Patch "20618595" is not needed since it has no fixes for this Oracle Home. Please see log file for details.
[Apr 21, 2015 3:15:00 AM]    StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:5490)
[Apr 21, 2015 3:15:00 AM]    StackTrace: oracle.opatch.ApplySession.processLocal(ApplySession.java:3520)
[Apr 21, 2015 3:15:00 AM]    StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5422)
[Apr 21, 2015 3:15:00 AM]    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2341)
[Apr 21, 2015 3:15:00 AM]    StackTrace: oracle.opatch.OPatch.main(OPatch.java:645)


According to the little information I have found I do need the patch because otherwise the upgrade to APEX 5.0 will fail.
[oracle@localhost apex]$ grep ORA- *.log
coreins30.log:ORA-00001: unique constraint (APEX_050000.WWV_FLOW_BANNER_U_IDX) violated
coreins30.log:ORA-06512: at "APEX_050000.WWV_FLOW_API", line 2811
coreins30.log:ORA-06512: at line 2
coreins31.log:ORA-00001: unique constraint (APEX_050000.WWV_FLOW_BANNER_U_IDX) violated
coreins31.log:ORA-06512: at "APEX_050000.WWV_FLOW_API", line 2811
coreins31.log:ORA-06512: at line 2


I was smart enough to take a snapshot of the VM prior to the attempt to upgrade, so I can replay this scenario.

Any ideas? My initial plan was to upgrade APEX to 4.2.6 first and then attempt an upgrade to 5.0 but perhaps someone else has a better idea. Did I miss something when applying patch 20618595?

MHE
Re: Upgrade VirtualBox Oracle VM to APEX 5.0 [message #636336 is a reply to message #636317] Wed, 22 April 2015 02:55 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Update: I patched Apex successfully to 4.2.6.00.03 but the errors are still the same. Back to the drawing board...

MHE

[Updated on: Wed, 22 April 2015 02:56]

Report message to a moderator

Re: Upgrade VirtualBox Oracle VM to APEX 5.0 [message #636462 is a reply to message #636336] Fri, 24 April 2015 09:05 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I made it! Not the way I wanted to go but I got my APEX 5 up and running. I ended up doing the following:



  1. Export existing applications and workspaces
  2. Uninstall APEX 4.2 from the CDB
  3. Install APEX 5.0 in the PDB
  4. Import the workspaces and applications again.



To install APEX 5.0 I had to do the following (note that I already downloaded and unzipped the installation file I retrieved from Oracle.com):



  1. Run the installer on the PDB database
  2. Copy the images from the extracted zip to the apex images directory on my Oracle home
  3. Run the provided REST configuration script.
  4. Run the provided admin change password script.



It took some trial and error but I made it.

MHE

Edit: It was my last idea and I can't say that I am thrilled I had to do it this way, but at least I can go further now.

[Updated on: Fri, 24 April 2015 09:09]

Report message to a moderator

Re: Upgrade VirtualBox Oracle VM to APEX 5.0 [message #636464 is a reply to message #636462] Fri, 24 April 2015 09:25 Go to previous message
John Watson
Messages: 8394
Registered: January 2010
Location: Global Village
Senior Member
I've been following this, but I have taken a different route. I'll open anothr topic to describe my experience.
Previous Topic: ORDS, RAC, TAF, Glassfish
Next Topic: APEX 5 in DB12.1.0.2
Goto Forum:
  


Current Time: Sat Oct 24 19:18:38 CDT 2020