Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3279079
  • 博文数量: 815
  • 博客积分: 12898
  • 博客等级: 上将
  • 技术积分: 7883
  • 用 户 组: 普通用户
  • 注册时间: 2006-12-25 09:57
文章分类

全部博文(815)

文章存档

2014年(1)

2011年(46)

2010年(192)

2009年(121)

2008年(70)

2007年(385)

分类: Oracle

2009-05-15 18:53:11

SQL> conn sys/123456 as sysdba;
Connected to an idle instance.
SQL> startup;
ORA-00371: not enough shared pool memory, should be atleast 168530636 bytes
SQL> startup;
ORACLE instance started.

Total System Global Area  566231040 bytes
Fixed Size                  2022112 bytes
Variable Size             528483616 bytes
Database Buffers           33554432 bytes
Redo Buffers                2170880 bytes
ORA-00205: error in identifying control file, check alert log for more info


SQL> select name from v$controlfile;

no rows selected

SQL> alter system set control_files='/opt/oracle/oradata/ATYU30/control01.ctl',
  2  '/opt/oracle/oradata/ATYU30/control02.ctl',
  3   '/opt/oracle/oradata/ATYU30/control03.ctl'
  4  scope=spfile;
alter system set control_files='/opt/oracle/oradata/ATYU30/control01.ctl',
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup


SQL> select name from v$controlfile;

no rows selected

SQL> quit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@wx_db_01 backup]$ ls
alert_ATYU30.log  hc_ATYU30.dat  init.ora  lkATYU30    orapwATYU30      spfileATYU30.ora
hc_orcl.dat      initdw.ora    lkORCL    orapworcl  spfileorcl.ora
[oracle@wx_db_01 backup]$ vi init
[oracle@wx_db_01 backup]$ cd ..
[oracle@wx_db_01 dbs]$ vi initATYU30.ora
[oracle@wx_db_01 dbs]$ vi initATYU30.ora
[oracle@wx_db_01 dbs]$ !sql
sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 15 19:00:22 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/123456 as sysdba;
Connected.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00111: no closing quote for value '/opt/oracl'
SQL> quit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@wx_db_01 dbs]$ vi initATYU30.ora
[oracle@wx_db_01 dbs]$ !sql
sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 15 19:01:22 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/123456 as sysdba;
Connected.
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area  566231040 bytes
Fixed Size                  2022112 bytes
Variable Size             528483616 bytes
Database Buffers           33554432 bytes
Redo Buffers                2170880 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/oradata/ATYU30/control01.ctl'


SQL>

阅读(3606) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~