Database Reference
In-Depth Information
SQL> execute dbms_stats.gather_fixed_objects_stats;
SQL> @/u01/app/oracle/prdoduct/12.1.0/rdbms/admin/utlrp.sql
SQL> @/u01/app/oracle/product/12.1.0/rdbms/admin/utlobj.sql
SQL> @/u01/app/oracle/product/12.1.0/rdbms/admin/utlu121s.sql
SQL> SHUTDOWN IMMEDIATE;
SQL> EXIT
utlrp.sql recomiples all invalid objects on the database
ultobj.sql verfies the validity of all packages/classes on the database
utlu121s.sql displays database upgrade summary
After successfully completing the database upgrade process, you will have to modify the cluster database
configuration details in the OCR using the following command:
srvctl upgrade database -d PRODB -o /u01/app/oracle/product/12.1.0/db_1
At this point in time, your cluster database is successfully upgraded to 12c. Now, open the database using the
following cluster command, which in turn will start all RAC database instances:
srvctl start database -d PRODB
■
executing the
utlrp.sql
is mandatory to avoid performance degradation when accessing the data dictionary
objects after the database upgrade completion. If the script doesn't run right after the database upgrade completion,
whenever the data dictionary is being accessed first, it will have a significant performance impact. therefore, it is advised
to run the script after the upgrade.
Note
Post-Database Upgrade Steps
Once the database is successfully upgraded to Oracle 12c, go through the following recommended post-database
upgrade steps:
postupgrade_fixups.sql
script as explained earlier
•
Run the
•
Back up the database
•
Also migrate the source database listener to Oracle 12 by dropping and re-creating the existing
listener
•
Adjust any RMAN backups, cron tab or other scripts, environment, profile variables, etc.,
to reflect the new Oracle Home settings
oratab
file
•
Ensure that the database points to the new Oracle Home in the
ATTRIBUTE 'compatible.asm'='12.1'
to the ASM diskgroups to make use of new
ASM features
•
Adjust the
•
Verify database configuration details with the following:
$ ./srvctl config database -d PRODB
