某SDE问题解决过程简记
分享
-
2015-11-27
环境：
ArcSDE 9.2+sp6 Oracle9.2.0.8 OS:HP-UX 11.11
Desktop:9.2+sp6
现象：
SDE的服务起来之后，无法使用ArcCatalog连接，报下图的错误：
SDE的后台日志为：
sde的日志报错信息: ERROR(-8),could't start server task;
解决过程：
从ArcCatalog报的错误和SDE的后台日志报的错误，无法确定问题的原因。 但是从错误的本身可以判断出来在这个过程中数据库应该已经连上了，但是因为某些条件出现了问题，导致了又断开了。因此抓取了一下整个过程后台所执行的SQL语句：
使用 oracle 提供的10046事件跟踪，产生跟踪信息如下：
1:
/**********************************************************************************************************/
2:
/oracle/admin
/newcrm/udump/newcrm_ora_7126.trc
3:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
4:
With
the Partitioning and
OLAP options
5:
JServer Release 9.2.0.8.0 - Production
6:
ORACLE_HOME = /oracle/product/9.2.0
7:
System name: HP-UX
8:
Node name: superdb
9:
Release: B.11.11
10:
Version: U
11:
Machine: 9000/800
12:
Instance name: newcrm
13:
Redo thread mounted by
this instance: 1
14:
Oracle process number: 13
15:
Unix process pid: 7126, image:oracle@superdb(TNS V1-V3)
16:
17:
*** SESSION
ID:(9.34) 2008-11-24 18:20:55.972
18:
WAIT #0: nam='SQL*Net message to client'
ela= 3 p1=1413697536 p2=1 p3=0
19:
WAIT #0: nam='SQL*Net message from client'
ela= 1603 p1=1413697536 p2=1 p3=0
20:
=====================
21:
PARSING IN
CURSOR
#1 len=147 dep=1 uid=0 ct=3 lid=0 tim=10643870288245 hv=1356713530 ad='5e72de8'
22:
select
privilege#,level
from
sysauth$ connect
by
grantee#=prior
privilege# and
privilege#>0 start
with
(grantee#=:1 or
grantee#=1) and
privilege#>0
23:
END
OF
STMT
24:
PARSE #1:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288231
25:
BINDS #1:
26:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=08 oacfl2=c000000600000001 size
=24 ffset=0
27:
bfp=800003fa0006b730 bln=22 avl=02 flg=05
28:
value
=37
29:
EXEC
#1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288570
30:
FETCH
#1:c=0,e=293,p=0,cr=6,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870288895
31:
FETCH
#1:c=0,e=14,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870288951
32:
FETCH
#1:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288984
33:
STAT #1 id=1 cnt=2 pid=0 pos=1 bj=0 p='CONNECT BY WITH FILTERING '
34:
STAT #1 id=2 cnt=2 pid=1 pos=1 bj=91 p='TABLE ACCESS BY INDEX ROWID SYSAUTH$ '
35:
STAT #1 id=3 cnt=2 pid=2 pos=1 bj=0 p='CONCATENATION '
36:
STAT #1 id=4 cnt=0 pid=3 pos=1 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '
37:
STAT #1 id=5 cnt=2 pid=3 pos=2 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '
38:
STAT #1 id=6 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS '
39:
STAT #1 id=7 cnt=2 pid=6 pos=1 bj=0 p='BUFFER SORT '
40:
STAT #1 id=8 cnt=2 pid=7 pos=1 bj=0 p='CONNECT BY PUMP '
41:
STAT #1 id=9 cnt=0 pid=6 pos=2 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '
42:
STAT #1 id=10 cnt=0 pid=1 pos=3 bj=91 p='TABLE ACCESS FULL SYSAUTH$ '
43:
=====================
44:
PARSING IN
CURSOR
#2 len=48 dep=2 uid=0 ct=3 lid=0 tim=10643870289770 hv=3997906522 ad='7eac418'
45:
select
user
# from
sys.user
$ where
name = 'OUTLN'
46:
END
OF
STMT
47:
PARSE #2:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=10643870289763
48:
BINDS #2:
49:
EXEC
#2:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=10643870289876
50:
FETCH
#2:c=0,e=39,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=10643870289942
51:
STAT #2 id=1 cnt=1 pid=0 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '
52:
STAT #2 id=2 cnt=1 pid=1 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '
53:
=====================
54:
PARSING IN
CURSOR
#1 len=495 dep=1 uid=37 ct=42 lid=37 tim=10643870290284 hv=3607159657 ad='5e6a6b8'
55:
ALTER
SESSION
SET
NLS_LANGUAGE= 'SIMPLIFIED CHINESE'
NLS_TERRITORY= 'CHINA'
NLS_CURRENCY= 'RMB'
NLS_ISO_CURRENCY= 'CHINA'
NLS_NUMERIC_CHARACTERS= '.,'
NLS_CALENDAR= 'GREGORIAN'
NLS_DATE_FORMAT= 'DD-MON-RR'
NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE'
NLS_SORT= 'BINARY'
TIME_ZONE= '+08:00'
NLS_DUAL_CURRENCY = 'RMB'
NLS_TIME_FORMAT = 'HH.MI.SSXFF AM'
NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM'
NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZR'
NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR'
56:
END
OF
STMT
57:
PARSE #1:c=0,e=638,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870290277
58:
BINDS #1:
59:
EXEC
#1:c=0,e=502,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870290860
60:
WAIT #0: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
61:
WAIT #0: nam='SQL*Net message from client'
ela= 772 p1=1413697536 p2=1 p3=0
62:
=====================
63:
PARSING IN
CURSOR
#1 len=21 dep=0 uid=37 ct=3 lid=37 tim=10643870291986 hv=1702091759 ad='7ea7170'
64:
SELECT
USER
FROM
DUAL
65:
END
OF
STMT
66:
PARSE #1:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870291979
67:
BINDS #1:
68:
EXEC
#1:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870292093
69:
WAIT #1: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
70:
FETCH
#1:c=0,e=76,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870292229
71:
WAIT #1: nam='SQL*Net message from client'
ela= 889 p1=1413697536 p2=1 p3=0
72:
STAT #1 id=1 cnt=1 pid=0 pos=1 bj=222 p='TABLE ACCESS FULL DUAL '
73:
=====================
74:
PARSING IN
CURSOR
#1 len=80 dep=0 uid=37 ct=47 lid=37 tim=10643870293586 hv=1755109904 ad='6e49d28'
75:
BEGIN
/* ArcSDE plsql */ dbms_utility.db_version (:version,:compatibility); END
;
76:
END
OF
STMT
77:
PARSE #1:c=0,e=222,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870293578
78:
BINDS #1:
79:
bind 0: dty=1 mxl=128(64) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=256 ffset=0
80:
bfp=800003fa0005f650 bln=128 avl=00 flg=05
81:
bind 1: dty=1 mxl=128(64) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=0 ffset=128
82:
bfp=800003fa0005f6d0 bln=128 avl=00 flg=01
83:
=====================
84:
PARSING IN
CURSOR
#2 len=62 dep=1 uid=0 ct=3 lid=0 tim=10643870294185 hv=1439923766 ad='7e96fa0'
85:
SELECT
VALUE
FROM
SYS.V$PARAMETER
WHERE
NAME = 'compatible'
86:
END
OF
STMT
87:
PARSE #2:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870294178
88:
BINDS #2:
89:
EXEC
#2:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870294292
90:
FETCH
#2:c=0,e=4458,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870298771
91:
WAIT #1: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
92:
EXEC
#1:c=10000,e=5243,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870298907
93:
WAIT #1: nam='SQL*Net message from client'
ela= 643 p1=1413697536 p2=1 p3=0
94:
=====================
95:
PARSING IN
CURSOR
#1 len=82 dep=0 uid=37 ct=3 lid=37 tim=10643870299752 hv=1074646296 ad='8dba280'
96:
SELECT
major, minor, bugfix, description, release, sdesvr_rel_low FROM
SDE.version
97:
END
OF
STMT
98:
PARSE #1:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870299745
99:
BINDS #1:
100:
EXEC
#1:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870299860
101:
WAIT #1: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
102:
FETCH
#1:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870299985
103:
WAIT #1: nam='SQL*Net message from client'
ela= 1061 p1=1413697536 p2=1 p3=0
104:
STAT #1 id=1 cnt=1 pid=0 pos=1 bj=156217 p='TABLE ACCESS FULL VERSION '
105:
=====================
106:
PARSING IN
CURSOR
#1 len=204 dep=0 uid=37 ct=47 lid=37 tim=10643870301339 hv=3503961007 ad='7e8df28'
107:
BEGIN
/* ArcSDE plsql */ :rval:= dbms_utility.get_parameter_value(:nval,:ival,:sval);:sql_code := SDE.sde_util.SE_SUCCESS; EXCEPTION
WHEN
OTHERS THEN
:sql_code := SQLCODE
; :error_string := SQLERRM; END
;
108:
END
OF
STMT
109:
PARSE #1:c=0,e=131,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870301331
110:
WAIT #1: nam='SQL*Net more data from client'
ela= 15 p1=1413697536 p2=1 p3=0
111:
BINDS #1:
112:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=80 ffset=0
113:
bfp=800003fa0005f700 bln=22 avl=00 flg=05
114:
bind 1: dty=1 mxl=32(24) mal=00 scl=00 pre=00 acflg=20 oacfl2=8000000100000010 size
=0 ffset=24
115:
bfp=800003fa0005f718 bln=32 avl=12 flg=01
116:
value
="open_cursors"
117:
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=0 ffset=56
118:
bfp=800003fa0005f738 bln=22 avl=02 flg=01
119:
value
=44
120:
bind 3: dty=1 mxl=4000(4000) mal=00 scl=00 pre=00 acflg=20 oacfl2=8000000100000010 size
=4000 ffset=0
121:
bfp=800003fa0005df30 bln=4000 avl=2000 flg=05
122:
value
=""...
123:
bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=24 ffset=0
124:
bfp=800003fa0005f6d0 bln=22 avl=00 flg=05
125:
bind 5: dty=1 mxl=2000(1024) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=2000 ffset=0
126:
bfp=800003fa0005d720 bln=2000 avl=00 flg=05
127:
=====================
128:
PARSING IN
CURSOR
#3 len=25 dep=1 uid=37 ct=3 lid=37 tim=10643870302296 hv=2403185938 ad='6e30078'
129:
SELECT
USER
FROM
SYS.DUAL
130:
END
OF
STMT
131:
PARSE #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302289
132:
BINDS #3:
133:
EXEC
#3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302392
134:
FETCH
#3:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870302453
135:
BINDS #3:
136:
EXEC
#3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302742
137:
FETCH
#3:c=0,e=21,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870302786
138:
WAIT #1: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
139:
WAIT #1: nam='SQL*Net more data to client'
ela= 47 p1=1413697536 p2=2030 p3=0
140:
EXEC
#1:c=0,e=1562,p=0,cr=6,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870303000
141:
WAIT #1: nam='SQL*Net message from client'
ela= 1556 p1=1413697536 p2=1 p3=0
142:
WAIT #0: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
143:
WAIT #0: nam='SQL*Net message from client'
ela= 504 p1=1413697536 p2=1 p3=0
144:
=====================
145:
PARSING IN
CURSOR
#4 len=47 dep=1 uid=0 ct=3 lid=0 tim=10643870305677 hv=2232614812 ad='8ed4910'
146:
select
metadata from
kopm$ where
name='DB_FDO'
147:
END
OF
STMT
148:
PARSE #4:c=0,e=57,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870305669
149:
BINDS #4:
150:
EXEC
#4:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870305791
151:
FETCH
#4:c=0,e=17,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870305836
152:
STAT #4 id=1 cnt=1 pid=0 pos=1 bj=350 p='TABLE ACCESS BY INDEX ROWID KOPM$ '
153:
STAT #4 id=2 cnt=1 pid=1 pos=1 bj=351 p='INDEX UNIQUE SCAN I_KOPM1 '
154:
WAIT #0: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
155:
WAIT #0: nam='SQL*Net message from client'
ela= 779 p1=1413697536 p2=1 p3=0
156:
WAIT #0: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
157:
WAIT #0: nam='SQL*Net message from client'
ela= 816 p1=1413697536 p2=1 p3=0
158:
=====================
159:
PARSING IN
CURSOR
#7 len=121 dep=0 uid=37 ct=3 lid=37 tim=10643870308650 hv=3709805476 ad='5e42fe0'
160:
select
text from
ALL_TYPE_VERSIONS where
wner = 'SDE'
and
type_name = upper
(:type_name) and
text like
'%C_Type_Release%'
161:
END
OF
STMT
162:
PARSE #7:c=0,e=139,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870308642
163:
BINDS #7:
164:
bind 0: dty=1 mxl=32(22) mal=00 scl=00 pre=00 acflg=20 oacfl2=c000000600000010 size
=32 ffset=0
165:
bfp=800003fa00073008 bln=32 avl=11 flg=05
166:
value
="ST_GEOMETRY"
167:
EXEC
#7:c=0,e=1020,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870309752
168:
WAIT #7: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
169:
FETCH
#7:c=0,e=281,p=0,cr=11,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870310100
170:
WAIT #7: nam='SQL*Net message from client'
ela= 934 p1=1413697536 p2=1 p3=0
171:
STAT #7 id=1 cnt=1 pid=0 pos=1 bj=0 p='FILTER '
172:
STAT #7 id=2 cnt=1 pid=1 pos=1 bj=71 p='TABLE ACCESS BY INDEX ROWID SOURCE$ '
173:
STAT #7 id=3 cnt=26 pid=2 pos=1 bj=0 p='NESTED LOOPS '
174:
STAT #7 id=4 cnt=1 pid=3 pos=1 bj=0 p='NESTED LOOPS '
175:
STAT #7 id=5 cnt=1 pid=4 pos=1 bj=0 p='NESTED LOOPS '
176:
STAT #7 id=6 cnt=1 pid=5 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '
177:
STAT #7 id=7 cnt=1 pid=6 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '
178:
STAT #7 id=8 cnt=1 pid=5 pos=2 bj=18 p='TABLE ACCESS BY INDEX ROWID OBJ$ '
179:
STAT #7 id=9 cnt=2 pid=8 pos=1 bj=37 p='INDEX RANGE SCAN I_OBJ2 '
180:
STAT #7 id=10 cnt=1 pid=4 pos=2 bj=300 p='INDEX UNIQUE SCAN I_TYPE2 '
181:
STAT #7 id=11 cnt=24 pid=3 pos=2 bj=119 p='INDEX RANGE SCAN I_SOURCE1 '
182:
STAT #7 id=12 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS '
183:
STAT #7 id=13 cnt=0 pid=12 pos=1 bj=309 p='FIXED TABLE FULL X$KZSRO '
184:
STAT #7 id=14 cnt=0 pid=12 pos=2 bj=109 p='INDEX RANGE SCAN I_OBJAUTH2 '
185:
STAT #7 id=15 cnt=0 pid=1 pos=3 bj=310 p='FIXED TABLE FULL X$KZSPR '
186:
=====================
187:
PARSING IN
CURSOR
#7 len=142 dep=0 uid=37 ct=3 lid=37 tim=10643870311620 hv=3347668576 ad='8d986f0'
188:
SELECT
status,validated FROM
all_constraints WHERE
wner = :table_owner AND
constraint_name = :constraint_name AND
table_name = :table_name
189:
END
OF
STMT
190:
PARSE #7:c=0,e=124,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311612
191:
BINDS #7:
192:
bind 0: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=384 ffset=0
193:
bfp=800003f9c000a908 bln=128 avl=03 flg=05
194:
value
="SDE"
195:
bind 1: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=0 ffset=128
196:
bfp=800003f9c000a988 bln=128 avl=09 flg=01
197:
value
="STATES_FK"
198:
bind 2: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=0 ffset=256
199:
bfp=800003f9c000aa08 bln=128 avl=06 flg=01
200:
value
="STATES"
201:
EXEC
#7:c=0,e=174,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311876
202:
WAIT #7: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
203:
FETCH
#7:c=0,e=30,p=0,cr=4,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311970
204:
WAIT #7: nam='SQL*Net message from client'
ela= 583 p1=1413697536 p2=1 p3=0
205:
STAT #7 id=1 cnt=0 pid=0 pos=1 bj=0 p='FILTER '
206:
STAT #7 id=2 cnt=0 pid=1 pos=1 bj=0 p='NESTED LOOPS OUTER '
207:
STAT #7 id=3 cnt=0 pid=2 pos=1 bj=0 p='NESTED LOOPS OUTER '
208:
STAT #7 id=4 cnt=0 pid=3 pos=1 bj=0 p='NESTED LOOPS OUTER '
209:
STAT #7 id=5 cnt=0 pid=4 pos=1 bj=0 p='NESTED LOOPS OUTER '
210:
STAT #7 id=6 cnt=0 pid=5 pos=1 bj=0 p='NESTED LOOPS '
211:
STAT #7 id=7 cnt=0 pid=6 pos=1 bj=0 p='NESTED LOOPS OUTER '
212:
STAT #7 id=8 cnt=0 pid=7 pos=1 bj=0 p='NESTED LOOPS '
213:
STAT #7 id=9 cnt=0 pid=8 pos=1 bj=0 p='NESTED LOOPS '
214:
STAT #7 id=10 cnt=1 pid=9 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '
215:
STAT #7 id=11 cnt=1 pid=10 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '
216:
STAT #7 id=12 cnt=0 pid=9 pos=2 bj=28 p='TABLE ACCESS BY INDEX ROWID CON$ '
217:
STAT #7 id=13 cnt=0 pid=12 pos=1 bj=48 p='INDEX UNIQUE SCAN I_CON1 '
218:
STAT #7 id=14 cnt=0 pid=8 pos=2 bj=31 p='TABLE ACCESS BY INDEX ROWID CDEF$ '
219:
STAT #7 id=15 cnt=0 pid=14 pos=1 bj=50 p='INDEX UNIQUE SCAN I_CDEF1 '
220:
STAT #7 id=16 cnt=0 pid=7 pos=2 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '
221:
STAT #7 id=17 cnt=0 pid=6 pos=2 bj=18 p='TABLE ACCESS BY INDEX ROWID OBJ$ '
222:
STAT #7 id=18 cnt=0 pid=17 pos=1 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '
223:
STAT #7 id=19 cnt=0 pid=5 pos=2 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '
224:
STAT #7 id=20 cnt=0 pid=4 pos=2 bj=28 p='TABLE ACCESS BY INDEX ROWID CON$ '
225:
STAT #7 id=21 cnt=0 pid=20 pos=1 bj=49 p='INDEX UNIQUE SCAN I_CON2 '
226:
STAT #7 id=22 cnt=0 pid=3 pos=2 bj=22 p='TABLE ACCESS CLUSTER USER$ '
227:
STAT #7 id=23 cnt=0 pid=22 pos=1 bj=11 p='INDEX UNIQUE SCAN I_USER# '
228:
STAT #7 id=24 cnt=0 pid=2 pos=2 bj=22 p='TABLE ACCESS CLUSTER USER$ '
229:
STAT #7 id=25 cnt=0 pid=24 pos=1 bj=11 p='INDEX UNIQUE SCAN I_USER# '
230:
STAT #7 id=26 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS '
231:
STAT #7 id=27 cnt=0 pid=26 pos=1 bj=309 p='FIXED TABLE FULL X$KZSRO '
232:
STAT #7 id=28 cnt=0 pid=26 pos=2 bj=109 p='INDEX RANGE SCAN I_OBJAUTH2 '
233:
STAT #7 id=29 cnt=0 pid=1 pos=3 bj=310 p='FIXED TABLE FULL X$KZSPR '
234:
XCTEND rlbk=0, rd_only=1
235:
WAIT #0: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
236:
WAIT #0: nam='SQL*Net message from client'
ela= 739 p1=1413697536 p2=1 p3=0
237:
=====================
238:
PARSING IN
CURSOR
#7 len=82 dep=0 uid=37 ct=3 lid=37 tim=10643870314110 hv=1074646296 ad='8dba280'
239:
SELECT
major, minor, bugfix, description, release, sdesvr_rel_low FROM
SDE.version
240:
END
OF
STMT
241:
PARSE #7:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870314103
242:
BINDS #7:
243:
EXEC
#7:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870314206
244:
WAIT #7: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
245:
FETCH
#7:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870314315
246:
WAIT #7: nam='SQL*Net message from client'
ela= 938 p1=1413697536 p2=1 p3=0
247:
STAT #7 id=1 cnt=1 pid=0 pos=1 bj=156217 p='TABLE ACCESS FULL VERSION '
248:
=====================
249:
PARSING IN
CURSOR
#7 len=73 dep=0 uid=37 ct=3 lid=37 tim=10643870315460 hv=3244238113 ad='6e15f20'
250:
SELECT
prop_name, char_prop_value, num_prop_value FROM
SDE.SERVER_CONFIG
251:
END
OF
STMT
252:
PARSE #7:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870315453
253:
BINDS #7:
254:
EXEC
#7:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870315563
255:
WAIT #7: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
256:
FETCH
#7:c=0,e=84,p=0,cr=3,cu=0,mis=0,r=41,dep=0,og=4,tim=10643870315711
257:
WAIT #7: nam='SQL*Net message from client'
ela= 1391 p1=1413697536 p2=1 p3=0
258:
=====================
259:
PARSING IN
CURSOR
#8 len=31 dep=0 uid=37 ct=3 lid=37 tim=10643870317246 hv=2813680287 ad='5e338e0'
260:
SELECT
COUNT
(*) FROM
SDE.LAYERS
261:
END
OF
STMT
262:
PARSE #8:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870317239
263:
BINDS #8:
264:
EXEC
#8:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870317351
265:
WAIT #8: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
266:
FETCH
#8:c=0,e=58,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870317464
267:
WAIT #8: nam='SQL*Net message from client'
ela= 916 p1=1413697536 p2=1 p3=0
268:
XCTEND rlbk=0, rd_only=1
269:
STAT #3 id=1 cnt=2 pid=0 pos=1 bj=222 p='TABLE ACCESS FULL DUAL '
270:
STAT #2 id=1 cnt=1 pid=0 pos=1 bj=0 p='MERGE JOIN '
271:
STAT #2 id=2 cnt=872 pid=1 pos=1 bj=59 p='FIXED TABLE FULL X$KSPPCV '
272:
STAT #2 id=3 cnt=1 pid=1 pos=2 bj=0 p='FILTER '
273:
STAT #2 id=4 cnt=1 pid=3 pos=1 bj=0 p='SORT JOIN '
274:
STAT #2 id=5 cnt=1 pid=4 pos=1 bj=58 p='FIXED TABLE FULL X$KSPPI '
275:
STAT #7 id=1 cnt=41 pid=0 pos=1 bj=156299 p='TABLE ACCESS FULL OBJ#(156299) '
276:
STAT #8 id=1 cnt=1 pid=0 pos=1 bj=0 p='SORT AGGREGATE '
277:
STAT #8 id=2 cnt=41 pid=1 pos=1 bj=156222 p='TABLE ACCESS FULL OBJ#(156222) '
278:
/****************************************************************************************************/
从后端执行的 sql 可以看出,还没有验证license信息就停止了,整个过程一共访问了以下几个sde的系统表: sde.version,sde.server_config,sde.layers
其中version表记录sde的版本信息,layers表记录层信息，这两个表出错的肯能性不是很大，而server_config表 记录的sde的配置信息，所以重点查看server_config表中是否有参数被修改过,经查看status参数被修改成2.
查看帮助status参数的意义: Values are 1 if this instance is accepting new connections or 2 if it is paused (not accepting new connections).
讲status改成1，问题解决。
至于为什么客户要这么修改，就不得而知了。
文章来源：http://blog.csdn.net/liufeng1980423/article/details/6072511
ArcSDE 9.2+sp6 Oracle9.2.0.8 OS:HP-UX 11.11
Desktop:9.2+sp6
现象：
SDE的服务起来之后，无法使用ArcCatalog连接，报下图的错误：
SDE的后台日志为：
sde的日志报错信息: ERROR(-8),could't start server task;
解决过程：
从ArcCatalog报的错误和SDE的后台日志报的错误，无法确定问题的原因。 但是从错误的本身可以判断出来在这个过程中数据库应该已经连上了，但是因为某些条件出现了问题，导致了又断开了。因此抓取了一下整个过程后台所执行的SQL语句：
使用 oracle 提供的10046事件跟踪，产生跟踪信息如下：
1:
/**********************************************************************************************************/
2:
/oracle/admin
/newcrm/udump/newcrm_ora_7126.trc
3:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
4:
With
the Partitioning and
OLAP options
5:
JServer Release 9.2.0.8.0 - Production
6:
ORACLE_HOME = /oracle/product/9.2.0
7:
System name: HP-UX
8:
Node name: superdb
9:
Release: B.11.11
10:
Version: U
11:
Machine: 9000/800
12:
Instance name: newcrm
13:
Redo thread mounted by
this instance: 1
14:
Oracle process number: 13
15:
Unix process pid: 7126, image:oracle@superdb(TNS V1-V3)
16:
17:
*** SESSION
ID:(9.34) 2008-11-24 18:20:55.972
18:
WAIT #0: nam='SQL*Net message to client'
ela= 3 p1=1413697536 p2=1 p3=0
19:
WAIT #0: nam='SQL*Net message from client'
ela= 1603 p1=1413697536 p2=1 p3=0
20:
=====================
21:
PARSING IN
CURSOR
#1 len=147 dep=1 uid=0 ct=3 lid=0 tim=10643870288245 hv=1356713530 ad='5e72de8'
22:
select
privilege#,level
from
sysauth$ connect
by
grantee#=prior
privilege# and
privilege#>0 start
with
(grantee#=:1 or
grantee#=1) and
privilege#>0
23:
END
OF
STMT
24:
PARSE #1:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288231
25:
BINDS #1:
26:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=08 oacfl2=c000000600000001 size
=24 ffset=0
27:
bfp=800003fa0006b730 bln=22 avl=02 flg=05
28:
value
=37
29:
EXEC
#1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288570
30:
FETCH
#1:c=0,e=293,p=0,cr=6,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870288895
31:
FETCH
#1:c=0,e=14,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870288951
32:
FETCH
#1:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288984
33:
STAT #1 id=1 cnt=2 pid=0 pos=1 bj=0 p='CONNECT BY WITH FILTERING '
34:
STAT #1 id=2 cnt=2 pid=1 pos=1 bj=91 p='TABLE ACCESS BY INDEX ROWID SYSAUTH$ '
35:
STAT #1 id=3 cnt=2 pid=2 pos=1 bj=0 p='CONCATENATION '
36:
STAT #1 id=4 cnt=0 pid=3 pos=1 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '
37:
STAT #1 id=5 cnt=2 pid=3 pos=2 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '
38:
STAT #1 id=6 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS '
39:
STAT #1 id=7 cnt=2 pid=6 pos=1 bj=0 p='BUFFER SORT '
40:
STAT #1 id=8 cnt=2 pid=7 pos=1 bj=0 p='CONNECT BY PUMP '
41:
STAT #1 id=9 cnt=0 pid=6 pos=2 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '
42:
STAT #1 id=10 cnt=0 pid=1 pos=3 bj=91 p='TABLE ACCESS FULL SYSAUTH$ '
43:
=====================
44:
PARSING IN
CURSOR
#2 len=48 dep=2 uid=0 ct=3 lid=0 tim=10643870289770 hv=3997906522 ad='7eac418'
45:
select
user
# from
sys.user
$ where
name = 'OUTLN'
46:
END
OF
STMT
47:
PARSE #2:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=10643870289763
48:
BINDS #2:
49:
EXEC
#2:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=10643870289876
50:
FETCH
#2:c=0,e=39,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=10643870289942
51:
STAT #2 id=1 cnt=1 pid=0 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '
52:
STAT #2 id=2 cnt=1 pid=1 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '
53:
=====================
54:
PARSING IN
CURSOR
#1 len=495 dep=1 uid=37 ct=42 lid=37 tim=10643870290284 hv=3607159657 ad='5e6a6b8'
55:
ALTER
SESSION
SET
NLS_LANGUAGE= 'SIMPLIFIED CHINESE'
NLS_TERRITORY= 'CHINA'
NLS_CURRENCY= 'RMB'
NLS_ISO_CURRENCY= 'CHINA'
NLS_NUMERIC_CHARACTERS= '.,'
NLS_CALENDAR= 'GREGORIAN'
NLS_DATE_FORMAT= 'DD-MON-RR'
NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE'
NLS_SORT= 'BINARY'
TIME_ZONE= '+08:00'
NLS_DUAL_CURRENCY = 'RMB'
NLS_TIME_FORMAT = 'HH.MI.SSXFF AM'
NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM'
NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZR'
NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR'
56:
END
OF
STMT
57:
PARSE #1:c=0,e=638,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870290277
58:
BINDS #1:
59:
EXEC
#1:c=0,e=502,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870290860
60:
WAIT #0: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
61:
WAIT #0: nam='SQL*Net message from client'
ela= 772 p1=1413697536 p2=1 p3=0
62:
=====================
63:
PARSING IN
CURSOR
#1 len=21 dep=0 uid=37 ct=3 lid=37 tim=10643870291986 hv=1702091759 ad='7ea7170'
64:
SELECT
USER
FROM
DUAL
65:
END
OF
STMT
66:
PARSE #1:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870291979
67:
BINDS #1:
68:
EXEC
#1:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870292093
69:
WAIT #1: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
70:
FETCH
#1:c=0,e=76,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870292229
71:
WAIT #1: nam='SQL*Net message from client'
ela= 889 p1=1413697536 p2=1 p3=0
72:
STAT #1 id=1 cnt=1 pid=0 pos=1 bj=222 p='TABLE ACCESS FULL DUAL '
73:
=====================
74:
PARSING IN
CURSOR
#1 len=80 dep=0 uid=37 ct=47 lid=37 tim=10643870293586 hv=1755109904 ad='6e49d28'
75:
BEGIN
/* ArcSDE plsql */ dbms_utility.db_version (:version,:compatibility); END
;
76:
END
OF
STMT
77:
PARSE #1:c=0,e=222,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870293578
78:
BINDS #1:
79:
bind 0: dty=1 mxl=128(64) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=256 ffset=0
80:
bfp=800003fa0005f650 bln=128 avl=00 flg=05
81:
bind 1: dty=1 mxl=128(64) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=0 ffset=128
82:
bfp=800003fa0005f6d0 bln=128 avl=00 flg=01
83:
=====================
84:
PARSING IN
CURSOR
#2 len=62 dep=1 uid=0 ct=3 lid=0 tim=10643870294185 hv=1439923766 ad='7e96fa0'
85:
SELECT
VALUE
FROM
SYS.V$PARAMETER
WHERE
NAME = 'compatible'
86:
END
OF
STMT
87:
PARSE #2:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870294178
88:
BINDS #2:
89:
EXEC
#2:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870294292
90:
FETCH
#2:c=0,e=4458,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870298771
91:
WAIT #1: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
92:
EXEC
#1:c=10000,e=5243,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870298907
93:
WAIT #1: nam='SQL*Net message from client'
ela= 643 p1=1413697536 p2=1 p3=0
94:
=====================
95:
PARSING IN
CURSOR
#1 len=82 dep=0 uid=37 ct=3 lid=37 tim=10643870299752 hv=1074646296 ad='8dba280'
96:
SELECT
major, minor, bugfix, description, release, sdesvr_rel_low FROM
SDE.version
97:
END
OF
STMT
98:
PARSE #1:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870299745
99:
BINDS #1:
100:
EXEC
#1:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870299860
101:
WAIT #1: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
102:
FETCH
#1:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870299985
103:
WAIT #1: nam='SQL*Net message from client'
ela= 1061 p1=1413697536 p2=1 p3=0
104:
STAT #1 id=1 cnt=1 pid=0 pos=1 bj=156217 p='TABLE ACCESS FULL VERSION '
105:
=====================
106:
PARSING IN
CURSOR
#1 len=204 dep=0 uid=37 ct=47 lid=37 tim=10643870301339 hv=3503961007 ad='7e8df28'
107:
BEGIN
/* ArcSDE plsql */ :rval:= dbms_utility.get_parameter_value(:nval,:ival,:sval);:sql_code := SDE.sde_util.SE_SUCCESS; EXCEPTION
WHEN
OTHERS THEN
:sql_code := SQLCODE
; :error_string := SQLERRM; END
;
108:
END
OF
STMT
109:
PARSE #1:c=0,e=131,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870301331
110:
WAIT #1: nam='SQL*Net more data from client'
ela= 15 p1=1413697536 p2=1 p3=0
111:
BINDS #1:
112:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=80 ffset=0
113:
bfp=800003fa0005f700 bln=22 avl=00 flg=05
114:
bind 1: dty=1 mxl=32(24) mal=00 scl=00 pre=00 acflg=20 oacfl2=8000000100000010 size
=0 ffset=24
115:
bfp=800003fa0005f718 bln=32 avl=12 flg=01
116:
value
="open_cursors"
117:
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=0 ffset=56
118:
bfp=800003fa0005f738 bln=22 avl=02 flg=01
119:
value
=44
120:
bind 3: dty=1 mxl=4000(4000) mal=00 scl=00 pre=00 acflg=20 oacfl2=8000000100000010 size
=4000 ffset=0
121:
bfp=800003fa0005df30 bln=4000 avl=2000 flg=05
122:
value
=""...
123:
bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=24 ffset=0
124:
bfp=800003fa0005f6d0 bln=22 avl=00 flg=05
125:
bind 5: dty=1 mxl=2000(1024) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=2000 ffset=0
126:
bfp=800003fa0005d720 bln=2000 avl=00 flg=05
127:
=====================
128:
PARSING IN
CURSOR
#3 len=25 dep=1 uid=37 ct=3 lid=37 tim=10643870302296 hv=2403185938 ad='6e30078'
129:
SELECT
USER
FROM
SYS.DUAL
130:
END
OF
STMT
131:
PARSE #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302289
132:
BINDS #3:
133:
EXEC
#3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302392
134:
FETCH
#3:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870302453
135:
BINDS #3:
136:
EXEC
#3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302742
137:
FETCH
#3:c=0,e=21,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870302786
138:
WAIT #1: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
139:
WAIT #1: nam='SQL*Net more data to client'
ela= 47 p1=1413697536 p2=2030 p3=0
140:
EXEC
#1:c=0,e=1562,p=0,cr=6,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870303000
141:
WAIT #1: nam='SQL*Net message from client'
ela= 1556 p1=1413697536 p2=1 p3=0
142:
WAIT #0: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
143:
WAIT #0: nam='SQL*Net message from client'
ela= 504 p1=1413697536 p2=1 p3=0
144:
=====================
145:
PARSING IN
CURSOR
#4 len=47 dep=1 uid=0 ct=3 lid=0 tim=10643870305677 hv=2232614812 ad='8ed4910'
146:
select
metadata from
kopm$ where
name='DB_FDO'
147:
END
OF
STMT
148:
PARSE #4:c=0,e=57,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870305669
149:
BINDS #4:
150:
EXEC
#4:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870305791
151:
FETCH
#4:c=0,e=17,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870305836
152:
STAT #4 id=1 cnt=1 pid=0 pos=1 bj=350 p='TABLE ACCESS BY INDEX ROWID KOPM$ '
153:
STAT #4 id=2 cnt=1 pid=1 pos=1 bj=351 p='INDEX UNIQUE SCAN I_KOPM1 '
154:
WAIT #0: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
155:
WAIT #0: nam='SQL*Net message from client'
ela= 779 p1=1413697536 p2=1 p3=0
156:
WAIT #0: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
157:
WAIT #0: nam='SQL*Net message from client'
ela= 816 p1=1413697536 p2=1 p3=0
158:
=====================
159:
PARSING IN
CURSOR
#7 len=121 dep=0 uid=37 ct=3 lid=37 tim=10643870308650 hv=3709805476 ad='5e42fe0'
160:
select
text from
ALL_TYPE_VERSIONS where
wner = 'SDE'
and
type_name = upper
(:type_name) and
text like
'%C_Type_Release%'
161:
END
OF
STMT
162:
PARSE #7:c=0,e=139,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870308642
163:
BINDS #7:
164:
bind 0: dty=1 mxl=32(22) mal=00 scl=00 pre=00 acflg=20 oacfl2=c000000600000010 size
=32 ffset=0
165:
bfp=800003fa00073008 bln=32 avl=11 flg=05
166:
value
="ST_GEOMETRY"
167:
EXEC
#7:c=0,e=1020,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870309752
168:
WAIT #7: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
169:
FETCH
#7:c=0,e=281,p=0,cr=11,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870310100
170:
WAIT #7: nam='SQL*Net message from client'
ela= 934 p1=1413697536 p2=1 p3=0
171:
STAT #7 id=1 cnt=1 pid=0 pos=1 bj=0 p='FILTER '
172:
STAT #7 id=2 cnt=1 pid=1 pos=1 bj=71 p='TABLE ACCESS BY INDEX ROWID SOURCE$ '
173:
STAT #7 id=3 cnt=26 pid=2 pos=1 bj=0 p='NESTED LOOPS '
174:
STAT #7 id=4 cnt=1 pid=3 pos=1 bj=0 p='NESTED LOOPS '
175:
STAT #7 id=5 cnt=1 pid=4 pos=1 bj=0 p='NESTED LOOPS '
176:
STAT #7 id=6 cnt=1 pid=5 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '
177:
STAT #7 id=7 cnt=1 pid=6 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '
178:
STAT #7 id=8 cnt=1 pid=5 pos=2 bj=18 p='TABLE ACCESS BY INDEX ROWID OBJ$ '
179:
STAT #7 id=9 cnt=2 pid=8 pos=1 bj=37 p='INDEX RANGE SCAN I_OBJ2 '
180:
STAT #7 id=10 cnt=1 pid=4 pos=2 bj=300 p='INDEX UNIQUE SCAN I_TYPE2 '
181:
STAT #7 id=11 cnt=24 pid=3 pos=2 bj=119 p='INDEX RANGE SCAN I_SOURCE1 '
182:
STAT #7 id=12 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS '
183:
STAT #7 id=13 cnt=0 pid=12 pos=1 bj=309 p='FIXED TABLE FULL X$KZSRO '
184:
STAT #7 id=14 cnt=0 pid=12 pos=2 bj=109 p='INDEX RANGE SCAN I_OBJAUTH2 '
185:
STAT #7 id=15 cnt=0 pid=1 pos=3 bj=310 p='FIXED TABLE FULL X$KZSPR '
186:
=====================
187:
PARSING IN
CURSOR
#7 len=142 dep=0 uid=37 ct=3 lid=37 tim=10643870311620 hv=3347668576 ad='8d986f0'
188:
SELECT
status,validated FROM
all_constraints WHERE
wner = :table_owner AND
constraint_name = :constraint_name AND
table_name = :table_name
189:
END
OF
STMT
190:
PARSE #7:c=0,e=124,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311612
191:
BINDS #7:
192:
bind 0: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=384 ffset=0
193:
bfp=800003f9c000a908 bln=128 avl=03 flg=05
194:
value
="SDE"
195:
bind 1: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=0 ffset=128
196:
bfp=800003f9c000a988 bln=128 avl=09 flg=01
197:
value
="STATES_FK"
198:
bind 2: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=0 ffset=256
199:
bfp=800003f9c000aa08 bln=128 avl=06 flg=01
200:
value
="STATES"
201:
EXEC
#7:c=0,e=174,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311876
202:
WAIT #7: nam='SQL*Net message to client'
ela= 2 p1=1413697536 p2=1 p3=0
203:
FETCH
#7:c=0,e=30,p=0,cr=4,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311970
204:
WAIT #7: nam='SQL*Net message from client'
ela= 583 p1=1413697536 p2=1 p3=0
205:
STAT #7 id=1 cnt=0 pid=0 pos=1 bj=0 p='FILTER '
206:
STAT #7 id=2 cnt=0 pid=1 pos=1 bj=0 p='NESTED LOOPS OUTER '
207:
STAT #7 id=3 cnt=0 pid=2 pos=1 bj=0 p='NESTED LOOPS OUTER '
208:
STAT #7 id=4 cnt=0 pid=3 pos=1 bj=0 p='NESTED LOOPS OUTER '
209:
STAT #7 id=5 cnt=0 pid=4 pos=1 bj=0 p='NESTED LOOPS OUTER '
210:
STAT #7 id=6 cnt=0 pid=5 pos=1 bj=0 p='NESTED LOOPS '
211:
STAT #7 id=7 cnt=0 pid=6 pos=1 bj=0 p='NESTED LOOPS OUTER '
212:
STAT #7 id=8 cnt=0 pid=7 pos=1 bj=0 p='NESTED LOOPS '
213:
STAT #7 id=9 cnt=0 pid=8 pos=1 bj=0 p='NESTED LOOPS '
214:
STAT #7 id=10 cnt=1 pid=9 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '
215:
STAT #7 id=11 cnt=1 pid=10 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '
216:
STAT #7 id=12 cnt=0 pid=9 pos=2 bj=28 p='TABLE ACCESS BY INDEX ROWID CON$ '
217:
STAT #7 id=13 cnt=0 pid=12 pos=1 bj=48 p='INDEX UNIQUE SCAN I_CON1 '
218:
STAT #7 id=14 cnt=0 pid=8 pos=2 bj=31 p='TABLE ACCESS BY INDEX ROWID CDEF$ '
219:
STAT #7 id=15 cnt=0 pid=14 pos=1 bj=50 p='INDEX UNIQUE SCAN I_CDEF1 '
220:
STAT #7 id=16 cnt=0 pid=7 pos=2 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '
221:
STAT #7 id=17 cnt=0 pid=6 pos=2 bj=18 p='TABLE ACCESS BY INDEX ROWID OBJ$ '
222:
STAT #7 id=18 cnt=0 pid=17 pos=1 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '
223:
STAT #7 id=19 cnt=0 pid=5 pos=2 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '
224:
STAT #7 id=20 cnt=0 pid=4 pos=2 bj=28 p='TABLE ACCESS BY INDEX ROWID CON$ '
225:
STAT #7 id=21 cnt=0 pid=20 pos=1 bj=49 p='INDEX UNIQUE SCAN I_CON2 '
226:
STAT #7 id=22 cnt=0 pid=3 pos=2 bj=22 p='TABLE ACCESS CLUSTER USER$ '
227:
STAT #7 id=23 cnt=0 pid=22 pos=1 bj=11 p='INDEX UNIQUE SCAN I_USER# '
228:
STAT #7 id=24 cnt=0 pid=2 pos=2 bj=22 p='TABLE ACCESS CLUSTER USER$ '
229:
STAT #7 id=25 cnt=0 pid=24 pos=1 bj=11 p='INDEX UNIQUE SCAN I_USER# '
230:
STAT #7 id=26 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS '
231:
STAT #7 id=27 cnt=0 pid=26 pos=1 bj=309 p='FIXED TABLE FULL X$KZSRO '
232:
STAT #7 id=28 cnt=0 pid=26 pos=2 bj=109 p='INDEX RANGE SCAN I_OBJAUTH2 '
233:
STAT #7 id=29 cnt=0 pid=1 pos=3 bj=310 p='FIXED TABLE FULL X$KZSPR '
234:
XCTEND rlbk=0, rd_only=1
235:
WAIT #0: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
236:
WAIT #0: nam='SQL*Net message from client'
ela= 739 p1=1413697536 p2=1 p3=0
237:
=====================
238:
PARSING IN
CURSOR
#7 len=82 dep=0 uid=37 ct=3 lid=37 tim=10643870314110 hv=1074646296 ad='8dba280'
239:
SELECT
major, minor, bugfix, description, release, sdesvr_rel_low FROM
SDE.version
240:
END
OF
STMT
241:
PARSE #7:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870314103
242:
BINDS #7:
243:
EXEC
#7:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870314206
244:
WAIT #7: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
245:
FETCH
#7:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870314315
246:
WAIT #7: nam='SQL*Net message from client'
ela= 938 p1=1413697536 p2=1 p3=0
247:
STAT #7 id=1 cnt=1 pid=0 pos=1 bj=156217 p='TABLE ACCESS FULL VERSION '
248:
=====================
249:
PARSING IN
CURSOR
#7 len=73 dep=0 uid=37 ct=3 lid=37 tim=10643870315460 hv=3244238113 ad='6e15f20'
250:
SELECT
prop_name, char_prop_value, num_prop_value FROM
SDE.SERVER_CONFIG
251:
END
OF
STMT
252:
PARSE #7:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870315453
253:
BINDS #7:
254:
EXEC
#7:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870315563
255:
WAIT #7: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
256:
FETCH
#7:c=0,e=84,p=0,cr=3,cu=0,mis=0,r=41,dep=0,og=4,tim=10643870315711
257:
WAIT #7: nam='SQL*Net message from client'
ela= 1391 p1=1413697536 p2=1 p3=0
258:
=====================
259:
PARSING IN
CURSOR
#8 len=31 dep=0 uid=37 ct=3 lid=37 tim=10643870317246 hv=2813680287 ad='5e338e0'
260:
SELECT
COUNT
(*) FROM
SDE.LAYERS
261:
END
OF
STMT
262:
PARSE #8:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870317239
263:
BINDS #8:
264:
EXEC
#8:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870317351
265:
WAIT #8: nam='SQL*Net message to client'
ela= 1 p1=1413697536 p2=1 p3=0
266:
FETCH
#8:c=0,e=58,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870317464
267:
WAIT #8: nam='SQL*Net message from client'
ela= 916 p1=1413697536 p2=1 p3=0
268:
XCTEND rlbk=0, rd_only=1
269:
STAT #3 id=1 cnt=2 pid=0 pos=1 bj=222 p='TABLE ACCESS FULL DUAL '
270:
STAT #2 id=1 cnt=1 pid=0 pos=1 bj=0 p='MERGE JOIN '
271:
STAT #2 id=2 cnt=872 pid=1 pos=1 bj=59 p='FIXED TABLE FULL X$KSPPCV '
272:
STAT #2 id=3 cnt=1 pid=1 pos=2 bj=0 p='FILTER '
273:
STAT #2 id=4 cnt=1 pid=3 pos=1 bj=0 p='SORT JOIN '
274:
STAT #2 id=5 cnt=1 pid=4 pos=1 bj=58 p='FIXED TABLE FULL X$KSPPI '
275:
STAT #7 id=1 cnt=41 pid=0 pos=1 bj=156299 p='TABLE ACCESS FULL OBJ#(156299) '
276:
STAT #8 id=1 cnt=1 pid=0 pos=1 bj=0 p='SORT AGGREGATE '
277:
STAT #8 id=2 cnt=41 pid=1 pos=1 bj=156222 p='TABLE ACCESS FULL OBJ#(156222) '
278:
/****************************************************************************************************/
从后端执行的 sql 可以看出,还没有验证license信息就停止了,整个过程一共访问了以下几个sde的系统表: sde.version,sde.server_config,sde.layers
其中version表记录sde的版本信息,layers表记录层信息，这两个表出错的肯能性不是很大，而server_config表 记录的sde的配置信息，所以重点查看server_config表中是否有参数被修改过,经查看status参数被修改成2.
查看帮助status参数的意义: Values are 1 if this instance is accepting new connections or 2 if it is paused (not accepting new connections).
讲status改成1，问题解决。
至于为什么客户要这么修改，就不得而知了。
文章来源：http://blog.csdn.net/liufeng1980423/article/details/6072511
