BRTools errors occur when accessing "database" directory

Symptom:

Determination of file status for spfileGEP.ora failed

After you use the Database Upgrade Assistant (DBUA) to apply Oracle patch set, BRBACKUP and BRCONNECT fail and the system issues error messages such as:

BR0252E Function CreateFile() failed for 'E:\oracle\SID\12102\database\spfileSID.ora' at location BrFileStatGet-2

BR0253E errno 5: Access is denied.

BR0273E Determination of file status for E:\oracle\SID\12102\database\spfileSID.ora failed.

Solution:

You must change the access authorizations so that they do not apply only to the database directory, but to all database files and the spfile. To avoid a large amount of manual steps, in BRCONNECT 7.00 Patch 39 and BRCONNECT 7.10 Patch 19, the workaround option "-SFP" (set file permissions) is provided for the "check" function. You can use this to perform a BRCONNECT call under the user <SID>ADM to set all of the required access authorizations, for example:

brconnect -u / -c -f check -SFP

In the process, the access authorizations to the following directories and the subdirectories and files under them are modified:

%ORACLE_HOME%\database,

<X>:\oracle\<DBDID>\origlog

<X>:\oracle\<DBDID>\mirrlog

<X>:\oracle\<DBDID>\sapdata<N>

If the system issues any warnings about Windows groups that do not exist (for example, ora_oper), you can ignore these.

Hope this helps!!!

Abraham