解决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/
[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: 1java.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@517da438oracle.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]$ ./perlSegmentation 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.sqlCan'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/
[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@7c60f77eoracle.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/
create or replace java systembegin if initjvmaux.startstep(\'CREATE_JAVA_SYSTEM\') then*ERROR at line 1:ORA-22288: file or LOB operation FILEOPEN failedNo such file or directoryORA-06512: at \"SYS.INITJVMAUX\", line 28ORA-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]$ lsjdk.versions libjtcjt.so[oracle@dbstyle admin]$ ln -s ../jdk/jdk6/admin/classes.bin .[oracle@dbstyle admin]$ lsclasses.bin jdk.versions libjtcjt.so[oracle@dbstyle admin]$ ls -alttotal 204drwxr-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.bindrwxr-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 databasedoes 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.
