What is interesting is that we have another 12.1.0.2 database on this
cluster and it's not having any issues.
The control files are on ASM:
SQL> show parameter control_files;
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
control_files string
+DATA/ORCL/CONTROLFILE/current
.263.881061111,
+DATA/ORCL/CON
TROLFILE/current.270.881061111
The database alert log shows the following:
NOTE: ASMB mounting group 1 (DATA)
NOTE: ASM background process initiating disk discovery for grp 1 (reqid:0)
WARNING: group 1 (DATA) has missing disks
ORA-15040: diskgroup is incomplete
WARNING: group 1 is being dismounted.
WARNING: ASMB force dismounting group 1 (DATA) due to missing disks
SUCCESS: diskgroup DATA was dismounted
The database shows the diskgroup and associated disks are mounted and
present:
1 select a.disk_number, a.name, b.name, b.state from v$asm_disk a
2 join v$asm_diskgroup b on a.group_number=b.group_number
3* order by b.name, a.disk_number
SQL> /
DISK_NUMBER NAME NAME
STATE
----------- ------------------------------ ------------------------------
-----------
0 DATA_0000 DATA
MOUNTED
1 DATA_0001 DATA
MOUNTED
2 DATA_0002 DATA
MOUNTED
3 DATA_0003 DATA
MOUNTED
0 FRA_0000 FRA
MOUNTED
1 FRA_0001 FRA
MOUNTED
0 GRID_0000 GRID
MOUNTED
1 GRID_0001 GRID
MOUNTED
2 GRID_0002 GRID
MOUNTED
3 GRID_0003 GRID
MOUNTED
0 PRDREPDATA01_0000 PRDREPDATA01
MOUNTED
DISK_NUMBER NAME NAME
STATE
----------- ------------------------------ ------------------------------
-----------
1 PRDREPDATA01_0001 PRDREPDATA01
MOUNTED
2 PRDREPDATA01_0002 PRDREPDATA01
MOUNTED
3 PRDREPDATA01_0003 PRDREPDATA01
MOUNTED
0 PRDREPFRA_0000 PRDREPFRA
MOUNTED
0 REDO1_0000 REDO1
MOUNTED
0 REDO2_0000 REDO2
MOUNTED
17 rows selected.
The ASM alert log shows:
NOTE: client orcl1:orcl:scan01-int no longer has group 1 (DATA) mounted
CRS shows:
[grid@node1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE node1 STABLE
ora.DATA.dg
ONLINE ONLINE node1 STABLE
ora.FRA.dg
ONLINE ONLINE node1 STABLE
ora.GRID.dg
ONLINE ONLINE node1 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE node1 STABLE
ora.PRDREPDATA01.dg
ONLINE ONLINE node1 STABLE
ora.PRDREPFRA.dg
ONLINE ONLINE node1 STABLE
ora.REDO1.dg
ONLINE ONLINE node1 STABLE
ora.REDO2.dg
ONLINE ONLINE node1 STABLE
ora.net1.network
ONLINE ONLINE node1 STABLE
ora.ons
ONLINE ONLINE node1 STABLE
ora.proxy_advm
OFFLINE OFFLINE node1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1 STABLE
ora.LISTENER_SCAN2.lsnr
1 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN3.lsnr
1 OFFLINE OFFLINE STABLE
ora.MGMTLSNR
1 ONLINE ONLINE node1 169.254.112.28
1.1.1
.1,STABLE
ora.asm
1 ONLINE ONLINE node1 Started,STABLE
2 ONLINE OFFLINE STABLE
ora.cvu
1 OFFLINE OFFLINE STABLE
ora.mgmtdb
1 ONLINE ONLINE node1 Open,STABLE
ora.node1.vip
1 ONLINE ONLINE node1 STABLE
ora.node2.vip
1 OFFLINE OFFLINE STABLE
ora.orcl.db
1 ONLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
ora.orcl.test.svc
1 OFFLINE OFFLINE STABLE
ora.prdrep.db
1 ONLINE ONLINE node1
Open,HOME=/u01/app/o
racle/product/12.1.0
/dbhome_2,STABLE
2 ONLINE OFFLINE STABLE
ora.prdrep.prdrepsvc.svc
1 ONLINE ONLINE node1 STABLE
2 ONLINE OFFLINE STABLE
ora.qosmserver
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE node1 STABLE
ora.scan2.vip
1 OFFLINE OFFLINE STABLE
ora.scan3.vip
1 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------------
On Sat, Feb 10, 2018 at 7:14 PM, Vishnu <vishnukumarmp@xxxxxxxxx> wrote:
Hi David, please check whether the file system which has the database
control file is mounted and able to read ? check your asm alert log to get
additional info.
$crsctl stat res -t
Above command will provide online/offline status of all of your resources
including asm disk groups.
Thanks,
Vishnu
On Sat, Feb 10, 2018 at 1:38 PM, David Barbour <david.barbour1@xxxxxxxxx>
wrote:
Good Afternoon,
I have upgraded the GI to 12.2 and the 12.1 databases are failing to
start with the error:
ORA-00205: error in identifying control file, check alert log for more
info
This behavior is described in Doc ID 2247077.1 but the solution is to apply
12.1.0.2.170117 DB BP or above on RDBMS_HOME. Unfortunately this doesn't
seem to be the answer in this case as the database is already at
12.1.0.2.170418.
CRS shows the following:
ora.orcl.db
1 ONLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
I can't seem to get this database to go offline:offline.
Has anyone had a similar issue?