ALLOnl+LOG Backup via DB13 failed

[Former Member]

Hi!

I have planned each week a ALL Online Backup with LOG.

When the action has been performed the backup failed and I get the following error:

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: likey_init: likeyche_fill_buffer: 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-104

BR0602W No valid SAP license found - please contact SAP

I checked via tcode SLICENSE and detected that a valid SAP license exist.

Question:

How can I solve this problem?

Thank you very much!

regards

Holger

[stefan_koehler]

Hello Holger,

before you can perform a backup the BR*Tools are checking the valid licenses. The PUBLIC synonym SAP_SAPLIKEY is used for that.

Your user that is performing this action is not allowed to query the PUBLIC synonym (and the corresponding base table). This can have different reasons (wrong synonym, sapconn or sapdba role script was not executed, etc.).

Normally the BR*Tools are run under <SID>adm, if you schedule the backup via DB13. So please check all these stuff (#1028220, #834917, #480266).

I also have investigated a topic like that with another user in the forum... please also check this thread:

Regards

Stefan

[Former Member]

Hi Holgar,

Can you tell me what it is showing in

system -> status->SAP sysetm DATA->License Expiration date

which version r u using and what is your current kernel patch?

Regards,

Nitin Salunkhe.

[former_member204746]

I have found this on another forum on the net:

1. Enter the following parameter in your $ORACLE_HOME/dbs/init<SID>.ora:

2. REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

3. Execute the following command on the operating system level:

4. orapwd file=$ORACLE_HOME/dbs/orapw password=<passwd> entries=10

5. Restart your database

6. Execute the following command for THE Oracle users who are to get sysdba/sysoper authorization

7. connect sys/<passwd> as sysdba;

8. grant sysoper to <username>;

[Former Member]

Hi!

Many thanks for your responses.

The license expiration is 31.12.9999.

I found that no SAPR3 user exist on the database.

What are the technical steps to proceed?

Thank you very much!

regards

Holger

[stefan_koehler]

Hello Holger,

> I found that no SAPR3 user exist on the database.

What do you mean? You must have a SAP schema owner (user), but the name of it can differ.

Please execute the following query

shell> sqlplus / as sysdba
SQL> SELECT USERNAME FROM DBA_USERS;

Regards

Stefan

[former_member204746]

have you checked steps from my previous answers? what were the results?

[Former Member]

Hi!

> grant sysoper to <username>;

Which <username> do I need here?

Thank you!

[former_member204746]

if this is a new install:

grant sysoper to SAPSR3;

if this was installed with R/3 4.7:

grant sysoper to SAP[SID];

if this was installed with 4.6c or earlier:

grant sysoper to SAPR3;