Users unable to save Changes to the database
A little bit of pre-info:
I'm fairly new to managing a site with an Oracle DB and might be missing some obvious stuff here and there. Awoke this morning with msg from customer stating that no one could access their Oracle DB. Note: this DB has been working fine as of Friday @ 1PM when the business closed for the holiday.
Upon arrival this morning the Forms program was returing errors ORA-12519 and 12516. Attempting to log into EM gave the following:
"The database status is currently unavailable. It is possible that the
database is in mount or nomount state. Click 'Startup' to obtain the current
status and open the database. If the database cannot be opened, click 'Perform
Recovery' to perform an appropriate recovery operation."
Worked through with Oracle and was able to resolve the issue and users could connect to the Database again.
Short time later attempted to connect to EM and noted that is was not active and was returning nothing when attempting to login. Started EM on the server and recieved the same message as above. Then the users were not able to access the database again as well. =(
Corrected issue again so that users could connect and then was informed that they could not save data.
Created a test table called "blargh" and input some data into it. Able to read the data back from the local station. Committed it to the database and tried from another workstation... could not find the table "blargh" nor display and of the data that was put in it. Attempting to drop the table from the any station results in the following:
SQL> drop table blargh;
drop table blargh
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: 'F:\ORACLE\ORADATA\TRPB\SYSAUX01.DBF'
ORA-06512: at line 16
Currently have a TAR open with Oracle, but I'm just curious on any pointers of where I could start looking regarding this problem while I wait for them to get back to me.
-Scott