由于需要修改ASM存储方式,所以需要卸载oracle数据库,重新安装。
1、首先检查rac状态
[grid@RAC-2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.CRS.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.DATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.LISTENER.lsnr
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.MEM_DATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.RACDATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.asm
ONLINE ONLINE rac-1 Started
ONLINE ONLINE rac-2 Started
ora.gsd
ONLINE OFFLINE rac-1
ONLINE OFFLINE rac-2
ora.net1.network
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.ons
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac-1
ora.cvu
1 ONLINE ONLINE rac-1
ora.oc4j
1 ONLINE ONLINE rac-1
ora.oralnx.db
1 ONLINE ONLINE rac-1 Open
2 ONLINE ONLINE rac-2 Open
ora.rac-1.vip
1 ONLINE ONLINE rac-1
ora.rac-2.vip
1 ONLINE ONLINE rac-2
ora.scan1.vip
1 ONLINE ONLINE rac-1
2、进入oracle_home目录下,运行deinstall。
cd $ORACLE_HOME/deinstall
[oracle@RAC-1 deinstall]$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /oracle/app/oraInventory/logs/
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################### CHECK OPERATION START #########################
## [START] Install check configuration ##
Checking for existence of the Oracle home location /oracle/app/oracle/product/11.2/db_1
Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database
Oracle Base selected for deinstall is: /oracle/app/oracle
Checking for existence of central inventory location /oracle/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /oracle/app/11.2/grid
The following nodes are part of this cluster: rac-1,rac-2
Checking for sufficient temp space availability on node(s) : 'rac-1,rac-2'
## [END] Install check configuration ##
Network Configuration check config START
Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_check2014-04-08_10-35-56-AM.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_check2014-04-08_10-35-59-AM.log
Use comma as separator when specifying list of values as input
Specify the list of database names that are configured in this Oracle home [oralnx]: 此处默认,回车即可
###### For Database 'oralnx' ######
RAC Database
The nodes on which this database has instances: [rac-1, rac-2]
The instance names: [oralnx1, oralnx2]
The local instance name on node: oralnx1
The diagnostic destination location of the database: /oracle/app/oracle/diag/rdbms/oralnx
Storage type used by the Database: ASM
The details of database(s) oralnx have been discovered automatically. Do you still want to modify the details of oralnx database(s)? [n]: 此处默认,回车即可
Database Check Configuration END
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /oracle/app/oraInventory/logs/emcadc_check2014-04-08_10-36-59-AM.log
Checking configuration for database oralnx
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /oracle/app/oraInventory/logs//ocm_check5383.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /oracle/app/11.2/grid
The cluster node(s) on which the Oracle home deinstallation will be performed are:rac-1,rac-2
Oracle Home selected for deinstall is: /oracle/app/oracle/product/11.2/db_1
Inventory Location where the Oracle home registered is: /oracle/app/oraInventory
The following databases were selected for de-configuration : oralnx
Database unique name : oralnx
Storage used : ASM
No Enterprise Manager configuration to be updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
rac-1 : Oracle Home exists with CCR directory, but CCR is not configured
rac-2 : Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y 此处输入y 回车
A log of this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2014-04-08_10-35-48-AM.out'
Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2014-04-08_10-35-48-AM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /oracle/app/oraInventory/logs/emcadc_clean2014-04-08_10-36-59-AM.log
Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_clean2014-04-08_10-37-24-AM.log
Database Clean Configuration START oralnx
This operation may take few minutes.
Database Clean Configuration END oralnx
Network Configuration clean config START
Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_clean2014-04-08_10-40-25-AM.log
De-configuring Listener configuration file on all nodes...
Listener configuration file de-configured successfully.
De-configuring Naming Methods configuration file on all nodes...
Naming Methods configuration file de-configured successfully.
De-configuring Local Net Service Names configuration file on all nodes...
Local Net Service Names configuration file de-configured successfully.
De-configuring Directory Usage configuration file on all nodes...
Directory Usage configuration file de-configured successfully.
De-configuring backup files on all nodes...
Backup files de-configured successfully.
The network configuration has been cleaned up successfully.
Network Configuration clean config END
Oracle Configuration Manager clean START
OCM clean log file location : /oracle/app/oraInventory/logs//ocm_clean5383.log
Oracle Configuration Manager clean END
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START
Detach Oracle home '/oracle/app/oracle/product/11.2/db_1' from the central inventory on the local node : Done
Delete directory '/oracle/app/oracle/product/11.2/db_1' on the local node : Done
The Oracle Base directory '/oracle/app/oracle' will not be removed on local node. The directory is not empty.
Detach Oracle home '/oracle/app/oracle/product/11.2/db_1' from the central inventory on the remote nodes 'rac-2' : Done
Delete directory '/oracle/app/oracle/product/11.2/db_1' on the remote nodes 'rac-2' : Done
The Oracle Base directory '/oracle/app/oracle' will not be removed on node 'rac-2'. The directory is not empty.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
## [START] Oracle install clean ##
Clean install operation removing temporary directory '/tmp/deinstall2014-04-08_10-35-37AM' on node 'RAC-1'
Clean install operation removing temporary directory '/tmp/deinstall2014-04-08_10-35-37AM' on node 'rac-2'
## [END] Oracle install clean ##
######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################
Successfully de-configured the following database instances : oralnx
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home '/oracle/app/oracle/product/11.2/db_1' from the central inventory on the local node.
Successfully deleted directory '/oracle/app/oracle/product/11.2/db_1' on the local node.
Successfully detached Oracle home '/oracle/app/oracle/product/11.2/db_1' from the central inventory on the remote nodes 'rac-2'.
Successfully deleted directory '/oracle/app/oracle/product/11.2/db_1' on the remote nodes 'rac-2'.
Oracle Universal Installer cleanup was successful.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############
过程很简单,几分钟搞定。
3、检查rac状态,一切正常。
[grid@RAC-2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.CRS.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.DATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.LISTENER.lsnr
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.MEM_DATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.RACDATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.asm
ONLINE ONLINE rac-1 Started
ONLINE ONLINE rac-2 Started
ora.gsd
ONLINE OFFLINE rac-1
ONLINE OFFLINE rac-2
ora.net1.network
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.ons
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac-1
ora.cvu
1 ONLINE ONLINE rac-1
ora.oc4j
1 ONLINE ONLINE rac-1
ora.rac-1.vip
1 ONLINE ONLINE rac-1
ora.rac-2.vip
1 ONLINE ONLINE rac-2
ora.scan1.vip
1 ONLINE ONLINE rac-1
[grid@RAC-2 ~]$
1、首先检查rac状态
[grid@RAC-2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.CRS.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.DATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.LISTENER.lsnr
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.MEM_DATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.RACDATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.asm
ONLINE ONLINE rac-1 Started
ONLINE ONLINE rac-2 Started
ora.gsd
ONLINE OFFLINE rac-1
ONLINE OFFLINE rac-2
ora.net1.network
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.ons
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac-1
ora.cvu
1 ONLINE ONLINE rac-1
ora.oc4j
1 ONLINE ONLINE rac-1
ora.oralnx.db
1 ONLINE ONLINE rac-1 Open
2 ONLINE ONLINE rac-2 Open
ora.rac-1.vip
1 ONLINE ONLINE rac-1
ora.rac-2.vip
1 ONLINE ONLINE rac-2
ora.scan1.vip
1 ONLINE ONLINE rac-1
2、进入oracle_home目录下,运行deinstall。
cd $ORACLE_HOME/deinstall
[oracle@RAC-1 deinstall]$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /oracle/app/oraInventory/logs/
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################### CHECK OPERATION START #########################
## [START] Install check configuration ##
Checking for existence of the Oracle home location /oracle/app/oracle/product/11.2/db_1
Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database
Oracle Base selected for deinstall is: /oracle/app/oracle
Checking for existence of central inventory location /oracle/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /oracle/app/11.2/grid
The following nodes are part of this cluster: rac-1,rac-2
Checking for sufficient temp space availability on node(s) : 'rac-1,rac-2'
## [END] Install check configuration ##
Network Configuration check config START
Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_check2014-04-08_10-35-56-AM.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_check2014-04-08_10-35-59-AM.log
Use comma as separator when specifying list of values as input
Specify the list of database names that are configured in this Oracle home [oralnx]: 此处默认,回车即可
###### For Database 'oralnx' ######
RAC Database
The nodes on which this database has instances: [rac-1, rac-2]
The instance names: [oralnx1, oralnx2]
The local instance name on node: oralnx1
The diagnostic destination location of the database: /oracle/app/oracle/diag/rdbms/oralnx
Storage type used by the Database: ASM
The details of database(s) oralnx have been discovered automatically. Do you still want to modify the details of oralnx database(s)? [n]: 此处默认,回车即可
Database Check Configuration END
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /oracle/app/oraInventory/logs/emcadc_check2014-04-08_10-36-59-AM.log
Checking configuration for database oralnx
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /oracle/app/oraInventory/logs//ocm_check5383.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /oracle/app/11.2/grid
The cluster node(s) on which the Oracle home deinstallation will be performed are:rac-1,rac-2
Oracle Home selected for deinstall is: /oracle/app/oracle/product/11.2/db_1
Inventory Location where the Oracle home registered is: /oracle/app/oraInventory
The following databases were selected for de-configuration : oralnx
Database unique name : oralnx
Storage used : ASM
No Enterprise Manager configuration to be updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
rac-1 : Oracle Home exists with CCR directory, but CCR is not configured
rac-2 : Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y 此处输入y 回车
A log of this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2014-04-08_10-35-48-AM.out'
Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2014-04-08_10-35-48-AM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /oracle/app/oraInventory/logs/emcadc_clean2014-04-08_10-36-59-AM.log
Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_clean2014-04-08_10-37-24-AM.log
Database Clean Configuration START oralnx
This operation may take few minutes.
Database Clean Configuration END oralnx
Network Configuration clean config START
Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_clean2014-04-08_10-40-25-AM.log
De-configuring Listener configuration file on all nodes...
Listener configuration file de-configured successfully.
De-configuring Naming Methods configuration file on all nodes...
Naming Methods configuration file de-configured successfully.
De-configuring Local Net Service Names configuration file on all nodes...
Local Net Service Names configuration file de-configured successfully.
De-configuring Directory Usage configuration file on all nodes...
Directory Usage configuration file de-configured successfully.
De-configuring backup files on all nodes...
Backup files de-configured successfully.
The network configuration has been cleaned up successfully.
Network Configuration clean config END
Oracle Configuration Manager clean START
OCM clean log file location : /oracle/app/oraInventory/logs//ocm_clean5383.log
Oracle Configuration Manager clean END
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START
Detach Oracle home '/oracle/app/oracle/product/11.2/db_1' from the central inventory on the local node : Done
Delete directory '/oracle/app/oracle/product/11.2/db_1' on the local node : Done
The Oracle Base directory '/oracle/app/oracle' will not be removed on local node. The directory is not empty.
Detach Oracle home '/oracle/app/oracle/product/11.2/db_1' from the central inventory on the remote nodes 'rac-2' : Done
Delete directory '/oracle/app/oracle/product/11.2/db_1' on the remote nodes 'rac-2' : Done
The Oracle Base directory '/oracle/app/oracle' will not be removed on node 'rac-2'. The directory is not empty.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
## [START] Oracle install clean ##
Clean install operation removing temporary directory '/tmp/deinstall2014-04-08_10-35-37AM' on node 'RAC-1'
Clean install operation removing temporary directory '/tmp/deinstall2014-04-08_10-35-37AM' on node 'rac-2'
## [END] Oracle install clean ##
######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################
Successfully de-configured the following database instances : oralnx
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home '/oracle/app/oracle/product/11.2/db_1' from the central inventory on the local node.
Successfully deleted directory '/oracle/app/oracle/product/11.2/db_1' on the local node.
Successfully detached Oracle home '/oracle/app/oracle/product/11.2/db_1' from the central inventory on the remote nodes 'rac-2'.
Successfully deleted directory '/oracle/app/oracle/product/11.2/db_1' on the remote nodes 'rac-2'.
Oracle Universal Installer cleanup was successful.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############
过程很简单,几分钟搞定。
3、检查rac状态,一切正常。
[grid@RAC-2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.CRS.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.DATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.LISTENER.lsnr
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.MEM_DATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.RACDATA.dg
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.asm
ONLINE ONLINE rac-1 Started
ONLINE ONLINE rac-2 Started
ora.gsd
ONLINE OFFLINE rac-1
ONLINE OFFLINE rac-2
ora.net1.network
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
ora.ons
ONLINE ONLINE rac-1
ONLINE ONLINE rac-2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac-1
ora.cvu
1 ONLINE ONLINE rac-1
ora.oc4j
1 ONLINE ONLINE rac-1
ora.rac-1.vip
1 ONLINE ONLINE rac-1
ora.rac-2.vip
1 ONLINE ONLINE rac-2
ora.scan1.vip
1 ONLINE ONLINE rac-1
[grid@RAC-2 ~]$
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22969361/viewspace-1137616/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22969361/viewspace-1137616/