asm10g&11g升级降级测试(五)

2015-02-03 03:55:32 · 作者: · 浏览: 47
-managed resources on 'oratest'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oratest'
CRS-2673: Attempting to stop 'ora.DG10.dg' on 'oratest'
CRS-2673: Attempting to stop 'ora.DG11.dg' on 'oratest'
CRS-2673: Attempting to stop 'ora.DG12.dg' on 'oratest'
CRS-2677: Stop of 'ora.DG10.dg' on 'oratest' succeeded
CRS-2677: Stop of 'ora.DG11.dg' on 'oratest' succeeded
CRS-2677: Stop of 'ora.DG12.dg' on 'oratest' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'oratest'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oratest' succeeded
CRS-2677: Stop of 'ora.asm' on 'oratest' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oratest'
CRS-2677: Stop of 'ora.cssd' on 'oratest' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'oratest'
CRS-2677: Stop of 'ora.evmd' on 'oratest' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oratest' has completed
CRS-4133: Oracle High Availability Services has been stopped.




--卸载11g asm 启动10g asm
[root@oratest ~]# /opt/oracle/product/11g/grid/crs/install/roothas.pl -deconfig -force
Using configuration parameter file: /opt/oracle/product/11g/grid/crs/install/crsconfig_params
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Stop failed, or completed with errors.
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Delete failed, or completed with errors.
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
Successfully deconfigured Oracle Restart stack
[root@oratest ~]# /opt/oracle/product/10.2.0/bin/localconfig add
-bash: /opt/oracle/product/10.2.0/bin/localconfig: No such file or directory
[root@oratest ~]# /opt/oracle/product/10g/bin/localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized


Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
oratest
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
[root@oratest ~]#

SQL> l
1* select name,state from v$asm_diskgroup
SQL> /


NAME STATE
------------------------------ -----------
DG10 MOUNTED
DG11 DISMOUNTED
DG12 DISMOUNTED


SQL> SELECT PATH FROM V$AMS_DISK;
SELECT PATH FROM V$AMS_DISK
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only




SQL> SELECT PATH FROM V$ASM_DISK;


PATH
--------------------------------------------------------------------------------
/dev/oracleasm/disks/VOL2
/dev/oracleasm/disks/VOL1
/dev/oracleasm/disks/VOL9


SQL>




--数据库可以直接挂载
[oracle@oratest kefd]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 18 09:41:39 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1052770304 bytes
Fixed Size 1277676 bytes
Variable Size 260047124 bytes
Database Buffers 788529152 bytes
Redo Buffers 2916352 bytes
Database mounted.
Database opened.
SQL> create table hj10g as select * from dba_objects;
Table created.
SQL>




- -磁盘重新挂在后信息的差异:ASM实例的修改
kfed read /