Database Recovery
860123May 24 2011 — edited Jun 24 2011I wasn't sure where I should post this so I'm putting it here. I just started a new job and came into an existing mess. Here is the situation, the database server crashed (Oracle 10.2.0.4) and when it was restored, they just attached the old datafiles. They were stored on some attached storage so they were fine. However, now I'm getting all kinds of weird issues with my database and I'm not sure what I need to do to fix them.
Here are the issues:
SQL> SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
COUNT(*)
----------
502
Most of them are due to the fact that Apex was installed previously and isn't now. When I try to compile some of the different objects using any of the compile methods that I know of I get this error:
SQL> exec dbms_utility.compile_schema('SCHEMANAME');
BEGIN dbms_utility.compile_schema('SCHEMANAME'); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [skkxerrp], [skkxdllload],
[SlfFopen],
[u01/app/oracle/product/10.2.0/db/native/d63/STANDARD__SYS__S__887.so], [No
such file or directory], [], [], []
I also get this error when I try to install Apex.
I am also unable to connect with SQL Developer as sysdba, it says invalid username/password. Everything is good with the TNS names and permissions as far as I can tell. I can connect as a normal user with no problems. I can connect using sqlplus while logged into the server as sysdba no problem, so I'm a bit confused about this one.
Any help or suggestions you can give would be highly appreciated!
GlenR