Problem in BRTOOLS

[Former Member]

Dear all,

I am getting the below pasted error in BRTOOLS while taking backup. Though its allowing me to go ahead and take the backup, I wanted to know what could have gone wrong afte rthe kernel upgrade : -

---

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

BR0602W No valid SAP license found - please contact SAP

Which insufficient privileges is it mentioning? I had ran saproot.sh after the kernel upgrade

Any inputs?

[Former Member · Accepted solution]

Hi Sandy,

I suggest you to run sapdba_role.sql again & check the log.

& let me know how u r running sapdba_role.sql.

Run it ---> as sapdba_role.sql <SID>.

BR,

Darshan..

[Former Member]

sqlplus /nolog

connect /as sysdba

Select owner from dba_tables where table_name = 'SDBAD';

The result should be SAPsid

Copy the sapdba_role to a folder and from there give the command sqlplus /nolog @sapdba_role sid

Check the sqldba_role.log file. There should be no error reported

Thanks to everyone for your time and inputs

[Former Member]

Dear All,

I was having the same issue after a system copy.

I have run the sapdba_role.sql and sapconn_role.sql with SID, but even then i had the error.

The SID was ECQ but the schema was SAPECX, and the log of role sql script had errors in it.

so i run the command as shown below from sql prompt.

@sapdba_role.sql ECX

The error is rectified now.

Thanks and Regards,

Kiran

[Former Member]

See note 912969 it has all the details

[Former Member]

The entire error is as below

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

BR0602W No valid SAP license found - please contact SAP

BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:

'PREPARE stmt_1 STATEMENT FROM'

'SELECT TABSPACE FROM "SAPSRD".TSORA UNION SELECT INDSPACE FROM "SAPSRD".TSORA ORDER BY 1'

ORA-01031: insufficient privileges

[Former Member]

Did you read the note provided by Rajesh ?

You will find out that 'case 2' is very much like the error you got.

And you will find out that the note is suggesting the same thing as I did above.

[Former Member]

Hi Sandy,

I think you haven't read the note carefuly...

It is saying to run the SQL script (attachment: sapdba_role_ora10.SAR) which is attached in the below note:

[Note 134592 - Importing the SAPDBA role (sapdba_role.sql)|https://service.sap.com/sap/support/notes/134592]

If you have already done this then check the environment variables $DIR_LIBRARY and $SAPSYSTEMNAME.

Or you can also try updating your BRTools..( I am not sure about version of your BRtools).

It should resolve your issue.

Regards.

Rajesh Narkhede

[Former Member]

Dear Rajesh

Thanks

but

echo $DIR_LIBRARY for orasid returns the following

/usr/sap/sid/SYS/exe/run

[Former Member]

Hi Sandy,

BR1302W Initialization of license key library likeywlib failed, return code 1

This is a program error and the solution is given in the below note..

Please refer the below SAP Note, which describe your problem and solution.

[ Note 912969 - BR*Tools 7.00 fails due to license problems|https://service.sap.com/sap/support/notes/912969]

Specially read this line :

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

Regards.

Rajesh Narkhede

[Former Member]

Dear Jo,

Thanks for your time

But the sapdba_role.sql and/or sapconn_role.sql.were ran successfully after the upgrade, as the relevant notes

What I meant was that is there any other syntax / user ID / command / way / method to call those scripts?

In fact I have opened this message with SAP also and during my communication with SAP, they had also suggested to re - run those scripts, which I had done successfully

This seems to me like an authorization issue in DB, not on OS level

Thanks again

[Former Member]

One more thing to check:

Did you run the latest version of these scripts?

There are changes sometimes. Downloading again might be worth a try.

As for the syntax and so on: As I wrote, I don't know all the details by heart. Please read it up yourself.

regards

[Former Member]

This is ECC 6.0 system upgraded from ECC 5.0

This problem cropped up after the upgrade

sapdba_role.sql and/or sapconn_role.sql.were ran successfully

Do you suggest sapdba_role.sql and/or sapconn_role.sql.to be ran again? and with which user ID? Kindly suggest

Thanks

[Former Member]

Afaik the scripts should be run after the upgrade.

Not sure about it, but I would try it again. Maybe they were run too early.

Can't hurt, anyway!

And I haven't details (user and so on) at hand; please read it up yourself.

regards

[Former Member]

Yes, saproot.sh was ran and the user ID was root

And, I also tried the sapexe file extract with sidadm and sapdbexe with orasid user ID

Kernel upgrade or reverting back is not the problem

thanks

[Former Member]

You didn't tell us what your SAP version is.

But dependig on it, it might help to re-apply scripts sapdba_role.sql and/or sapconn_role.sql.

Search for them in SAP notes!

[Former Member]

Tried with old kernel but still the same....

Re-applied and double checked the license. That area looks fine

seems to me like some authorization issue

[Former Member]

Did you run the script saproot.sh after reverting to old kernel? Make sure you run this even when you revert back to the old kernel.

Also let us know by which user you are doing kernel upgrade? User should be root.

Regards

Sourabh Majumdar

[Former Member]

Hi,

In error message i could see that there is an issue with user privilages, which user u r using.

and one more critical issue is BR0602W No valid SAP license found - please contact SAP so please check u r license first.

saplicenst -show.

if your license expired or if your license not installed properly then request the license from SAP and install the same once you got the license from SAP.

once you are done with license installation and recheck whether BRTOOLS are working fine. still if you face any problem then rever back u r new kernel and check whether BRTOOLS work properly for the old version of kernel files.

-Srini

[Former Member]

Hi Sandy,

As a first step please validate your license number in SMP and in your SAP. If the license numbers are same, then I would recommend that you revert back to the old kernel, download fresh kernel files and perform the kernel upgrade once again.

Regards

Sourabh Majumdar