BR0253E errno 13: Permission denied

[Former Member]

Hi Experts,

It's suddenly crashed and showing the below message

Oracle analyzer is not running and got the below error:

BR0801I BRCONNECT 7.00 (18)

BR0252E Function fopen() failed for '/oracle/PP0/sapcheck/cdxeoroa.sta'

at location main-9

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/PP0/sapcheck/cdxeoroa.sta failed

BR0806I End of BRCONNECT processing: cdxeoroa.sta 2008-08-04 06.00.02

BR0280I BRCONNECT time stamp: 2008-08-04 06.00.02

BR0804I BRCONNECT terminated with errors

The script owner ORASID & dba is having the below permissions

-rwxr-xr-x 1 orapp0 dba 168 21 Mar 2007 oracle_dbms_stats_analyze

Any help appreciated.

Regards,

Sreedhar Gunda

[fidel_vales · Accepted solution]

Hi,

may be that the br* authorizations are not correct.

Check the owner, group, and access authorizations for BR*Tools and SAPDBA in accordance with Note 113747.

[Former Member · Accepted solution]

Hi Fidel,

Thanks for the reply.

I checked the SAP Note. 113747 , they mentioned like

" The following settings are required for calling the BRTools and SAPDBA correctly, in particular when calling the BRTools from sapgui:"

But in my case, i'm checking all these permissions on Portal no sapgui. The BRCONNECT permissions on my server is not matching as per the note.

-rwsrwxr-x 1 ad0adm dba 6072423 26 Oct 2006 brconnect

But as per the note brconnect permission are below

brarchive, brbackup, and brconnect have permission 4775:

-rwsrwxr-x ora<sid> sapsys ...

which one is correct one ? pls suggest.

Regards

Sreedhar Gunda

[fidel_vales · Accepted solution]

>

> But in my case, i'm checking all these permissions on Portal no sapgui. The BRCONNECT permissions on my server is not matching as per the note.

I have to say that I do not understand properly what you mention about portal here but I think it does not matter much, what is important is:

> -rwsrwxr-x 1 ad0adm dba 6072423 26 Oct 2006 brconnect

The owner and group of brconnect is not the correct one. It must be the same as in the note:

> brarchive, brbackup, and brconnect have permission 4775:

> -rwsrwxr-x ora<sid> sapsys ...

otherwise you get authorization error as ad0adm does not have privileges to write the file

[former_member227600 · Accepted solution]

Hi Gunda,

You have to set the owner ora<sid> & group dba for

initSID.sap

sapdba_role.sql

initSID.dba

libsbt.o

brrestore

brtools

brarchive

brbackup

brconnect

brrecover

sapdba

dbatoolsora.lst

And than start

Karan

[fidel_vales · Accepted solution]

Hi,

Sorry but you are NOT correct.

The SAP note 113747 is clear about the owner:

brarchive, brbackup, and brconnect have permission 4775:                
-rwsrwxr-x   ora<sid>   sapsys   ...                                    
These can be started by the ora<sid> or the <sid>adm OS user.                                                                                
brrestore, brrecover, brspace, brtools, and sapdba have permission 755: 
-rwxr-xr-x   <sid>adm   sapsys   ...                                    
These can only be started by the ora<sid> OS user.                      

That means that you are providing wrong information that can lead to problems in the future.

It does not matter the owner of dbatoolsora.lst, it is only a list.

It does not matter the owner of sapdba_role.sql. It is only important that the user who is executing it can read it.

It does not matter the owner of initSID.sap and initSID.dba as they are only examples for creating your own files.

The note does not mention libsbt.o. That is the backup library, if you do not use it, the authorizations will not matter. As it is a library, not an executable, and it is provided by SAP the owner has to be <sid>adm and the group sapsys.

Please, read the SAP notes, they are there for a reason.

Some times they could contain mistakes, in that cases, SAP people would be happy to be pointed to them (some times is only a translation issue)

thanks

[Former Member · Accepted solution]

Hi,

I think recently you have done some upgradation on your system.

Just do one thing assign dba role to OPS$ users and I think issue will be resolved.

Shivam

[former_member227600 · Accepted solution]

Hi Fidel,

Sorry it's my mistake.

Karan

[Former Member · Accepted solution]

Hi All,

Thanks for the reply,

Shivam:

In Feb, we have upgraded the Portal but not the Orcale DB, are you refering to the application / DB?

if it's portal - still do I need to assign dba role to OPS$ users ?

I can agree with karan too bcz I checked the same on some other environments for brtools ,pls see the below info.

-rwxrwxr-x 1 oraasa dba 1929358 Oct 21 2006 brrestore

-rwxrwxr-x 1 oraasa dba 4493034 Oct 26 2006 brarchive

-rwsrwxr-x 1 oraasa dba 4619637 Oct 26 2006 brbackup

-rwsrwxr-x 1 oraasa dba 6072423 Oct 26 2006 brconnect

-rwxrwxr-x 1 oraasa dba 5070138 Oct 26 2006 brrecover

-rwxrwxr-x 1 oraasa dba 6176926 Oct 26 2006 brspace

-rwsrwxr-x 1 oraasa dba 2248568 Oct 26 2006 brtools

As per the note both environments are misleading the problem.

Which one is correct ? I can agree we need to follow SAP Notes .

Regs,

sree

[Former Member · Accepted solution]

Hi Sreedhar,

I think you should be facing this issue since your portal upgrade.So I will suggest you to login on SQL and check the roles assign to OPS$ users.If DBA is not there..Plz assign this role and try again .

Shivam

[fidel_vales · Accepted solution]

Again, sorry but OPS$ user has nothing to do with the error reported.

The error is an OS error:

> 13: Permission denied

it is not an oracle error. It may be that the ops$ is not properly configured, it may be that oracle parameters are not properly set, it may be a lot of things, but the current error is due to wrong authorizations at operating system level and the OPS$ user does not exist as a "real" user on the operating system, but it is an ORACLE specific mechanism.

The first thing that must be done is to follow the note, apply the correct authorizations and users to the BR* tools and try again.

If, afterwards, you get a different error (may be related to OPS$) that can be investigated, in this or other thread. But currently palying around with the OPS$ will not do any good for your error.

[Former Member]

Hi Sreedhar,

Could you please let me know, how you resolved this error. It would be great help.

Thanks

[stefan_koehler]

Hello,

> BR0252E Function fopen() failed for '/oracle/PP0/sapcheck/cdxeoroa.sta' at location main-9

Have you already checked the permissions for the folder /oracle/PP0/sapcheck/ ?

Regards

Stefan