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

[Hayden,Robert]

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 (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 (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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://oss.oracle.com/pipermail/olt-users/attachments/20081021/df896d8a/attachment.html