奇怪的事情又来了--从sqlplus里不能启动oracle.

一个双节点的RAC。

其中一个节点关闭了。

于是想启动,结果报错了。

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 2550136832 bytes
Fixed Size 2032256 bytes
Variable Size 553655680 bytes
Database Buffers 1979711488 bytes
Redo Buffers 14737408 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oradata1/RTST/spfileRTST.ora
SQL> show paraemter cluster
SP2-0158: unknown SHOW option "paraemter"
SP2-0158: unknown SHOW option "cluster"
SQL> show parameter cluster

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string
SQL> show parameter recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle_backup/RTST/flash
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0

于是想用crs_start试一下

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Data Mining options

$ crs_stop -all
Attempting to stop `ora.RTST.RTST1.RTST1.srv` on member `tst-rac02-ud-us-eqx`
Attempting to stop `ora.RTST.RTST2.RTST2.srv` on member `tst-rac02-ud-us-eqx`
Attempting to stop `ora.tst-rac02-ud-us-eqx.ons` on member `tst-rac02-ud-us-eqx`
Attempting to stop `ora.tst-rac01-ud-us-eqx.ons` on member `tst-rac01-ud-us-eqx`
Attempting to stop `ora.RTST.RTST1.cs` on member `tst-rac01-ud-us-eqx`
Attempting to stop `ora.RTST.db` on member `tst-rac01-ud-us-eqx`
Attempting to stop `ora.RTST.RTST2.cs` on member `tst-rac02-ud-us-eqx`
Stop of `ora.RTST.RTST1.RTST1.srv` on member `tst-rac02-ud-us-eqx` succeeded.
Stop of `ora.RTST.RTST2.RTST2.srv` on member `tst-rac02-ud-us-eqx` succeeded.
Stop of `ora.tst-rac01-ud-us-eqx.ons` on member `tst-rac01-ud-us-eqx` succeeded.
Stop of `ora.tst-rac02-ud-us-eqx.ons` on member `tst-rac02-ud-us-eqx` succeeded.
Stop of `ora.RTST.RTST1.cs` on member `tst-rac01-ud-us-eqx` succeeded.
Stop of `ora.RTST.RTST2.cs` on member `tst-rac02-ud-us-eqx` succeeded.
Stop of `ora.RTST.db` on member `tst-rac01-ud-us-eqx` succeeded.
Attempting to stop `ora.tst-rac01-ud-us-eqx.LISTENER_TST-RAC01-UD-US-EQX.lsnr` on member `tst-rac01-ud-us-eqx`
`ora.RTST.RTST2.inst` is already OFFLINE.
`ora.RTST.RTST1.inst` is already OFFLINE.
Attempting to stop `ora.tst-rac02-ud-us-eqx.LISTENER_TST-RAC02-UD-US-EQX.lsnr` on member `tst-rac02-ud-us-eqx`
Stop of `ora.tst-rac02-ud-us-eqx.LISTENER_TST-RAC02-UD-US-EQX.lsnr` on member `tst-rac02-ud-us-eqx` succeeded.
Stop of `ora.tst-rac01-ud-us-eqx.LISTENER_TST-RAC01-UD-US-EQX.lsnr` on member `tst-rac01-ud-us-eqx` succeeded.
Attempting to stop `ora.tst-rac01-ud-us-eqx.vip` on member `tst-rac01-ud-us-eqx`
Attempting to stop `ora.tst-rac02-ud-us-eqx.vip` on member `tst-rac02-ud-us-eqx`
Stop of `ora.tst-rac01-ud-us-eqx.vip` on member `tst-rac01-ud-us-eqx` succeeded.
Stop of `ora.tst-rac02-ud-us-eqx.vip` on member `tst-rac02-ud-us-eqx` succeeded.
CRS-0216: Could not stop resource 'ora.RTST.RTST1.inst'.

CRS-0216: Could not stop resource 'ora.RTST.RTST2.inst'.

$ crs_start -all
Attempting to start `ora.tst-rac01-ud-us-eqx.vip` on member `tst-rac01-ud-us-eqx`
Attempting to start `ora.RTST.RTST2.inst` on member `tst-rac02-ud-us-eqx`
Attempting to start `ora.RTST.RTST1.inst` on member `tst-rac01-ud-us-eqx`
Attempting to start `ora.tst-rac02-ud-us-eqx.vip` on member `tst-rac02-ud-us-eqx`
Start of `ora.tst-rac01-ud-us-eqx.vip` on member `tst-rac01-ud-us-eqx` succeeded.
Attempting to start `ora.tst-rac01-ud-us-eqx.LISTENER_TST-RAC01-UD-US-EQX.lsnr` on member `tst-rac01-ud-us-eqx`
Start of `ora.tst-rac02-ud-us-eqx.vip` on member `tst-rac02-ud-us-eqx` succeeded.
Attempting to start `ora.tst-rac02-ud-us-eqx.LISTENER_TST-RAC02-UD-US-EQX.lsnr` on member `tst-rac02-ud-us-eqx`
Start of `ora.tst-rac01-ud-us-eqx.LISTENER_TST-RAC01-UD-US-EQX.lsnr` on member `tst-rac01-ud-us-eqx` succeeded.
Start of `ora.tst-rac02-ud-us-eqx.LISTENER_TST-RAC02-UD-US-EQX.lsnr` on member `tst-rac02-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST1.inst` on member `tst-rac01-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST2.inst` on member `tst-rac02-ud-us-eqx` succeeded.
Attempting to start `ora.RTST.RTST1.RTST1.srv` on member `tst-rac01-ud-us-eqx`
CRS-1002: Resource 'ora.tst-rac01-ud-us-eqx.ons' is already running on member 'tst-rac01-ud-us-eqx'

Attempting to start `ora.RTST.RTST2.cs` on member `tst-rac02-ud-us-eqx`
CRS-1002: Resource 'ora.tst-rac02-ud-us-eqx.ons' is already running on member 'tst-rac02-ud-us-eqx'

Attempting to start `ora.RTST.db` on member `tst-rac01-ud-us-eqx`
Attempting to start `ora.RTST.RTST2.RTST2.srv` on member `tst-rac02-ud-us-eqx`
Attempting to start `ora.RTST.RTST1.cs` on member `tst-rac01-ud-us-eqx`
Start of `ora.RTST.RTST1.RTST1.srv` on member `tst-rac01-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST1.cs` on member `tst-rac01-ud-us-eqx` succeeded.
Start of `ora.RTST.db` on member `tst-rac01-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST2.cs` on member `tst-rac02-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST2.RTST2.srv` on member `tst-rac02-ud-us-eqx` succeeded.
CRS-0223: Resource 'ora.tst-rac01-ud-us-eqx.ons' has placement error.

CRS-0223: Resource 'ora.tst-rac02-ud-us-eqx.ons' has placement error.

$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....ST1.srv application ONLINE ONLINE tst-...-eqx
ora....TST1.cs application ONLINE ONLINE tst-...-eqx
ora....T1.inst application ONLINE ONLINE tst-...-eqx
ora....ST2.srv application ONLINE ONLINE tst-...-eqx
ora....TST2.cs application ONLINE ONLINE tst-...-eqx
ora....T2.inst application ONLINE ONLINE tst-...-eqx
ora.RTST.db application ONLINE ONLINE tst-...-eqx
ora....QX.lsnr application ONLINE ONLINE tst-...-eqx
ora....eqx.ons application ONLINE ONLINE tst-...-eqx
ora....eqx.vip application ONLINE ONLINE tst-...-eqx
ora....QX.lsnr application ONLINE ONLINE tst-...-eqx
ora....eqx.ons application ONLINE ONLINE tst-...-eqx
ora....eqx.vip application ONLINE ONLINE tst-...-eqx

成功了，但不清楚为什么。

曾经咨询过oracle support，据说在里面和在外面启动和关闭效里是一致的。

从这里看肯定是有区别的。到底是什么区别有必要进一步考察。