Tracking DBCA database creation log

Source: Internet
Author: User
Tracking the DBCA database creation log to facilitate exception resolution, that is, when you are bored when running the dbca database creation, you can look at Method 1: (view the log location provided by oracle) location of dbca10gdbca logs in 10g and 11g $ ORACLE_HOMEcfgtoollogsdbcatrace.log11gdbca logs are stored in the $ ORACLE_BASEcfgtoollogsdbca instance

Tracking the DBCA database creation log to facilitate exception resolution, that is, when you are bored when running the dbca database creation, you can look at Method 1: (view the log location provided by oracle) the log location of dbca 10g dbca in 10g and 11g $ ORACLE_HOME/export toollogs/dbca/trace. log 11g dbca logs are stored in $ ORACLE_BASE/export toollogs/dbca/instance

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 stored in $ ORACLE_BASE/export toollogs/dbca/Instance name/trace. log

For example:

Ora11g$ Cd/oracle/export toollogs/dbca/ora11g/

Ora11g$ Ll-trlh

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.