刚刚安装了ORA9，都说建库简单，可是总是出错，哪位指点一下

m11andyov

建库的过程中，没有任何出错。在rdbms的日志中查看，已经执行完建库教本的最后一项了呀！
由于系统安装后，所有oracle的配置参数都是缺省的，我不知道是否因为sharedmem不够的原因造成的。我本机上的realmem是4G呀！
Tue Jan 13 12:05:16 2004
Errors in file /opt/oracle/app/product/9.2.0/rdbms/log/ora9_dbw0_1081460.trc:
ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","object level
s"
Tue Jan 13 12:05:16 2004
DBW0: terminating instance due to error 4031
Tue Jan 13 12:05:16 2004
Errors in file /opt/oracle/app/product/9.2.0/rdbms/log/ora9_lgwr_958678.trc:
ORA-04031: unable to allocate  bytes of shared memory ("","","",""
Tue Jan 13 12:05:16 2004
Errors in file /opt/oracle/app/product/9.2.0/rdbms/log/ora9_pmon_1056802.trc:
ORA-04031: unable to allocate  bytes of shared memory ("","","",""
Tue Jan 13 12:05:16 2004
Errors in file /opt/oracle/app/product/9.2.0/rdbms/log/ora9_ckpt_1138808.trc:
ORA-04031: unable to allocate  bytes of shared memory ("","","",""
Instance terminated by DBW0, pid = 1081460

nocode

oracle的小版本是什么？如果安装都没有报错出问题的话，检查一下linux系统内核参数是否都符合要求。
可能是个bug

m11andyov

oracle系统版本为9.2.0，系统是AIX5.1。

frankswf

把sharepool调大一点！

m11andyov

[quote]原帖由 "frankswf"]把sharepool调大一点！[/quote 发表：


是否有写道理！是否可以说明白些？

jianan

04031 这种错误太多了.建议去METALINK走一遭.

seraphim

realmem是4G不管用，需要调整系统内核的SHMMAX参数，设置为1073741824，也就是1G。否则创建数据库不会成功。