Offline redo log files are created with unexpectd permisions, and......

[former_member524429]

Hello friends,

I am facing this unexpected problems.

Let me give some brief information about the Server.

SAP System - Business Warehouse Quality Server, (Netweaver 04)

Database : - Oracle 9.2

Operating System : - HP_UX B.11.23, 64bit

Processor: ia64

Archive directory : /oracle/BQ1/oraarch

Archive Backup is carried out using external Backup Utility.

The main problem is:

Every time, The offline redo log files in /oracle/BQ1/oraarch directory, are created with Owner (ReadWrite), permissions only. Whereas, it should have the permissions for Owner(ReadWrite) as well as for Group (Read+Write). I compared this settings with other existing servers.

The Backup do not complete, as its getting error something like 'can not open <offline redo log files>', while performing backup.

When i manually set the permissions for the affected files and folders , then, the next backup completes without a single error.

I can't understand, why the next Offline redo file is created with unexpected permissions. (Owner(Read+Write) only).

Ultimately, I also manually set the permissions of "some directories as followed,

"/oracle/BQ1/saparch" -

---

> Owner (ReadWriteExecute)

Group (ReadWriteExecute)

All Users (ReadWriteExecute)

and

"/oracle/BQ1/oraarch" -

---

> Owner (ReadWriteExecute)

Group (ReadWriteExecute)

All Users (ReadWriteExecute)

This is not recommended , but i have changed them for sometime just to test.

But, Still the problems remain same. The offline redo log file(s) are created with Owner's only permissions.So, While taking backup, it will create problem in Opening for Group's User(s).

I have attached log that shows the problem.

_ _ _ _ _ _ _ __ _ _ _ _ _ _ _ _ _ _ _ _ __ ____ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ __ _ _ _ _ __ _ _ _ _ _ _ _ _ _

[Major] From: OB2BAR_SAPBACK@biwqas "BQ1" Time: 6/24/2008 5:40:35 AM

Cannot open file '/oracle/BQ1/oraarch/BQ1arch1_8400.dbf'. Error: 13.

[Normal] From: OB2BAR_SAPBACK@biwqas "BQ1" Time: 06/24/08 05:40:35 Starting OB2BAR Backup: biwqas:BQ1.3 "SAP"

[Normal] From: OB2BAR_SAPBACK@biwqas "BQ1" Time: 6/24/2008 5:41:11 AM

Completed OB2BAR Backup: biwqas:BQ1.3 "SAP"

[Major] From: OB2BAR_SAPBACK@biwqas "BQ1" Time: 06/24/08 05:40:35 Cannot open file '/oracle/BQ1/oraarch/BQ1arch1_8400.dbf'. Error: 13.

BR0233E Backup utility has reported an error while saving file /oracle/BQ1/oraarch/BQ1arch1_8400.dbf

BR0233E Backup utility has reported an error while saving file /oracle/BQ1/oraarch/BQ1arch1_8400.dbf

[Normal] From: OB2BAR_SAPBACK@biwqas "BQ1" Time: 06/24/08 05:41:11 Completed OB2BAR Backup: biwqas:BQ1.3 "SAP"

[Normal] From: OB2BAR_BACKINT@biwqas "BQ1" Time: 06/24/08 05:41:11

Backint exits with the code (2).

BR0280I BRARCHIVE time stamp: 2008-06-24 05.41.11

BR0279E Return code from '/usr/sap/BQ1/SYS/exe/run/backint -u BQ1 -f backup -i /oracle/BQ1/saparch/.adyfepsp.lst -t file -c': 2

BR0232E 0 of 1 file saved by backup utility

BR0280I BRARCHIVE time stamp: 2008-06-24 05.41.11

BR0231E Backup utility call failed

-

---

-

---

-

---

BR0007I End of offline redo log processing: adyfepsp.cds 2008-06-24 05.41.12

BR0280I BRARCHIVE time stamp: 2008-06-24 05.41.12

BR0005I BRARCHIVE terminated with errors

[Major] From: OB2BAR_OMNISAP@biwqas "OMNISAP" Time: 06/24/08 05:41:12

BRARCHIVE /sapmnt/BQ1/exe/brarchive -d util_file -cds -c -u system/********** returned 5

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ __ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

I am waiting for your precious response.

Regards,

*Bhavik Shroff *

[markus_doehr2 · Accepted solution]

Check note 831006 - Oracle installation on HP-UX 11.23 and 11.31 and read the section about "umask" (and change it)

Markus

[former_member524429 · Accepted solution]

Thanks, for your quick response.

I red the note 831006. There they have given nice example....

Can i set umask to 022 ?

The effect is dynamic or not ?

Whats about the Side Effects ?

Regards,

Bhavik Shroff

[markus_doehr2 · Accepted solution]

> Can i set umask to 022 ?

yes

> The effect is dynamic or not ?

The umask is not changed for running processes - means - you will need to change the umask for the ora<SID> user and restart your database.

> Whats about the Side Effects ?

A "side effect" will be, that the permissions are correctly set.

Markus

[former_member524429 · Accepted solution]

hi,

I have one doubt.

On other server (r3qas) the Umask settings are as followed

User UMASK value

<sid>adm 077

ora<SID> 077

root 077

Running SAP System : SAP R3 4.6C

Running DBMS : Oracle 9.0

Operating System :- HP_UX

On this system The new offline redo log files are created with 600 permissions. There is not a problem here, while taking the backup. I checked last "r3qas-archive" backups. There, i have not found any single error related to permissions, or any others (something like, Cannot open /oracle/RQ1/../.........dbf).

If everything is working fine, with this umask setting on this server, then, what's going wrong with the BW Quality server, which have the same umask settings (also others) for all the concerned users, as mentioned above.

Regards,

Bhavik Shroff

[Former Member · Accepted solution]

Hi,

did you check following notes.

Note 651351 - BR tools on UNIX: Error due to executable permissions

Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

regards,

kaushal

[former_member524429 · Accepted solution]

Hello Friends,

My problem is solved.

As per as the Note 113747 - Permissions for DBA tools BRTools and SAPDBA, I checked the permissions of brarchive, brbackup, brconnect and brtools. They all were set with permissions 775, only.

They should have the permissions 4755. So, I changed them to 4755.

1. chmod 4755 brarchive*

2. chmod 4755 brbackup*

3. chmod 4755 brconnect*

4. chmod 4755 brtools*

Now, my morning Archive Backup is completed Successfully, without errors.

Thanks a lot.

Regards,

Bhavik Shroff