解決12c安裝過程中的各種報錯

【詳細內容請點擊http://www.dbstyle.net/?p=993 地址】
Oracle Database 12c 推出不久，看到很多人已經完成了安裝測試。但是基本上都是使用“Create and configure a database”中的“Typical install”來完成安裝，而沒有人使用“Install database software only”中的”Advanced Mode”安裝方法。嘗試了一下高級安裝方法，有一些報錯發生，這可能就是大家都沒有選擇高級安裝方法的原因吧。經過嘗試，解決了所有報錯，分析如下：

1.第一個報錯，發生在7%，如圖： 

查看日志$ORACLE_BASE/cfgtoollogs/dbca/<ORACLE_SID>/trace.log可以看到如下報錯

[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 這個執行文件有問題，于是手工執行一下，果然不行。

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

執行安裝時的命令也一樣會報錯。

[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.

看來是oracle自帶的這個perl不完整所致，于是用系統的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

報錯解決

[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.第二個報錯，發生在16%，如圖： 

查看日志$ORACLE_BASE/cfgtoollogs/dbca/<ORACLE_SID>/trace.log可以看到如下報錯：

[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)

因為已經替換了perl文件應該不會再是perl原因導致了。于是進一步查看 $ORACLE_BASE/cfgtoollogs/dbca/<ORACLE_SID>/initjvm0.log 日志，看到如下報錯：

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的啟發（見附錄），應該是 $ORACLE_HOME/javavm/admin/ 中找不到classes.bin文件，于是創建到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,否則會報錯

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

最終，報錯解決，完成安裝。

【總結】

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

2.內存一定要給到2G左右，內存不足時，安裝時會報各種錯誤。

3.為什么會有如此的報錯呢？應該是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.