Try doing a tnsping to the Database SID from the app server. Also, once you start AR Server with "./arsystem start", the two processes arserverd and armonitor are started. arserverd caches the definitions from the db - so you would see steady memory increase for the arserverd process. at around 400K to 600 K [based on your application forms], armonitor would kickin and start the process based on the armonitor.conf file..
On Oct 21, 10:26 pm, "ZHANG, ERIC L" <[EMAIL PROTECTED]> wrote: > Jarl, > > We tried with api and sql logs on. API log shows only the following: > > <API > <TID: 0000000001> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.4127 */API Trace Log -- ON > > The following is the sql log. I am not sure what to look at from these > logs. > > <SQL > <TID: 0000000001> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.4130 */SQL Trace Log -- ON > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.5293 */CONNECT ARAdmin > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7746 */SELECT BANNER FROM V$VERSION > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7768 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7771 */SELECT dbVersion FROM control > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7784 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7787 */SELECT MAX(serverId) FROM server_cache > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7800 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7801 */## mbGetLocaleCodeSet()=0 > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7802 */SELECT groupId,groupName,groupType,groupCategory > FROM group_cache ORDER BY 1 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7831 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7962 */COMMIT WORK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.7975 */SELECT groupId,floatLic,floatLicFTS FROM > group_cache ORDER BY 1 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.8008 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.8091 */COMMIT WORK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.8097 */SELECT groupType,MAX(timestamp) FROM group_cache > GROUP BY groupType > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.8142 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.8150 */SELECT > name,schemaId,schemaType,coreVersion,timestamp,numFields,defaultVui,numV > uis,nextFieldId,upgrdVersion,version,smObjProp,safeGuard > ,nextId,objProp FROM arschema ORDER BY 2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:16:53.8172 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:12.6380 */SELECT schemaId,groupId,permission FROM > schema_group_ids ORDER BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:12.6441 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:12.7090 */SELECT schemaId,groupId FROM subadmin_group ORDER > BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:12.7112 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.1067 */SELECT > schemaId,listIndex,fieldId,columnWidth,separatorLen,separator FROM > schema_list_fields ORDER BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.1158 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6084 */SELECT schemaId,listIndex,fieldId,sortOrder FROM > schema_sort ORDER BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6114 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6206 */SELECT > schemaId,listIndex,indexName,numFields,uniqueFlag,f1,f2,f3,f4,f5,f6,f7,f > 8,f9,f10,f11,f12,f13,f14,f15,f16 FROM schema_index ORDER BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6274 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6902 */SELECT > schemaId,enable,archiveType,archiveToForm,archiveToFile,queryShort,query > Long,monthday,weekday,hourmask,minute,archiveFromForm FR > OM schema_archive ORDER BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6926 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6935 */SELECT > schemaId,enable,style,form,queryShort,queryLong FROM schema_audit ORDER > BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6948 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6965 */SELECT > schemaId,memberA,memberB,options,queryShort,queryLong FROM schema_join > ORDER BY 1 ASC,2 ASC,3 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:13.6978 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:14.5819 */SELECT > schemaId,tableName,keyField,queryShort,queryLong FROM schema_view ORDER > BY 1 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:14.5842 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:14.5882 */SELECT schemaId,vendorName,tableName FROM > schema_vendor ORDER BY 1 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:14.5901 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:14.6157 */SELECT > schemaId,vuiId,vuiName,locale,vuiType,timestamp FROM vui ORDER BY 1 > ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:14.6227 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:14.6811 */SELECT > schemaId,fieldId,fieldType,timestamp,datatype,fOption,createMode,fbOptio > n,defaultValue,fieldName FROM field ORDER BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:15.1761 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:34.5456 */SELECT schemaId,fieldId,memberIndex,mfieldId FROM > join_mapping ORDER BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:34.6246 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:36.8035 */SELECT schemaId,fieldId,extField FROM view_mapping > ORDER BY 1 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:36.8056 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:36.8065 */SELECT schemaId,fieldId,extField FROM > vendor_mapping ORDER BY 1 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:36.8087 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:37.2153 */SELECT schemaId,fieldId,rangeLow,rangeHigh FROM > field_int ORDER BY 1 ASC,2 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:37.2342 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:37.4862 */SELECT > schemaId,fieldId,rangeLow,rangeHigh,arprecision FROM field_real ORDER BY > 1 ASC > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:37.4896 */OK > <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > > <Client-RPC: 000000 > <USER:> /* Sun Oct 21 > > 2007 12:17:37.5151 */SELECT > schemaId,fieldId,maxLength,menuStyle,qbeMatchOp,charMenu,pattern,fullTex > tOptions,isLong FROM ... > > read more » _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
