Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

srvctl start database error

MUSICOVERYFeb 3 2015 — edited Feb 4 2015

aI was installing Single instance Oracle with ASM.

While running DBCA, I got an error.

bandicam 2015-02-02 18-35-03-131.png

And I completed DBCA.

When i try below, I got an error.

[asm@localhost ~]$ srvctl start database -d orcl

PRCR-1079 : Failed to start resource ora.orcl.db

CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

CRS-2674: Start of 'ora.orcl.db' on 'localhost' failed

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Process ID: 0

Session ID: 0 Serial number: 0

In oraagent_asm.log file, there are several lines that i don't understand what the problem is.

[asm@localhost oraagent_asm]$ cat oraagent_asm.log | grep CLSN00007

2015-02-03 12:12:45.979: [ora.orcl.db][327149312] [check] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:12:45.979: [ora.orcl.db][327149312] [check] Exception type=2 string=CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

2015-02-03 12:12:45.979: [ AGFW][327149312] sending status msg [CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

2015-02-03 12:13:22.621: [ora.orcl.db][2877286144] [clean] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:13:22.622: [ora.orcl.db][2877286144] [clean] (:CLSN00007:)InstAgent::check: return unplanned offline

2015-02-03 12:13:26.765: [ora.orcl.db][3397371648] [check] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:13:26.765: [ora.orcl.db][3397371648] [check] (:CLSN00007:)InstAgent::check: return unplanned offline

2015-02-03 12:13:26.870: [ora.orcl.db][2877286144] [check] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:13:26.871: [ora.orcl.db][2877286144] [check] Exception type=2 string=CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

2015-02-03 12:13:26.871: [ AGFW][2877286144] sending status msg [CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

2015-02-03 12:13:26.900: [ora.orcl.db][2877286144] [clean] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:13:26.900: [ora.orcl.db][2877286144] [clean] (:CLSN00007:)InstAgent::check: return unplanned offline

2015-02-03 12:13:26.931: [ora.orcl.db][2877286144] [check] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:13:26.931: [ora.orcl.db][2877286144] [check] (:CLSN00007:)InstAgent::check: return unplanned offline

2015-02-03 12:13:31.991: [ora.orcl.db][2877286144] [check] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:13:31.991: [ora.orcl.db][2877286144] [check] Exception type=2 string=CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

2015-02-03 12:13:31.991: [ AGFW][2877286144] sending status msg [CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

2015-02-03 12:13:31.998: [ora.orcl.db][2877286144] [clean] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:13:31.998: [ora.orcl.db][2877286144] [clean] (:CLSN00007:)InstAgent::check: return unplanned offline

2015-02-03 12:13:32.029: [ora.orcl.db][2877286144] [check] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:13:32.029: [ora.orcl.db][2877286144] [check] (:CLSN00007:)InstAgent::check: return unplanned offline

2015-02-03 12:15:25.291: [ora.orcl.db][3397371648] [check] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:15:25.291: [ora.orcl.db][3397371648] [check] Exception type=2 string=CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

2015-02-03 12:15:25.291: [ AGFW][3397371648] sending status msg [CRS-5011: Check of resource "orcl" failed: details at "(:CLSN00007:)" in "/app/ora_asm/product/11g_r2/grid/log/localhost/agent/ohasd/oraagent_asm/oraagent_asm.log"

2015-02-03 12:15:25.302: [ora.orcl.db][3397371648] [clean] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:15:25.302: [ora.orcl.db][3397371648] [clean] (:CLSN00007:)InstAgent::check: return unplanned offline

2015-02-03 12:15:25.332: [ora.orcl.db][3397371648] [check] (:CLSN00007:)DbAgent::check failed gimh state 0

2015-02-03 12:15:25.332: [ora.orcl.db][3397371648] [check] (:CLSN00007:)InstAgent::check: return unplanned offline

alertlocalhost.log file

[asm@localhost ~]$ cd $GRID_HOME/log

[asm@localhost log]$ ls

crs diag localhost

[asm@localhost log]$ cd localhost/

[asm@localhost localhost]$ ls

admin agent alertlocalhost.log client crsd cssd ctssd diskmon evmd gipcd gnsd gpnpd mdnsd ohasd racg srvm

[asm@localhost localhost]$

[asm@localhost localhost]$ cat alertlocalhost.log

Oracle Database 11g Clusterware Release 11.2.0.1.0 - Production Copyright 1996, 2009 Oracle. All rights reserved.

2015-02-01 18:19:10.056

[client(22625)]CRS-1006:The OCR location /app/ora_asm/product/11g_r2/grid/cdata/localhost/local.ocr is inaccessible. Details in /app/ora_asm/product/11g_r2/grid/log/localhost/client/crsctl.log.

2015-02-01 18:19:10.510

[client(22625)]CRS-1001:The OCR was formatted using version 3.

[client(22756)]CRS-10001:ADVM/ACFS is not supported on oraclelinux-release-6Server-6.0.2.x86_64

crsctl.log file

[asm@localhost localhost]$ cd /app/ora_asm/product/11g_r2/grid/log/localhost/client

[asm@localhost client]$ ls

crsctl.log ocrconfig_22619.log ocrconfig_22758.log

[asm@localhost client]$ cat crsctl.log

Oracle Database 11g Clusterware Release 11.2.0.1.0 - Production Copyright 1996, 2009 Oracle. All rights reserved.

2015-02-01 18:19:10.041: [ CSSCLNT][1288648480]clssscConnect: gipc request failed with 29 (0x13)

2015-02-01 18:19:10.041: [ CSSCLNT][1288648480]clsssInitNative: connect failed, rc 29

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 0

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 1

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 2

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 3

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 4

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 5

2015-02-01 18:19:10.056: [ OCRRAW][1288648480]propriogid:1_1: Failed to read the whole bootblock. Assumes invalid format.

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 0

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 1

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 2

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 3

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 4

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e56000 buflen 4096 retval 0 phy_offset 102400 retry 5

2015-02-01 18:19:10.056: [ OCRRAW][1288648480]ibctx: Failed to read the whole bootblock. Assumes invalid format.

2015-02-01 18:19:10.056: [ OCRRAW][1288648480]proprinit:problem reading the bootblock or superbloc 22

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e0c000 buflen 4096 retval 0 phy_offset 102400 retry 0

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e0c000 buflen 4096 retval 0 phy_offset 102400 retry 1

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e0c000 buflen 4096 retval 0 phy_offset 102400 retry 2

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e0c000 buflen 4096 retval 0 phy_offset 102400 retry 3

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e0c000 buflen 4096 retval 0 phy_offset 102400 retry 4

2015-02-01 18:19:10.056: [ OCROSD][1288648480]utread:3: Problem reading buffer 1e0c000 buflen 4096 retval 0 phy_offset 102400 retry 5

2015-02-01 18:19:10.056: [ OCRRAW][1288648480]propriogid:1_1: Failed to read the whole bootblock. Assumes invalid format.

2015-02-01 18:19:10.510: [ OCRRAW][1288648480]iniconfig:No 92 configuration

2015-02-01 18:19:10.510: [ OCRAPI][1288648480]a_init:6a: Backend init successful

2015-02-01 18:19:10.510: [ CRSCTL][1288648480]crsctlcss_GetEnvVar: Environment variable NLS_LANG not found

2015-02-01 18:19:10.510: [ CRSCTL][1288648480]crsctlcss_GetEnvVar: Error 21101 in getting environment variable ORACLE_HOME

2015-02-01 18:19:10.511: [ CRSCTL][1288648480]crsctlcss_doclusterkeys: the current number of pinned nodes 0, set is 1

2015-02-01 18:19:10.909: [ CRSCTL][1288648480]crsctl_pin_ocr: set OCR keys succ.

bandicam 2015-02-03 14-54-49-045.png

I started thinking that this problem might be cause of some steps below. ( In installation step, I editted several files before running a script file in grid infrastructure step)

BEFORE BELOW STEP,

bandicam 2015-02-03 13-01-41-452.png

I went to this URL

ohasd failed to start Inappropriate ioctl for device at roothas.pl

and I took a step below.

2. Re: ohasd failed to start Inappropriate ioctl for device at roothas.pl

909337Newbie

909337 2012. 7. 25 오후 3:35 (santysharma에 대한 응답)

Hello,
Problem is indeed because of upstart/init incompatibility. Here is the working way:

  1. Proceed with the installation as usual until root.sh invocation.
  2. Before root.sh edit $GRID_HOME/crs/install/s_crsconfig_lib.pm, go to line 1173 (you should find a code like: if ($srv eq "ohasd") { # Start OHASD).
  3. Insert a following snippet before starting OHASD part (line 1173)

my $UPSTART_OHASD_SERVICE = "oracle-ohasd";
my $INITCTL = "/sbin/initctl";

($status, @output) = system_cmd_capture ("$INITCTL start $UPSTART_OHASD_SERVICE");
if (0 != $status)
{
error ("Failed to start $UPSTART_OHASD_SERVICE, error: $!");
return $FAILED;
}

  1. Create a file /etc/init/oracle-ohasd.conf with the following content inside

# Oracle OHASD startup

start on runlevel [35]
stop on runlevel [!35]
respawn
exec /etc/init.d/init.ohasd run >/dev/null 2>&1 </dev/null

  1. Invoke root.sh
  2. Finish the installation.

If you previously ran root.sh (not successfully), simply roll it back:
$GRID_HOME/crs/install/roothas.pl -deconfig -force -verbose
Make changes above and continue.

good luck
Anand

This part is suspicious. Did i do right thing?

Can anyone help me to use srvctl to start oracle database normally ???

Thanks & Regard
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2015
Added on Feb 3 2015
#performance-availability, #rac-asm-clusterware-installation
22 comments
5,789 views