472,353 Members | 1,353 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

ORA-01092: ORACLE instance terminated. Disconnection forced


I am facing this error while working with a database, about 40-50 persons are using this DB.

I searched thru the sites to refer these error. They are saying t look into ALERT.LOG. I searched the entire server but couldn't find ALERT.LOG. Can any body help in finding this file???

Also, why this happens??? In the server, I have One database, 2 Users, 1 Listener, 1 Service Name.

Anybody Help..........

May 3 '07 #1
4 8183
Hi Reshma
you can find the alert file in oracle\admin\yourdatabasename\bdump

reason:i am not sure.. some problem with memory allocation i guess. :)
May 7 '07 #2

Thanks, i was seaching for Alert.LOG !!!

Thaks again

Hi Reshma
you can find the alert file in oracle\admin\yourdatabasename\bdump

reason:i am not sure.. some problem with memory allocation i guess. :)
May 8 '07 #3

In the ALERT LOG I found...

Sat May 05 11:15:42 2007
alter database open
Beginning crash recovery of 1 threads
Sat May 05 11:15:43 2007
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 30112 Reading mem 0
Sat May 05 11:15:43 2007
Thread recovery: finish rolling forward thread 1
Thread recovery: 7 data blocks read, 4 data blocks written, 7 redo blocks read
Crash recovery completed successfully
Sat May 05 11:15:43 2007
Thread 1 advanced to log sequence 30113
Thread 1 opened at log sequence 30113
Current log# 2 seq# 30113 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO02.LOG
Successful open of redo thread 1.
Sat May 05 11:15:44 2007
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat May 05 11:15:51 2007
Completed: alter database open
Sat May 05 11:20:53 2007
Thread 1 advanced to log sequence 30114
Current log# 3 seq# 30114 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO01.LOG
Sat May 05 11:23:08 2007
Thread 1 advanced to log sequence 30115
Current log# 1 seq# 30115 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO03.LOG
Sat May 05 11:25:23 2007
Thread 1 advanced to log sequence 30116
Current log# 2 seq# 30116 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO02.LOG

What may be the problem with my Database????
May 8 '07 #4

Is this the corruption of REDO log file. How can I rectify it

May 10 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Galina | last post by:
Hello I have created a trigger not to let records with certain fields null to be inserted into the table: BEGIN IF :new.RUL_CODE is null or...
by: Adam Ruth | last post by:
I'm using OCI on Mac OS X and I've run into a strange problem with my TNSNAMES.ORA file. My TNSNAMES.ORA file has one entry INV4II and it works...
by: bdj | last post by:
Hello! I have at set of tnsnames.ora. I wich to make an union, e.g. a single file of it. How can I do that easy? Greetings Bjørn
by: Brett Baloun | last post by:
Hello, I received this error message when I issue the drop statement. We are using a DB on UNIX OS. I have been able to drop other...
by: Michael John | last post by:
Hey, how can I get ORA-..... error messages in languages other than english. I did a alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1';...
by: CJM | last post by:
I have a working web application (ASP) which links to an Oracle 10g DB via OO4O. I'm trying to port it to either of two test servers, but in fact, I...
by: shweta9833 | last post by:
Hi, I did a shutdown normal, ran an OS command to copy a data file into a new drectory, ran a ALTER DATABASE command to relocate a data file by...
by: hemantmudaliar | last post by:
The Trigger is giving following exception java.sql.SQLException: ORA-04091: table PSCONTENT.VGNASCHANNEL is mutating, trigger/function may not see...
by: ravishankars | last post by:
Hi, I have made the following declarations I created an object as below. create or replace type emp_obj as object( emp_id ...
by: amoldiego | last post by:
Hi I have encountered the error ORA-01536 . I have earlier grant sysdba to SCOTT & then I revoked the sysdba role from SCOTT a couple of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.