【Troubleshooting】Resolve Error in installation of Oracle 12c on OEL 6.5




  • Oracle Database 12c 推出不久,看到很多人已经完成了安装测试。但是基本上都是使用“Create and configure a database”中的“Typical install”来完成安装,而没有人使用“Install database software only”中的”Advanced Mode”安装方法。尝试了一下高级安装方法,有一些报错发生,这可能就是大家都没有选择高级安装方法的原因吧。经过尝试,解决了所有报错,分析如下:

    1.第一个报错,发生在7%,如图: 

    20140710.1.1

    查看日志$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%,如图: 

    20140710.1.2

    查看日志$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.

    Speak Your Mind

    *