DB13 jobs cancelled due to "Permission denied" error.

[Former Member]

Hi all,

DB13 jobs are cancelled due to "Permission denied" error. I pasted the error log below. Actually we have upgraded database from Oracle 9 to 10, then after these jobs are cancelling before that this was fine. What could be the problem cousing to cancell these jobs in DB13. Please help me to resolve this issue.

Please let me know if you need any more information.

Current Database:- ORACLE, Release:- 10.2.0.2.0

SAP Component version:- SRM 4.0 , Release 640

-

---

Job log

Job started

Step 001 started (program RSDBAJOB, variant &0000000000080, user ID sridharm)

Execute logical command BRCONNECT On host aaebp0us

Parameters: -u / -c -f check

BR0801I BRCONNECT 7.00 (26)

BR0252W Function fopen() failed for '/oracle/PRD/102_64/dbs/initPRD.ora' at location BrInitOraCopy-2

BR0253W errno 13: Permission denied

BR0252E Function fopen() failed for '/oracle/PRD/sapcheck/cdyeuiqp.chk' at location main-11

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/PRD/sapcheck/cdyeuiqp.chk failed

BR0806I End of BRCONNECT processing: cdyeuiqp.chk2008-06-21 22.00.15

BR0280I BRCONNECT time stamp: 2008-06-21 22.00.16

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

-

---

Thanks for your help....

Sridhar M

[former_member59574]

Hello,

Please check the SAP Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

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

(1)

ora<sid> and <sid>adm on DB server have a search path on /sapmnt/<SID>/exe. (All br* and sapdba are contained in this directory.)

ora<sid> belongs to the dba group,

<sid>adm belongs to the sapsys group,

(2)

<sid>adm on the database server has the rhosts entry: "+ <sid>adm".

(3)

The ops$<sid>adm Oracle user must be created in the DB and must have the sapdba role (not DBA!) (refer to Note 134592 for more information about the role).

(4)

brarchive, brbackup, brconnect, brtools 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, and sapdba have permission 755:

-rwxr-xr-x <sid>adm sapsys ...

These can only be started by the ora<sid> OS user.

<<

Problem is due to authorization, so correct it and it will work.

Peter

[former_member185954]

Also,

Please check the following SAP Note:

Note 8523 - DB backups using CCMS do not work

Regards,

Siddhesh

[former_member185954]

Hello Sridhar,

From the OS Level, can you access the file :

'/oracle/PRD/102_64/dbs/initPRD.ora'

using userid ora<sid> ?

Regards,

Siddhesh