80005

Upgrading a Database Using DBUA

Complete the following stcps to upgrade a database using DBUA. If you need help at any pagc or want to consult morę documentation about DBUA. then click the Help button to access the online Help.

To upgrade a database using DBUA:

1.    Start DBUA. See "Starting DBUA" on pagc 11-3.

2.    At the Select Operation page of DBUA, choose Upgrade Oracle Database. Then, click Next.

The Select Database page appears.

3.    At the Select Database page, the Target Oracle Home field shows the location of the new Oracle home for the Oracle Database 12c software installation.

In the Select Database area, from the Source Oracle Home list, choose the database you want to upgrade to Oracle Database 12c. DBUA fills in the information for the release and selects the Oracle database associated with the selected Oracle home.

You can select only one database at a time. If you do not see the database that you want. then make surę an cntry with the database name cxists in the oratab file in the etc directory.

If you run DBUA from a uscr account that does not havc SYS DBA privilcgcs, then enter the user name and password credentials to enable SYS DBA privileges for the selected database.

Click Next.

4.    DBUA displays a message saying it is getting database information. DBUA analyzes the selected database, performing pre-upgrade checks and displaying wamings as necessary. Examples of DBUA database checks include:

■Empty database recycle bin

■Invalid objects

■Deprecated or desupported initialization parameters ■Time zonę data filc version

When DBUA finishcs its checks, the Prcrcquisitc Checks page appears. The analysis takcs several minutes to complete.

5.    The Prcrcquisitc Checks pagc shows the validation and results, the scvcrity, whether the rcsult is fixablc if thcre is a problem, and the action you can takc.

When you select the validation result, the Fixable column displays whether the rcsult can be fixed or not. The Action drop-down list shows actions you can takc.

For example. select Fix for DBUA to run a script or command to fix the problem. When you select a result in the Yalidation column, DBUA displays information about the result in the bottom area of the screen.

■Click the morę dctails link in the text information area. The Validation Details box appears with morę information.

■ If there are validation crrors or wamings and these are fixable, you can select an Action to take.

Click Next.

The Upgrade Options Configuration page appears with the Upgrade Options tab selected.