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]

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