Upgrade Steps for convert NON CDB to CDB Database

Upgrade Steps for convert NON CDB to CDB Database

1. Backup the database

2. Install new release of Oracle Software.

3. Preupgrade tool is run on source database and fixed the issue.

In Case on NON-CDB
$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
$ export ORACLE_BASE=/u01/app/oracle
$ export ORACLE_SID=ORCL
$ export PATH=.:$ORACLE_HOME/bin:$PATH
$ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/12.2.0/rdbms/admin/preupgrade.jar TERMINAL TEXT

In case of CDB
alter pluggable database all open;
$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
$ export ORACLE_BASE=/u01/app/oracle
$ export ORACLE_SID=sales01
$ export PATH=.:$ORACLE_HOME/bin:$PATH
$ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/preupgrade.jar TERMINAL TEXT -c "pdb1 pdb2"

Note: -c option need to specify on which database it will run.

4. Shutdown the current database.

Shutdown immediate

5. Set the new oracle home and go to directory of new home: $ORACLE_HOME/rdbms/admin.

6. Start the database with SQLPLUS in upgrade mode.

SQL> startup upgrade;

7. Exit SQL*Plus.

8. Run the Parallel Upgrade Utility from the new Oracle home.
Run the utility as a shell command (dbupgrade on Linux and UNIX, and dbupgrade.cmd on Windows) or you can run it as a Perl command (catctl.pl).
Note: Take care for following things:
Parallel Upgrade Utility (catctl.pl) runs:
-c ‘PDB1 PDB2’ for linux or unix single quote
-c “PDB1 PDB2” for windows Double quote
-d Location of directory having file you wantt to proceed.
-e echo on while running the script.
-F force to clean previous upgrade error
-l location of directory to use spool file
-i identifers used in spool file creation.
-n for parallel
-R resume for failed phase.
-u username and prompt for password

--In Linux or Unix:
cd $ORACLE_HOME/bin
./dbupgrade

--In Windows:
cd %ORACLE_HOME%\bin
dbupgrade

Example of upgrade:
cd $ORACLE_HOME/bin
dbupgrade -n 4 -l $ORACLE_HOME/diagnostics

9. Now upgrade process will start.

10. After Upgrade database start the database.

Startup

11. Run the utlrp.sql on database

$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql

12. Run the POSTUPGRADE Script

@postupgrade_fixups.sql

13. Run the utllu122s utility of POST upgrade step.

@$ORACLE_HOME/rdbms/admin/utllu122s.sql

14. Took backup of Database with RMAN.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.