Monthly Archives: November 2015

GI, ASM, Listener and Database will be down after changing Host Name and/or IP address. Will get an error when starting ASM or trying to query the Disk Group. At this point, we have to deconfigure the GI on the new machine with the different host name.

Below are the mandatory steps that need to be executed after the hostname and/or IP address was updated/changed/modified.

Note: CRS processes in the RAC installation is not installed for the single instance installations.For the single instance installations, there is the HAS processes stands for “High Availability Services” and covers the cssd and diskmon processes.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘usdbvmsvr115’CRS-2673: Attempting to stop ‘ora.evmd’ on ‘usdbvmsvr115’CRS-2677: Stop of ‘ora.evmd’ on ‘usdbvmsvr115’ succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘usdbvmsvr115’ has completedCRS-4133: Oracle High Availability Services has been stopped.

NAME=ora.cssdTYPE=ora.cssd.typeTARGET=ONLINESTATE=ONLINE on usdbvmsvr115NAME=ora.diskmonTYPE=ora.diskmon.typeTARGET=OFFLINESTATE=OFFLINENAME=ora.evmdTYPE=ora.evm.typeTARGET=ONLINESTATE=ONLINE on usdbvmsvr115NAME=ora.onsTYPE=ora.ons.typeTARGET=OFFLINESTATE=OFFLINE

Note: If the CSS & OHAS service did NOT start, then you will need to reboot the Linux/unix box and check them again.

5) Recreate the default listener (LISTENER) using port 1521 (or using your desired port), thru the NETCA GUI located on the new Grid Infrastructure Oracle Home (or manually if you do not have graphical access) as grid or oracle OS user (as the Grid Infrastructure OS owner):

6) Please create the init+ASM.ora file on the <11.2 Grid Infrastructure Oracle Home>/dbs directory with the next parameters:

Already had the init file…no changes were made. This step can be skipped for ASM to choose the default init file.

[oracle@usdbvmsvr115dbs]$ more init+ASM.ora+ASM.__oracle_base=’/grid/11.2.0’#ORACLE_BASE set from environment+ASM.asm_diskgroups=’EBSPRDDG_ASM’*.asm_diskgroups=’EBSPRDDG_ASM’*.asm_power_limit=4*.diagnostic_dest=’/grid/11.2.0/grid’*.instance_type=’asm’*.large_pool_size=400M#*.local_listener=’LISTENER’*.processes=400*.remote_login_passwordfile=’SHARED’*.shared_pool_size=450M