Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Recovery

860123May 24 2011 — edited Jun 24 2011
I 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
This post has been answered by 848395 on Jun 1 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2011
Added on May 24 2011
48 comments
3,502 views