<!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.7653.38">
<TITLE>ORA-942 with st-mem-spike on RH52 Ora11106 and OLT22</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">I have been testing a Linux cluster with Red Hat 5.2 and Oracle 11.1.0.6 with OLT2.2 and have run into an issue with st-mem-spike test case. Basically, the test fails because it finds ORA- errors in the</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> database</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> ‘trace’ directory.</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri"></FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">Looking at these Oracle errors, I find that all of them are ORA-942 table or view does not exist. </FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">All of the ORA- errors are located in the user trace files while no Oracle errors are located in the alert log. </FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">I turned on sql tracing and was able to determine the query (see below). </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">I did use the</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">install-silent-oracle-11106</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> successfully and completely cleaned up the underlying database prior to executing st-mem-spike test to allow for OLT to rebuild the database. This is a single node configuration at this point in time.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">The view DBA_REGISTRY just has CATALOG and CATPROC, nothing about XD</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">B. Connecting l</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">ocally and through the listener with the DBT user has no logon errors.</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Basically, I am asking if this is a known issue with my combination</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">, i.e. 11.1.0.6,</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"> or if anyone has seen this before.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Thanks</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Robert</FONT></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">[oracle@ipht03 trace]$ cat o2sl1_ora_16993.trc</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Trace file /home/oracle/work/st-mem-spike_Oct20_08-16-03-56/st-mem-spike-dbt2_1_Oct-20-16-03-56-676934000-23115/work/run-dump/diag/r</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">dbms/o2sl1/o2sl1/trace/o2sl1_ora_16993.trc</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">With the Partitioning, OLAP, Data Mining and Real Application Testing options</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">ORACLE_HOME = /opt/oracle/oltest/.srchome/ora-11.1.0.6-X86_64//oradb</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">System name: Linux</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Node name: ipht03.northamerica.cerner.net</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Release: 2.6.18-92.el5</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Version: #1 SMP Tue Apr 29 13:16:15 EDT 2008</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Machine: x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Instance name: o2sl1</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Redo thread mounted by this instance: 1</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Oracle process number: 68</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">Unix process pid: 16993, image:</FONT></SPAN><SPAN LANG="en-us"> </SPAN><A HREF="mailto:oracle@ipht03.northamerica.cerner.net"><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><U><FONT COLOR="#0000FF" SIZE=2 FACE="r_ansi">oracle@ipht03.northamerica.cerner.net</FONT></U></SPAN><SPAN LANG="en-us"></SPAN></A><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi"> (TNS V1-V)</FONT></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">*** 2008-10-20 16:07:47.646</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">*** SESSION ID:(3620.15) 2008-10-20 16:07:47.646</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">*** CLIENT ID:() 2008-10-20 16:07:47.646</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">*** SERVICE NAME:(SYS$USERS) 2008-10-20 16:07:47.646</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">*** MODULE NAME:(</FONT></SPAN><SPAN LANG="en-us"></SPAN><A HREF="mailto:sqlplus@ipht03.northamerica.cerner.net"><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><U><FONT COLOR="#0000FF" SIZE=2 FACE="r_ansi">sqlplus@ipht03.northamerica.cerner.net</FONT></U></SPAN><SPAN LANG="en-us"></SPAN></A><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi"> (TNS V1-V) 2008-10-20 16:07:47.646</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">*** ACTION NAME:() 2008-10-20 16:07:47.646</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi"> </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">=====================</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">PARSING IN CURSOR #1 len=120 dep=1 uid=0 oct=3 lid=0 tim=1224536867646049 hv=3015134136 ad='ad8c6df0' sqlid='0xqtr8ftvfkxs'</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">select extractvalue(value(p), '/user/UID') from xdb.xs$principals p where extractvalue(value(p), '/user/userName') = :1</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">END OF STMT</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">PARSE #1:c=0,e=1090,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1224536867646044</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">=====================</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">PARSE ERROR #1:len=120 dep=1 uid=0 oct=3 lid=0 tim=1224536867646589 err=942</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">select extractvalue(value(p), '/user/UID') from xdb.xs$principals p where extractvalue(value(p), '/user/userName') = :1</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">XS Users and Roles -- OCI Info</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="r_ansi">kzxupnamread error -- 942: ORA-00942: table or view does not exist</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<HR>CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024.<BR>
</BODY>
</HTML>