EM 13.1.0.0.0
Database 12.1.0.2
Ive logged call with support on these, I dont see bugs for the behaviour but they have to be really.
Go to the EM, > performance > SQL > Run SQL.
create table from the EM sql window generates an ora-29701
create table t1 as select * from dba_objects
*
ERROR at line 1:
ORA-29701: unable to connect to Cluster Synchronization Service
truncate table t1 or delete table from the EM window and we get
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 4: '+ASMDISK/oracle_instance/datafile/users.594.868531615'
ORA-15081: failed to submit an I/O operation to a disk
The errors come out in alert log as well.
select works, drop table works; insert into table works. Happens every time.
The statements failing above work from any other client, sqlplus, sql developer. Its just the EM window.
How often would we have to do this? I would have thought never, but sure enough a case came up at the weekend where I could have done with the delete functionality from the window, testing this morning showed me the errors.
Might be helpful for anyone else seeing IO errors in the alert log that they cant explain.