oracle sqlplus出不来,奇怪的事情又来了--从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，据说在里面和在外面启动和关闭效里是一致的。

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