Re: Database Will Not Mount: ORA-00205
Date: Sat, 10 Feb 2018 21:38:55 -0600
Message-ID: <CAFH+ifeeW3uw7Sa8QQJC+raLJ0bA5LgiB=w2cA-1PDdpm6qM1A_at_mail.gmail.com>
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+DATA/ORCL/CON TROLFILE/current.270.881061111
------------------------------------ -----------
------------------------------
control_files string +DATA/ORCL/CONTROLFILE/current .263.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 NAMESTATE
----------- ------------------------------ ------------------------------
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 NAMESTATE
----------- ------------------------------ ------------------------------
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_at_node1 ~]$ crsctl stat res -t
Name Target State Server State detailsLocal 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_at_gmail.com> 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_at_gmail.com> > 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? >> >> >> >> >> >
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 11 2018 - 04:38:55 CET