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)

Create a free website or blog at WordPress.com.