Visit Counter

Tuesday, May 17, 2016

Upgrading to Oracle Database 11.2.0.4 TO 12c

Upgrading to Oracle Database 12c

Enviroment

O/S:   Solaris 11.3 Sparc 64-bit

DB:   Oracle 11.2.0.4

DB:   Oracle 12.1.0.1
---------------------------------------------------------------------------------------------------------


Upgrade Database Using DBUA


1. $./dbua

Select the "Upgrade Oracle Database" option, then click the "Next" button.

















Select the database you wish to upgrade and click the "Next" button.
















It can take a few minutes before the next screen is available. Wait at the "Getting database information. Please wait..." message.
Wait while the prerequisite checks takes place.


















If the prerequisite checks highlight any issues, take the appropriate action to fix the issues. When you are happy with the prerequisites, click the "Next" button.
















Amend the upgrade options if necessary, then click the "Next" button.


















Select the desired management options, then click the "Next" button.



















If you need to move the database files and/or the fast recovery area, check the relevant option and enter the destination. Click the "Next" button.








If this database is the only one using the 11g listener, accept the defaults, so the listener will be upgraded. If you prefer to manually define a new listener, so do now. Click the "Next" button.














Select the recovery options for use in the event of an upgrade failure, then click the "Next" button.




















If you are happy with the summary information, click the "Finish" button.


















Wait while the upgrade takes place. When the upgrade is complete, click the "Upgrade Results" button.

















Check the upgrade results, then click the "Close" button to leave the DBUA.

























-bash-4.1$ pwd
/ora/app/oracle/product/12.1.0/dbhome_1/bin


-bash-4.1$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Jan 18 19:00:20 2011

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.


SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
         0

PL/SQL Release 12.1.0.2.0 - Production
         0

CORE    12.1.0.2.0      Production
         0


BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
TNS for Solaris: Version 12.1.0.2.0 - Production
         0

NLSRTL Version 12.1.0.2.0 - Production
         0


SQL>