Hi There,
We're running Oracle 11.2.0.4 EE on Oracle Linux Server release 6.10. This is a standalone environment ASM environment:
oracle@kc1prdb02 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE cmddev01
ora.FRA.dg
ONLINE ONLINE cmddev01
ora.LISTENER_ASM.lsnr
ONLINE ONLINE cmddev01
ora.LISTENER_CMDDEV.lsnr
ONLINE ONLINE cmddev01
ora.asm
ONLINE ONLINE cmddev01 Started
ora.ons
OFFLINE OFFLINE cmddev01
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE cmddev01
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE cmddev01
We changed the host name and host ip, recycled the server, and obviously oracle has didn't come up, so we followed MOS doc id 986740.1 "How to Reconfigure Oracle Restart" to reset the environment. We removed HAS configurations, reconfigured it again, added ASM, started the ASM instance, then we proceeded to recreating the ASM pfile:
asm_diskgroups='DATA','FRA'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='EXCLUSIVE'
Then we ran the following "crsctl stat res -t":
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.asm
ONLINE ONLINE cmddev03 Started
ora.ons
OFFLINE OFFLINE cmddev03
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE cmddev03
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE cmddev03
Then we logged in to the ASM instance to mount the DATA diskgroup and we're stuck:
SYS@+ASM> alter diskgroup DATA mount;
alter diskgroup DATA mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15040: diskgroup is incomplete
We can't mount the disk group, and we're not sure how to proceed! The resource is obviously missing from crsctl output, so does it need to be added there 1st? I've also noticed the asm_diskstring is no longer set in ASM:
SYS@+ASM> show parameter disks
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string
and none of the directories and/or disks are available under asmcmd. How can we add the disk groups again and mount them please? Your help is highly appreciated.
Many Thanks