on 08-03-2016 4:08 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.