Hi,
When i try to start a database, system throws the ORA-00604 error but still it opens the database and iam able to work on that database only for few minutes , after that the iam getting the following message
ORA-12500: TNS:listener failed to start a dedicated server process
and when i checked the alert log and trace file, it shows ORA-00604 error.
Find below the contents of alert log and the trace file.
Server process
System parameters with non-default values:
processes = 59
shared_pool_size = 262144000
large_pool_size = 614400
control_files = e:\ORANEW\oradata\FCIS45\c
ontrol01.c
tl, e:\ORANEW\oradata\FCIS45\c
ontrol02.c
tl, e:\ORANEW\oradata\FCIS45\c
ontrol03.c
tl
db_block_buffers = 25600
db_block_size = 8192
compatible = 8.1.0
log_buffer = 10485760
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_co
unt= 8
rollback_segments = RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6
max_enabled_roles = 30
remote_login_passwordfile=
EXCLUSIVE
global_names = FALSE
distributed_transactions = 10
instance_name = FCIS45
service_names = FCIS45
open_links = 4
sort_area_size = 1048576
sort_area_retained_size = 65536
db_name = FCIS45
open_cursors = 100
os_authent_prefix =
optimizer_mode = RULE
job_queue_processes = 4
job_queue_interval = 60
parallel_max_servers = 5
background_dump_dest = e:\ORANEW\admin\FCIS45\bdu
mp
user_dump_dest = e:\ORANEW\admin\FCIS45\udu
mp
max_dump_file_size = 10240
oracle_trace_collection_na
me=
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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Wed Oct 13 12:19:51 2004
alter database mount
Wed Oct 13 12:19:58 2004
Successful mount of redo thread 1, with mount id 418530990.
Wed Oct 13 12:19:58 2004
Database mounted in Exclusive Mode.
Completed: alter database mount
Wed Oct 13 12:39:13 2004
alter database open
Wed Oct 13 12:39:13 2004
ORA-1113 signalled during: alter database open...
Wed Oct 13 12:45:53 2004
alter database open
Wed Oct 13 12:45:53 2004
ORA-1113 signalled during: alter database open...
Wed Oct 13 12:47:06 2004
ALTER DATABASE RECOVER datafile 'E:\ORANEW\ORADATA\FCIS45\
FCIS1.ORA'
Wed Oct 13 12:47:06 2004
Media Recovery Datafile: 'E:\ORANEW\ORADATA\FCIS45\
FCIS1.ORA'
Media Recovery Start
WARNING! Recovering data file 8 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 1 Seq 159616 Reading mem 0
Mem# 0 errs 0: E:\ORANEW\ORADATA\FCIS45\R
EDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 159617 Reading mem 0
Mem# 0 errs 0: E:\ORANEW\ORADATA\FCIS45\R
EDO02.LOG
Media Recovery Complete
Completed: ALTER DATABASE RECOVER datafile 'E:\ORANEW\ORADA
Wed Oct 13 12:47:12 2004
alter database open
Beginning crash recovery of 1 threads
Wed Oct 13 12:47:13 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 159616 Reading mem 0
Mem# 0 errs 0: E:\ORANEW\ORADATA\FCIS45\R
EDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 159617 Reading mem 0
Mem# 0 errs 0: E:\ORANEW\ORADATA\FCIS45\R
EDO02.LOG
Wed Oct 13 12:47:13 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 48 data blocks read, 14 data blocks written, 2209 redo blocks read
Crash recovery completed successfully
Wed Oct 13 12:47:15 2004
Thread 1 advanced to log sequence 159618
Thread 1 opened at log sequence 159618
Current log# 3 seq# 159618 mem# 0: E:\ORANEW\ORADATA\FCIS45\R
EDO01.LOG
Successful open of redo thread 1.
Wed Oct 13 12:47:15 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Oct 13 12:47:21 2004
Errors in file e:\ORANEW\admin\FCIS45\udu
mp\ORA0021
9.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin declare end exception exit for goto if loop mod null
pragma raise return select update while <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall
<a single-quoted SQL string>
Wed Oct 13 12:47:21 2004
Completed: alter database open
ORA00219.TRC Contents :
Dump file e:\ORANEW\admin\FCIS45\udu
mp\ORA0021
9.TRC
Wed Oct 13 12:47:21 2004
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 6, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows NT Version 4.0 Service Pack 6, CPU type 586
Instance name: fcis45
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 219, image: ORACLE.EXE
*** SESSION ID:(11.7) 2004-10-13 12:47:21.592
Error in executing triggers on database startup
*** 2004-10-13 12:47:21.655
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin declare end exception exit for goto if loop mod null
pragma raise return select update while <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall
<a single-quoted SQL string>
Pls. let me know how to resolve this issue.
Thanks in advance
Gomathy