免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 数据库技术 › Oracle › RHEL 5 上安装oracle 9i 9.2,启动数据数库时报以下错
最近访问板块 发新帖
查看: 3207 | 回复: 3
打印 上一主题 下一主题

RHEL 5 上安装oracle 9i 9.2,启动数据数库时报以下错 [复制链接]

rb_sp

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2008-07-30 17:13 |只看该作者 |倒序浏览
RHEL 5  上安装oracle 9i  9.2,启动数据数库时报以下错误
-----------------------------------------------------------------
SQL> startup
ORACLE instance started.

Total System Global Area   97588504 bytes
Fixed Size                   451864 bytes
Variable Size              46137344 bytes
Database Buffers           50331648 bytes
Redo Buffers                 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
----------------------------------------------------------------------
alert_oracle1.log文件内容如下

Wed Jul 30 22:42:53 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  db_name                  = oracle1
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
RECO started with pid=7
Wed Jul 30 22:49:19 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 30 22:49:19 2008
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jul 30 22:49:34 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  db_name                  = oracle1
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
RECO started with pid=7
Wed Jul 30 22:49:39 2008
ALTER DATABASE   MOUNT
Wed Jul 30 22:49:39 2008
ORA-00202: controlfile: '?/dbs/cntrl@.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Wed Jul 30 22:49:39 2008
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Wed Jul 30 22:52:27 2008
Starting ORACLE instance (normal)
Wed Jul 30 22:52:57 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 30 22:52:57 2008
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jul 30 22:53:12 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  db_name                  = oracle1
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
RECO started with pid=7
Wed Jul 30 22:53:16 2008
ALTER DATABASE   MOUNT
Wed Jul 30 22:53:16 2008
ORA-00202: controlfile: '?/dbs/cntrl@.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Wed Jul 30 22:53:16 2008
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Starting ORACLE instance (normal)
Starting ORACLE instance (normal)
Wed Jul 30 23:11:45 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 30 23:11:45 2008
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jul 30 23:11:54 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  db_name                  = oracle1
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
RECO started with pid=7
Wed Jul 30 23:11:59 2008
ALTER DATABASE   MOUNT
Wed Jul 30 23:11:59 2008
ORA-00202: controlfile: '?/dbs/cntrl@.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Wed Jul 30 23:11:59 2008
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Wed Jul 30 23:25:28 2008
Errors in file /u01/app/oracle/9.2.0/rdbms/log/oracle1_ora_6945.trc:
ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []
Wed Jul 30 23:27:32 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 30 23:27:32 2008
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jul 30 23:27:44 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  db_name                  = oracle1
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
RECO started with pid=7
Wed Jul 30 23:27:48 2008
ALTER DATABASE   MOUNT
Wed Jul 30 23:27:48 2008
ORA-00202: controlfile: '?/dbs/cntrl@.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Wed Jul 30 23:27:48 2008
ORA-205 signalled during: ALTER DATABASE   MOUNT...


请高手指导,谢谢!
zhaopingzi

论坛徽章:
71
15-16赛季CBA联赛之同曦 日期:2018-08-23 15:41:42辰龙 日期:2014-08-15 09:07:43狮子座 日期:2014-06-03 13:55:33亥猪 日期:2014-06-02 11:17:08巨蟹座 日期:2014-05-06 10:02:03午马 日期:2014-05-04 08:18:27亥猪 日期:2014-04-29 11:11:32技术图书徽章 日期:2014-04-24 15:51:26技术图书徽章 日期:2014-04-17 11:01:53辰龙 日期:2014-04-15 12:45:46亥猪 日期:2014-04-11 09:06:23射手座 日期:2014-04-01 15:28:10
2楼 [报告]
发表于 2008-07-30 19:03 |只看该作者
看一下该目录下的控制文件存在吗?No such file or directory
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
interboy

论坛徽章:
0
3楼 [报告]
发表于 2008-07-30 19:32 |只看该作者
应该是找不到控制文件了
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
interboy

论坛徽章:
0
4楼 [报告]
发表于 2008-07-30 19:42 |只看该作者
你将数据库启动到nomount状态，查看控制存储的位置
startup nomount;
show parameters control_files;
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP