Tracking DBCA database creation log

Tracking the DBCA database creation log to facilitate exception resolution, that is, when you are running the dbca database creation, you can look at it when you are bored.

Method 1: (view the log location provided by oracle)

Dbca in 10g and 11g

Locate the log location of 10 Gb dbca $ ORACLE_HOME/export toollogs/dbca/trace. log logs

When the logs of GB dbca are displayed in the format indicated by $ ORACLE_BASE/export toollogs/dbca/Instance name/trace. log->

For example:

Ora11g

Ora11g

Total 260 K

-Rw-r ----- 1 oracle oinstall 0 Jan 12 09:46 rmanDeleteFiles. SQL

-Rw-r ----- 1 oracle oinstall 1.3 K Feb 18 rmanRestoreDatafiles. SQL

-Rw-r ----- 1 oracle oinstall 733 Feb 18 CloneRmanRestore. log

-Rw-r ----- 1 oracle oinstall 2.2 K Feb 18 tts_example_imp.log

-Rw-r ----- 1 oracle oinstall 38 K Feb 18 05:02 cloneDBCreation. log

-Rw-r ----- 1 oracle oinstall 17 K Feb 18 05:02 mkplug_v3_ora11g.log

-Rw-r ----- 1 oracle oinstall 16 Feb 18 05:02 postScripts. log

-Rw-r ----- 1 oracle oinstall 48 Feb 18 05:02 lockAccount. log

-Rw-r ----- 1 oracle oinstall 2.4 K Feb 18 postDBCreation. log

-Rw-r ----- 1 oracle oinstall 26 K Feb 18 05:05 emConfig. log

-Rw-r ----- 1 oracle oinstall 142 K Feb 18 trace. log

Method 2: edit the installation script. In this step, install the oracle software first, and use the keystore only when creating the database.

1. Find the dbca Executable File

[Root @ ora11g ~] # Su-oracle

[Oracle @ ora11g ~] $ Cd $ ORACLE_HOME/bin

2. View commands and back up data

[Oracle @ ora11g ~] $ Ls encrypted-al dbca

[Oracle @ ora11g ~] $ Cp dbca. bak

[Oracle @ ora11g ~] $ Ls-al dbca *

-Rwxr-xr-x 1 oracle oinstall 6229 Jan 12 dbca
-Rwxr-xr-x 1 oracle oinstall 6229 Mar 26 dbca. bak restart

3. Modify dbca trace Parameters

[Oracle @ ora11g ~] $ Vi dbca restart

Locate locate the following line

Running # Run DBCA merge exec $ JRE_DIR/bin/java $ JRE_OPTIONS $ DEBUG_STRING-classpath $ CLASSPATH oracle. sysman. assistants. dbca. Dbca $ ARGUMENTS

Pipeline exec $ JRE_DIR/bin/java $ JRE_OPTIONS $ DEBUG_STRING-DTRACING. ENABLED = true-DTRACING. LEVEL = 2-classpath $ CLASSPATH oracle. sysman. assistants. dbca. dbca $ ARGUMENTS

4. Import dbcalog

[Oracle @ ora11g ~] $ Dbca> dbca. log

[Oracle @ ora11g ~] $ Pwd

/Home/oracle Connector

5. view the content of the dbca trace file