Error while starting of Oracle Single instance ASM Database
Posted by Mir Sayeed Hassan on September 17th, 2017
Error while starting of Oracle Single instance ASM Database
1st Error – Starting ASM
[code] [root@asmdb ~]#su – grid [/code]
[code] [grid@asmdb ~]$ asmcmd [/code]
Connected to an idle instance
[code] ASMCMD> ls [/code]
ASMCMD-08102: no connection to ASM; command requires ASM to run<;
ASMCMD;
[code] [grid@asmdb ~]$ sqlplus / as sysasm [/code]
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 23 17:44:30 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Automatic Storage Management option
[code] SQL> conn / as sysasm [/code]
Connected to an idle instance
SQL> <b>startup</b><b> ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service</b> SQL> exit Disconnected
2nd Error: Starting DB
[code] [oracle@asmdb ~]$ sqlplus / as sysdba [/code]
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 23 17:15:15 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
[code] SQL> startup [/code]
ORACLE instance started.
Total System Global Area 1503199232 bytes
Fixed Size 2253424 bytes
Variable Size 1006636432 bytes
Database Buffers 486539264 bytes
Redo Buffers 7770112 bytes [/code]
ORA-00205: error in identifying control file, check alert log for more info
Verify the below Command & if fail fallow the given solution
[code] [grid@asmdb ~]$ crsctl enable has [/code]
CRS-4622: Oracle High Availability Services autostart is enabled.
[code] [grid@asmdb ~]$ crsctl start has [/code]
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
[code] [grid@asmdb ~]$ crsctl start res ora.cssd [/code]
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Start failed, or completed with errors.
Solution:
[code] [root@asmdb install]# <b>cd /u01/app/11.2.0/grid/crs/install </b>[/code]
[code] [root@asmdb install]# <b>pwd </b>[/code]
/u01/app/11.2.0/grid/crs/install
[code] [root@DB install]# <b>./roothas.pl -deconfig -force </b>[/code]
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.
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
Successfully deconfigured Oracle Restart stack
[code] [root@DB install]# <b>./roothas.pl </b>[/code]
Using configuration parameter file: ./crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user ‘grid’, privgrp ‘oinstall’..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
CRS-4664: Node asmdb successfully pinned.
Adding Clusterware entries to upstart
asmdb 2017/01/23 17:10:03 /u01/app/11.2.0/grid/cdata/asmdb/backup_20170123_171003.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
[code] [root@DB install]# <b>su – grid </b>[/code]
[code] [grid@asmdb ~]$ <b>crsctl start resource "ora.cssd" </b>[/code]
CRS-2672: Attempting to start ‘ora.cssd’ on ‘asmdb’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘asmdb’
CRS-2676: Start of ‘ora.diskmon’ on ‘asmdb’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘asmdb’ succeeded
[code] [grid@asmdb ~]$ <b>oracleasm listdisks </b>[/code]
CRSVOL1
DATA1
DATAVOL1
FRAVOL1
[code] > startup
ORA-00099: warning: no parameter file specified for ASM instance
ASM instance started
Total System Global Area 1135747072 bytes
Fixed Size 2260728 bytes
Variable Size 1108320520 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted [/code]
[code] [grid@asmdb dbs]$ sqlplus / as sysasm [/code]
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 23 17:18:04 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Automatic Storage Management option
[code]<b> SQL> select name,state,type from v$asm_diskgroup;</b> [/code]
NAME STATE TYPE
—————————— ———– ——
CRS DISMOUNTED
DATA DISMOUNTED
FRA DISMOUNTED
SQL> alter diskgroup crs mount;
Diskgroup altered.
SQL> alter diskgroup data mount;
Diskgroup altered.
SQL> alter diskgroup fra mount;
Diskgroup altered.
[code]<b> SQL> select name,state,type from v$asm_diskgroup; </b>[/code]
NAME STATE TYPE
—————————— ———– ——
CRS MOUNTED EXTERN
DATA MOUNTED EXTERN
FRA MOUNTED EXTERN
After mounting all the above ASM Disk – Need to start the database
[code] [root@asmdb <b>~]# su – oracle </b>[code]
[code] [oracle@asmdb ~]$ <b>pwd </b>[/code]
/home/oracle
[code] [oracle@asmdb ~]$ <b>sqlplus / as sysdba </b>[/code]
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 23 18:04:03 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[code]<b> SQL> select status from V$instance; </b>[/code]
STATUS
————
OPEN
[code]<b> SQL> select * from v$instance; </b>[/code]
INSTANCE_NUMBER INSTANCE_NAME
————— —————-
HOST_NAME
—————————————————————-
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
—————– ——— ———— — ———- ——- —————
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
———- — —————– —————— ——— —
1 asmdb1
asmdb
11.2.0.4.0 23-JAN-17 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 5114 5055 0 5055 0 N CRS/
MOUNTED EXTERN N 512 4096 1048576 5114 1795 0 1795 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 5114 869 0 869 0 N FRA/
Hence Solved the issue in our test ENV – 192.168.xxx.xxx (ASM Test DB)