cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01031: insufficient privileges

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

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>;

former_member217765
Active Participant
0 Kudos

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

sunny_pahuja2
Active Contributor
0 Kudos

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

Former Member
0 Kudos

apply note 985607 as we need to install SAPCONN role in Oracle 10G after upgrade manually ..

Former Member
0 Kudos

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