我在公司环境做测试的时候发现RAC环境的二节点实例没起来

[oracle@s2-11g dbs]$ ps -ef |grep smon

oracle    7030     1  0 Jun14 ?        00:00:56 ora_smon_orcl2

root     21726     1  3 May26 ?        1-01:40:25 /oracle/grid/crs_1/bin/osysmond.bin

grid     22185     1  0 May26 ?        00:00:51 asm_smon_+ASM2

oracle   25043 13931  0 11:05 pts/1    00:00:00 grep smon

 

尝试进行手动启动:

[oracle@s2-11g trace]$  srvctl start instance -d fulldb -i fulldb2

PRCR-1013 : Failed to start resource ora.fulldb.db

PRCR-1064 : Failed to start resource ora.fulldb.db on node s2-11g

CRS-2674: Start of 'ora.ons' on 's1-11g' failed

CRS-5017: The resource action "ora.fulldb.db start" encountered the following error:

ORA-01078: failure in processing system parameters

ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account

ORA-00849: SGA_TARGET 3221225472 cannot be set to more than MEMORY_MAX_TARGET 0.

 

 

 

 

 

查看alert日志发现:

Mon Jun 12 19:43:09 2017

ALTER SYSTEM SET memory_target='0' SCOPE=SPFILE SID='fulldb2';

ALTER SYSTEM SET memory_max_target='0' SCOPE=SPFILE SID='fulldb2';

ALTER SYSTEM SET sga_target='0' SCOPE=SPFILE SID='fulldb2';

 

 

memory_target的参数值被手动修改过。

这样修改其实并不是关闭memory_target参数,oracle在启动的时候默认这个参数开启,并且值为0,所以报错。

 

 

创建参数文件:

fulldb2>create pfile='/tmp/init.ora' from spfile;

vi /tmp/init.ora

中删除memory_target参数。

 

 

fulldb2>startup pfile='/tmp/init.ora'

ORACLE instance started.

 

Total System Global Area 3206836224 bytes

Fixed Size                  2257520 bytes

Variable Size            1040190864 bytes

Database Buffers         2147483648 bytes

Redo Buffers               16904192 bytes

Database mounted.

Database opened.

 

可以看到在启动数据库的时候memory_target参数被关闭了。

 

SQL>create spfile from pfile;

SQL>shutdown immediate

$srvctl start instance -d fulldb -i fulldb2

[oracle@s2-11g dbs]$ ps -ef |grep smon

oracle    7030     1  0 Jun14 ?        00:00:56 ora_smon_orcl2

oracle   21649     1  0 10:48 ?        00:00:00 ora_smon_fulldb2

root     21726     1  3 May26 ?        1-01:40:25 /oracle/grid/crs_1/bin/osysmond.bin

grid     22185     1  0 May26 ?        00:00:51 asm_smon_+ASM2

 

oracle   25043 13931  0 11:05 pts/1    00:00:00 grep smon




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件