OraFAQ Forum: Server Administration » ORA-01092: ORACLE instance terminated. Disconnection forced

Home » RDBMS Server » Server Administration » ORA-01092: ORACLE instance terminated. Disconnection forced

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01092: ORACLE instance terminated. Disconnection forced [message #536407]

Tue, 20 December 2011 14:25

basabendra
Messages: 1
Registered: December 2011
Location: Mumbai

Junior Member

I am still getting the erros. Kindly help.

C:\>set oracle_sid = sidname
C:\>set oracle_sid oracle_sid = sidname
C:\>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 21 01:49:06 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: sys/sys as sysdba Connected to an idle instance. SQL> startup ORACLE instance started.
Total System Global Area 1653518336
bytes Fixed Size 2176288 bytes
Variable Size 989858528 bytes
Database Buffers 654311424 bytes
Redo Buffers 7172096 bytes
Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist Process ID: 5372 Session ID: 5 Serial number: 3 SQL>

[Updated on: Tue, 20 December 2011 14:27]

Report message to a moderator

Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #536409 is a reply to message #536407]

Tue, 20 December 2011 14:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I am still getting the erros
When did Oracle last work without error?
What changed since then?

What clues exist with alert_SID.log file?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #536459 is a reply to message #536407]

Wed, 21 December 2011 01:16

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Previous Topic:	DATABASE CREATION
Next Topic:	eRROR ora-12560

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 18:50:11 CST 2025