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

ORA-1122 error and huge TEMP tablespace

My Oracle 8.0.5 database runs on Windows NT. After restarting Oracle, suddenly the database failed to open giving an ORA-1122 error. On investigating I noticed that the TEMPORARY tablespace has become huge: 4 gigabytes (generally it is 10 megabytes). It was not allowing me to connect through Internal either. Please suggest what I can do to solve this problem.

The ORA-1122 error message isn't enough for me to give you an answer in full. This message should accompany other error messages as well. But what I can tell you about the ORA-1122 error is that one of your database datafiles could not be verified correctly. Without knowing your specific configuration, I would suggest the following steps to try to get your database up and running:

  1. SVRMGRL
  2. CONNECT INTERNAL
  3. STARTUP MOUNT
  4. RECOVER DATABASE; You should see a message indicating that the database has been recovered.
  5. ALTER DATABASE OPEN;

If the above does not work, you might have to restore your database from a backup. If you are running in ArchiveLog mode, then you can roll forward all changes since the backup. If you are not running ArchiveLog mode, then you will lose any changes since the last backup.

This was last published in December 2004

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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