on 01-10-2013 5:18 PM
Hi All,
I am taking online backup of SAP oracle database.I have configured BRTools backup configurtion to local SAN disk.I have made the archivelog backup successfull,but while triggering for online backup am facing below issues.Please let me know any solutions.
BR0051I BRBACKUP 7.20 (23)
BR0055I Start of database backup: bekhiqbz.and 2013-01-10 14.12.51
BR0484I BRBACKUP log file: /oracle/XXX/sapbackup/bekhiqbz.and
BR0477I Oracle pfile /oracle/XXX/112_64/dbs/initXXX.ora created from spfile /oracle/CBD/112_64/dbs/spfilexxx.ora
BR0280I BRBACKUP time stamp: 2013-01-10 14.12.53
BR0301W SQL error -1031 at location saplikey_read-1, SQL statement:
'OPEN curs_122 CURSOR FOR'
'SELECT SELECT LIKEY, VALUE FROM SAP_SAPLIKEY ORDER BY LIKEY'
ORA-01031: insufficient privileges
BR1301W Error message from likeywlib: 96 likey_init: Couldn't get the list of all records from the persistence.
BR1302W Initialization of license key library likeywlib failed, return code 1
BR1304W Checking SAP license failed at location BrLicCheck-122
BR0602W No valid SAP license found - please contact SAP
The solution i got for the above is there is a license problem and i got the SAP note 912969(BR*Tools 7.00 fails due to license problems)
BR0280I BRBACKUP time stamp: 2013-01-10 14.12.54
BR0319I Control file copy created: /oracle/XXX/sapbackup/cntrlxxx.dbf 29114368
BR0280I BRBACKUP time stamp: 2013-01-10 14.12.55
BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:
'PREPARE stmt_1 FROM'
'SELECT TABSPACE FROM "SAPXXX".TSORA UNION SELECT INDSPACE FROM "SAPxxx".TSORA ORDER BY 1'
ORA-01031: insufficient privileges
BR0056I End of database backup: bekhiqbz.and 2013-01-10 14.12.55
BR0280I BRBACKUP time stamp: 2013-01-10 14.12.55
BR0054I BRBACKUP terminated with errors
From which User you are trying to take backup through BRTOOLS
Use ORA<SID> not <SID>ADM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shahnas,
I followed that note and inported sapdba role as per case 2.
Case 2:
Import the SAPDBA role (Version 7.00) in accordance with Note 134592. To do this, use the script sapdba_role.sql from the attachment sapdba_role_ora10.SAR provided in this note
I have done this and my database is 11gr2 and imported the spadba role for 11g too..stsill issue persisting
Regards
Ram
Caution 1:
----------
On Unix systems, you must also set the
environment variable DIR_LIBRARY to the directory that contains the
libsapsecu library, for example:
DIR_LIBRARY = /usr/sap/<SID>/SYS/exe/run
or
DIR_LIBRARY = /usr/sap/<SID>/SYS/exe/uc|nuc/<platform>
This
is especially important if you use an external scheduler (cron, at or
BACKINT scheduler) to start BR*Tools. In that case, this variable must
be set in the environment of this scheduler (for example, in an
environment file).
The same applies to the environment variable SAPSYSTEMNAME.
It must always be set if the SAP SID differs from the Oracle SID. In
addition, it often has the incorrect value after a system copy. In
particular, this applies to the environment of the user ora<sid>
and of an external scheduler.
Caution 2:
----------
If you
still operate an older level of the SAP kernel, it is often necessary
to exchange the libsapsecu.so. The most recent versions of the
libsapsecu.so are available on SAP Service Marketplace.
For more information about downloading patches, see Notes 12741 and 19466.
Hi All,
Let me know if anyone can give me any help on this below one:
BR0280I BRBACKUP time stamp: 2013-01-10 14.12.54
BR0319I Control file copy created: /oracle/XXX/sapbackup/cntrlxxx.dbf 29114368
BR0280I BRBACKUP time stamp: 2013-01-10 14.12.55
BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:
'PREPARE stmt_1 FROM'
'SELECT TABSPACE FROM "SAPXXX".TSORA UNION SELECT INDSPACE FROM "SAPxxx".TSORA ORDER BY 1'
ORA-01031: insufficient privileges
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
The workaround we have done is we have granted sapdba role, sapconn role to SAPPBW( SAP schema name).I have followed above SAP notes and followed the instructions appropriately, but the online backup is failing at the below these 2 issues .
I have installed new licenses to the system. But still issue persists
BR0301W SQL error -1031 at location saplikey_read-1, SQL statement:
'OPEN curs_122 CURSOR FOR'
'SELECT SELECT LIKEY, VALUE FROM SAP_SAPLIKEY ORDER BY LIKEY'
ORA-01031: insufficient privileges
BR1301W Error message from likeywlib: 96 likey_init: Couldn't get the list of all records from the persistence.
BR1302W Initialization of license key library likeywlib failed, return code 1
BR1304W Checking SAP license failed at location BrLicCheck-122
BR0602W No valid SAP license found - please contact SAP
BR0280I BRBACKUP time stamp: 2013-01-11 05.52.16
BR0319I Control file copy created: /oracle/CBD/sapbackup/cntrlCBD.dbf 29114368
BR0280I BRBACKUP time stamp: 2013-01-11 05.52.17
BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:
'PREPARE stmt_1 FROM'
'SELECT TABSPACE FROM "SAPPBW".TSORA UNION SELECT INDSPACE FROM "SAPPBW".TSORA ORDER BY 1'
ORA-01031: insufficient privileges
Can anyone provide further inputs to us as we are stuck in triggering the online backup
Regards
Ram
Hi ,
Hope i have given the role sapdba and sapconn as the below SQL query has given the confirmation
select grantee, granted_role, default_role from dba_role_privs where grantee = 'SAPPBW';
GRANTEE GRANTED_ROLE DEF
------------------------------ ------------------------------ ---
SAPPBW DBA YES
SAPPBW SAPDBA YES
SAPPBW CONNECT YES
SAPPBW SAPCONN YES
SAPPBW RESOURCE YES
SAPPBW SELECT_CATALOG_ROLE YES
Regards
Ram
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.