Home » RDBMS Server » Server Administration » ORA-1115
ORA-1115 [message #193966] Wed, 20 September 2006 03:03 Go to next message
vivekarnie
Messages: 1
Registered: September 2006
Location: Mumbai
Junior Member

I m getting this error ORA-1115 in Alert Log while i m opening the database. Any Urgent help will be appreciated.


Dump file c:\oracle\admin\itoll\bdump\alert_itoll.log
Wed Sep 20 09:09:48 2006
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 1, CPU type 586
Wed Sep 20 09:09:48 2006
Starting ORACLE instance (normal)
Wed Sep 20 09:09:48 2006
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 33554432
large_pool_size = 12582912
java_pool_size = 33554432
control_files = c:\oracle\oradata\iToll\CONTROL01.CTL, c:\oracle\oradata\iToll\CONTROL02.CTL, c:\oracle\oradata\iToll\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 46137344
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = c:\oracle\oradata\iToll\
log_archive_format = arch_iToll_%S.arc
db_file_multiblock_read_count= 16
fast_start_mttr_target = 0
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain = world
instance_name = iToll
dispatchers = (PROTOCOL=TCP) (SERVICE=iTollXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = c:\oracle\admin\iToll\bdump
user_dump_dest = c:\oracle\admin\iToll\udump
core_dump_dest = c:\oracle\admin\iToll\cdump
sort_area_size = 524288
db_name = iToll
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 19922944
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Sep 20 09:09:50 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
ARC1 started with pid=13
ARC1: Archival started
Wed Sep 20 09:09:52 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Oracle Data Guard is not available in this edition of Oracle.
Wed Sep 20 09:09:52 2006
ARC0: Thread not mounted
Wed Sep 20 09:09:52 2006
alter database mount exclusive
Wed Sep 20 09:09:53 2006
ARC1: Thread not mounted
Wed Sep 20 09:09:59 2006
Successful mount of redo thread 1, with mount id 3145902947.
Wed Sep 20 09:09:59 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Sep 20 09:09:59 2006
alter database open
Wed Sep 20 09:09:59 2006
Beginning crash recovery of 1 threads
Wed Sep 20 09:09:59 2006
Started recovery at
Thread 1: logseq 1842, block 12435, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1842 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\ORADATA\ITOLL\REDO03.LOG
Mem# 1 errs 0: C:\ORACLE\ORADATA\ITOLL\REDO06.LOG
ORA-1115 signalled during: alter database open[/B]...
Wed Sep 20 09:10:52 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Sep 20 09:16:04 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Sep 20 09:21:13 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Sep 20 09:26:28 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Sep 20 09:31:38 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Sep 20 09:36:50 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Sep 20 09:42:00 2006
Restarting dead background process QMN0
QMN0 started with pid=9

Arnie!!
Re: ORA-1115 [message #193974 is a reply to message #193966] Wed, 20 September 2006 04:04 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, it's an I/O Error.

There should be an additional tracefile which mentions the datafile and the block where the error happened. Possibly with an OS Error message that states the cause, too.

I would guess either the hard drive has a problem or there is some corruption in the datafiles.
Previous Topic: How to find IP address of system using SQLPLUs
Next Topic: How to estimate EXTENT size
Goto Forum:
  


Current Time: Fri Dec 09 05:49:38 CST 2016

Total time taken to generate the page: 0.05610 seconds