473,412 Members | 2,027 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

ORA-01092: ORACLE instance terminated. Disconnection forced

Hi

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..........

Regards
Reshmi
May 3 '07 #1
4 8233
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
Hi

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


Thaks again
Reshmi

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
Hi

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
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORACLE\REDO03.LOG
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
Hi

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

Reshmi
May 10 '07 #5

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

Similar topics

1
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 :new.FES_UINS_CODE is null or :new.FES_UIO_CALOCC is...
1
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 fine. However, it will only work if that is the...
6
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
1
by: Brett Baloun | last post by:
Hello, I received this error message when I issue the drop statement. We are using a 9.2.0.3 DB on UNIX OS. I have been able to drop other users within the same session, but this particular...
3
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'; but this only threw an ORA-00922. Or I'm wrong...
8
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 can't get it to work with either - 'Unable to...
2
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 startting up in the mount mode, now when trying to...
2
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 it ORA-06512: at...
0
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 number(6), email varchar2(25)
2
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 days later. After that, I encountered the error...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.