How to Reconfigure Oracle HAS (High Availability Services) after changing hostname?－DanBrother的部落格

How to Reconfigure Oracle HAS (High Availability Services) after changing hostname?

Issue:

[grid@newhost ~]$ crsctl check has
CRS-4639: Could not contact High Availability Services
CRS-4000: Command Start failed, or completed with errors.

Solution:

-- Deconfigure the Oracle Grid Infrastructure installation for a standalone server by:
su -
cd $GRID_HOME/crs/install

./roothas.pl -deconfig -force

Using configuration parameter file: ./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.
CLSU-00100: Operating System function: opendir failed with error data: 2
CLSU-00101: Operating System error message: No such file or directory
CLSU-00103: error location: scrsearch1
CLSU-00104: additional error information: cant open scr home dir scls_scr_getval
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
Successfully deconfigured Oracle Restart stack

[root@newhost install]# pwd
/grid/orabase/product/11.2.0.3/grid/crs/install

-- Reconfigure the Oracle Grid Infrastructure
./roothas.pl

Using configuration parameter file: ./crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'dba'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node newhost successfully pinned.
Adding Clusterware entries to inittab

newhost 2014/06/17 12:26:35 /grid/orabase/product/11.2.0.3/grid/cdata/newhost/backup_20140617_122635.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server

[root@newhost install]# su - grid

[grid@newhost ~]$ crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.

[grid@newhost ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
OFFLINE OFFLINE newhost
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE newhost

[grid@newhost ~]$ crsctl start res "ora.cssd"
CRS-2672: Attempting to start 'ora.cssd' on 'newhost'
CRS-2672: Attempting to start 'ora.diskmon' on 'newhost'
CRS-2676: Start of 'ora.diskmon' on 'newhost' succeeded
CRS-2676: Start of 'ora.cssd' on 'newhost' succeeded

[grid@newhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /grid/orabase/product/11.2.0.3/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = newhost)(PORT = 1521))
)
)

[grid@newhost admin]$ srvctl add listener -l LISTENER
[grid@newhost admin]$ srvctl start listener
[grid@newhost admin]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): newhost

[grid@newhost admin]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE newhost
ora.ons
OFFLINE OFFLINE newhost
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE newhost

[grid@newhost admin]$ cd $ORACLE_HOME/dbs
[grid@newhost dbs]$ cat spfile+ASM.ora
*.asm_diskstring='/dev/*'
*.asm_diskgroups ='ARCH, DATA, FLASH'
*.asm_power_limit=1
*.diagnostic_dest='/grid/orabase'
*.instance_type='asm'
*.large_pool_size=12M
*.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=newhost)(PORT=1521))))'
*.remote_login_passwordfile='EXCLUSIVE'

[grid@newhost dbs]$ srvctl add asm -l LISTENER -p "/grid/orabase/product/11.2.0.3/grid/dbs/spfile+ASM.ora"
[grid@newhost dbs]$ srvctl start asm
[grid@newhost dbs]$ srvctl status asm
ASM is running on newhost

[grid@newhost dbs]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE newhost
ora.DATA.dg
ONLINE ONLINE newhost
ora.FLASH.dg
ONLINE ONLINE newhost
ora.LISTENER.lsnr
ONLINE ONLINE newhost
ora.asm
ONLINE ONLINE newhost Started
ora.ons
OFFLINE OFFLINE newhost
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE newhost
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE newhost

su - oracle

[oracle@newhost config]$ srvctl add database -d testdb -o $ORACLE_HOME -p +data/testdb/spfiletestdb.ora -s open -t immediate -a "DATA,ARCH,FLASH"
[oracle@newhost config]$ srvctl config database -d testdb
Database unique name: testdb
Database name:
Oracle home: /oracle/orabase/product/11.2.0.3/dbhome_1
Oracle user: oracle
Spfile: +data/testdb/spfiletestdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: testdb
Disk Groups: DATA,ARCH,FLASH
Services: