ORA-01031: insufficient privileges and SAP license issue

[Former Member]

Hi,

We have successfully installed the NW7.31 with ORACLE 11.2.0.4 on AIX.

Its a fresh installed system, after installation we have applied the saplicense through SLICENSE and after that upgrade the kernel(We have run the ./saproot.sh <SAPSID> with root user).

Kernels are upgraded successfully, we have checked the disp+work, kernel patch level is upgraded successfully.

SAP is started normally, but now we are facing two issues on OS level.

1. Issue is regarding to the saplicense command....

abcadm 4> saplicense -show

saplicense: no license entries found

abcadm 5> saplicense -number

saplicense: read installation number failed

*** Can not read profile parameter SAPSYSTEMNAME

Start saplicense with -number NAME=<sid>

abcadm 6> saplicense -number NAME=ABC

Read installation number for SAP SYSTEM: ABC

INSTALLATION NO = INITIAL

2. When we are trying to run the Update statistics on database with DB13 command following error occurs. Even i have tried via brtools but still following error occures.

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

I have checked the R3trans -d it working fine.

oraabc 15> R3trans -d

This is R3trans version 6.24 (release 721 - 08.05.14 - 16:50:00).

unicode enabled version

R3trans finished (0000).

In SLICENSE tcode it showing the license entries but when we are run the command from os level "saplicense", it didnt found any license entry.

Kindly suggest.

regards,

amit

[Former Member]

Hi all,

Issue has been resolved by using the note 134592 .

regards,

amit..

[divyanshu_srivastava3]

That was expected.

[former_member188883]

Hi Amit,

Good to know problem has been resolved .

Regards,

Deepak Kori

[Former Member]

Hi,

I suggest you to close this thread as your issue has resolved.

Regards,

Nick Loy

[divyanshu_srivastava3]

Hi,

Have you tried using saplikey show command ?

Also did you set dbms_type=ora and DIR_LIBRARY environment variables for sidadm ?

Regards

[Former Member]

Hi Divyanshu,

Output of saplikey show as follows....

abcadm 15> saplikey show

saplikey: no parameter SAPSYSTEMNAME.

Following env variable are already assigned to user <sid>adm......

dbms_type=ORA

DIR_LIBRARY=/usr/sap/ABC/SYS/exe/run

SAPSYSTEMNAME=ABC

dbs_ora_tnsname=ABC

ORACLE_SID=ABC

regards,

amit

[divyanshu_srivastava3]

Hi,

How to use this, read below.

ReferLicense Administration at Operating System Level with Program saplikey - SAP Licensing Procedure - S...

[divyanshu_srivastava3]

And ORA should be in small not in caps.

[Former Member]

Hi Divyanshu,

I think capital ORA allows in env variable.

regards,

amit

[divyanshu_srivastava3]

I think it depends on OS how it handles small and caps. For eg. In AIX abc and ABC are different.

[Former Member]

Hi Divyanshu

Yup you are right, so shall i temporary set the parameter dbms_type=ora?

via..... setenv dbms_type ora

and then try to check the saplicense? If it works then i will set this env variable permanent in <sid>adm user profile ???

regards,

amit

[divyanshu_srivastava3]

That was an just an suggestion. I have faced an issue because of this so thought of sharing with you.

[Reagan]

You don't need to change any parameters.

The dbms_type=ORA is the correct format for the environment variable.

Use splikey to view the licenses.

saplikey -show pf=/sapmnt/SID/profile/SID_DVEBMGS00_HOSTNAME

For the ORA-01031: insufficient privileges issue run the sapdba_role.sql present at the kernel location.

Regards

RB

[Former Member]

Hi Reagan,

The command suggested by you has been resolved my license issue.....

saplikey -show pf=/sapmnt/SID/profile/SID_DVEBMGS00_HOSTNAME

But why it doesnt display the license info only by entering the command "saplikey -show'

Output of saplikey show as follows....

abcadm 15> saplikey show

saplikey: no parameter SAPSYSTEMNAME.

Kindly suggest.

About the ORA-01031: insufficient privileges issue, I am working on it, i will update you.

regards,

amit

[divyanshu_srivastava3]

Hi Amit,

I believe that answer was told you before by me with help.sap link and to use saplikey.

[former_member188883]

Hi Amit,

saplikey command needs to be executed with path of instance profile only.

This is the reason when you execute saplikey -show it did not return any output.

Regards,

Deepak Kori

[Reagan]

You should always specify the profile when you run saplikey.

Check this SAP note 870871 - License key installation

Always enter the commands under the specification of the profile: saplikey pf=<profile> <command> <product>

Regards

RB

[former_member188883]

Hi Amit,

Please share your NW SP level + SAP kernel level + DBATOOLS patch level.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

NW SP level as follows.............

SAP_BASIS	731	0011
SAP_ABA	731	0011
PI_BASIS	731	0011
ST-PI	2008_1_710	0010
SAP_BW	731	0011

SAP Kernel as follows....................

kernel release                721

kernel make variant           721_EXT_REL

compiled on                   AIX 1 6 00CFADC14C00 for rs6000_64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  May 27 2014 03:48:09

update level                  0

patch number                  300

source id                     0.300

DBATOOLS level as follows...............

oraabc 12> brtools

BR0651I BRTOOLS 7.20 (36)

regards,

amit

[former_member188883]

Hi Amit,

Please import the sapdba role as described in SAP note

134592 - Importing the SAPDBA role (sapdba_role.sql)

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Sure i will import the role, but I have to check that SAPDBA role is already exist in or not?

Also any solution for license issue?

slicense tcode displays correct license, but when i tried on OS level it says "saplicense: no license entries found"

regards,

amit