跟踪dbca

跟踪DBCA

Oracle DBCA建库有问题的时候，可以通过DBCA trace来定位问题

1.找到DBCA可执行文件
[root@RAC2 ~]# su - oracle
[oracle@RAC2 ~]$ cd $ORACLE_HOME/bin

2.查看备份原始文件
[oracle@RAC2 bin]$ ls -al dbca
-rwxr-xr-x 1 oracle oinstall 6305 Jan  9 11:51 dbca
[oracle@RAC2 bin]$ cp dbca dbca.ori

[oracle@RAC2 bin]$ ls -al dbca*
-rwxr-xr-x 1 oracle oinstall 6305 Jan  9 11:51 dbca
-rwxr-xr-x 1 oracle oinstall 6264 Jan  9 11:48 dbca.ori


3.增加dbca trace参数
[oracle@RAC2 bin]$ vi dbca 

找到如下一行

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


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


4.图形化运行dbca TRACE模式
[oracle@RAC2 bin]$ dbca > dbca.trc
[oracle@RAC2 bin]$pwd 
/home/oracle

5.查看dbca trace文件内容
[oracle@RAC2 ~]$ more dbca.trc 
[main] [ 2014-01-09 11:51:52.337 CST ] [CommandLineArguments.process:719]  CommandLineArguments->process: number of arguments = 0
[main] [ 2014-01-09 11:51:52.392 CST ] [StepContext.<init>:323]  Inside StepContext
[main] [ 2014-01-09 11:51:52.562 CST ] [OsUtilsBase.getScratchPath:633]  scratch location /tmp
[main] [ 2014-01-09 11:51:52.833 CST ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2014-01-09 11:51:52.838 CST ] [HAUtils.<init>:239]  oui location /u01/app/oraInventory/ContentsXML
[main] [ 2014-01-09 11:51:52.851 CST ] [Version.isPre:528]  version to be checked 11.2.0.3.0 major version to check against10
[main] [ 2014-01-09 11:51:52.851 CST ] [Version.isPre:539]  isPre.java: Returning FALSE
[main] [ 2014-01-09 11:51:52.855 CST ] [OCR.loadLibrary:312]  
 Inside constructor of OCR
[main] [ 2014-01-09 11:51:52.869 CST ] [OCR.loadLibrary:320]  Going to load the ocr library
[main] [ 2014-01-09 11:51:52.869 CST ] [Library.load:188]  library.load
[main] [ 2014-01-09 11:51:52.870 CST ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2014-01-09 11:51:52.870 CST ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2014-01-09 11:51:52.871 CST ] [Library.load:264]  Loading  library /u01/app/oracle/11.2/db_1/lib/libsrvmocr11.so
[main] [ 2014-01-09 11:51:52.872 CST ] [OCR.loadLibrary:322]  loaded ocr libraries
[main] [ 2014-01-09 11:51:52.872 CST ] [OCR.isCluster:952]  Calling OCRNative for isCluster()
[main] [ 2014-01-09 11:51:52.874 CST ] [nativesystem.OCRNative.Native]  JNI: isCluster() Successfully initialized meta context
[main] [ 2014-01-09 11:51:52.874 CST ] [nativesystem.OCRNative.Native]  JNI: procr_get_conf() retValue = 0
[main] [ 2014-01-09 11:51:52.875 CST ] [nativesystem.OCRNative.Native]  The OCR file is configured  & local_only=false
 


注：10g、11g中dbca 自身也有安装日志

针对10g dbca的日志在

$ORACLE_HOME/cfgtoollogs/dbca/trace.log

11g dbca的日志在

$ORACLE_BASE/cfgtoollogs/dbca/RAC2/trace.log 

例：
[oracle@RAC01 cfgtoollogs]$ cd $ORACLE_BASE/cfgtoollogs
[oracle@RAC01 cfgtoollogs]$ cd dbca/
[oracle@RAC01 dbca]$ ll
total 3484
drwxr-xr-x 2 oracle oinstall    4096 Jan  8 13:03 orcl
-rw-r----- 1 oracle oinstall    4357 Jan  8 19:31 ShutdownInst.log
-rw-r----- 1 oracle oinstall  404796 Jan  7 20:44 trace.log_OraDb11g_home1_2014-01-07_08-38-04-PM
-rw-r----- 1 oracle oinstall  226108 Jan  8 16:57 trace.log_OraDb11g_home1_2014-01-08_04-55-19-PM
-rw-r----- 1 oracle oinstall  385353 Jan  8 19:36 trace.log_OraDb11g_home1_2014-01-08_07-28-17-PM
-rw-r----- 1 oracle oinstall    3925 Jan  8 20:47 trace.log_OraDb11g_home1_2014-01-08_08-47-06-PM