Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-29740: evicted by member , group incarnation

882931Aug 31 2011 — edited Aug 31 2011
Hi again ,Oracle RAC 9i problem has not been solved. This is the trace file.

ump file c:\oracle\admin\recp9\bdump\recp91_lck0_4080.trc
Wed Aug 31 05:30:45 2011
ORACLE V9.2.0.5.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Instance name: recp91

Redo thread mounted by this instance: 1

Oracle process number: 20

Windows thread id: 4080, image: ORACLE.EXE


*** 2011-08-31 05:30:45.235
*** SESSION ID:(20.1) 2011-08-31 05:30:45.235
error 29740 detected in background process
ORA-29740: evicted by member , group incarnation


From the Alert Log File
ed Aug 31 05:30:44 2011
Errors in file c:\oracle\admin\recp9\bdump\recp91_lms1_3648.trc:
ORA-29740: evicted by member , group incarnation

Wed Aug 31 05:30:45 2011
Errors in file c:\oracle\admin\recp9\bdump\recp91_lck0_4080.trc:
ORA-29740: evicted by member , group incarnation

Instance terminated by LMON, pid = 3624
Dump file c:\oracle\admin\recp9\bdump\alert_recp91.log
Wed Aug 31 09:32:02 2011
ORACLE V9.2.0.5.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed Aug 31 09:32:02 2011
Starting ORACLE instance (normal)
Wed Aug 31 09:32:02 2011
Global Enqueue Service Resources = 4086, pool = 1
Wed Aug 31 09:32:02 2011
Global Enqueue Service Enqueues = 5947
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
GES IPC: Receivers 3 Senders 3
GES IPC: Buffers Receive 1000 Send 530 Reserve 300
GES IPC: Msg Size Regular 420 Batch 2048
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 478150656
sga_max_size = 1553017760
large_pool_size = 109051904
java_pool_size = 25165824
spfile = o:\oradata\recp9\spfilerecp9.ora
resource_manager_plan =
control_files = o:\oradata\recp9\CONTROL01.CTL, o:\oradata\recp9\CONTROL02.CTL, o:\oradata\recp9\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 813694976
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = location=o:\oradata\recp9\archive
log_archive_format = arch_%t_%s.arc
db_file_multiblock_read_count= 16
cluster_database = TRUE
cluster_database_instances= 2
thread = 1
fast_start_mttr_target = 300
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
audit_sys_operations = TRUE
db_domain = cashdesk.casino
instance_name = recp91
dispatchers = (PROTOCOL=TCP) (SERVICE=recp9XDB)
local_listener = LISTENER_RECP91
remote_listener = LISTENERS_RECP9
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = c:\Oracle\admin\recp9\bdump
user_dump_dest = c:\Oracle\admin\recp9\udump
core_dump_dest = c:\Oracle\admin\recp9\cdump
audit_trail = DB
sort_area_size = 524288
db_name = recp9
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 200000000
aq_tm_processes = 1
Wed Aug 31 09:32:02 2011
cluster interconnect IPC version:Oracle 9i Winsock2 TCP/IP IPC
IPC Vendor 0 proto 0 Version 0.0
PMON started with pid=2
DIAG started with pid=3
LMON started with pid=4
LMD0 started with pid=5
LMS0 started with pid=6
LMS1 started with pid=7
DBW0 started with pid=8
LGWR started with pid=9
CKPT started with pid=10
SMON started with pid=11
RECO started with pid=12
CJQ0 started with pid=13
QMN0 started with pid=14
Wed Aug 31 09:32:08 2011
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=17
ARC0: Archival started
ARC1 started with pid=18
ARC1: Archival started
Wed Aug 31 09:32:09 2011
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Aug 31 09:32:09 2011
ARC0: Thread not mounted
Wed Aug 31 09:32:09 2011
ARC1: Thread not mounted
Wed Aug 31 09:32:09 2011
alter database mount exclusive
Wed Aug 31 09:32:09 2011
ORA-32700 signalled during: alter database mount exclusive...
Wed Aug 31 09:35:14 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 09:40:27 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 09:45:40 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 09:50:53 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 09:56:05 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 10:01:18 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 10:06:28 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 10:11:41 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 10:16:53 2011
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Aug 31 10:22:06 2011
Restarting dead background process QMN0
QMN0 started with pid=14

I haven't found anything in the internet. 2 possible causes the backup we take this time ,and something with ntp and time sychronization.
Any help sould be appreciated.
Even if i restart the services of the oracle instance the instance doesn't start.
The only solution is to restart the node.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 28 2011
Added on Aug 31 2011
3 comments
1,726 views