- 跟踪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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29913993/viewspace-1303646/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29913993/viewspace-1303646/