oracle9i dbca出现01092错误,我快崩溃了,望前辈指点!
在redhat9 安装oracle9i 过程正常,但是dbca建库不成功总在第一步0%时
出现ora-01092racle instance terminated disconnection forced的错误
我的配置是392M ,PIII500
我收下oracle 9i 的LOG
以下是 alert_zz.log错误部分。
Sat May 15 18:16:33 2004
Errors in file /mnt/DISK2G/admin/zz/udump/ora_2448.trc:
ORA-01501: CREATE DATABASE failed
ORA-01990: error opening password file '/mnt/diskc/oracle/product/9.0.1/dbs/orapw'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Sat May 15 18:16:33 2004
Error 1990 happened during db open, shutting down database
USER: terminating instance due to error 1990
Instance terminated by USER, pid = 2448
ORA-1092 signalled during: CREATE DATABASE zz
MAXINSTANCES 1
MAXLOGHISTORY 1
...
以下是 ora_2448.trc 的内容
/mnt/DISK2G/admin/zz/udump/ora_2448.trc
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
ORACLE_HOME = /mnt/diskc/oracle/product/9.0.1
System name: Linux
Node name: zn
Release: 2.4.20-8bigmem
Version: #1 SMP Thu Mar 13 17:32:29 EST 2003
Machine: i686
Instance name: zz
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 2448, image: oracle@zn (TNS V1-V3)
*** 2004-05-15 18:16:33.842
*** SESSION ID7.3) 2004-05-15 18:16:33.697
ORA-01501: CREATE DATABASE failed
ORA-01990: error opening password file '/mnt/diskc/oracle/product/9.0.1/dbs/orapw'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
完整的alert_zz.log
Sat May 15 18:08:49 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Sat May 15 18:09:16 2004
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 100663296
large_pool_size = 10485760
java_pool_size = 67108864
resource_manager_plan = SYSTEM_PLAN
control_files = /mnt/DISK2G/oradata/zz/control01.ctl, /mnt/DISK2G/oradata/zz/control02.ctl, /mnt/DISK2G/oradata/zz/control03.ctl
db_block_size = 8192
db_cache_size = 201326592
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain = zn.com.cn
instance_name = zz
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = /mnt/DISK2G/admin/zz/bdump
user_dump_dest = /mnt/DISK2G/admin/zz/udump
core_dump_dest = /mnt/DISK2G/admin/zz/cdump
sort_area_size = 524288
db_name = zz
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
Sat May 15 18:09:26 2004
starting up 1 shared server(s) ...
RECO started with pid=7
Sat May 15 18:09:27 2004
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat May 15 18:09:34 2004
CREATE DATABASE zz
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE '/mnt/DISK2G/data1/oradata/zz/system01.dbf' SIZE 325M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS" DATAFILE '/mnt/DISK2G/data1/oradata/zz/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/mnt/diskc/oracle/oradata/zz/redo01.log') SIZE 100M,
GROUP 2 ('/mnt/diskc/oracle/oradata/zz/redo02.log') SIZE 100M,
GROUP 3 ('/mnt/diskc/oracle/oradata/zz/redo03.log') SIZE 100M
Sat May 15 18:09:39 2004
Database mounted in Exclusive Mode.
Sat May 15 18:10:22 2004
Successful mount of redo thread 1, with mount id 4016122590.
Assigning activation ID 4016122590 (0xef612ade)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /mnt/diskc/oracle/oradata/zz/redo01.log
Successful open of redo thread 1.
Sat May 15 18:10:23 2004
SMON: enabling cache recovery
Sat May 15 18:10:23 2004
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 May 15 18:10:24 2004
create tablespace SYSTEM datafile '/mnt/DISK2G/data1/oradata/zz/system01.dbf' SIZE 325M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Sat May 15 18:13:29 2004
Completed: create tablespace SYSTEM datafile '/mnt/DISK2G/da
Sat May 15 18:13:29 2004
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Sat May 15 18:14:06 2004
CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/mnt/DISK2G/data1/oradata/zz/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
Sat May 15 18:16:09 2004
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/mnt/DIS
Sat May 15 18:16:13 2004
SMON: enabling tx recovery
Sat May 15 18:16:33 2004
Errors in file /mnt/DISK2G/admin/zz/udump/ora_2448.trc:
ORA-01501: CREATE DATABASE failed
ORA-01990: error opening password file '/mnt/diskc/oracle/product/9.0.1/dbs/orapw'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Sat May 15 18:16:33 2004
Error 1990 happened during db open, shutting down database
USER: terminating instance due to error 1990
Instance terminated by USER, pid = 2448
ORA-1092 signalled during: CREATE DATABASE zz
MAXINSTANCES 1
MAXLOGHISTORY 1
...
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论