cancel
Showing results for 
Search instead for 
Did you mean: 

backup via Cron job - SQL> ERROR: ORA-01031: insufficient privileges

Former Member
0 Kudos

Hi,

We are Using Oracle RAC - linux - SAP EP . We have scheduled online backup through crontab .

Always we are getting below error when the backup job runs via crontab

================

BR0278E Command output of '/usr/sap/EP1/SYS/exe/run/brtools -f printcmd -U /oracle/EP1/sapbackup/.begpjvay.003 'archive log list;' 'exit;' | /oracle/EP1/102_6

4/bin/sqlplus /nolog':

SQL*Plus: Release 10.2.0.5.0

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

SQL> ERROR:

ORA-01031: insufficient privileges

SQL> ORA-01012: not logged on

SQL>

BR0280I BRBACKUP time stamp: 2011-08-22 02.00.12

BR0279E Return code from '/usr/sap/EP1/SYS/exe/run/brtools -f printcmd -U /oracle/EP1/sapbackup/.begpjvay.003 'archive log list;' 'exit;' | /oracle/EP1/102_64

/bin/sqlplus /nolog': 0

BR0302E SQLPLUS call for database instance EP12 failed

=====================

whereas if i trigger the same commend

brbackup -u / -c force -t online -m all -p <init*.sap> manually it end successfully.

Kindly can anyone help over below issue.

Regards,

Ayyappan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ayyappan,

Could you please show us the crontab entry as well?

Br,

Venky.

Answers (3)

Answers (3)

Former Member
0 Kudos

Issue got fixed after changing the script.. Thanks Venky for your support

ngdms_ngdms
Explorer
0 Kudos

Hi Ayyappan,

Thanks in Advance,

We are also having same scenario with RAC and Linux, we are trying to configure backup and getting the same error could you please guide me how u resolved the issue, please help....

Regards,

Sumeesh

Former Member
0 Kudos

Hi Ayyappan,

If this is scheduled through cron, request you to check if there any other scripts which are modifying the environment variables.

Also, have a look at the following notes.

Note 776505 - BR*Tools fail with ORA-01017 / ORA-01031 on Linux

Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

Br,

Venky.

markus_doehr2
Active Contributor
0 Kudos

As which user are you running the cron job?

Markus