Home » RDBMS Server » Server Administration » ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01092: ORACLE instance terminated. Disconnection forced [message #536407] Tue, 20 December 2011 14:25 Go to next message
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 Go to previous messageGo to next message
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/
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #536459 is a reply to message #536407] Wed, 21 December 2011 01:16 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: DATABASE CREATION
Next Topic: eRROR ora-12560
Goto Forum:
  


Current Time: Fri Mar 29 07:26:28 CDT 2024