on 11-13-2008 1:24 PM
hi experts
while iam taking backup with brtools i got following error
BR0051I BRBACKUP 7.00 (24)
BR0055I Start of database backup: bdzgcgba.ant 2008-11-13 13.23.38
BR0484I BRBACKUP log file: /oracle/KPR/sapbackup/bdzgcgba.ant
BR0280I BRBACKUP time stamp: 2008-11-13 13.23.38
BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:
'CONNECT / AT PROF_CONN IN SYSOPER MODE'
ORA-01031: insufficient privileges
BR0303E Determination of Oracle version failed
BR0056I End of database backup: bdzgcgba.ant 2008-11-13 13.23.38
BR0280I BRBACKUP time stamp: 2008-11-13 13.23.38
BR0054I BRBACKUP terminated with errors
###############################################################################
BR0292I Execution of BRBACKUP finished with return code 3
can anyone answer this error
As of Oracle 10g you have new roles database SAPCONN and SAPDBA. You can problem for this role...
As you can start SAP , the SAPCONN role are configured correctly, are you importing SAPDBA role to ?
try to check the "Note 134592 - Importing the SAPDBA role (sapdba_role.sql)"
to check your SAP database user in sqlplus execute :
SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'T000';
Some times all authorization are GOOD, but you steel will see same error ,as me for example in one situation
in case of HP Data Protector :
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi experts
i added these roles sapdba,sapconn to sapsr3,ops$sidam users again i got sam problem.
BR0051I BRBACKUP 7.00 (24)
BR0055I Start of database backup: bdzgcgba.ant 2008-11-13 13.23.38
BR0484I BRBACKUP log file: /oracle/KPR/sapbackup/bdzgcgba.ant
BR0280I BRBACKUP time stamp: 2008-11-13 13.23.38
BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:
'CONNECT / AT PROF_CONN IN SYSOPER MODE'
ORA-01031: insufficient privileges
BR0303E Determination of Oracle version failed
BR0056I End of database backup: bdzgcgba.ant 20
i tried with sidadm user following error get
usr/sap/KPR/SYS/exe/run/brbackup: error while loading shared libraries: libclnt sh.so.10.1: cannot open shared object file: No such file or directory
###############################################################################
BR0292I Execution of BRBACKUP finished with return code 127
regards
vasu
Edited by: vasu k on Nov 14, 2008 10:17 AM
Hi Eric,
it is possible to use BRtools 7.00 with Oracle 9i.
In any case, BRTools require the oracle 10g instant client to be installed and properly configured and this does not seem to be the case here.
If the OP does not want to complicate itself by installing the instantclient and changing environment variables ... then it should follow you recommendation (use 6.40)
Hi All,
I have resolved this error by adding group "oper" to user ora<sid>
How to add:
=========
To check the available groups
cat /etc/group
To add the "oper" group as supplementary group use below command
usermod -G 503 orasxy ( 503 is group id)
we can findout group id in /etc/group
ex:oper::503
To check the available groups for user orasid use command. "id"
Regards
======
DeviSri
try
SQL> connect system as sysoper
Enter password:
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL> connect sys as sysdba
Enter password:
Connected.
SQL> grant sysoper to system;
Grant succeeded.
SQL> connect system as sysoper
Enter password:
Connected.
/thread/672949 [original link is broken]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try SAP note 400241.
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 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.