DBVERIFY || 0005 Error during processing

[Former Member]

Hi,

PFA,

In CRP server, VerifyDB job is getting failed with error code 0005.

Reason:

BR0278E Command output of '/oracle/CRP/102_64/bin/dbv file=/oracle/CRP/sapdata1/crp_70/crp.data70 blocksize=8192':

12714110 : map : Permission Denied

DBVERIFY: Release 10.2.0.4.0 - Production on Sun Apr 20 03:00:46 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBV-00100: Specified FILE (/oracle/CRP/sapdata1/crp_70/crp.data70) not accessible

BR0280I BRBACKUP time stamp: 2014-04-20 03.00.46

BR0363E Verification of backup of /oracle/CRP/sapdataX/crp_XX/crp.dataXX failed due to previous errors.

Kindly help me to sort this typical issue.

Regards,

Sanjeev Kumar.

Database verification using DBVERIFY or RMAN validate.txt.zip

[Former Member · Accepted solution]

Hi friends,

Thanks for the valuable inputs.

The issue got resolved...

We have changed the DB parameter FILESYSTEMIO_OPTIONS to ASYNCH. Post taking restart the issue fixed.

Regards,

Sanjeev Kumar.

[Former Member]

Hi,

It clearly says you do not have required permissions to perform the activity.

Make sure that you have 755 permissions on all /oracle/SID/sapdata* folders and contents.

Go to /oracle/SID

do chmod -R 755 *

Regards,

Nick Loy

[Former Member]

Nick Loy wrote:

Go to /oracle/SID
do chmod -R 755 *

NO !!

NEVER EVER DO THIS !!

It would, for example, remove the s-bit from oracle binaries.

[willi_eimler]

Yes, this would kill the database!

You should do the procedure in the sapdata directories:

oracrp> cd /oracle/CRP/sapdata1

oracrp> chmod -rf chmod -R 755 *

oracrp> cd /oracle/CRP/sapdata2

oracrp> chmod -rf chmod -R 755 *

oracrp> cd /oracle/CRP/sapdata3

oracrp> chmod -rf chmod -R 755 *

oracrp> cd /oracle/CRP/sapdata4

oracrp> chmod -rf chmod -R 755 *

Best regards

Willi Eimler

[Former Member]

Sorry for typo

It's chmod -R 755 sapdata*

You should have 755 permissions on all sapdata folders and thier contents.

Regards,

Nick Loy

[willi_eimler]

Hi Kumar,

please check file belong to ora<sid> with permission 755.

Best regards

Willi Eimler

[Former Member]

Any experts, who can help me to resolve this issue 🙂

[former_member182657]

Hi Sanjeev,

Please follow SAP Note   527250 - DBV-00100 Composite SAP note

Regards,

Gaurav

[former_member185239]

Hi Sanjeev,

Checked the below things.

1. /oracle/CRP/sapdata1/crp_70/crp.data70 file is accessible with sidadm and orasid.

2. checked whether this file exit or not

3. id crpadm and checked the group dba and oper is assigned to the user

manually run the command

/oracle/CRP/102_64/bin/dbv file=/oracle/CRP/sapdata1/crp_70/crp.data70 blocksize=8192

with sidadm and orasid.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi experts,

As suggested, i have executed below command with SIDADM manually,

/oracle/CRP/102_64/bin/dbv file=/oracle/CRP/sapdata4/crp_102/crp.data102 blocksize=8192

But i got error stating :

13959408 : map : Permission Denied

DBVERIFY: Release 10.2.0.4.0 - Production on Sun Jul 27 03:00:35 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBV-00100: Specified FILE (/oracle/CRP/sapdata4/crp_102/crp.data102) not accessible

Anyone available to resolve my above expressed issue..

Regards,

Sanjeev Kumarf

[former_member225142]

Hi Sanjeev,

Can you try to give sapdba and sapconn role to sidadm and then execute the command.

Regards,

Meenu Hans

[divyanshu_srivastava3]

Hi Sanjeev,

Use command "chmod -Rf 0755 crp_102" for user sidadm and orasid.

[former_member188883]

Hi Sanjeev,

There is an Oracle script ($ORACLE_HOME/install/changePerm.sh) which can be run by a root user in UNIX to open the permissions on the Oracle folders.

Please schedule the same and check the results.

Regards,

Deepak Kori