on 08-23-2011 11:30 AM
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
Hi Ayyappan,
Could you please show us the crontab entry as well?
Br,
Venky.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Issue got fixed after changing the script.. Thanks Venky for your support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As which user are you running the cron job?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.