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

Subscribe Post Reply

8183

ManjunathRG

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

Reshmi Jacob

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

Reshmi Jacob

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

Reshmi Jacob

Hi

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

Reshmi

May 10 '07 #5

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

Oracle Database

Strange TNSNAMES.ORA problem

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

Oracle Database

union of tnsnames.ora

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

Oracle Database

ORA-00604 ORA-04031 while issuing a DROP USER USER_NAME CASCADE statement

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

Oracle Database

NLS_LANG and language of ORA-[xxxxx]

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

Oracle Database

OO4O: ORA-12154 Error - TNS:could not resolve the connect identifier specified

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

ASP / Active Server Pages

ORA-03113: end-of-file on communication channel

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

Oracle Database

Trigger giving exception ORA-04091

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

Oracle Database

ORA-06531: Reference to uninitialized collection

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

Oracle Database

Tablespace error:ORA-01536

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

Oracle Database

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...

General

Basic concepts of WebLogic Admin training?

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

Oracle Database

https redirect with reverse proxy

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

IIS / Internet Information Server

How to use http requests (Get function) to get variable value?

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

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

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

General

How do I view Redshift db tables in Alteryx

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

General

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

General

FPGA Question

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

General

Join our open community on Discord to learn programming, SEO, and marketing

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

General

ORA-01092: ORACLE instance terminated. Disconnection forced

Similar topics