After Upgrade Kernel 742 PL to 425 offline backup failed

[Former Member]

Dear Support team,

We are using SAP NETWEAVER 7.4 with database oracle 12.1.0.2 and server operating system is AIX 7.1

Recently updage kernel 742 patch level 417 to 425 as advices by SAP Note no.2356238.

After upgrade kernel patch level our SAP Offline backup failed with below error message.

----------------------

betysvkq.fff---error message from log file.  

BR0278E Command output of 'SHELL=/bin/sh /oracle/DVB/12102/bin/rman nocatalog':

ORA-19564: error occurred writing 8192 bytes at block number 1

ORA-27091: unable to queue I/O

ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 13: Permission denied

BR0279E Return code from 'SHELL=/bin/sh /oracle/DVB/12102/bin/rman nocatalog': 1

BR0536E RMAN call for database instance DVB failed

BR0532E Cataloging backups of all database files failed

BR0279E Return code from 'SHELL=/bin/sh /oracle/DVB/12102/bin/rman nocatalog': 0

BR0536E RMAN call for database instance DVB failed

---------------------------------

betysvkq.fff.log file attached for your ready reference.

Restore old version (iepatch level 417) scheduled offline backup work successfully.

Kindly guide us to resolve the issue at the earliest.

Naik Diptesh 

betysvkg.fff.txt.zip

[Former Member]

Hello Diptesh,

Please execute oraroot.sh, sapdba_role.sql and sapconn_role.sql.

If you are using oracle user as per Oracle 12 check following note

1598594 - BR*Tools configuration for Oracle installation using user "oracle"

Thanks,

Hardeep

[Reagan]

Check if the Oracle/BR*Tools user is part of the required groups.

[JamesZ]

Hi Naik,

The problem may be caused by that brtools permission changed. Please check SAP note 113747 for the brtools permission setting.

Following error could be caused by that <sid>adm user does not have permission to oracle control file:

'SHELL=/bin/sh /oracle/DVB/12102/bin/rman nocatalog'

RMAN-03009: failure of catalog command on default channel at 09/01/2016 11:09:39

ORA-19564: error occurred writing 8192 bytes at block number 1

ORA-27091: unable to queue I/O

ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 13: Permission denied

Best regards,
James

[former_member182505]

Hi

after kernel upgrade did you ran the ./saproot.sh.

Please check the permission of br* file

Thanks

sadiq

[Former Member]

Hi Sadiq

Thanks for update.

permission for br* set as per note 1598594.

./saproot.sh also upgrade.

Naik Diptesh

[manish_singh13]

Hi Diptesh,

Please recheck all the steps as per SAP Note 1598594. Also please confirm if your Oracle installation is being done by oracle user OR orasid.

Please paste BR* tools file permissions here to verify further.

Thanks,

Manish