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
[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)
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
ReplyDeletebest desktop application for business communications
https://bayanlarsitesi.com/
ReplyDeleteYenibosna
Anadolu Kavağı
İçerenköy
Yeşilköy
D6SV0L
ankara evden eve nakliyat
ReplyDeletemalatya evden eve nakliyat
antep evden eve nakliyat
giresun evden eve nakliyat
kayseri evden eve nakliyat
83İ7PK
03ED5
ReplyDelete%20 binance referans kodu
A88E1
ReplyDeletemobil sohbet et
Nevşehir En İyi Rastgele Görüntülü Sohbet
sesli sohbet
Nevşehir Canlı Sohbet Et
Diyarbakır En İyi Ücretsiz Görüntülü Sohbet Siteleri
Amasya Yabancı Canlı Sohbet
chat sohbet
canlı sohbet siteleri
diyarbakır sesli sohbet odası
78A1E
ReplyDeleteuşak rastgele görüntülü sohbet uygulaması
yabancı sohbet
uşak görüntülü sohbet odaları
çanakkale sesli sohbet sitesi
zonguldak görüntülü sohbet siteleri
bedava sohbet odaları
rastgele canlı sohbet
yalova rastgele görüntülü sohbet uygulaması
ığdır canlı görüntülü sohbet siteleri
F2BA5
ReplyDeleteçankırı yabancı sohbet
kastamonu sohbet sitesi
adana telefonda sohbet
isparta sesli sohbet sesli chat
kütahya telefonda görüntülü sohbet
nanytoo sohbet
balıkesir sohbet chat
aydın kızlarla canlı sohbet
tekirdağ canlı sohbet odası
2593D
ReplyDeleteKripto Para Nedir
Sohbet
Meta Coin Hangi Borsada
Bitcoin Nasıl Alınır
Referans Kimliği Nedir
Binance Kimin
Binance Kaldıraçlı İşlem Nasıl Yapılır
Ön Satış Coin Nasıl Alınır
Onlyfans Beğeni Satın Al
fdegfdgfhbfgjhgjhg
ReplyDeleteشركة مكافحة مكافحة بالهفوف
XDFHGCH
ReplyDeleteشركة مكافحة النمل الابيض بالاحساء