Shulou(Shulou.com)06/01 Report--

[click the http://www.dbstyle.net/?p=993 address for details]

Shortly after the launch of Oracle Database 12c, I saw that many people have completed the installation test. But basically they use the "Typical install" in "Create and configure a database" to complete the installation, and no one uses the "Advanced Mode" installation method in "Install database software only". I tried the advanced installation method, and some errors occurred, which may be the reason why we did not choose the advanced installation method. After trying, all the errors are solved, and the analysis is as follows:

1. The first error occurred at 7%, as shown in the figure:

Check the log $ORACLE_BASE/cfgtoollogs/dbca//trace.log and you can see the following error report

[Thread-99] [2014-07-10 16 executing 28 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 PerlEngine.execute:182 28secretArgs 55.965 CST] [PerlEngine.execute:182] Thread-99] [2014-07-10 16 28 secretArgs 55.970 CST] [PerlEngine.execute:212] m_bReaderStarted: false [CST-99] [PerlEngine.execute:216] Starting Reader Thread... [Thread-99] [2014-07-10 16 Thread-99 28 Inputing secret arg 55.972 CST] [PerlEngine.execute:255] Inputing secret arg: 0 [Thread-99] [2014-07-10 16 Vista 28 Thread-99 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 at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run 28V 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)

Indicates that there is something wrong with the execution file / u01/app/oracle/product/12.1.0/dbhome_1/perl/bin/perl, so execute it manually, and it really doesn't work.

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

Executing the installation command will also report an error.

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

It seems that the perl that comes with oracle is incomplete, so replace the perl that comes with oracle with the perl of the system.

[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

Error reporting and resolution

[Thread-94] [2014-07-09 23 BasicStep.executeScriptUsingPerlEngine:769 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 CST CST] [PerlEngine.execute:182] Execing PERL process.[ 2014-07-09 23 CST 22 CST] [PerlEngine.execute:212] m_bReaderStarted: false [CST-94] [PerlEngine.execute:216] Starting Reader Thread... [Thread-94] [2014-07-09 23 Inputing secret arg] [PerlEngine.execute:255] Inputing secret arg: 0 [Thread-94] [2014-07-09 23 PerlEngine.execute:255] [CST] [PerlEngine.execute:255] Inputing secret arg: 12. The second error occurred at 16%, as shown in the figure:

Looking at the log $ORACLE_BASE/cfgtoollogs/dbca//trace.log, you can see the following error:

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 CST 47 CST] [PerlEngine.execute:182] Execing PERL process.Thread-94] [2014-07-10 16 CST 47 CST] [PerlEngine.execute:212] m_bReaderStarted: false [CST-94] [PerlEngine.execute:216] Starting Reader Thread... [Thread-94] [2014-07-10 16 Thread-94 47 Inputing secret arg 48.776 CST] [PerlEngine.execute:255] Inputing secret arg: 0 [Thread-94] [2014-07-10 16 Thread-94 47 Thread-94 48.776 CST] [PerlEngine.execute:255] Inputing secret arg: 1 [Thread-94] [2014-07-10 16 1474 messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@7c60f77eoracle.sysman.assistants.util.step.StepExecutionException] [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) because the perl file has been replaced, it should no longer be caused by perl. Then take a closer look at the $ORACLE_BASE/cfgtoollogs/dbca//initjvm0.log log and see the following error:

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, inspired by MOS (see appendix), should not find the classes.bin file in $ORACLE_HOME/javavm/admin/, so create a soft link to oracle's native jdk6, as follows:

[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. Lrwxrrwxwwx 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] $Note: do not link jdk7 classes.bin Otherwise, an error will be reported.

ORA-29548: Java system class reported: release of classes.bin in the databasedoes not match that of the oracle executable finally, the error is resolved, and the installation is completed.

[summary]

1. Select the "Advanced Mode" installation method in "Install database software only" when installing.

two。 Memory must be given to about 2G, when there is insufficient memory, various errors will be reported during installation.

3. Why is there such an error? It should be oracle's own fault.

[appendix]

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.