CheckDB fail with BR0252E Function stat() failed

[g_vandenbroucke]

In DB13 the CheckDB terminated with errors:

BR0252E Function _stat64() failed for 'E:\oracle\REP' at location BrDiskStatGet-1

BR0253E errno 2: No such file or directory

BR0277E Determination of disk volume status for E:\oracle\REP failed

Actually it was never succesfully (checked up to 27th February).

Checked Note 952080 - BR*Tools fail with BR0252E Function stat() failed

But this is no soft link.

It is an ORACLE 11.2.0.2.0 on Windows Server 2008

BR0801I BRCONNECT 7.20 (22)

BR0805I Start of BRCONNECT processing: cejeknpb.chk 2012-08-10 14.18.51

BR0484I BRCONNECT log file: E:\oracle\REP\sapcheck\cejeknpb.chk

BR0477I Oracle pfile D:\oracle\REP\11202\database\initREP.ora created from spfile D:\oracle\REP\11202\database\spfileREP.ora

BR0101I Parameters

Name                           Value

oracle_sid                     REP

oracle_home                    D:\oracle\REP\11202

oracle_profile                 D:\oracle\REP\11202\database\initREP.ora

sapdata_home                   E:\oracle\REP

sap_profile                    D:\oracle\REP\11202\database\initREP.sap

system_info                    SAPServiceREP IN1SBRAPP007 Windows 6.1 Build 7601 Service Pack 1 AMD64

oracle_info                    REP 11.2.0.2.0 8192 15172 146875187 IN1SBRAPP007 UTF8 UTF8 2712953336 &REP_IN1SBRAPP007

sap_info                       701 SAPSR3 0002LK0003REP0011C13422638210015Maintenance_ORA

make_info                      NTAMD64 OCI_10201_SHARE Jan 16 2012

command_line                   brconnect -u / -jid CHECK20120810141850 -c -f check

alert_log                      E:\oracle\REP\saptrace\diag\rdbms\rep_in1sbrapp007\rep\trace\alert_rep.log

The environment variable ORACLE_HOME has value D:\oracle\REP\11202

The environment variable SAPDATA_HOME has value E:\oracle\REP

Checked the security for E:\oracle\REP and added full control for repadm.

Started checkdb in db13, but with same error messages as result.

Any idea's what I am missing ?

[srinivasan_vinayagam]

Hi Geert,

This permission issue of user SAPServiceSID.

1. Add this user to group ORA_SID_DBA, ORA_SID_OPER, SAP_SID_GlobalAdmin and SAP_SID_Localadmin.

2. Right click on E drive- properties - Security - Advanced - Permission - Give Full permission to SAP ServiceSID user.

Regards,

V Srinivasan

[Former Member]

Hi Geert,

Is this a Local or Domain Installation?

I think it might be an issue with the Users involved. for a Domain installation, only domain users are able to access the System.

Check that the SIDADM and SAPServiceSID are created locally or in Domain.

AC

[Former Member]

Hi,

Please check with your ORACLE_HOME and check for the settings from where the disk volume is fetching the data.

When trying to connect all the tables from the database. It did checks the path defined. So Please check for your oracle home path .

It will sure fix the issue.

Thanks & Regards,

Ahamed.

[g_vandenbroucke]

Command line is working:

C:\Users\repadm>brconnect -u / -jid CHECK20120813122718 -c -f check

BR0801I BRCONNECT 7.20 (22)

BR0805I Start of BRCONNECT processing: cejeyxwx.chk 2012-08-13 12.35.59

BR0484I BRCONNECT log file: E:\oracle\REP\sapcheck\cejeyxwx.chk

BR0477I Oracle pfile D:\oracle\REP\11202\database\initREP.ora created from spfil

e D:\oracle\REP\11202\database\spfileREP.ora

BR0280I BRCONNECT time stamp: 2012-08-13 12.36.08

BR0813I Schema owners found in database REP: APPQOSSYS, DBSNMP, DIP, OPS$IN1SAP\

REPADM, OPS$IN1SAP\SAPSERVICEREP, ORACLE_OCM, OUTLN, SAPSR3*, SYS, SYSTEM

BR0280I BRCONNECT time stamp: 2012-08-13 12.37.35

BR0814I Number of tables in schema of owner SAPSR3: 79672

BR0836I Number of tables treated as info cubes for owner SAPSR3: 93

BR0814I Number of tables/partitions in schema of owner SYS: 880/232

BR0814I Number of tables/partitions in schema of owner SYSTEM: 147/39

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.00

BR0815I Number of indexes in schema of owner SAPSR3: 95504

BR0815I Number of indexes/partitions in schema of owner SYS: 961/242

BR0815I Number of indexes/partitions in schema of owner SYSTEM: 207/52

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.13

BR0816I Number of segments in schema of owner DBSNMP: 8

BR0816I Number of segments in schema of owner OPS$IN1SAP\REPADM: 1

BR0816I Number of segments in schema of owner OUTLN: 9

BR0816I Number of segments/LOBs in schema of owner SAPSR3: 59396/2455

BR0816I Number of segments/LOBs in schema of owner SYS: 2577/141

BR0816I Number of segments/LOBs in schema of owner SYSTEM: 394/20

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.13

BR0961I Number of conditions found in DBCHECKORA: 118

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.13

BR0818I Number of tables found in DBDIFF for owner SAPSR3: 2

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.13

BR0818I Number of tables found in DBSTATC for owner SAPSR3: 391

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.13

BR0807I Name of database instance: REP

BR0808I BRCONNECT action ID: cejeyxwx

BR0809I BRCONNECT function ID: chk

BR0810I BRCONNECT function: check

BR0951I Number of active/inactive check conditions for database administration:

21/2

BR0952I Number of active/inactive check conditions for database operations: 5/5

BR0953I Number of active/inactive check conditions for database messages: 56/2

BR0954I Number of active/inactive check conditions for database profile: 25/2

BR0960I Last successful BRCONNECT check run: cejekzdx.chk 2012-08-10 16.29.13

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.13

BR0969I Checking database administration...

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.14

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: cejeyxcx.chk, time

: 2012-08-13 12.27.19, condition: Last 'chk' operation failed with rc = 3

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.14

BR0974I Checking database messages in E:\oracle\REP\saptrace\diag\rdbms\rep_in1s

brapp007\rep\trace\alert_rep.log ...

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.15

BR0977I Checking database profile...

BR0978W Database profile alert - level: WARNING, parameter: DB_FILES, value: 200

(< 254)

BR0978W Database profile alert - level: WARNING, parameter: DB_FILE_MULTIBLOCK_R

EAD_COUNT, value: 128 (set in parameter file)

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.15

BR0980I Number of changed database profile parameters: 0

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.15

BR0955I Number of signaled error/warning/exception alerts for database administr

ation: 0/0/0

BR0956I Number of signaled error/warning/exception alerts for database operation

s: 0/1/0

BR0957I Number of signaled error/warning/exception alerts for database messages:

0/0/0

BR0958I Number of signaled error/warning/exception alerts for database profile:

0/2/0

BR0806I End of BRCONNECT processing: cejeyxwx.chk 2012-08-13 12.38.15

BR0280I BRCONNECT time stamp: 2012-08-13 12.38.15

BR0803I BRCONNECT completed successfully with warnings

[Former Member]

Hello Geert,

It looks to be a permission issue, can you please make sure sidadm and SAPServiceSID have full access to this directory and also that both the users are part of Administrator group, ORA_SID_DBA and ORA_SID_OPER groups

Thanks

[g_vandenbroucke]

Hello Rohit,

Added full control permissions for the user sidadm and SAPServiceSID on the folder E:\oracle\REP.

The user sidadm and SAPServiceSID are part of the Administrator group, ORA_SID_DBA and ORA_SID_OPER groups.

Result is same message:

BR0280I BRCONNECT time stamp: 2012-08-13 12.27.26

BR0813I Schema owners found in database REP: APPQOSSYS, DBSNMP, DIP, OPS$IN1SAP\REPADM, OPS$IN1SAP\SAPSERVICEREP, ORACLE_OCM, OU

BR0252E Function _stat64() failed for 'E:\oracle\REP' at location BrDiskStatGet-1

BR0253E errno 2: No such file or directory

BR0277E Determination of disk volume status for E:\oracle\REP failed

[Former Member]

Try to add 'List Folder Contents' rights to E:\ for user <sid>adm and SAPServiceSID

Regards

Roman

[g_vandenbroucke]

Hello Roman,

The user SAPServiceSID has full control and user sidadm has 'List Folder Contents' rights  for E:\ folder, subfolders and files.