跟踪dbca
-
quanjima
2014-10-19 13:39:06
-
Oracle
-
原创
-
跟踪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.: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.: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