centos4.8_64上安装oracle10201建库报ORA-12547

最新推荐文章于 2022-02-20 15:05:52 发布

jadesuper6

最新推荐文章于 2022-02-20 15:05:52 发布

阅读量1.7k

点赞数

分类专栏： oracle 文章标签： oracle centos passwords database 数据库 character

本文链接：https://blog.csdn.net/jadesuper6/article/details/8080910

版权

oracle 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

根据Oracle提供的官方文档在centos x86-64上安装Oracle10201，在建立数据库的过程中，DBCA报错，错误号为ORA-12547。

整个安装过程没有报错，通过DBCA建立数据库时则会出现ORA-12547错误。检查$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包。Metalink的文档Doc ID:Note:462325.1对这个问题进行了说明。

测试发现，对于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%]

更多参考：