Q

ORA-01092 error with upgrade

I am trying to upgrade from Oracle 8.1.7 to 9.2.0.6. I changed the dump file destinations in the init file and set the env variables accordingly. When I did startup pfile = '../init.ora' I got the "ORA-01092" error.

I am a junior database administrator. I am trying to upgrade from Oracle 8.1.7 to 9.2.0.6. The newer version has already been installed and had patches applied to it. I am just trying to upgrade the database. I changed the dump file destinations in the init file and set the env variables accordingly. When I did startup pfile = '../init.ora' I got this "ORA-01092" error:
ORACLE instance started.

Total System Global Area 526353976 bytes 
Fixed Size 730680 bytes 
Variable Size 218103808 bytes 
Database Buffers 307200000 bytes 
Redo Buffers 319488 bytes 
Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced
Unfortunately, the ORA-1092 error does not tell you why the instance was terminated. You will have to look in your Alert Log for more information. The Alert Log is found in the directory denoted by your BACKGROUND_DUMP_DEST parameter. In that same directory, look for any trace files generated at the same time the instance was terminated. These may shed some light as to the root cause of your problem. There are too many things that could go wrong to guess what the real problem is.
This was last published in January 2007

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close