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

全部博文(815)

文章存档

2014年(1)

2011年(46)

2010年(192)

2009年(121)

2008年(70)

2007年(385)

分类: Oracle

2009-04-03 00:07:18

[oracle@demo ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 3 00:07:37 2009

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

SQL> conn sys/123456 as sysdba;
Connected to an idle instance.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/10.2.0/db_1/dbs/initdbcl.ora'
SQL>

处理过程:
1.
[oracle@demo dbs]$ cd /opt/oracle/product/10.2.0/db_1/dbs/
[oracle@demo dbs]$ cp init.ora initdbcl.ora
[oracle@demo dbs]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 3 00:22:31 2009

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

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

2.没有足够的共享池,调整shared_spool_size 值
[oracle@demo dbs]$ vi initdbcl.ora
shared_pool_size = 90000000                                         # SMALL

SQL> startup;
ORACLE instance started.

Total System Global Area  125829120 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            4194304 bytes
Redo Buffers                2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info


SQL>


阅读(1111) | 评论(0) | 转发(0) |
0

上一篇:oralce 测试

下一篇:sina 域名问题

给主人留下些什么吧!~~