Oracle Database Discussions

I am unable to open the database due to error :-- ORA-01092: ORACLE instance terminated. Disconnection forced.

Let me tell what I was trying to do - I created a DB manually on Fedora core -3 OS / Oracle 10g
successfully opened it for the first time.

executed catalog.sql [it was succesful]
executed catproc.sql [not successful] and my session got disconnected

tried again but the DB did not open

I encountered a error which was due to missing catproc.sql deployment. To deploy this catproc.sql I am unable as the DB is not opening.

After debugging I resized the SGA_max size and set SGA_target =0 to make it automatic

then catproc execution failed. The snapshsot from SQLPLUS screen and alert log are below.

********************************sqlplus ************************************
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL> shu immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> disconn
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> disconn
SQL> exit
[oracle@localhost u01]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 3 21:04:10 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1223540 bytes
Variable Size 1019217036 bytes
Database Buffers 50331648 bytes
Redo Buffers 2969600 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL> startup nomount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> shu immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> sho user
USER is "SYS"
SQL> conn
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> shu immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1223540 bytes
Variable Size 1019217036 bytes
Database Buffers 50331648 bytes
Redo Buffers 2969600 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

************************************* ALERT LOG ***************************************
Tue Nov 3 21:00:24 2009
Errors in file /u01/app/oracle/IDXTRY/ADMIN/udump/idxtry_ora_5047.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Tue Nov 3 21:00:24 2009
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 5047
ORA-1092 signalled during: alter database open...

Regards,
CNS