- #Oracle 10g upgrade install#
- #Oracle 10g upgrade update#
- #Oracle 10g upgrade manual#
- #Oracle 10g upgrade Patch#
- #Oracle 10g upgrade upgrade#
Post-Upgrade Status the results, and if there any errors, must be resolved at this Invalid Objects:Īny invalid SYS/SYSTEM objects found before upgrading the database are stored in the table named registry$sys_inv_objs.
Monitor the alert log file and check for any errors. PROD should point to /u01/app/oracle/product/11.2.0/db_1 as ORACLE_HOME
#Oracle 10g upgrade upgrade#
(because the upgrade is looking for 10.2 objects that have not yet been created).
This will avoid any unnecessary ORA-942 errors from being reported in SMON trace files during the upgrade If you are upgrading from 10.1.0.x or 10.2.0.x then you can leave the COMPATIBLE parameter set to it's current value until the upgrade hasīeen completed successfully.
#Oracle 10g upgrade manual#
Upgrade 11.2.0.1 to 11.2.0.3 using Manual upgrade method
#Oracle 10g upgrade Patch#
When going toĭSTv14 there is no need to apply any DST patch to the 11.2.0.3 home.ġ4. DST version in 11gR2 (11.2.0.1 and up) using DBMS_DST from step 3a) using "14" as () in that note.
#Oracle 10g upgrade update#
* (recommended) update the 11.2.0.3 database(s) to DSTv14 (standard DST version of 11.2.0.3) by following Note 977512.1 Updating the RDBMS. You can skip any DST related upgrade instructions. SQL> SELECT version FROM v$timezone_file Check timezone version of 10.2.0.4 database and 11.2.0.3 and compare if both are same Better raise a SR with Oracle support for confirmation. Important: If you see a warning about the presence of the release 10g DMSYS schema in the database, then you must drop the DMSYS schema before proceeding with the upgrade. Run utlrp.sql to fix invalid objects or components issue Run Pre-Upgrade Information Tool in 10.2.0.4 database (Must)Ĭheck the output of the Pre-Upgrade Information Tool in upgrade_info.log Set the environment to Existing 10.2.0.4 Environmentġ2. Apply recommended Patches for 11.2.0.4 ORACLE_HOMEġ1. Take full backup before upgrade activity.ĩ. u03/stage/11203_sw/examples/runInstallerĮxport ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1Įxport PATH = $ORACLE_HOME/bin: $ORACLE_HOME/perl/bin:$PATHĨ.
#Oracle 10g upgrade install#
Install Oracle Database 11g Products from the 11g Examples CDĮnable VNC, Enter following command on VNC to start Example Installer Install 11.2.0.4 Enterprise edition Oracle softwareĮnable VNC, Enter following command on VNC to start OUI for installation Mkdir -p /u01/app/oracle/product/11.2.0/db_1Įdit /etc/oraInst.loc to point to /u01/app/oraInventoryĥ. Uname –a (Use this command to check Kernel version and OS version Patch 10404530: 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVERĭownload above software from Oracle Support and keep in a staging location Install 11.2.0.3 Software on current server Current database version is 10.2.0.4.0 64 BitĢ. Sharing real time knowledge,issues on Oracle DBAġ. Upgrade your database from Oracle 10.2.0.4 to 11.2.0.4 database