Home » RDBMS Server » Server Administration » ORA-01092: ORACLE instance terminated. Disconnection forced (Oracle DB 10.2.0.1.0 32bit, RHEL 4.6 32bit.)
ORA-01092: ORACLE instance terminated. Disconnection forced [message #448001] Fri, 19 March 2010 00:16 Go to next message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
Hi,

I got this error after i patch to 10.2.0.4.0. Before patch, database running smooth.

I shutdown as usual using shutdown only. I don't know what wrong.

Please assist me.

Thank you.
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #448004 is a reply to message #448001] Fri, 19 March 2010 00:23 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
01092, 00000, "ORACLE instance terminated. Disconnection forced"
// *Cause:  The instance this process was connected to was terminated
//	    abnormally, probably via a shutdown abort. This process
//	    was forced to disconnect from the instance.
// *Action: Examine the alert log for more details. When the instance has been 
//          restarted, retry action.


STARTUP UPGRADE?

[Updated on: Fri, 19 March 2010 00:24]

Report message to a moderator

Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #448020 is a reply to message #448001] Fri, 19 March 2010 02:14 Go to previous messageGo to next message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
I use startup upgrade and i can start database. I use shutdown and start again with startup i got same error.

Is it i need to use startup upgrade after this?

Thank you.
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #448033 is a reply to message #448020] Fri, 19 March 2010 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 63812
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Examine the alert log for more details.

Regards
Michel
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #448037 is a reply to message #448001] Fri, 19 March 2010 02:48 Go to previous messageGo to next message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
Solution:
SQL> startup
ORACLE instance started.

Total System Global Area 123456789 bytes
Fixed Size 123456 bytes
Variable Size 9283748 bytes
Database Buffers 88888888 bytes
Redo Buffers 777777 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced.

Solution:

1. Run startup upgrade:

SQL> startup upgrade
ORACLE instance started.
...
...
Database mounted.
Database opened.

2. Run a script (ORACLE_HOME)/rdbms/admin/catupgrd.sql

[Updated on: Fri, 19 March 2010 03:11] by Moderator

Report message to a moderator

Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #448521 is a reply to message #448001] Tue, 23 March 2010 23:36 Go to previous messageGo to next message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
After a few hours, i got same error again. I don't know what is wrong.

SQL> startup
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  1271616 bytes
Variable Size             448792768 bytes
Database Buffers          620756992 bytes
Redo Buffers                2920448 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


Please assist me.

[Updated on: Tue, 23 March 2010 23:37]

Report message to a moderator

Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #448529 is a reply to message #448521] Wed, 24 March 2010 00:20 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

what clues exist within alert_SID.log
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #448533 is a reply to message #448521] Wed, 24 March 2010 00:38 Go to previous messageGo to next message
Michel Cadot
Messages: 63812
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 19 March 2010 02:35
Quote:
Examine the alert log for more details.

Regards
Michel

Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #448710 is a reply to message #448001] Wed, 24 March 2010 23:19 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
mzainal wrote on Fri, 19 March 2010 00:16
Hi,

I got this error after i patch to 10.2.0.4.0. Before patch, database running smooth.

I shutdown as usual using shutdown only. I don't know what wrong.

Please assist me.

Thank you.



Which patch ?
Previous Topic: Open ref Cursor
Next Topic: oracle in not available
Goto Forum:
  


Current Time: Fri Sep 30 05:30:17 CDT 2016

Total time taken to generate the page: 0.16044 seconds