oracle9i01092,Oracle9i&10g编程艺术一书中create database 报错: ora-01092, 请教原因!

已用find命令找到alert_ALLEN.log文件

[root@localhost]# find / -name alert_ALLEN.log

/home/oracle/oracle/product/10.2.0/db_3/rdbms/log/alert_ALLEN.log

现贴出alert_ALLEN.log文件如下:

Sat Nov 24 21:27:05 2007

Starting ORACLE instance (normal)

Cannot determine all dependent dynamic libraries for /proc/self/exe

Unable to find dynamic library libocr10.so in search paths

RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:

LD_LIBRARY_PATH = /lib:/lib:/usr/lib

The default library directories are /lib and /usr/lib

Unable to find dynamic library libocrb10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Shared memory segment for instance monitoring created

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_1 parameter default value as /home/oracle/oracle/product/10.2.0/db_3/dbs/arch

Autotune of undo retention is turned off.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

db_name                  = ALLEN

PSP0 started with pid=3, OS id=3406

PMON started with pid=2, OS id=3404

MMAN started with pid=4, OS id=3408

DBW0 started with pid=5, OS id=3410

LGWR started with pid=6, OS id=3412

CKPT started with pid=7, OS id=3414

SMON started with pid=8, OS id=3416

RECO started with pid=9, OS id=3418

MMON started with pid=10, OS id=3420

Sat Nov 24 21:27:12 2007

Oracle Data Guard is not available in this edition of Oracle.

MMNL started with pid=11, OS id=3422

Sat Nov 24 21:34:02 2007

create database

Sat Nov 24 21:34:02 2007

WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command

Default Temporary Tablespace will be necessary for a locally managed database in future release

Sat Nov 24 21:34:03 2007

Database mounted in Exclusive Mode

Sat Nov 24 21:34:10 2007

Successful mount of redo thread 1, with mount id 1328336330

Assigning activation ID 1328336330 (0x4f2ccdca)

Thread 1 opened at log sequence 1

Current log# 1 seq# 1 mem# 0: /home/oracle/oracle/product/10.2.0/db_3/dbs/log1ALLEN.dbf

Successful open of redo thread 1

Sat Nov 24 21:34:10 2007

SMON: enabling cache recovery

Sat Nov 24 21:34:10 2007

create tablespace SYSTEM datafile '?/dbs/dbs1@.dbf' SIZE 81920000 REUSE

default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online

Sat Nov 24 21:34:15 2007

Completed: create tablespace SYSTEM datafile '?/dbs/dbs1@.dbf' SIZE 81920000 REUSE

default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online

Sat Nov 24 21:34:15 2007

create rollback segment SYSTEM tablespace SYSTEM

storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM

storage (initial 50K next 50K)

Sat Nov 24 21:34:25 2007

Errors in file /home/oracle/oracle/product/10.2.0/db_3/rdbms/log/allen_ora_3423.trc:

ORA-00604: error occurred at recursive SQL level 3

ORA-04031: unable to allocate 192 bytes of shared memory ("shared pool","select intcol#,nvl(pos#,0),c...","Typecheck","seg:kggfaAllocSeg")

Sat Nov 24 21:34:25 2007

Errors in file /home/oracle/oracle/product/10.2.0/db_3/rdbms/log/allen_ora_3423.trc:

ORA-01501: CREATE DATABASE failed

ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 1752

ORA-00604: error occurred at recursive SQL level 3

ORA-04031: unable to allocate 192 bytes of shared memory ("shared pool","select intcol#,nvl(pos#,0),c...","Typecheck","seg:kggfaAllocSeg")

Error 1519 happened during db open, shutting down database

USER: terminating instance due to error 1519

Sat Nov 24 21:34:25 2007

Errors in file /home/oracle/oracle/product/10.2.0/db_3/rdbms/log/allen_mman_3408.trc:

ORA-01519: error while processing file '' near line

Instance terminated by USER, pid = 3423

ORA-1092 signalled during: create database...

Sun Nov 25 14:47:02 2007

Starting ORACLE instance (normal)

Cannot determine all dependent dynamic libraries for /proc/self/exe

Unable to find dynamic library libocr10.so in search paths

RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:

LD_LIBRARY_PATH = /lib:/lib:/usr/lib

The default library directories are /lib and /usr/lib

Unable to find dynamic library libocrb10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_1 parameter default value as /home/oracle/oracle/product/10.2.0/db_3/dbs/arch

Autotune of undo retention is turned off.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

db_name                  = ALLEN

PMON started with pid=2, OS id=3181

PSP0 started with pid=3, OS id=3183

MMAN started with pid=4, OS id=3185

DBW0 started with pid=5, OS id=3187

LGWR started with pid=6, OS id=3189

CKPT started with pid=7, OS id=3191

SMON started with pid=8, OS id=3193

RECO started with pid=9, OS id=3195

Sun Nov 25 14:47:09 2007

Oracle Data Guard is not available in this edition of Oracle.

MMON started with pid=10, OS id=3197

MMNL started with pid=11, OS id=3199

丛错误提示看来:

1. WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command

Default Temporary Tablespace will be necessary for a locally managed database in future release

引用oracle文档:

Default Temporary Tablespace 3.2.5 默认的临时表空间

076 When the SYSTEM tablespace is locally managed, you must define at least one default temporary tablespace when creating a database. A locally managed SYSTEM tablespace cannot be used for default temporary storage

我没有指定默认的临时表空间.

2. ORA-00604: error occurred at recursive SQL level 3

ORA-04031: unable to allocate 192 bytes of shared memory ("shared pool","select intcol#,nvl(pos#,0),c...","Typecheck","seg:kggfaAllocSeg")

估计要加大共享内存

我用show parameter shared显示

shared_pool_size                     big integer 32M

只有32M

3. ORA-01501: CREATE DATABASE failed

ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 1752

参考了eygle

http://www.eygle.com/archives/2006/08/createdb_sql_bsq.html

当sql.bsq这个文件不存在的时候, 就会报如下错误:

ORA-01526: error in opening file '?/rdbms/admin/sql.bsq'

我的目录下面是有文件的: sql.bsq

因为在create database的时候, 会调用文件: sql.bsq, 估计是调用过程中出现了问题.

为什么会报这个错啊? 到网上找了很多文章, 都没有发现原因. 请教啊!