跟踪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
转载于:https://blog.51cto.com/evils798/1420915