The real error is:
ORA-12801: error signaled in parallel query server P000 ORA-01115: IO error reading block from file (block # )
ORA-01115: IO error reading block from file 2 (block # 215616)
ORA-27072: File I/O error
Additional information: 4
Additional information: 215616
Additional information: 212992
The "solutions" you tried make no sense when you ...
There is built-in type called SYS.ODCINUMBERLIST which is a VARRAY(32767) of NUMBER, and EXECUTE privilege is granted on it to everyone (PUBLIC). You can use that for up to 32767 numbers, example:
with function f1 (p_numbers SYS.ODCINUMBERLIST) return number
select f1(SYS.ODCINUMBERLIST(1,2,3,4,5,6,7)) from dual;
SQL> with cte_test
3 (select * from emp);
(select * from emp)
ERROR at line 3:
ORA-00928: missing SELECT keyword
SQL> select cte_test as (select * from emp)
2 select * from cte;
select cte_test as (select * from emp)
ERROR at line 1:
ORA-00923: FROM ...
This is only a matter of the metadata being incomplete in the installer.
If you have access to Oracle support, then:
Reference data is not available for release "12.1" on Linux x86-64 SLES-12 (Doc ID 2127760.1)
In the above note, there is a link for the patch for this issue.
The workaround is to ignore the prerequisites by starting the installer as: