Thinking Out Loud

July 12, 2010

Using DBUA in Silent Mode

Filed under: 11g,oracle,upgrade — mdinh @ 5:38 pm

I just completed upgrade to 11gR2 for a test and small reporting database.

This time I used DBUA (recommended) versus the manual process.

/u01/app/oracle/product/11gR2/dbhome_1/bin/dbua -silent \
-sid dbtest \
-oracleHome /u01/app/oracle/product/10.2.0/db_1 \
-diagnosticDest /u01/app/oracle \
-autoextendFiles \
-recompile_invalid_objects true \
-degree_of_parallelism 4 \
-emConfiguration NONE

The summary log files are located at $ORACLE_BASE/cfgtoollogs/dbua/logs (ORACLE_BASE=/u01/app/oracle)

oracle@proddbtest:dbtest:/u01/app/oracle/cfgtoollogs/dbua/logs
> ll
total 144
drwxr-x--- 4 oracle dba 96 Jun 18 10:11 ..
-rw-r----- 1 oracle dba 19287 Jun 22 10:03 sqls.log
-rw-r----- 1 oracle dba 28750 Jun 22 10:03 trace.log
-rw-r----- 1 oracle dba 1833 Jun 22 10:38 silent.log
drwxr-x--- 2 oracle dba 8192 Jun 22 10:38 .

The detailed logs are located at $ORACLE_BASE/cfgtoollogs/dbua/<db_unique_name>/upgrade#

Example: db_name=dbtest and db_unique_name=dc_dbtest (dc is the name for data center)

oracle@proddbtest:dbtest:/u01/app/oracle/cfgtoollogs/dbua
> ll
total 16
drwxr-x--- 5 oracle dba 96 Jun 18 10:10 ..
drwxr-x--- 4 oracle dba 96 Jun 18 10:11 .
drwxr-x--- 4 oracle dba 96 Jun 22 10:03 dc_dbtest
drwxr-x--- 2 oracle dba 8192 Jun 22 10:38 logs

I attempted 2 upgrades just so I can get the feel of things.

oracle@proddbtest:dbtest:/u01/app/oracle/cfgtoollogs/dbua/dc_dbtest
> ll
total 32
drwxr-x--- 4 oracle dba 96 Jun 18 10:11 ..
drwxr-x--- 2 oracle dba 8192 Jun 18 10:13 upgrade1
drwxr-x--- 4 oracle dba 96 Jun 22 10:03 .
drwxr-x--- 2 oracle dba 8192 Jun 22 10:38 upgrade2

oracle@proddbtest:dbtest:/u01/app/oracle/cfgtoollogs/dbua/dc_dbtest/upgrade2
> ll
total 41136
drwxr-x--- 4 oracle dba 96 Jun 22 10:03 ..
-rw-r----- 1 oracle dba 1732 Jun 22 10:03 upgrade.xml
-rw-r----- 1 oracle dba 1167 Jun 22 10:03 Upgrade_Directive.log
-rw-r----- 1 oracle dba 397 Jun 22 10:03 SpaceUsage.txt
-rw-r----- 1 oracle dba 5210 Jun 22 10:03 PreUpgradeResults.html
-rw-r----- 1 oracle dba 442 Jun 22 10:04 PreUpgrade.log
-rw-r----- 1 oracle dba 20751782 Jun 22 10:36 Oracle_Server.log
-rw-r----- 1 oracle dba 9317 Jun 22 10:38 PostUpgrade.log
drwxr-x--- 2 oracle dba 8192 Jun 22 10:38 .
-rw-r----- 1 oracle dba 6087 Jun 22 10:38 UpgradeResults.html
-rw-r----- 1 oracle dba 155467 Jun 22 10:38 trace.log
-rw-r----- 1 oracle dba 73544 Jun 22 10:38 sqls.log

More information can be found in the upgrade guide (open new window)

Advertisements

3 Comments »

  1. http://surachartopun.com/2010/11/just-upgrade-oracle-database-10gr2-to.html Nice manual upgrade instructions.

    Comment by mdinh — November 23, 2010 @ 2:37 pm | Reply

  2. Excellent comments . I Appreciate the insight . Does someone know where my company can grab a template a form copy to use ?

    Comment by LEONARDA MUNGUIA — November 30, 2015 @ 1:53 pm | Reply

    • There is not a template I am aware of. Would suggest test in DEV and used parameters for PROD.

      Comment by mdinh — November 30, 2015 @ 2:53 pm | Reply


RSS feed for comments on this post. TrackBack URI

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: