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 field_char ORDER BY 1 ASC <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Sun Oct 21 2007 12:17:37.6535 */OK <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Sun Oct 21 2007 12:17:40.2137 */SELECT schemaId,fieldId,fullTextOptions,isLong FROM field_diary ORDER BY 1 ASC <SQL > <TID: 0000000005> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Sun Oct 21 -----Original Message----- Turn on sql and api logs and then start the ar server again... -- Jarl > >From: "Action Request System discussion list(ARSList)" >[mailto:[EMAIL PROTECTED] On Behalf Of "ZHANG, ERIC L" >Sent: Sunday, October 21, 2007 1:39 AM >To: [email protected] >Subject: URGENT - cannot start AR System >Importance: High > > >** > >ARS 7.0.01 > >Solaris 9 > >Oracle 10gR2 (on another Solaris 9 server) > > > >We cannot bring back arsystem server after UNIX admin have applied a >UNIX patch on the database server (Solaris 9). There is no error >message at arerror.log. ps only show arserverd and armonitor, no sign >of other process such as arplugin, etc.: > > > > remedy 13649 13356 0 00:30:19 pts/1 0:00 -ksh > > remedy 16960 1 0 01:15:02 ? 0:00 ./armonitor -s >remedyprod2 -c /etc/arsystem/remedyprod2/armonitor.conf > > remedy 13591 13372 0 00:28:54 pts/5 0:00 -ksh > > remedy 17545 17543 0 01:28:02 pts/6 0:00 -ksh > > remedy 16961 16960 0 01:15:02 ? 0:19 ./arserverd -s >remedyprod2 -i /opt/remedy/arsystem/remedyprod2 -l /opt/remedy/a > > remedy 17865 13591 0 01:32:58 pts/5 0:00 ps -ef > > remedy 17866 13591 0 01:32:58 pts/5 0:00 grep remedy > > > >DBA can see one database connection to the database by aradmin. > > > >Anybody has experienced this before? > > > >Thanks, > >Eric > >__20060125_______________________This posting was submitted with HTML in >it___ > >_______________________________________________________________________ ___ _____ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
