Solutions: error while starting of Oracle Single instance ASM Database

1st – Starting ASM

[root@asmdb ~]#su - grid

[grid@asmdb ~]$ asmcmd
Connected to an idle instance

ASMCMD> ls
ASMCMD-08102: no connection to ASM; command requires ASM to run
ASMCMD>

[grid@asmdb ~]$ sqlplus / as sysasm
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

SQL> conn / as sysasm
Connected to an idle instance

SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service


SQL> exit
Disconnected

2nd : Starting DB
[oracle@asmdb ~]$ sqlplus / as sysdba
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.

SQL> startup
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

ORA-00205: error in identifying control file, check alert log for more info
3rd: Verify the below Command & if fail fallow the given solution

[grid@asmdb ~]$ crsctl enable has
CRS-4622: Oracle High Availability Services autostart is enabled.

[grid@asmdb ~]$ crsctl start has
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.

[grid@asmdb ~]$ crsctl start res ora.cssd
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Start failed, or completed with errors.

===================================================
Solution:

===================================================


[root@asmdb install]# cd /u01/app/11.2.0/grid/crs/install

[root@asmdb install]# pwd

/u01/app/11.2.0/grid/crs/install

[root@DB install]# ./roothas.pl -deconfig -force
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

[root@DB install]# ./roothas.pl
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

[root@DB install]# su - grid

[grid@asmdb ~]$ crsctl start resource "ora.cssd"
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

[grid@asmdb ~]$ oracleasm listdisks
CRSVOL1
DATA1
DATAVOL1
FRAVOL1

[grid@asmdb dbs]$ sqlplus / as sysasm

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

SQL>  select name,state,type from v$asm_diskgroup;
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.

SQL>  select name,state,type from v$asm_diskgroup;
NAME                           STATE       TYPE
------------------------------ ----------- ------
CRS                            MOUNTED     EXTERN
DATA                         MOUNTED     EXTERN
FRA                            MOUNTED     EXTERN

After mounting all the above ASM Disk – Need to start the database

[root@asmdb ~]# su - oracle

[oracle@asmdb ~]$ pwd
/home/oracle

[oracle@asmdb ~]$ sqlplus / as sysdba

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

SQL> select status from V$instance;
STATUS
------------
OPEN

SQL> select * from v$instance;
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
Hence Solved the issue in our test ENV (ASM Test DB)

Comments

  1. Cloud-based networking, is when some of an organization’s networking resources are hosted in the cloud. This may refer to either a public or private cloud. My cousin get cloud solutions from Setton Consulting for her local business development. Their services are so satisfied. best desktop application for business communications
    best desktop application for business communications

    ReplyDelete

Post a Comment

Popular posts from this blog

RAC Failure Scenario - Testing in our RAC Test DB - Node 1 & Node 2

ORA-01110: data file 1: '/oradata/datafiles/system01.dbf'

Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4)