Cannot fetch a datasource connection.
The process domain was unable to establish a connection with the datasource with the connection URL "jdbc/BPELServerDataSourceWorkflow". The exception reported is: ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM
When we tried to login to the dehydration store database using the standard user orabpel we got the same error. We then asked the DBA to clean the SYS.AUD$ table that fixed the issue for us. Verified the tablespace and found that it came down by 30% in this case. So was wondering how to manage these tables so that we have uninterrupted running of our SOA Suite server when I tumbled on this blog post Why is my SYSTEM Tablespace so Big?
No comments:
Post a Comment