Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-29702, how to resolve?

Status
Not open for further replies.

nekocat

MIS
Sep 26, 2002
10
HK
My environment:
RDBMS Version: 8.1.7.4
Operating System and Version: Tru64 4.0F

In my OPS environment (two nodes), the error ORA-29702 will often prompt. It will be triggered when doing import, export, simple sql statement like insert, update, create package, create trigger, etc.

Everytime this error is encountered, an trace file will be logged. Following is a sample:

/oracle/admin/abcde/udump/ora_12425.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning and Parallel Server options
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /oracle/product/8.1.7
System name: OSF1
Node name: abc
Release: V4.0
Version: 1229
Machine: alpha
Instance name: def
Redo thread mounted by this instance: 1
Oracle process number: 26
Unix process pid: 12425, image: oracle@abc (TNS V1-V3)

*** SESSION ID:(31.426) 2002-10-23 19:29:35.167
kjfmsgr: the master member (1) does not exist

The process id 12425 is actually the child process forked by sqlplus session creating this error.

What can I do to resolve this?

Thanks.
nekocat
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top