ORA-01092 error with upgrade
I am a junior database administrator. I am trying to upgrade from Oracle 8.1.7 to 184.108.40.206. 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
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