Question Re: DBVERIFY || 0005 Error during processing in Technology Q&A

DBVERIFY || 0005 Error during processing

Former Member — Fri, 25 Apr 2014 00:34:32 GMT

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

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.

Re: DBVERIFY || 0005 Error during processing

Former Member — Fri, 25 Apr 2014 01:13:47 GMT

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

Re: DBVERIFY || 0005 Error during processing

former_member182657 — Fri, 25 Apr 2014 03:14:42 GMT

Hi Sanjeev,

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

Regards,

Gaurav

Re: DBVERIFY || 0005 Error during processing

Former Member — Fri, 25 Apr 2014 04:16:50 GMT

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

Re: DBVERIFY || 0005 Error during processing

Former Member — Tue, 26 Aug 2014 00:49:02 GMT

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

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

Anyone available to resolve my above expressed issue..

Regards,

Sanjeev Kumarf

Re: DBVERIFY || 0005 Error during processing

former_member225142 — Tue, 26 Aug 2014 04:34:08 GMT

Hi Sanjeev,

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

Regards,

Meenu Hans

Re: DBVERIFY || 0005 Error during processing

willi_eimler — Tue, 26 Aug 2014 06:30:32 GMT

Hi Kumar,

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

Best regards

Willi Eimler

Re: DBVERIFY || 0005 Error during processing

divyanshu_srivastava3 — Tue, 26 Aug 2014 06:39:40 GMT

Hi Sanjeev,

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

Re: DBVERIFY || 0005 Error during processing

Former Member — Tue, 26 Aug 2014 08:14:46 GMT

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

Re: DBVERIFY || 0005 Error during processing

Former Member — Wed, 27 Aug 2014 03:14:05 GMT

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

Re: DBVERIFY || 0005 Error during processing

Former Member — Wed, 27 Aug 2014 09:09:33 GMT


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.

Re: DBVERIFY || 0005 Error during processing

willi_eimler — Wed, 27 Aug 2014 12:36:06 GMT

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

Re: DBVERIFY || 0005 Error during processing

Former Member — Thu, 28 Aug 2014 04:16:14 GMT

Sorry for typo

It's chmod -R 755 sapdata*

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

Regards,

Nick Loy

Re: DBVERIFY || 0005 Error during processing

Former Member — Thu, 18 Jun 2015 10:13:54 GMT

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.