All thst is fine and the scripts worked perfectly prior to last night... In fact the scripts work fine... it is just that they are reported as failed in OTM.
I found an entry in the wls_oats.log.2013-10-23 log advising that the Internal Exception: java.sql.SQLException: ORA-12952: The request exceeds the maximum allowed database size of 4 GB.
Searched for a file of this kind of size and found USERS.DBF which has reached 4GB... looking back... this file has grown overtime.
What does this file store and more importantly; how do I increase or purge it ?