问题：在REDHAT AS4 x86-64上安装Oracle10201（依据Oracle提供的官方文档），在建立数据库的过程中，DBCA报错，错误号为ORA-12547。在整个安装过程没有报错，通过DBCA建立数据库时则会出现ORA-12547错误。检查$ORACLE_HOME/cfgtoollogs/dbca目录下的trace.log文件发现下面的错误信息：
ORACLE_HOME/cfgtoollogs/dbca目录下的trace.log文件发现下面的错误信息：
[Thread-12] [18:18:55:185] [DBEntryStep.executeImpl:457]
CREATEDB without passwords = CREATE DATABASE "kaifa"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/data/oracle/oradata/kaifa/system01.dbf'
SIZE 1024M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/data/oracle/oradata/kaifa/sysaux01.dbf'
SIZE 1024M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '/data/oracle/oradata/kaifa/temp01.dbf' SIZE 4096M
REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/data/oracle
/oradata/kaifa/undotbs01.dbf' SIZE 4096M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/data/oracle/oradata/kaifa/redo01.log') SIZE 512000K,
GROUP 2 ('/data/oracle/oradata/kaifa/redo02.log') SIZE 512000K,
GROUP 3 ('/data/oracle/oradata/kaifa/redo03.log') SIZE 512000K
[Thread-12] [18:18:55:185] [StepContext$ModeRunner.run:2458]
---- Progress Needed:=true
[Thread-12] [18:18:55:186] [BasicStep.execute:201]
Executing Step : DB_CREATE_FILES
[Thread-12] [18:18:55:188]
[DBCreateFilesStep.executeImpl:323] creating TBS SQL=CREATE
SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '
/data/oracle/oradata/kaifa/users01.dbf' SIZE 50M REUSE
AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT
LOCAL SEGMENT SPACE MANAGEMENT AUTO
[Thread-12] [18:18:55:188] [DBCreateFilesStep.executeImpl:329]
Establish USERS as the default permanent tablespace of the database
[Thread-12] [18:18:55:188] [StepContext$ModeRunner.run:2458]
---- Progress Needed:=true
[Thread-12] [18:18:55:189] [BasicStep.execute:201]
Executing Step : DB_CATALOG
[Thread-12] [18:18:55:189] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-00942
[Thread-12] [18:18:55:189] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-00955
[Thread-12] [18:18:55:189] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-01432
[Thread-12] [18:18:55:189] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-01434
[Thread-12] [18:18:55:189] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-01918
[Thread-12] [18:18:55:189] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-01919
[Thread-12] [18:18:55:190] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-01921
[Thread-12] [18:18:55:190] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-02289
[Thread-12] [18:18:55:191] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-04043
[Thread-12] [18:18:55:191] [StepErrorHandler.setFatalErrors:322]
setting Fatal Error: ORA-29807
.
.
.
[Thread-15] [18:44:1:470] [StepErrorHandler.setIgnorableErrors:250]
setting Ignorable Error: PLS-00201
[Thread-15] [18:44:1:470] [StepErrorHandler.setIgnorableErrors:250]
setting Ignorable Error: PL/SQL
[Thread-15] [18:44:1:470] [StepErrorHandler.setIgnorableErrors:250]
setting Ignorable Error: ORA-29931
[Thread-15] [18:44:1:470] [StepErrorHandler.setIgnorableErrors:250]
setting Ignorable Error: ORA-02024
[Thread-15] [18:44:1:510] [SQLEngine.done:1951] Done called
|
解答：查询metalink，你可以清楚的发现缺少一个libaio包。
对于libaio包，无论是32位的还是64位的，都是Oracle所必不可少的，两者缺一不可。而这个包是AS4 64 UPDATE 4所必须的，在安装10201 for As4 for x86-64 update1时，则不会发现类似的问题。
在将两个libaio包安装之后，重新创建数据库，安装就会顺利完成。
共2页: 上一页 1 [2] 下一页 |
