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]

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 Member]

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 Member]

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