问题描述:
修改主机名后 db启动不了
[root@wk2 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.rac.db application OFFLINE OFFLINE
ora....c1.inst application ONLINE OFFLINE
ora....c2.inst application ONLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE wk1
ora....K1.lsnr application ONLINE ONLINE wk1
ora.wk1.gsd application ONLINE ONLINE wk1
ora.wk1.ons application ONLINE ONLINE wk1
ora.wk1.vip application ONLINE ONLINE wk1
ora....SM2.asm application ONLINE ONLINE wk2
ora....K2.lsnr application ONLINE ONLINE wk2
ora.wk2.gsd application ONLINE ONLINE wk2
ora.wk2.ons application ONLINE ONLINE wk2
ora.wk2.vip application ONLINE ONLINE wk2
尝试:
两个节点,ORACLE用户使用sqlplus工具进行启动
[root@wk2 ~]# su - oracle
[oracle@wk2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 29 06:38:26 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))'
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521))'
问题出现
解决办法:
一、任一节点进入sqlplus(如这里是节点1)使用init.ora文件启动
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 29 06:46:21 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile=$ORACLE_HOME/dbs/init.ora
ORA-00371: not enough shared pool memory, should be atleast62198988 bytes
出现该错误要修改$ORACLE_HOME/dbs/init.ora
改成: shared_pool_size =62198988
再次尝试
startup pfile=$ORACLE_HOME/dbs/init.ora
ORACLE instance started.
Total System Global Area 96468992 bytes
Fixed Size 1217884 bytes
Variable Size 88083108 bytes
Database Buffers 4194304 bytes
Redo Buffers 2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info
无法启动的原因找到,是因为参数REMOTE_LISTENER问题,需要修改为空
方法1:如果有一个节点能正常启动集群数据库,则直接修改参数remote_listener在内存和spfile的值
SQL> alter system set remote_listener=’’ scope=both;
方法2:借助ASM实例进行修改:
二、进入ASM实例使用sqlplus工具启动
[oracle@wk1 dbs]$ export ORACLE_SID=+ASM1
[oracle@wk1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 29 06:53:00 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> create pfile='/oracle/pfile_12_2' from spfile='+DATA/rac/spfilerac.ora' ;
File created.
创建一个Pfile, (pfile的路径任意指定
spfile的路径:在$ORACLE_HOME/dbs下使用cat 查看initrac1.ora)
[oracle@wk1 dbs]$ cat initrac1.ora
SPFILE='+DATA/rac/spfilerac.ora'
三、修改pfile文件
[oracle@wk1 dbs]$ cd /oracle
[oracle@wk1 oracle]$ vi pfile_12_2
在最后一行加上
*.remote_listener=''
四、登陆到RAC实例 使用RAC实例进入sqlplus
[oracle@wk1 ~]$ export ORACLE_SID=rac1 (或者直接退出sqlplus后再进)
[oracle@wk1 ~]$ sqlplus / as sysdba
SQL> shutdown immediate (关闭数据库)
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup pfile='/oracle/pfile_12_2' (使用Pfile文件启动)
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 155190864 bytes
Database Buffers 125829120 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> create spfile='+DATA/rac/spfilerac.ora' from pfile='/oracle/pfile_12_2' ;(将Pfile文件写入到spfile)
File created.
然后再另一个节点进入sqlplus进行数据库启动
[root@wk2 ~]# su - oracle
[oracle@wk2 ~]$ sqlplus / as sysdba
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 167773776 bytes
Database Buffers 113246208 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
最后检查CRS服务正常启动
[root@wk2 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.rac.db application ONLINE ONLINE wk2
ora....c1.inst application ONLINE ONLINE wk1
ora....c2.inst application ONLINE ONLINE wk2
ora....SM1.asm application ONLINE ONLINE wk1
ora....K1.lsnr application ONLINE ONLINE wk1
ora.wk1.gsd application ONLINE ONLINE wk1
ora.wk1.ons application ONLINE ONLINE wk1
ora.wk1.vip application ONLINE ONLINE wk1
ora....SM2.asm application ONLINE ONLINE wk2
ora....K2.lsnr application ONLINE ONLINE wk2
ora.wk2.gsd application ONLINE ONLINE wk2
ora.wk2.ons application ONLINE ONLINE wk2
ora.wk2.vip application ONLINE ONLINE wk2
----------------------------------------------------------------------------------------------
版权所有,如需转载,请注明出处,否则追加法律责任!
blog:http://blog.csdn.net/waycomecome