Issue with DB13

[former_member759680]

Hello,

We have SAP on Windows+Oracle

Update stats and CheckDB are failing with the error :

BR0801I BRCONNECT 7.00 (40)
BR0477I Oracle pfile D:\oracle\P5E\102\database\initP5E.ora created from spfile D:\oracle\P5E\102\database\spfileP5E.ora
BR0805I Start of BRCONNECT processing: cecdjfyl.chk 2009-12-16 11.23.03
BR0484I BRCONNECT log file: F:\oracle\P5E\sapcheck\cecdjfyl.chk
BR0252E Function fopen() failed for 'F:\oracle\P5E\sapcheck\connP5E.log' at location main-13
BR0253E errno 13: Permission denied
BR0121E Processing of log file F:\oracle\P5E\sapcheck\connP5E.log failed

BR0806I End of BRCONNECT processing: cecdjfyl.chk2009-12-16 11.23.05
BR0280I BRCONNECT time stamp: 2009-12-16 11.23.05
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3

Since it is no Windows, there is no permission issue.

Kindly advise how to correct this issue.

Thanks.

[former_member720526]

Please check the group memberships of SAPService<SID>. This is the user that starts the services in windows and therefore the call must be happening with this user.

Vipin

[Former Member]

This message was moderated.

[Former Member]

Hi

Just a silly question, is your DB and CI on the same machine? The last time I had the same issue (regardless of the operating system type), it was because the two CI and DB were residing on different machines. So BRTOOLS (which is visible to both the CI and the DB because of the mapped SAPMNT directory (assumption here), instead of executing on remote host, Brtools is executed from the CI host (as executed by the ADM user). Again, thats if you have them on different machines.

Ronny

[Former Member]

BR0252E Function fopen() failed for 'F:\oracle\P5E\sapcheck\connP5E.log' at location main-13
BR0253E errno 13: Permission denied

Looks like you have some problem with the permissions. Are you logged in as ,sid>adm ? Also check following note

[http://service.sap.com/sap/support/notes/113747]

[former_member759680]

Did any update to BRTOOLS, kernel?
Try running saproot.sh and then run the check DB,etc..
<a class="jive_macro jive_macro_message" href="" __jive_macro_name="message" modifiedtitle="true" __default_attr="5958799"></a>
Also check the permissions of sidadm user, it should have dba group assigned to it.

Like I said in my first post - Its a Windows system.

What permissions do I check in Windows?

Looks like you have some problem with the permissions. Are you logged in as ,sid>adm ?

I have this error only in DB13.

From OS level brconnect works fine.

[JPReyes]

Check that <sid>adm is a member of the local admins...

I had a problem similar to this one once and I fix it by changing the password of system user back to the default... I think i later re-runned sapconn_role.sql and sapdba_role.sql to fix the issue.

Was this system refreshed?

Regards

Juan

[Former Member]

We have SAP on Windows+Oracle 

Since it is no Windows, 

Like I said in my first post - Its a Windows system.

Score is 2 : 1 for Windows now.

[former_member759680]

Check that <sid>adm is a member of the local admins...

I am able to run brconnect for check and stats from OS level using sidadm

So sidadm is fine.

From OS level with sidadm I am able to access the saptrace folder and the connP5e.log as well.

My question is doesn't DB13 use sidadm user as well?

If I am able to do all the tasks using sidadm from OS level, why isnt DB13 able to do the same tasks?

[JPReyes]

As far as I remember use the system user at DB level... did you read my entire post?

Regards

Juan

[former_member759680]

Hello Juan,

To answer your question - No, there was no refresh of the system.

But I did not get your reply -

use the system user at DB level

If I am able to do all the tasks using sidadm from OS level, why isnt DB13 able to do the same tasks?

[Former Member]

Hi Gautam,

Please check if F: is not full or is about to be full. Also as <sidadm> try to access the path 'F:\oracle\P5E\sapcheck and create a dummy file.

Regards.

Ruchit

[former_member759680]

Theres 12 GB free on F:\

and I am also able to create new files in F:\oracle\P5E\sapcheck with P5EADM.

[Former Member]

Hello Gautam,

Can you check if you are following all recommendations of note 656365.

Regards.

Ruchit

[Former Member]

Hi,

Try updating BRTOOLS patch to 44.

Cheers.....,

Raghu

[Former Member]

Hello,

Did any update to BRTOOLS, kernel?

Try running saproot.sh and then run the check DB,etc..

Also check the permissions of sidadm user, it should have dba group assigned to it.

Regards,

Yoganand.V

Edited by: Yoganand Vedagiri on Dec 16, 2009 11:54 AM