[Olt-users] ORA-942 with st-mem-spike on RH52 Ora11106 and OLT22

[Sriharsha]

Hi,
If you are referring  to the below error in the st-mem-spike OLT test  
with oracle db version 11.1.0.6 ,
kzxupnamread error -- 942: ORA-00942: table or view does not exist
Then its known issue with 11.1.0.6  & these OCI errors are  fixed in 11.2 .

Thanks,
Sriharsha

Hayden,Robert wrote:

> 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 
> database 'trace' directory.  Looking at these Oracle errors, I find 
> that all of them are ORA-942 table or view does not exist.  All of the 
> ORA- errors are located in the user trace files while no Oracle errors 
> are located in the alert log.  I turned on sql tracing and was able to 
> determine the query (see below). 
>
> I did use the install-silent-oracle-11106 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.
>
> The view DBA_REGISTRY just has CATALOG and CATPROC, nothing about 
> XDB.  Connecting locally and through the listener with the DBT user 
> has no logon errors.
>
> Basically, I am asking if this is a known issue with my combination, 
> i.e. 11.1.0.6, or if anyone has seen this before.
>
> Thanks
>
> Robert
>
>
> [oracle at ipht03 trace]$ cat  o2sl1_ora_16993.trc
>
> 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
>
> dbms/o2sl1/o2sl1/trace/o2sl1_ora_16993.trc
>
> Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit 
> Production
>
> With the Partitioning, OLAP, Data Mining and Real Application Testing 
> options
>
> ORACLE_HOME = /opt/oracle/oltest/.srchome/ora-11.1.0.6-X86_64//oradb
>
> System name:    Linux
>
> Node name:      ipht03.northamerica.cerner.net
>
> Release:        2.6.18-92.el5
>
> Version:        #1 SMP Tue Apr 29 13:16:15 EDT 2008
>
> Machine:        x86_64
>
> Instance name: o2sl1
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 68
>
> Unix process pid: 16993, image: oracle at ipht03.northamerica.cerner.net 
> <mailto:oracle at ipht03.northamerica.cerner.net> (TNS V1-V)
>
>
> *** 2008-10-20 16:07:47.646
>
> *** SESSION ID:(3620.15) 2008-10-20 16:07:47.646
>
> *** CLIENT ID:() 2008-10-20 16:07:47.646
>
> *** SERVICE NAME:(SYS$USERS) 2008-10-20 16:07:47.646
>
> *** MODULE NAME:(sqlplus at ipht03.northamerica.cerner.net 
> <mailto:sqlplus at ipht03.northamerica.cerner.net> (TNS V1-V) 2008-10-20 
> 16:07:47.646
>
> *** ACTION NAME:() 2008-10-20 16:07:47.646
>
>  
>
> =====================
>
> PARSING IN CURSOR #1 len=120 dep=1 uid=0 oct=3 lid=0 
> tim=1224536867646049 hv=3015134136 ad='ad8c6df0' sqlid='0xqtr8ftvfkxs'
>
> select extractvalue(value(p), '/user/UID') from xdb.xs$principals p  
> where extractvalue(value(p), '/user/userName') = :1
>
> END OF STMT
>
> PARSE 
> #1:c=0,e=1090,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1224536867646044
>
> =====================
>
> PARSE ERROR #1:len=120 dep=1 uid=0 oct=3 lid=0 tim=1224536867646589 
> err=942
>
> select extractvalue(value(p), '/user/UID') from xdb.xs$principals p  
> where extractvalue(value(p), '/user/userName') = :1
>
> XS Users and Roles -- OCI Info
>
> kzxupnamread error -- 942: ORA-00942: table or view does not exist
>
> ------------------------------------------------------------------------
> 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.
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Olt-users mailing list
>Olt-users at oss.oracle.com
>http://oss.oracle.com/mailman/listinfo/olt-users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://oss.oracle.com/pipermail/olt-users/attachments/20081021/2f8591e0/attachment-0001.html