Formerly-working Oracle installation no longer functions
Greetings Oracle experts,
I'm running Oracle 9iR2 on a Solaris 8 SPARC workstation. After completing nearly all of the installation, I had some problems and was consulted by a knowledgeable Oracle admin who was able to get the database up and running.
Unfortunately, after a power outage and subsequent reboot of the machine, things don't quite seem to work anymore. I can manually start the TNS listener server and use 'tnsping' to verify that it's working -- so that's fine I think. I can use the 'oemapp console' tool to access the database entry and login -- so all that's still fine. But when I try to expand the Schema section under the database that I'd like to access/manipulate, I get an "Oracle not available" error. I've also tried using 'sqlplus', and that can connect to an idle instance, but beyond that I simply get shared memory/realm errors.
I've searched various forums/newsgroups, and all solutions that seem to be related to the problem I'm having don't seem to work. I verified that my ORACLE_SID environment variable (and all other important environment variables) are set-up properly. My 'oracle' user account and 'dba' group seem to be functioning properly.
Has the power outage somehow ruined my table data, or is the problem stemming from something else?
Thank you in advance for any insight you can lend!