Q
Problem solve Get help with specific problems with your technologies, process and projects.

Unable to open 8.0 database on Windows

I run Oracle 8.0 on Windows 98 for my pharmacy software. The system has been hanging a couple of times. Now when I start Oracle prior to running my application it shows the database instance started, then mounted, but stops with this error: "ORA-1122: Cannot open database."

I run Oracle 8.0 on Windows 98 for my pharmacy software. The system has been hanging a couple of times before Oracle ceased to start up. Now when I start Oracle prior to running my application it shows the database instance started, then mounted, but stops with this error: "ORA-1122: Cannot open database." I scanned the database directory files but do not seem to have a problem with the files.

What can be done when I have all the datafiles with me, but still can't get Oracle to start? Is creating a new control file a solution to get my database working? Please advise. (The previous backup dmp file that I have is very old -- about two months old.)

The ORA-1122 error is not enough to figure out the cause of your problem. Are there other error messages?

I would try to start the database again. Then look in your Alert Log located in the directory specified by your BACKGROUND_DUMP_DEST parameter. This should give more details as to why your database could not start. It might even point to a trace file which can give further information.

Once you have more information, feel free to post to this forum again.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close