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
Join the conversationComment
Share
Comments
Results
Contribute to the conversation