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 first published in January 2007

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close