<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi, <br>
If you are referring to the below error in the <span lang="en-us"><font
face="Calibri">st-mem-spike OLT test with oracle db version 11.1.0.6
, </font></span><br>
kzxupnamread error -- 942: ORA-00942: table or view does not exist <br>
Then its known issue with 11.1.0.6 & these OCI errors are fixed
in 11.2 .<br>
<br>
Thanks,<br>
Sriharsha<br>
<br>
<span lang="en-us"></span>Hayden,Robert wrote:
<blockquote
cite="midEB5E260392FCD1408A29EEFC9767E4A2017A4A24@EMAIL03.cerner.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<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>
<!-- 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"> </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 face="r_ansi" size="2">[oracle@ipht03 trace]$ cat
o2sl1_ora_16993.trc</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">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 face="r_ansi" size="2">dbms/o2sl1/o2sl1/trace/o2sl1_ora_16993.trc</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">Oracle
Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">With the
Partitioning, OLAP, Data Mining and Real Application Testing options</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">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 face="r_ansi" size="2">System
name: Linux</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">Node
name: ipht03.northamerica.cerner.net</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">Release:
2.6.18-92.el5</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">Version:
#1 SMP Tue Apr 29 13:16:15 EDT 2008</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">Machine:
x86_64</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">Instance
name: o2sl1</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">Redo
thread mounted by this instance: 1</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">Oracle
process number: 68</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">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"
face="r_ansi" size="2">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 face="r_ansi" size="2"> (TNS V1-V)</font></span></p>
<br>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">***
2008-10-20 16:07:47.646</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">***
SESSION ID:(3620.15) 2008-10-20 16:07:47.646</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">***
CLIENT ID:() 2008-10-20 16:07:47.646</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">***
SERVICE NAME:(SYS$USERS) 2008-10-20 16:07:47.646</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">***
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"
face="r_ansi" size="2">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 face="r_ansi" size="2"> (TNS V1-V) 2008-10-20
16:07:47.646</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">***
ACTION NAME:() 2008-10-20 16:07:47.646</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2"> </font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">=====================</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">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 face="r_ansi" size="2">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 face="r_ansi" size="2">END OF
STMT</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">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 face="r_ansi" size="2">=====================</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="r_ansi" size="2">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 face="r_ansi" size="2">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 face="r_ansi" size="2">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 face="r_ansi" size="2">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>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Olt-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Olt-users@oss.oracle.com">Olt-users@oss.oracle.com</a>
<a class="moz-txt-link-freetext" href="http://oss.oracle.com/mailman/listinfo/olt-users">http://oss.oracle.com/mailman/listinfo/olt-users</a></pre>
</blockquote>
<br>
</body>
</html>