解決12c安裝過(guò)程中的各種報(bào)錯(cuò)

【詳細(xì)內(nèi)容請(qǐng)點(diǎn)擊http://www.dbstyle.net/?p=993 地址】
Oracle Database 12c 推出不久，看到很多人已經(jīng)完成了安裝測(cè)試。但是基本上都是使用“Create and configure a database”中的“Typical install”來(lái)完成安裝，而沒(méi)有人使用“Install database software only”中的”Advanced Mode”安裝方法。嘗試了一下高級(jí)安裝方法，有一些報(bào)錯(cuò)發(fā)生，這可能就是大家都沒(méi)有選擇高級(jí)安裝方法的原因吧。經(jīng)過(guò)嘗試，解決了所有報(bào)錯(cuò)，分析如下：

1.第一個(gè)報(bào)錯(cuò)，發(fā)生在7%，如圖： 

查看日志$ORACLE_BASE/cfgtoollogs/dbca/<ORACLE_SID>/trace.log可以看到如下報(bào)錯(cuò)

[Thread-99] [ 2014-07-10 16:28:55.965 CST ] [BasicStep.executeScriptUsingPerlEngine:769] executing : [/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl, -n, 1, -l, /u01/app/oracle/cfgtoollogs/dbca/DBSTYLE, -b, catalog, -u, SYS, -U, SYS, /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catalog.sql];secretArgs: 2
[Thread-99] [ 2014-07-10 16:28:55.965 CST ] [PerlEngine.execute:182] Execing PERL process...
[Thread-99] [ 2014-07-10 16:28:55.970 CST ] [PerlEngine.execute:212] m_bReaderStarted: false
[Thread-99] [ 2014-07-10 16:28:55.970 CST ] [PerlEngine.execute:216] Starting Reader Thread... 
[Thread-99] [ 2014-07-10 16:28:55.972 CST ] [PerlEngine.execute:255] Inputing secret arg: 0
[Thread-99] [ 2014-07-10 16:28:55.972 CST ] [PerlEngine.execute:255] Inputing secret arg: 1
java.io.IOException: Error in Process: /u01/app/oracle/product/12.1.0/dbhome_1/perl/bin/perl
    at oracle.sysman.assistants.util.sqlEngine.PerlEngine.execute(PerlEngine.java:305)
    at oracle.sysman.assistants.util.step.BasicStep.executeScriptUsingPerlEngine(BasicStep.java:770)
    at oracle.sysman.assistants.util.step.BasicStep.executeScriptUsingPerlEngine(BasicStep.java:625)
    at oracle.sysman.assistants.dbca.backend.DBCatalogStep.executeScripts(DBCatalogStep.java:352)
    at oracle.sysman.assistants.dbca.backend.DBCatalogStep.executeImpl(DBCatalogStep.java:212)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:254)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:135)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2865)
    at java.lang.Thread.run(Thread.java:662)
[Thread-99] [ 2014-07-10 16:28:55.994 CST ] [BasicStep.configureSettings:348] messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@517da438
oracle.sysman.assistants.util.step.StepExecutionException: Error in Process: /u01/app/oracle/product/12.1.0/dbhome_1/perl/bin/perl
    at oracle.sysman.assistants.dbca.backend.DBCatalogStep.executeScripts(DBCatalogStep.java:406)
    at oracle.sysman.assistants.dbca.backend.DBCatalogStep.executeImpl(DBCatalogStep.java:212)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:254)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:135)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2865)
    at java.lang.Thread.run(Thread.java:662)
java.io.IOException: Bad file descriptor
    at java.io.FileInputStream.readBytes(Native Method)
    at java.io.FileInputStream.read(FileInputStream.java:220)
    at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:264)
    at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:306)
    at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:158)
    at java.io.InputStreamReader.read(InputStreamReader.java:167)
    at java.io.BufferedReader.fill(BufferedReader.java:136)
    at java.io.BufferedReader.readLine(BufferedReader.java:299)
    at java.io.BufferedReader.readLine(BufferedReader.java:362)
    at oracle.sysman.assistants.util.sqlEngine.PerlEngine$LogStreamReader.readLogOutput(PerlEngine.java:1359)
    at oracle.sysman.assistants.util.sqlEngine.PerlEngine$LogStreamReader.run(PerlEngine.java:1306)
    at java.lang.Thread.run(Thread.java:662)

表示 /u01/app/oracle/product/12.1.0/dbhome_1/perl/bin/perl 這個(gè)執(zhí)行文件有問(wèn)題，于是手工執(zhí)行一下，果然不行。

[oracle@dbstyle ~]$ cd $ORACLE_HOME/perl/bin
[oracle@dbstyle bin]$ ./perl
Segmentation fault (core dumped)

執(zhí)行安裝時(shí)的命令也一樣會(huì)報(bào)錯(cuò)。

[oracle@dbstyle admin]$ /u01/app/oracle/product/12.1.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -n 1 -l /u01/app/oracle/cfgtoollogs/dbca/DBSTYLE -b catalog -u SYS -U SYS /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catalog.sql
Can't locate catcon.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl line 56.
BEGIN failed--compilation aborted at /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl line 56.

看來(lái)是oracle自帶的這個(gè)perl不完整所致，于是用系統(tǒng)的perl替換oracle自帶的perl

[oracle@dbstyle ~]$ cd $ORACLE_HOME/perl/bin
[oracle@dbstyle bin]$ mv perl perl.bak
[oracle@dbstyle bin]$ ln -s /usr/bin/perl $ORACLE_HOME/perl/bin

報(bào)錯(cuò)解決

[Thread-94] [ 2014-07-09 23:22:23.789 CST ] [BasicStep.executeScriptUsingPerlEngine:769] executing : [/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl, -n, 1, -l, /u01/app/oracle/cfgtoollogs/dbca/DBSTYLE, -b, catalog, -u, SYS, -U, SYS, /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catalog.sql];secretArgs: 2
[Thread-94] [ 2014-07-09 23:22:23.790 CST ] [PerlEngine.execute:182] Execing PERL process...
[Thread-94] [ 2014-07-09 23:22:23.791 CST ] [PerlEngine.execute:212] m_bReaderStarted: false
[Thread-94] [ 2014-07-09 23:22:23.791 CST ] [PerlEngine.execute:216] Starting Reader Thread... 
[Thread-94] [ 2014-07-09 23:22:23.795 CST ] [PerlEngine.execute:255] Inputing secret arg: 0
[Thread-94] [ 2014-07-09 23:22:23.795 CST ] [PerlEngine.execute:255] Inputing secret arg: 1

2.第二個(gè)報(bào)錯(cuò)，發(fā)生在16%，如圖： 

查看日志$ORACLE_BASE/cfgtoollogs/dbca/<ORACLE_SID>/trace.log可以看到如下報(bào)錯(cuò)：

[Thread-94] [ 2014-07-10 16:47:48.769 CST ] [BasicStep.executeScriptUsingPerlEngine:769] executing : [/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl, -n, 1, -l, /u01/app/oracle/cfgtoollogs/dbca/DBSTYLE, -b, initjvm, -u, SYS, -U, SYS, /u01/app/oracle/product/12.1.0/dbhome_1/javavm/install/initjvm.sql]; secretArgs: 2
[Thread-94] [ 2014-07-10 16:47:48.769 CST ] [PerlEngine.execute:182] Execing PERL process...
[Thread-94] [ 2014-07-10 16:47:48.770 CST ] [PerlEngine.execute:212] m_bReaderStarted: false
[Thread-94] [ 2014-07-10 16:47:48.770 CST ] [PerlEngine.execute:216] Starting Reader Thread... 
[Thread-94] [ 2014-07-10 16:47:48.776 CST ] [PerlEngine.execute:255] Inputing secret arg: 0
[Thread-94] [ 2014-07-10 16:47:48.776 CST ] [PerlEngine.execute:255] Inputing secret arg: 1
[Thread-94] [ 2014-07-10 16:47:50.429 CST ] [BasicStep.configureSettings:348] messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@7c60f77e
oracle.sysman.assistants.util.step.StepExecutionException: Error in Process: /u01/app/oracle/product/12.1.0/dbhome_1/perl/bin/perl
    at oracle.sysman.assistants.util.step.dboption.JServerDBOptionStep.executeImpl(JServerDBOptionStep.java:334)
    at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:254)
    at oracle.sysman.assistants.util.step.Step.execute(Step.java:135)
    at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2865)
    at java.lang.Thread.run(Thread.java:662)

因?yàn)橐呀?jīng)替換了perl文件應(yīng)該不會(huì)再是perl原因?qū)е铝?。于是進(jìn)一步查看 $ORACLE_BASE/cfgtoollogs/dbca/<ORACLE_SID>/initjvm0.log 日志，看到如下報(bào)錯(cuò)：

create or replace java system
begin if initjvmaux.startstep(\'CREATE_JAVA_SYSTEM\') then
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at \"SYS.INITJVMAUX\", line 28
ORA-06512: at line 5

受到MOS的啟發(fā)（見(jiàn)附錄），應(yīng)該是 $ORACLE_HOME/javavm/admin/ 中找不到classes.bin文件，于是創(chuàng)建到oracle自帶jdk6的軟鏈接，如下：

[oracle@dbstyle ~]$ cd /u01/app/oracle/product/12.1.0/dbhome_1/javavm/admin
[oracle@dbstyle admin]$ ls
jdk.versions libjtcjt.so
[oracle@dbstyle admin]$ ln -s ../jdk/jdk6/admin/classes.bin .
[oracle@dbstyle admin]$ ls
classes.bin jdk.versions libjtcjt.so
[oracle@dbstyle admin]$ ls -alt
total 204
drwxr-xr-x 2 oracle oinstall 4096 Jul 10 16:52 .
lrwxrwxrwx 1 oracle oinstall 29 Jul 10 16:52 classes.bin -> ../jdk/jdk6/admin/classes.bin
drwxr-xr-x 8 oracle oinstall 4096 Jul 8 23:15 ..
-rw-r--r-- 1 oracle oinstall 195974 Apr 4 2013 libjtcjt.so
-rw-r--r-- 1 oracle oinstall 723 Jul 14 2011 jdk.versions
[oracle@dbstyle admin]$

注意：不要鏈接jdk7的classes.bin,否則會(huì)報(bào)錯(cuò)

ORA-29548: Java system class reported: release of classes.bin in the database
does not match that of the oracle executable

最終，報(bào)錯(cuò)解決，完成安裝。

【總結(jié)】

1.安裝時(shí)，選擇“Install database software only”中的”Advanced Mode”安裝方法。

2.內(nèi)存一定要給到2G左右，內(nèi)存不足時(shí)，安裝時(shí)會(huì)報(bào)各種錯(cuò)誤。

3.為什么會(huì)有如此的報(bào)錯(cuò)呢？應(yīng)該是oracle自己的原因。

【附錄】

Check ORA$ENV to resolve "ORA-22288 Executing initjvm.sql on z/OS" (Doc ID 143773.1)

Problem Description

-------------------

When executing the create or replace java system command in initjvm script 

on z/OS the following message appears without a specific file name:

ORA-22288: file or LOB operation FILEOPEN failed

(NO DATA)

Solution Description

--------------------

The cause of this message is that JDK(classes.bin file) cannot be accessed.

If the following message is displayed displayed in the Database joblog

IKJ56228I PATH /frsup/EMEA/10g/V10202/javavm/admin/classes.bin NOT IN CATALOG OR

 CATALOG CAN NOT BE ACCESSED

Then, check that ORACLE_HOME is inside ORA$ENV file. E.G: 

//EPS9 PROC

//*----------------------------------------------------------------*

//*----------------------------------------------------------------*

//IEFPROC  EXEC PGM=ORARASC,REGION=0M

//STEPLIB  DD  DISP=SHR,DSN=EMEASUP.V10202.FIXTAPE.B5225799.AUTHLOAD

//         DD  DISP=SHR,DSN=EMEASUP.V10202.AUTHLOAD

//ORA$LIB  DD  DISP=SHR,DSN=EMEASUP.V10202.MESG

//SQLBSQ   DD DISP=SHR,DSN=EMEASUP.V10202.SQL(SQLBSQ)

//*

//ORA$FPS  DD DISP=SHR,DSN=EMEASUP.EPS9.PARMLIB(EPS9FPS)

//ORA$ENV  DD *

ORACLE_HOME='/support/EMEA/10g/V10202'

//INITORA  DD DISP=SHR,DSN=EMEASUP.EPS9.PARMLIB(INITORA)

If the ORACLE_HOME is correct, then check the permissions to access the classes.bin file.

Go to omvs either by rlogin, telnet or executing command 'tso omvs'.

Then execute ls command 

$ ls - $ORACLE_HOME/javavm/admin

-rw-rw-r--   1 AJONES   EMEASUP  63106160 Jan 25  2006 classes.bin   

See Note 261070.1 ORA-22288 when running SIDJD01/initjvm, for other potential

solutions for JDK(classes.bin) access issues.

Explanation

-----------

The create or replace java system command is executed in the Oracle Database address space 

and calls the Java Virtual Machine installed in Unix Services.

To call the JVM, access to the JDK(classes.bin file) is required. 

The directory where the JDK is installed is indicated in the ORACLE_HOME variable

in Unix Services.

The Oracle Database address space checks the ORACLE_HOME variable

included in DD card ORA$ENV to find out where the directory is.

If the value of this variable is wrong or permissions to the directory or file are

wrong, the Database cannot read the JDK.