DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Wednesday, October 22, 2014

Oracle database 12c - Deprecation of catupgrd.sql and Introduction of Utility

Oracle Database 12c introduces the new Parallel Upgrade Utility, This utility replaces the catupgrd.sql script that was used in earlier releases.
Although you can still use the catupgrd.sql script, it is deprecated starting with Oracle Database 12c and will be removed in future releases.
Oracle recommends database upgrades be performed with the new Parallel Upgrade Utility,

If you choose to run the catupgrd.sql script instead of running, doing so now requires an additional input parameter as follows:

SQL> @catupgrd.sql PARALLEL=NO

If you run catupgrd.sql without the parameter, then Oracle displays the following error message:


The catupgrd.sql script is being deprecated in the 12.1 release of Oracle Database. Customers are encouraged to use as the replacement for catupgrd.sql when upgrading the database dictionary.

                cd $ORACLE_HOME/rdbms/admin
                $ORACLE_HOME/perl/bin/perl -n 4 catupgrd.sql

Refer to the Oracle Database Upgrade Guide for more information.


Mathew Stephen said...

There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.

Oracle Training in Chennai | Oracle Course in Chennai | hadoop training in chennai

Nikshitha S said...

Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
SAS Training in Chennai | SAS Course in Chennai

Sridevi K said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.