on 02-16-2010 3:22 AM
I've done oracle 9.2.0.5 to 10g, SAP 4.6C to ECC 6 upgrade, but now can not walk BRBACKUP with errors as below. I have replaced most brtools with the new. judging from the error, if anything to do with the sap license? when viewed from SAPGui, sap license no problem, but if viewed from the operating system level there is no license attached.
if there is among friends who can help with this problem, thank you
"45y0CBR0051I BRBACKUP 7.00 (46)
BR0055I Start of database backup: becpakki.fnf 2010-02-16 09.32.04
BR0484I BRBACKUP log file: /oracle/SGQ/sapbackup/becpakki.fnf
BR0477I Oracle pfile /oracle/SGQ/102_64/dbs/initSGQ.ora created from spfile /oracle/SGQ/102_64/dbs/spfileSGQ.ora
BR0280I BRBACKUP time stamp: 2010-02-16 09.32.04
BR0301E SQL error -1031 at location BrLicCheck-12, SQL statement:
'SELECT MAX(SYSTEMNAME), MAX(SYSID) FROM SAP_MLICHECK WHERE EXPIRATION_DATE = (SELECT MAX(EXPIRATION_DATE) FROM SAP_MLICHECK)'
ORA-01031: insufficient privileges
BR0056I End of database backup: becpakki.fnf 2010-02-16 09.32.04
BR0280I BRBACKUP time stamp: 2010-02-16 09.32.05
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2010-02-16 09.32.05
BR0291I BRARCHIVE will be started with options '-U -jid FLLOG20100216093203 -c force -p initSGQ.sap -cds'
BR0280I BRBACKUP time stamp: 2010-02-16 09.32.05
BR0292I Execution of BRARCHIVE finished with return code 3"
Hadi
For everyone's information, I got the same issue:
BR0280I BRBACKUP time stamp: 2015-04-13 11.08.10
BR0301E SQL error -1031 at location BrLicCheck-12, SQL statement:
'SELECT MAX(SYSTEMNAME), MAX(SYSID) FROM SAP_MLICHECK WHERE EXPIRATION_DATE = (SELECT MAX(EXPIRATION_DATE) FROM SAP_MLICHECK)'
ORA-01031: insufficient privileges
And it's fixed by running below statement:
grant select,update on <SCHEMA>.MLICHECK to OPS$ORA<SID>;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hadi,
"SAP ERP 6.0 Upgrade" is to deal with problems during upgrade/EHP installation/SP implementation using the corresponding sap tool SAPup/EHPI/SPAM/SAINT.
For your problem, I think it is better for you to create a new thread under forum "Database & OS Platforms" ->"SAP on Oracle".
With Best Regards
Julia Song
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
check SAP Note 834917 - Oracle Database 10g: New database role SAPCONN and Note 912969 - BR*Tools 7.00 fails due to license problems
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI hadi,
as upgrade guidance, you have to execute Oracle Performing Specific Actions.
proceed as follow :
- Logon as user ora<sid> at Unix level
- start this code
cd $ORACLE_HOME/dbs
cp /usr/sap/<SID>/SYS/exe/run/sapdba_role.sql sapdba_role.sql
- Check sapdba_role.sql exist in $ORACLE_HOME/dbs
run with sqlplus /nolog
- sqlplus /nolog @sapdba_role <SCHEMA_ID>
e.g. sqlplus /nolog @sapdba_role SAPR3
if any error has message like PRODUCT_USER_PROFILE just ignore it
wait and done. you can user BRtools for update statistic
thanks
ghochi
User | Count |
---|---|
83 | |
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.