Skip to Content
0
Former Member
Aug 23, 2011 at 10:30 AM

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

219 Views

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