已用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, 估计是调用过程中出现了问题.
为什么会报这个错啊? 到网上找了很多文章, 都没有发现原因. 请教啊!