同事搭一个测试RAC说节点2发现idle了，报ORA-00304

程序员文章站 2022-08-31 12:32:57

[oracle@testrac2 11204]$ sqlplus / as sysdba

sql*plus: release 11.2.0.4.0 production on wed jan 16 18:50:03 2019

connected to an idle instance.

sql> startup
ora-00304: requested instance_number is busy

[grid@testrac1 ~]$ crs_stat -t -v
name type r/ra f/ft target state host
----------------------------------------------------------------------
ora.datadg.dg ora....up.type 0/5 0/ online online testrac1
ora.griddg.dg ora....up.type 0/5 0/ online online testrac1
ora....er.lsnr ora....er.type 0/5 0/ online online testrac1
ora....n1.lsnr ora....er.type 0/5 0/0 online online testrac1
ora.asm ora.asm.type 0/5 0/ online online testrac1
ora.cvu ora.cvu.type 0/5 0/0 online online testrac1
ora.gsd ora.gsd.type 0/5 0/ offline offline
ora....network ora....rk.type 0/5 0/ online online testrac1
ora.oc4j ora.oc4j.type 0/1 0/2 online online testrac1
ora.ons ora.ons.type 0/3 0/ online online testrac1
ora.scan1.vip ora....ip.type 0/0 0/0 online online testrac1
ora.testrac.db ora....se.type 0/2 0/1 online online testrac1
ora....sm1.asm application 0/5 0/0 online online testrac1
ora....c1.lsnr application 0/5 0/0 online online testrac1
ora....ac1.gsd application 0/5 0/0 offline offline
ora....ac1.ons application 0/3 0/0 online online testrac1
ora....ac1.vip ora....t1.type 0/0 0/0 online online testrac1
ora....sm2.asm application 0/5 0/0 online online testrac2
ora....c2.lsnr application 0/5 0/0 online online testrac2
ora....ac2.gsd application 0/5 0/0 offline offline
ora....ac2.ons application 0/3 0/0 online online testrac2
ora....ac2.vip ora....t1.type 0/0 0/0 online online testrac2

检查下环境变量，发现不是网上所说的环境变量的问题
[grid@testrac2 ~]$ env | grep oracle_sid
oracle_sid=+asm2
[grid@testrac2 ~]$ ps -ef|grep oracle |grep asm
grid 31099 1 0 2018 ? 00:00:00 oracle+asm2 (description=(local=yes)(address=(protocol=beq)))
grid 31171 1 0 2018 ? 00:00:00 oracle+asm2_ocr (description=(local=yes)(address=(protocol=beq)))
grid 31175 1 0 2018 ? 00:02:33 oracle+asm2_asmb_+asm2 (description=(local=yes)(address=(protocol=beq)))
grid 31318 1 0 2018 ? 00:00:09 oracle+asm2 (description=(local=yes)(address=(protocol=beq)))

[oracle@testrac2 ~]$ echo $oracle_sid
testrac2

sql> select inst_id ,instance_number ,instance_name from gv$instance;

inst_id instance_number instance_name
---------- --------------- ------------------------------------------------
1 1 testrac1
sql> select group#,thread# from v$log;

group# thread#
---------- ----------
1 1
2 1
3 1

sql> select member from v$logfile;

member
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+datadg/testrac/onlinelog/group_1.257.995827307
+datadg/testrac/onlinelog/group_2.258.995827307
+datadg/testrac/onlinelog/group_3.259.995827309

sql> alter database add logfile thread 2 ('+datadg','+datadg') size 100m;

database altered.

sql> alter database add logfile thread 2 ('+datadg','+datadg') size 100m;

database altered.

sql> alter database add logfile thread 2 ('+datadg','+datadg') size 100m;

database altered.

sql> select group#,thread# from v$log;

group# thread#
---------- ----------
1 1
2 1
3 1
4 2
5 2
6 2

6 rows selected.

sql> alter database enable thread 2;

database altered.

难道安装时候没勾选节点2，他说从节点1拷贝了一个参数文件，下面的3个参数也没改。。。能启动才怪
#testrac2.instance_number=1
testrac2.instance_number=2
*.open_cursors=300
*.pga_aggregate_target=1649410048
*.processes=150
*.remote_listener='racscanip:1521'
*.remote_login_passwordfile='exclusive'
*.sga_target=4949278720
#testrac2.thread=1
testrac2.thread=2
#testrac2.undo_tablespace='undotbs1'
testrac2.undo_tablespace='undotbs2'

[oracle@testrac2 dbs]$ sqlplus / as sysdba

sql*plus: release 11.2.0.4.0 production on wed jan 16 19:34:42 2019

connected to an idle instance.

sql> startup pfile='/u01/app/oracle/11204/dbs/inittestrac2.ora';
oracle instance started.

total system global area 4927172608 bytes
fixed size 2261648 bytes
variable size 1090522480 bytes
database buffers 3825205248 bytes
redo buffers 9183232 bytes
database mounted.
database opened.
sql> select status from v$instance;

status
------------------------------------
open

sql> select inst_id ,instance_number ,instance_name from gv$instance;

inst_id instance_number instance_name
---------- --------------- ------------------------------------------------
2 2 testrac2
1 1 testrac1

sql>
可以了正常了。。。

上一篇： Java 插入附件到PDF文档

下一篇：不止骁龙888版本！Redmi K40系列下月发：2999元起