After upgraded to 11 g from 10g db error

[Former Member]

Hello Dear,

After upgraded to 11 g from 10g, in DB16 check DB giving one error like.os is windows server.

BR0252E Function fopen() failed for 'D:\app\sidadm\diag\rdbms\sid\sol\trace\alert_sid.log' at location ora_alert_check-1
BR0253E errno 13: Permission denied

Please help me.

Thanks

Santosh dwivedi

[srinivasan_vinayagam]

Dear Santosh,

You can refer this note: SAP  Note 113747 - Owners and authorizations for BR*Tools

Regards,

V Srinivasan

[Former Member]

Hi Srinivasan,

Now its working fine. Thanks

Thanks

Santosh Dwivedi

[Former Member]

Make sure that the ORA<SID> user has the RWX permissions on /Oracle filesystem and the BRTOOLS commands under /Usr/sap/<SID>/SYS/exe/run

[Former Member]

And check SAP NOTE: 1836386 - DBA Planning Calendar Jobs fail with error "BR0253E" errno 13: Permission denied

and SAP NOTE: 113747: Owner and Permissions of BR Tools

Regards

Philipp

[Reagan]

Philipp Zapatka wrote:

Make sure that the ORA<SID> user has the RWX permissions on /Oracle filesystem and the BRTOOLS commands under /Usr/sap/<SID>/SYS/exe/run

This is a Windows system and the notes you are pointing out are valid only for the *nix platforms.

Santosh, are you able to run Brconnect check from the OS level ?

brconnect -u / -c -f check

I suspect this could be due to the Oracle installation.

Reagan

[Former Member]

Hi Reagan,

Yes, i am able to run brconnect -u / -c -f check at os level.

Result is completed with warning

[Reagan]

Before the upgrade what was the location of the Oracle alert log ?

I am still unaware of the version of the BRTools you are using and also is the manual execution of the brconnect looking for the same location for the alert log ? Assuming that you have referred to all the relevant SAP notes you may 1 - Restart the SAP system and the server 2 - Check whether the SAPServiceSID and <SID>adm user has the permissions to access this drive and the location.

Cheers

Reagan

[Former Member]

Hi Reagan,

Oracle alert log location is same and brtool version 720(39).

When i executed the brconnect -u / -c -f check -SFP through command line its ok with warning.

But whenever i am executing with DB16 it giving error in db24 log check.

Thanks

Santosh Dwivedi

[Reagan]

I believe you executed the "Check" command under <SID>adm user. In that case check whether the user SAPService<SID> has sufficient rights as well.

There is nothing much I can assist you now as I am out of clues now. I am still wondering why you have a non standard Oracle installation for the SAP system.

Good Luck

Reagan

[Former Member]

Hi Reagan

Thanks, its solved now .

Thanks

Santosh Dwivedi

[Reagan]

Have you updated the BR*Tools after the Oracle upgrade ?

Secondly you have a non standard Oracle installation for SAP.

Reagan

[Former Member]

Hi Reagan,

Yes i have updated the brtools after oracle upgrade.

It upgraded by DBUA tool.

Thanks

Santosh Dwivedi

[alichtenau]

Hi Santosh,

please update BR*tools to the latest available version.
Please also check note #113747 which deals with owners and authorization questions of BR*Tools.

Maybe also note #1173159 can help here.

Cheers,
Andreas

[Former Member]

Hello Andreas,

I have already check this sap note and also updated the brtools after 11 g upgrade.

Thanks

Santosh Dwivedi

[former_member185239]

Hi Santosh,

Give the full permission 'D:\app\sidadm\diag\rdbms\sid\sol\trace\alert_sid.log' to the path.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashu,

I have already given full permission to this path.

[Former Member]

Hi Santosh,

give full permissions to the path you wrote and try again.

Regards

Philipp

[Former Member]

Hi,

I have already given full permission to this path.

Thanks

Santosh Dwivedi