Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2880692
  • 博文数量: 599
  • 博客积分: 16398
  • 博客等级: 上将
  • 技术积分: 6875
  • 用 户 组: 普通用户
  • 注册时间: 2009-11-30 12:04
个人简介

WINDOWS下的程序员出身,偶尔也写一些linux平台下小程序, 后转行数据库行业,专注于ORACLE和DB2的运维和优化。 同时也是ios移动开发者。欢迎志同道合的朋友一起研究技术。 数据库技术交流群:58308065,23618606

文章分类

全部博文(599)

文章存档

2014年(12)

2013年(56)

2012年(199)

2011年(105)

2010年(128)

2009年(99)

分类: Oracle

2013-02-27 15:08:40

本文信息来在ORACLE SUPPORT 


Tracing the Database Configuration Assistant (DBCA) [ID 188134.1]


Purpose

The purpose of this document is to assist in debugging Database Configuration Assistant problems and enable DBCA trace.

Scope

This document is for DBAs and support analysts to troubleshoot DBCA issues.

Details

To provide verbose output for DBCA, tracing can be enabled to provide additional 
output. To turn on tracing from 9i to 10g:

1. Do a copy of the original dbca file in $ORACLE_HOME/bin. For example:

cp $ORACLE_HOME/bin/dbca $ORACLE_HOME/bin/dbca.ori

2. vi the dbca file in the $ORACLE_HOME/bin directory.

3. At the end of the file, look for the following line:

# Run DBCA
$JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath 
$CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS

4. Add the following just before the -classpath in the '$JRE_DIR' line:


-DTRACING.ENABLED=true -DTRACING.LEVEL=2


5. At the end of the dbca file, the string should now look like this:

# Run DBCA
$JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m 
-DTRACING.ENABLED=true -DTRACING.LEVEL=2 -classpath $CLASSPATH 
oracle.sysman.assistants.dbca.Dbca $ARGUMENTS

The -DTRACING.LEVEL was missing a space after the 2 so that it looks
like 2-classpath.

6. To trace run:

[opcbsol1]/u01/home/usupport> dbca > dbca.out &

The output will be written to the dbca.out file.


In 10.2 you can add the -DDEBUG flag so that you get the debug information 
given to you interactively 

"C:\oracle\product\10.2.0\racdb\jdk\jre\BIN\JAVA" -DDEBUG -DORACLE_HOME="%OH%" -
DJDBC_PROTOCOL=thin -mx128m oracle.sysman.assistants.dbca.Dbca %* 


BUT in 10.2 you should already have the trace information written automatically 
to the following location 

$ORACLE_HOME/cfgtoollogs/dbca/trace.log

In 11g, the location of trace.log has changed to:

$ORACLE_BASE/cfgtoollogs/dbca//trace.log 


阅读(1161) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~