问题：在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%]
|
闽公网安备 35060202000074号