Ask the Expert

ORA-01092 error with upgrade

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

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: