Skip to Content
0
Aug 03, 2016 at 03:08 PM

iotc.convert ORA-01031: insufficient privileges

403 Views

Hi All,

I have just installed the IOTC package in an Oracle 12c database following SAP Note http://service.sap.com/sap/support/notes/1856270

But it errors.

sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 3 14:43:12 2016

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> create or replace directory "~IOT_DIR" as '/tmp';

Directory created.

SQL> grant read, write on directory "~IOT_DIR" to sapsr3;

Grant succeeded.

SQL> grant execute on DBMS_REDEFINITION to sapsr3;

Grant succeeded.

SQL> exit

sqlplus sapsr3

SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 3 14:43:44 2016

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Enter password:

Last Successful login time: Wed Aug 03 2016 14:35:12 +01:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> start iotc

Package created.

No errors.

Package body created.

No errors.

SQL> exec iotc.convert (10);

Processing the 10 largest tables

Processing table SAPSR3.SCPRSVALS

0:: Error_Stack...

0:: ORA-01031: insufficient privileges

0::

0:: Error_Backtrace...

0:: ORA-06512: at "SYS.DBMS_REDEFINITION", line 180

0:: ORA-06512: at "SYS.DBMS_REDEFINITION", line 3780

0:: ORA-06512: at "SAPSR3.IOTC", line 718

0::

0:: Fatal error - See preceding lines

0:: Error_Stack...

0:: ORA-01031: insufficient privileges

0::

0:: Error_Backtrace...

0:: ORA-06512: at "SAPSR3.IOTC", line 844

0:: ORA-06512: at "SAPSR3.IOTC", line 601

0::

0:: Fatal error - See preceding lines

BEGIN iotc.convert (10); END;

*

ERROR at line 1:

ORA-01031: insufficient privileges

ORA-06512: at "SAPSR3.IOTC", line 619

ORA-06512: at line 1

So I tried again reducing the number

SQL> exec iotc.convert (5);

BEGIN iotc.convert (5); END;

*

ERROR at line 1:

ORA-01031: insufficient privileges

ORA-06512: at "SAPSR3.IOTC", line 619

ORA-06512: at line 1

SQL> quit

Any ideas what's causing this and how I can fix it?

Thanks

Craig