oracle9i dbca出现01092错误,我快崩溃了,望前辈指点!

发布于 2022-10-02 02:09:46 字数 9098 浏览 13 评论 0

在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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文