Chinaunix首页 | 论坛 | 博客
  • 博客访问: 714890
  • 博文数量: 139
  • 博客积分: 7607
  • 博客等级: 少将
  • 技术积分: 1964
  • 用 户 组: 普通用户
  • 注册时间: 2007-11-11 23:43
个人简介

...

文章分类

全部博文(139)

文章存档

2012年(53)

2011年(4)

2010年(29)

2009年(10)

2008年(33)

2007年(10)

分类: LINUX

2008-05-11 16:03:07

SQL> startup
ORACLE instance started.
Total System Global Area  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
ORA-00201: control file version 10.2.0.1.0 incompatible with ORACLE version
10.2.0.0.0
ORA-00202: control file: '/opt/oracle/product/oradata/orcl/control01.ctl'
===================================
SQL> alter system set compatible='10.2.0.1.0' scope=spfile;
System altered.
============================
SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
===========================
SQL> startup
ORACLE instance started.
Total System Global Area  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/opt/oracle/product/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3
========================
root用户下:
  [root@localhost product]# chown -R oracle.oinstall /opt/oracle
======================
SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
===================
SQL> startup
ORACLE instance started.
Total System Global Area  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
ORA-01103: database name 'ORCL' in control file is not 'DEFAULT'
========================

SQL> show parameter db_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      DEFAULT
==========================
SQL> alter system set db_name=ORCL scope=spfile;
System altered.
========================
SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
========================
SQL> startup
ORACLE instance started.
Total System Global Area  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
==========================
SQL>
 
 
OK! Yeah!
阅读(1649) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~