建库的过程中DBCA报错，错误号为ORA-12547

来源：赛迪网    作者：李丝

问题：在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包安装之后，重新创建数据库，安装就会顺利完成。

[root@yans3 ~]# rpm -ivh libaio-0.3.105-2.i386.rpm 
warning: libaio-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:libaio ########################################### [100%]
[root@yans3 ~]# rpm -ivh libaio-0.3.105-2.x86_64.rpm 
warning: libaio-0.3.105-2.x86_64.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:libaio ########################################### [100%]