Trace analyzer in RAC

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

Trace analyzer in RAC

Trace analyzer in RAC

2005-08-25 - By Hameed, Amir

Does anyone know how Oracle's trace analyzer should be configured in
RAC. It works fine in single instance but spits out the following
message when I try to run it in a RAC instance.

exec trca$i.trace_analyzer('racvt1n2_ora_7276.trc');
BEGIN trca$i.trace_analyzer('racvt1n2_ora_7276.trc'); END;

*
ERROR at line 1:
ORA-00001 (See ORA-00001.ora-code.com): unique constraint (TRCANLZR.TRCA$_STAT_PK) violated
ORA-06512 (See ORA-06512.ora-code.com): at "TRCANLZR.TRCA$D", line 642
ORA-06512 (See ORA-06512.ora-code.com): at "TRCANLZR.TRCA$D", line 1046
ORA-06512 (See ORA-06512.ora-code.com): at "TRCANLZR.TRCA$I", line 438
ORA-06512 (See ORA-06512.ora-code.com): at "TRCANLZR.TRCA$I", line 499
ORA-06512 (See ORA-06512.ora-code.com): at line 1

I have tried to completely de-install and then re-installed it but have
not had any luck. and Any help will be appreciated.
Thanks
Amir

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7232.39">
<TITLE>Trace analyzer in RAC</TITLE>
</HEAD>
<BODY>


Does anyone know how Oracle's trace
analyzer should be configured in RAC. It works fine in single instance but
spits out the following message when I try to run it in a RAC instance.

exec trca$i.trace_analyzer('racvt1n2_ora
_7276.trc');

 BEGIN trca$i.trace_analyzer('racvt1n2_ora
_7276.trc'); END;


*

 ERROR at line 1:

 ORA-00001 (See ORA-00001.ora-code.com): unique constraint (TRCANLZR.TRCA
$_STAT_PK) violated

 ORA-06512 (See ORA-06512.ora-code.com): at "TRCANLZR.TRCA$D",
line 642

 ORA-06512 (See ORA-06512.ora-code.com): at "TRCANLZR.TRCA$D",
line 1046

 ORA-06512 (See ORA-06512.ora-code.com): at "TRCANLZR.TRCA$I",
line 438

 ORA-06512 (See ORA-06512.ora-code.com): at "TRCANLZR.TRCA$I",
line 499

 ORA-06512 (See ORA-06512.ora-code.com): at line 1


I have tried to completely de-install and
then re-installed it but have not had any luck. and Any help will be
appreciated.

Thanks

 Amir


</BODY>
</HTML>