[oracle@testrac2 11204]$ sqlplus / as sysdba
sql*plus: release 11.2.0.4.0 production on wed jan 16 18:50:03 2019
copyright (c) 1982, 2013, oracle. all rights reserved.
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
copyright (c) 1982, 2013, oracle. all rights reserved.
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>
可以了正常了。。。