cancel
Showing results for 
Search instead for 
Did you mean: 

iotc.convert ORA-01031: insufficient privileges

former_member204618
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member204618
Active Contributor
0 Kudos

UPDATE

If I specify offline with "exec iotc.convert (10,2,false);" it completes with no issues.

So what is it about the online bit that causes it to fail?

Thanks

Craig

UPDATE 2

I re-applied the sapdba_role.sql and updated sapuprof_profile.sql role from http://service.sap.com/sap/support/notes/1519872 and now it appears to be working but I get another error.  Perhaps I should post that separately.

Answers (1)

Answers (1)

former_member204618
Active Contributor
0 Kudos

OK I have just tried this again in our UAT environment and exactly the problem.

I've also tried this on an 11g installation and get this error which is different.


SQL> exec iotc.convert (10);

Processing the 10 largest tables

Processing table SAPSR3.DSWPBI_SERVER

0:: Error_Stack...

0:: ORA-29283: invalid file operation

0:: ORA-06512: at "SYS.UTL_FILE", line 536

0:: ORA-29283: invalid file operation

0::

0:: Error_Backtrace...

0:: ORA-06512: at "SYS.UTL_FILE", line 536

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

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

0::

0:: Fatal error - See preceding lines

0:: Error_Stack...

0:: ORA-29283: invalid file operation

0:: ORA-06512: at "SYS.UTL_FILE", line 536

0:: ORA-29283: invalid file operation

0::

0:: Error_Backtrace...

0:: ORA-06512: at "SYS.UTL_FILE", line 536

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-29283: invalid file operation

ORA-06512: at "SYS.UTL_FILE", line 536

ORA-29283: invalid file operation

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

ORA-06512: at line 1

Seems to me that there is a few bugs in the package.

UPDATE,

Seems if I change the directory "~IOT_DIR" to C:\Windows\TEMP it worked.  Well on this Windows Server running 11g anyway.