ReSQL.ru
     
powered by simpleCommunicator - 2.0.53     © 2025 Programmizd 02
Мобильная версия    Контакт    Правила    FAQ    Помощь
Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр
Форумы / Oracle [игнор отключен] [закрыт для гостей] / падает листенер при переключении на экземляр
7 сообщений из 7, страница 1 из 1
падает листенер при переключении на экземляр
    #39869074
Фотография vava
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
vava
Участник
Добрый день, жил-был на ноуте (win10) oracle 12.2 и всё было нормально. После опытов с установкой weblogic, перестал работать листенер.
Выглядит так: листенер запускается, работает. Если экземпляр остановлен, то ответит что не знает такую БД ну и т.д.
Если экземпляр запущен, tnsping говорит OK, но при попытке переключить соединение с клиентом на БД, листенер падает.
В логах (в трейсах) - ошибка internal error [17099] DIA-48001.
Иногда успевает подключиться из SQL+ (любым пользователем), но листенер гибнет и тогда.
Направьте, в какую сторону копать. Вопрос, конечно, не жизни и смерти, но не переустанавливать же.

listener.ora:
 
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
# listener.ora Network Configuration File: C:\app\user\product\12.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

#DIAG_ADR_ENABLED_LISTENER = OFF

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\user\product\12.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ANY")
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\app\user\product\12.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ANY")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = glob3)
      (SID_NAME = glob3)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = pako)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app\user\product\12.2.0\dbhome_1\log

TRACE_LEVEL_LISTENER = ADMIN



tnsnames.ora:
 
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
# tnsnames.ora Network Configuration File: C:\app\user\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

# (PROTOCOL=TCP) (SERVICE=GLOB3XDB)
# (dispatchers='(PROTOCOL=TCP)', '(PROTOCOL=TCP)(SERVICE=ORCLXDB)')

GLOB3 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Pako)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = GLOB3)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )



sqlnet.ora:
 
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10



ну и ora_8380_16404.trc (тут немного - я оставил хвост) :
 
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
тут всякие ожидания и пр. - неограниченное время
попытка коннекта - в 12:20.57
…….
	WRITE
2019-09-30 12:18:45.538 : nttaddr2bnd:entry
2019-09-30 12:18:45.538 : snlinGetNameInfo:entry
2019-09-30 12:18:45.538 : snlinGetNameInfo:exit
2019-09-30 12:18:45.538 : nttaddr2bnd:exit
2019-09-30 12:18:45.539 : nsevfnt:cxd: 0x3e7f6e70 cid=3 stage 0: NS events set:
2019-09-30 12:18:45.539 : nsevwait:0 posted event(s)
2019-09-30 12:18:45.539 : nsevwait:4 registered connection(s)
2019-09-30 12:18:45.539 : nsevwait:0 pre-posted event(s)
2019-09-30 12:18:45.539 : nsevwait:waiting for transport event (0 thru 4)...
2019-09-30 12:20:57.310 : nsevwait:1 newly-posted event(s)
2019-09-30 12:20:57.311 : nttaddr2bnd:entry
2019-09-30 12:20:57.311 : snlinGetNameInfo:entry
2019-09-30 12:20:57.311 : snlinGetNameInfo:exit
2019-09-30 12:20:57.311 : nttaddr2bnd:exit
2019-09-30 12:20:57.311 : nsevfnt:cxd: 0x3dd787d0 cid=0 stage 0: NT events set:
	CONNECTION REQUEST
2019-09-30 12:20:57.311 : nttaddr2bnd:entry
2019-09-30 12:20:57.311 : snlinGetNameInfo:entry
2019-09-30 12:20:57.311 : snlinGetNameInfo:exit
2019-09-30 12:20:57.311 : nttaddr2bnd:exit
2019-09-30 12:20:57.311 : nsevfnt:cxd: 0x3dd787d0 cid=0 stage 0: NS events set:
	INCOMING CALL
2019-09-30 12:20:57.311 : nsevrec:event is 0x1, on 0
2019-09-30 12:20:57.311 : nsevwait:1 posted event(s)
2019-09-30 12:20:57.311 : nsglhe:entry
2019-09-30 12:20:57.311 : nsmal:1880 bytes at 0x3e875cc0
2019-09-30 12:20:57.311 : nsmal:3536 bytes at 0x3e89aad0
2019-09-30 12:20:57.311 : nstoSetupTimeout:ATO enabled for ctx=0x000001A33E875CC0, val=60000(millisecs)
2019-09-30 12:20:57.311 : nstoUpdateActive:Active timeout is 0 (see nstotyp)
2019-09-30 12:20:57.311 : nsopen:opening transport...
2019-09-30 12:20:57.311 : nttcon:entry
2019-09-30 12:20:57.311 : nttcon:toc = 3
2019-09-30 12:20:57.311 : nttcnp:entry
2019-09-30 12:20:57.312 : nttcnp:getting sockname
2019-09-30 12:20:57.312 : nttcnp:getting peername
2019-09-30 12:20:57.312 : nttcnp:exit
2019-09-30 12:20:57.312 : nttcnr:entry
2019-09-30 12:20:57.312 : nttcnr:waiting to accept a connection.
2019-09-30 12:20:57.312 : nttcnr:getting sockname
2019-09-30 12:20:57.312 : snlinGetNameInfo:entry
2019-09-30 12:20:57.312 : snlinGetNameInfo:exit
2019-09-30 12:20:57.312 : nttcnr:connected on source ipaddr fe80::d96a:7ccd:c517:7c89%23 port 1521
2019-09-30 12:20:57.312 : snlinGetNameInfo:entry
2019-09-30 12:20:57.312 : snlinGetNameInfo:exit
2019-09-30 12:20:57.312 : nttcnr:connected on destination ipaddr fe80::d96a:7ccd:c517:7c89%23 port 51783
2019-09-30 12:20:57.312 : nttvlser:entry
2019-09-30 12:20:57.312 : nlvlsern:entry
2019-09-30 12:20:57.312 : snlinGetNameInfo:entry
2019-09-30 12:20:57.312 : snlinGetNameInfo:exit
2019-09-30 12:20:57.312 : nttvlser:valid node check on incoming node fe80::d96a:7ccd:c517:7c89%23
2019-09-30 12:20:57.312 : nttvlser:Accepted Entry: fe80::d96a:7ccd:c517:7c89%23
2019-09-30 12:20:57.312 : nttcnr:exit
2019-09-30 12:20:57.312 : nttctl:entry
2019-09-30 12:20:57.312 : nttctl:Setting connection into nodelay mode
2019-09-30 12:20:57.312 : nttctl:set TCP_NODELAY on 1404
2019-09-30 12:20:57.312 : nttcon:exit
2019-09-30 12:20:57.312 : nsopen:transport is open
2019-09-30 12:20:57.312 : nsnainit:answer
2019-09-30 12:20:57.312 : nsnasvnainfo:NA disabled for this connection
2019-09-30 12:20:57.312 : nainit:entry
2019-09-30 12:20:57.312 : nagblini:entry
2019-09-30 12:20:57.313 : nau_gin:entry
2019-09-30 12:20:57.313 : nau_gparams:entry
2019-09-30 12:20:57.313 : nam_gbp:Reading parameter "sqlnet.authentication_required" from parameter file
2019-09-30 12:20:57.313 : nam_gbp:Parameter not found
2019-09-30 12:20:57.313 : nau_gparams:Using default value "FALSE"
2019-09-30 12:20:57.313 : nau_gslf:entry
2019-09-30 12:20:57.313 : nam_gic:entry
2019-09-30 12:20:57.313 : nam_gic:Counting # of items in "sqlnet.authentication_services" parameter
2019-09-30 12:20:57.313 : nam_gic:Parameter not found
2019-09-30 12:20:57.313 : nam_gic:Found 0 items
2019-09-30 12:20:57.313 : nam_gic:exit
2019-09-30 12:20:57.313 : nau_gslf:Using default value "all available adapters"
2019-09-30 12:20:57.313 : nauss_set_state:entry
2019-09-30 12:20:57.313 : nauss_set_state:exit
2019-09-30 12:20:57.313 : nau_gslf:exit
2019-09-30 12:20:57.313 : nau_gparams:exit
2019-09-30 12:20:57.313 : nau_gin:exit
2019-09-30 12:20:57.313 : nagblini:exit
2019-09-30 12:20:57.313 : na_saveprot:entry
2019-09-30 12:20:57.313 : na_saveprot:exit
2019-09-30 12:20:57.313 : nacomin:entry
2019-09-30 12:20:57.313 : nas_init:entry
2019-09-30 12:20:57.313 : nas_init:exit
2019-09-30 12:20:57.313 : nau_ini:entry
2019-09-30 12:20:57.313 : naugcp_get_connect_parameters:entry
2019-09-30 12:20:57.313 : nauss_set_state:entry
2019-09-30 12:20:57.313 : nauss_set_state:exit
2019-09-30 12:20:57.313 : naugcp_get_connect_parameters:exit
2019-09-30 12:20:57.313 : nau_gfauth:entry
2019-09-30 12:20:57.313 : nam_gbp:Reading parameter "sqlnet.fallback_authentication" from parameter file
2019-09-30 12:20:57.313 : nam_gbp:Parameter not found
2019-09-30 12:20:57.313 : nau_gfauth:Using default value "FALSE"
2019-09-30 12:20:57.313 : nau_gfauth:exit
2019-09-30 12:20:57.313 : nau_gettab:entry
2019-09-30 12:20:57.313 : nau_gettab:exit
2019-09-30 12:20:57.313 : nau_sini:entry
2019-09-30 12:20:57.313 : nau_sini:exit
2019-09-30 12:20:57.313 : nau_ini:exit
2019-09-30 12:20:57.314 : naeeinit:entry
2019-09-30 12:20:57.314 : nam_gbp:Reading parameter "SQLNET.FIPS_140" from parameter file
2019-09-30 12:20:57.314 : nam_gbp:Parameter not found
2019-09-30 12:20:57.314 : naeconp:entry
2019-09-30 12:20:57.314 : naeconp:Reading ENCRYPTION_CLIENT or CRYPTO_CHECKSUM_CLIENT parameter from connection string.
2019-09-30 12:20:57.314 : nam_gnsp:Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter file
2019-09-30 12:20:57.314 : nam_gnsp:Parameter not found
2019-09-30 12:20:57.314 : naequad:Using default value "ACCEPTED"
2019-09-30 12:20:57.314 : nam_gbp:Reading parameter "SQLNET._ENHANCED_LOGON_PROTECTION" from parameter file
2019-09-30 12:20:57.314 : nam_gbp:Parameter not found
2019-09-30 12:20:57.314 : nam_gic:entry
2019-09-30 12:20:57.314 : nam_gic:Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER" parameter
2019-09-30 12:20:57.314 : nam_gic:Parameter not found
2019-09-30 12:20:57.314 : nam_gic:exit
2019-09-30 12:20:57.314 : naesno:Using default value "all available algorithms"
2019-09-30 12:20:57.314 : naeshow:entry
2019-09-30 12:20:57.314 : naeshow:exit
2019-09-30 12:20:57.314 : naeeinit:exit
2019-09-30 12:20:57.314 : naecinit:entry
2019-09-30 12:20:57.314 : naeconp:entry
2019-09-30 12:20:57.314 : naeconp:Reading ENCRYPTION_CLIENT or CRYPTO_CHECKSUM_CLIENT parameter from connection string.
2019-09-30 12:20:57.314 : nam_gnsp:Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from parameter file
2019-09-30 12:20:57.314 : nam_gnsp:Parameter not found
2019-09-30 12:20:57.314 : naequad:Using default value "ACCEPTED"
2019-09-30 12:20:57.314 : nam_gic:entry
2019-09-30 12:20:57.314 : nam_gic:Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" parameter
2019-09-30 12:20:57.314 : nam_gic:Parameter not found
2019-09-30 12:20:57.314 : nam_gic:exit
2019-09-30 12:20:57.314 : naesno:Using default value "all available algorithms"
2019-09-30 12:20:57.315 : naeshow:entry
2019-09-30 12:20:57.315 : naeshow:exit
2019-09-30 12:20:57.315 : naecinit:exit
2019-09-30 12:20:57.315 : nadisc:entry
2019-09-30 12:20:57.315 : nacomtm:entry
2019-09-30 12:20:57.315 : nacompd:entry
2019-09-30 12:20:57.315 : nacompd:exit
2019-09-30 12:20:57.315 : nacompd:entry
2019-09-30 12:20:57.315 : nacompd:exit
2019-09-30 12:20:57.315 : nacomtm:exit
2019-09-30 12:20:57.315 : nas_dis:entry
2019-09-30 12:20:57.315 : nas_dis:exit
2019-09-30 12:20:57.315 : nau_dis:entry
2019-09-30 12:20:57.315 : nau_dis:exit
2019-09-30 12:20:57.315 : naeetrm:entry
2019-09-30 12:20:57.315 : naeetrm:exit
2019-09-30 12:20:57.315 : naectrm:entry
2019-09-30 12:20:57.315 : naectrm:exit
2019-09-30 12:20:57.315 : nagbltrm:entry
2019-09-30 12:20:57.315 : nau_gtm:entry
2019-09-30 12:20:57.315 : nau_gtm:exit
2019-09-30 12:20:57.315 : nagbltrm:exit
2019-09-30 12:20:57.315 : nadisc:exit
2019-09-30 12:20:57.315 : nainit:exit
2019-09-30 12:20:57.315 : nsnainit:NS Connection version: 316
2019-09-30 12:20:57.315 : nsnainit:inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
2019-09-30 12:20:57.315 : nsnainit:"or" info flags: 0xd	Translations follow:
	native service(s) is (are) wanted
	NA disabled remotely for this connection
	NA services unavailable on both processes - negotiation not needed

2019-09-30 12:20:57.315 : nsnainit:"or" info flags: 0xd	Translations follow:
	native service(s) is (are) wanted
	NA disabled remotely for this connection
	NA services unavailable on both processes - negotiation not needed
"and" info flags: 0xd	Translations follow:
	native service(s) is (are) wanted
	NA disabled remotely for this connection
	NA services unavailable on both processes - negotiation not needed

2019-09-30 12:20:57.315 : nsopen:global context check-in (to slot 5) complete
2019-09-30 12:20:57.315 : nsopen:lcl[0]=0xf4ffefff, lcl[1]=0x12003, gbl[0]=0x7abf, gbl[1]=0x2001, tdu=2097152, sdu=8192
2019-09-30 12:20:57.315 : nsfull_opn:cid=5, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x0
2019-09-30 12:20:57.315 : nsfull_opn:nsctx: state=7, flg=0x4000, mvd=0
2019-09-30 12:20:57.315 : nsmal:168 bytes at 0x3e89bba0
2019-09-30 12:20:57.315 : nsmal:168 bytes at 0x3e89c8b0
2019-09-30 12:20:57.316 : nsanswer:deferring connect attempt; at stage 5
2019-09-30 12:20:57.316 : nttaddr2bnd:entry
2019-09-30 12:20:57.316 : snlinGetNameInfo:entry
2019-09-30 12:20:57.316 : snlinGetNameInfo:exit
2019-09-30 12:20:57.316 : nttaddr2bnd:exit
2019-09-30 12:20:57.316 : nsevreg:begin registration process for 5
2019-09-30 12:20:57.316 : nsevreg:sgt=0, evn=4, evt[2]=0x0
2019-09-30 12:20:57.316 : nsevreg:begin notification process for 5
2019-09-30 12:20:57.316 : nsrah:setting transport read mode (2)
2019-09-30 12:20:57.316 : nttctl:entry
2019-09-30 12:20:57.316 : nttctl:Clearing non-blocking mode
2019-09-30 12:20:57.316 : nttctl:entry
2019-09-30 12:20:57.316 : nttctl:Setting connection into async mode
2019-09-30 12:20:57.316 : nsevreg:rdm=2, sgt=0, evt[0]=0x20, [1]=0x20, [2]=0x0, nrg=0
2019-09-30 12:20:57.316 : nsevreg:registering for 0x20
2019-09-30 12:20:57.316 : nttmrd:entry
2019-09-30 12:20:57.316 : nttrd:entry
2019-09-30 12:20:57.316 : ntt2err:entry
2019-09-30 12:20:57.316 : ntt2err:soc 1404 error - operation=5, ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0
2019-09-30 12:20:57.316 : ntt2err:exit
2019-09-30 12:20:57.316 : nttrd:exit
2019-09-30 12:20:57.316 : nsglhe:exit
2019-09-30 12:20:57.316 : nsevwait:5 registered connection(s)
2019-09-30 12:20:57.316 : nsevwait:0 pre-posted event(s)
2019-09-30 12:20:57.316 : nsevwait:waiting for transport event (0 thru 5)...
2019-09-30 12:20:57.316 : snttcallback:entry
2019-09-30 12:20:57.316 : snttcallback:op = 5, bytes = 266, err = 0
2019-09-30 12:20:57.316 : snttcallback:exit
2019-09-30 12:20:57.316 : nsevwait:0 newly-posted event(s)
2019-09-30 12:20:57.316 : nttaddr2bnd:entry
2019-09-30 12:20:57.316 : snlinGetNameInfo:entry
2019-09-30 12:20:57.316 : snlinGetNameInfo:exit
2019-09-30 12:20:57.317 : nttaddr2bnd:exit
2019-09-30 12:20:57.317 : nsevfnt:cxd: 0x3e8c9ab0 cid=5 stage 5: NT events set:
	READ
2019-09-30 12:20:57.317 : nttaddr2bnd:entry
2019-09-30 12:20:57.317 : snlinGetNameInfo:entry
2019-09-30 12:20:57.317 : snlinGetNameInfo:exit
2019-09-30 12:20:57.317 : nttaddr2bnd:exit
2019-09-30 12:20:57.317 : nsevfnt:cxd: 0x3e8c9ab0 cid=5 stage 5: NS events set:
	OUTGOING CALL COMPLETE
	(ADDRESS=(PROTOCOL=tcp)(HOST=fe80::d96a:7ccd:c517:7c89%23)(PORT=51783))
2019-09-30 12:20:57.317 : nsevdansw:at STAGE 5
2019-09-30 12:20:57.317 : nsdo:cid=5, opcode=68, *bl=2040, *what=8, uflgs=0x0, cflgs=0x3
2019-09-30 12:20:57.317 : nsdo:rank=64, nsctxrnk=0
2019-09-30 12:20:57.317 : nsdo:nsctx: state=14, flg=0x20004004, mvd=0
2019-09-30 12:20:57.317 : nsdo:gtn=10, gtc=10, ptn=10, ptc=8111
2019-09-30 12:20:57.317 : nscon:doing connect handshake...
2019-09-30 12:20:57.317 : nscon:recving a packet
2019-09-30 12:20:57.317 : nsprecv:266 bytes from leftover
2019-09-30 12:20:57.317 : nsprecv:tlen=266, plen=266, type=1
2019-09-30 12:20:57.317 : nscon:got NSPTCN packet
2019-09-30 12:20:57.317 : nsconneg:vsn=314, lov=300, opt=0x41, sdu=8192, tdu=32767, ntc=0xc60e
2019-09-30 12:20:57.317 : nsconneg:after negotiation compression flag=0 
2019-09-30 12:20:57.317 : nsconneg:vsn=314, gbl=0x1, sdu=8192, tdu=32767
2019-09-30 12:20:57.317 : nscon:connect id = 0x0000
2019-09-30 12:20:57.317 : nscon:got 208 bytes connect data
2019-09-30 12:20:57.317 : nsdo:nsctxrnk=0
2019-09-30 12:20:57.317 : nsevdansw:exit
2019-09-30 12:20:57.317 : nsevrec:event is 0x20, on 5
2019-09-30 12:20:57.317 : nsevwait:1 posted event(s)
2019-09-30 12:20:57.318 : nsglhe:entry
2019-09-30 12:20:57.318 : nsglfc:Assume establishing a connection...
2019-09-30 12:20:57.318 : nsglfc:command = establish
2019-09-30 12:20:57.318 : nsglauthorized:entry
2019-09-30 12:20:57.318 : nsglecmd:entry
2019-09-30 12:20:57.318 : nstoClearTimeout:ATO disabled for ctx=0x000001A33E875CC0
2019-09-30 12:20:57.318 : nstoUpdateActive:Active timeout is -1 (see nstotyp)
2019-09-30 12:20:57.318 : nstoControlATO:ATO disabled for ctx=0x000001A33E875CC0
2019-09-30 12:20:57.318 : nscontrol:cmd=26, lcl=0x0
2019-09-30 12:20:57.318 : nsglbgetRSPidx:entry
2019-09-30 12:20:57.318 : nsglbgetRSPidx:returning ecode=0
2019-09-30 12:20:57.318 : nsglbgetRSPidx:exit
2019-09-30 12:20:57.318 : nsgettrans_bycxdwattr:entry
2019-09-30 12:20:57.318 : ntgettrans:entry
2019-09-30 12:20:57.318 : ntgettrans:exit
2019-09-30 12:20:57.318 : nsgettrans_bycxdwattr:exit
2019-09-30 12:20:57.318 : nsglbgetSdPidx:secondary protocol=2
2019-09-30 12:20:57.318 : nsglb:entry
2019-09-30 12:20:57.318 : nsglb:instance:GLOB3 new lbscore:1
2019-09-30 12:20:57.318 : nsglb:exit
2019-09-30 12:20:57.318 : nsgettrans_bycxd:entry
2019-09-30 12:20:57.318 : ntgettrans:entry
2019-09-30 12:20:57.318 : ntgettrans:exit
2019-09-30 12:20:57.318 : nsgettrans_bycxd:exit
2019-09-30 12:20:57.319 : nsc2addr:(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=C:\app\user\product\12.2.0\dbhome_1\bin\oracle.exe)(ARGV0='oracleglob3')(ARGS='(LOCAL=NO)'))
2019-09-30 12:20:57.320 : nlpcaini:entry
2019-09-30 12:20:57.320 : nlpcaini:prg = C:\app\user\product\12.2.0\dbhome_1\bin\oracle.exe
2019-09-30 12:20:57.320 : nlpcaini:arg[0] = oracleglob3
2019-09-30 12:20:57.320 : nlpcaini:arg[1] = (LOCAL=NO)
2019-09-30 12:20:57.320 : nlpcaini:env[0] = ALLUSERSPROFILE=C:\ProgramData
2019-09-30 12:20:57.320 : nlpcaini:exit
2019-09-30 12:20:57.320 : nsbeqaddr:connecting...
2019-09-30 12:20:57.320 : nsmal:1880 bytes at 0x3e86f500
2019-09-30 12:20:57.320 : nsmal:3536 bytes at 0x3e82b620
2019-09-30 12:20:57.320 : nsmal:168 bytes at 0x3e89c490
2019-09-30 12:20:57.320 : ntpcon:entry
2019-09-30 12:20:57.320 : ntpcon:toc = 6
2019-09-30 12:20:57.320 : ntpcon:exit
2019-09-30 12:20:57.320 : nsopen:opening transport...
2019-09-30 12:20:57.320 : ntpcon:entry
2019-09-30 12:20:57.320 : ntpcon:toc = 1
2019-09-30 12:20:57.320 : sntpcall:entry
2019-09-30 12:20:57.320 : snlpcss:entry
2019-09-30 12:20:57.322 : snlpcss:Spawn Oracle completed oracle      (LOCAL=NO) glob3.
2019-09-30 12:20:57.323 : snlpcss:exit
2019-09-30 12:20:57.323 : sntpcall:Attempting to open pipe \\.\PIPE\ORANTP29C8.4088
2019-09-30 12:20:57.339 : sntpcall:Successfully established pipe 1564 to child with 0 retries.
2019-09-30 12:20:57.339 : sntpcall:Attempting to open pipe \\.\PIPE\ORANTP29C8.4088.w
2019-09-30 12:20:57.339 : sntpcall:Successfully established pipe 852 to child with 0 retries.
2019-09-30 12:20:57.339 : sntpcall:exit
2019-09-30 12:20:57.339 : ntpcon:NT layer IPC connection has been established.
2019-09-30 12:20:57.340 : ntpcon:exit
2019-09-30 12:20:57.340 : nsopen:transport is open
2019-09-30 12:20:57.340 : nsoptions:lcl[0]=0x0, lcl[1]=0x2006, gbl[0]=0x0, gbl[1]=0x0, cha=0x0
2019-09-30 12:20:57.340 : nsoptions:lcl[0]=0xf4ffe9ff, lcl[1]=0x6016, gbl[0]=0xe881, gbl[1]=0x0
2019-09-30 12:20:57.340 : nsopen:global context check-in (to slot 6) complete
2019-09-30 12:20:57.340 : nsopen:lcl[0]=0xf4ffe9ff, lcl[1]=0x6016, gbl[0]=0xe881, gbl[1]=0x0, tdu=4096, sdu=8192
2019-09-30 12:20:57.340 : nsfull_opn:cid=6, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x0
2019-09-30 12:20:57.340 : nsfull_opn:nsctx: state=7, flg=0x4001, mvd=0
2019-09-30 12:20:57.342 : nttaddr2bnd:entry
2019-09-30 12:20:57.342 : snlinGetNameInfo:entry
2019-09-30 12:20:57.342 : snlinGetNameInfo:exit
2019-09-30 12:20:57.342 : nttaddr2bnd:exit
2019-09-30 12:20:57.342 : nsbequeath_stg2:doing connect handshake...
2019-09-30 12:20:57.343 : nsgettrans_bycxd:entry
2019-09-30 12:20:57.343 : ntgettrans:entry
2019-09-30 12:20:57.343 : ntgettrans:exit
2019-09-30 12:20:57.343 : nsgettrans_bycxd:exit
2019-09-30 12:20:57.343 : nsbequeath:doing connect handshake...
2019-09-30 12:20:57.343 : ntpwr:entry
2019-09-30 12:20:57.343 : sntpwrite:entry
2019-09-30 12:20:57.343 : sntpwrite:Attempting to write 4 bytes to handle 1564
2019-09-30 12:20:57.343 : sntpwrite:WriteFile returned 4 bytes
2019-09-30 12:20:57.343 : sntpwrite:exit
2019-09-30 12:20:57.343 : ntpwr:exit
2019-09-30 12:20:57.343 : ntpwr:entry
2019-09-30 12:20:57.343 : sntpwrite:entry
2019-09-30 12:20:57.343 : sntpwrite:Attempting to write 80 bytes to handle 1564
2019-09-30 12:20:57.343 : sntpwrite:WriteFile returned 80 bytes
2019-09-30 12:20:57.343 : sntpwrite:exit
2019-09-30 12:20:57.343 : ntpwr:exit
2019-09-30 12:20:57.343 : ntpwr:entry
2019-09-30 12:20:57.343 : sntpwrite:entry
2019-09-30 12:20:57.343 : sntpwrite:Attempting to write 8 bytes to handle 1564
2019-09-30 12:20:57.343 : sntpwrite:WriteFile returned 8 bytes
2019-09-30 12:20:57.343 : sntpwrite:exit
2019-09-30 12:20:57.343 : ntpwr:exit
2019-09-30 12:20:57.343 : ntprd:entry
2019-09-30 12:20:57.343 : sntpread:entry
2019-09-30 12:20:57.343 : sntpread:Attempting to read 4 bytes from handle 852
2019-09-30 12:20:57.343 : sntpread:ReadFile returned 4 bytes
2019-09-30 12:20:57.343 : sntpread:rc = 0, ntresnt[0] = 0
2019-09-30 12:20:57.343 : sntpread:exit
2019-09-30 12:20:57.343 : ntprd:exit
2019-09-30 12:20:57.343 : ntprd:entry
2019-09-30 12:20:57.343 : sntpread:entry
2019-09-30 12:20:57.344 : sntpread:Attempting to read 4 bytes from handle 852
2019-09-30 12:20:57.344 : sntpread:ReadFile returned 4 bytes
2019-09-30 12:20:57.344 : sntpread:rc = 0, ntresnt[0] = 0
2019-09-30 12:20:57.344 : sntpread:exit
2019-09-30 12:20:57.344 : ntprd:exit
2019-09-30 12:20:57.344 : nsbequeath:NSE=12586
2019-09-30 12:20:57.344 : nsbequeath:error reading REDIR/NSE msg
2019-09-30 12:20:57.344 : nserror:nsres: id=5, op=72, ns=12586, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
2019-09-30 12:20:57.344 : nsdo:cid=5, opcode=67, *bl=0, *what=13, uflgs=0x0, cflgs=0x3
2019-09-30 12:20:57.344 : nsdo:rank=64, nsctxrnk=0
2019-09-30 12:20:57.344 : nsdo:nsctx: state=2, flg=0xa0004004, mvd=0
2019-09-30 12:20:57.344 : nsdo:gtn=266, gtc=266, ptn=10, ptc=8111
2019-09-30 12:20:57.344 : nscon:sending NSPTRS packet
2019-09-30 12:20:57.344 : nspsend:plen=8, type=11
2019-09-30 12:20:57.344 : nttmwr:entry
2019-09-30 12:20:57.344 : nttwr:entry
2019-09-30 12:20:57.344 : ntt2err:entry
2019-09-30 12:20:57.344 : ntt2err:soc 1404 error - operation=6, ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0
2019-09-30 12:20:57.344 : ntt2err:exit
2019-09-30 12:20:57.344 : nttwr:exit
2019-09-30 12:20:57.344 : nsmal:168 bytes at 0x3e89c960
2019-09-30 12:20:57.344 : nspsend:8 bytes to transport
2019-09-30 12:20:57.344 : nsdo:nsctxrnk=0
2019-09-30 12:20:57.344 : nsvntx_dei:entry
DDE previous invocation failed before phase II

DDE was called in a 'No Invocation Mode'

----- Start Diag Diagnostic Dump -----
Diagnostic dump is performed due to an error in the diagfw code during error handling.
DDE is switched to protected mode during the diagnostic dump to prevent recursive errors in the error handling code.
Dump error and call stack for the diagnostic dump:
Starting a Diag Context default dump (level=1)
DIA-48001: internal error code, arguments: [17099], [0x8C3BCFDC00], [0x8C3B9F3230], [0x1A33D792E30], [], [], [], []


----- Call Stack Trace -----
2019-09-30 12:20:57.364 : snttcallback:entry
2019-09-30 12:20:57.364 : snttcallback:op = 6, bytes = 8, err = 0
2019-09-30 12:20:57.364 : snttcallback:exit
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
Encountered exception while getting args for function:0x00007FFDA5BE312F
Encountered exception while getting args for function:0x00007FFDA5B4D490
DDE: Flood control is not active
dbgexExecuteIntDiag  CALL???  dbgc_dmp()           FFFFFFFF93A2D110
Dmp()+1564                                         FFFFFFFF9414F090 000000000 ?
                                                   000000000 ?
dbgexExecuteDiagDmp  CALL???  dbgexExecuteIntDiag  03D77F520 000000000
()+18                         Dmp()                000000000 ? 000000000 ?
dbgeBeginInvoke()+2  CALL???  dbgexExecuteDiagDmp  03D77F520 000000000 ?
68                            ()                   000000000 ? 000000000 ?
dbgePostErrorKGE()+  CALL???  dbgeBeginInvoke()    03B9EA138 03D792E30
2072                                               000000000 ? 000000000 ?
kgeade()+453         CALL???  dbgePostErrorKGE()   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kgeriv_int()+142     CALL???  kgeade()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kgeriv()+40          CALL???  kgeriv_int()         000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
Warning! DDE is invoked in protected mode. DDE call is aborted.

********** Internal heap ERROR 17183 addr=000001A33DCA70F8 *********

...
Рейтинг: 0 / 0
30.09.2019, 12:49
| Ответить | Цитировать | Написать  
падает листенер при переключении на экземляр
    #39869104
Als1973
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Als1973
Участник
vava,
Weblogic выставляет свой ORACLE_HOME, посмотри переменные окружения.
...
Рейтинг: 0 / 0
30.09.2019, 13:23
| Ответить | Цитировать | Написать  
падает листенер при переключении на экземляр
    #39869204
Фотография vava
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
vava
Участник
Als1973,
Проверил, удалил лишние (да, они были). Оставил один. Проблема осталась.

Выглядит так:
1) сервисы остановлены:
 
Код: powershell
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
PS C:\Users\user> lsnrctl services

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 30-SEP-2019 14:36:15

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pako)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error

- вполне ожидаемо.

2) запущен только листенер:
 
Код: powershell
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
PS C:\Users\user> lsnrctl services

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 30-SEP-2019 14:36:40

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pako)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "glob3" has 1 instance(s).
  Instance "glob3", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully

- пока нормально.

3) запущены и листенер и БД:
 
Код: powershell
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
PS C:\Users\user> lsnrctl services

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 30-SEP-2019 14:37:59

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pako)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "GLOB3XDB" has 1 instance(s).
  Instance "GLOB3", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: PAKO, pid: 10332>
         (ADDRESS=(PROTOCOL=tcp)(HOST=Pako)(PORT=50029))
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "glob3" has 2 instance(s).
  Instance "GLOB3", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
  Instance "glob3", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully

- а вот тут уже что-то лишнее, какие-то остатки weblogic. Или, может, это диспетчер shared-подключений?
...
Рейтинг: 0 / 0
30.09.2019, 15:08
| Ответить | Цитировать | Написать  
падает листенер при переключении на экземляр
    #39869208
Фотография andrey_anonymous
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
andrey_anonymous
Участник
vava Или, может, это диспетчер shared-подключений?
БД зарегистрировала свои сервисы в дополнение к сервисам из конфига листенера, это нормально.
Если не хотите дублей - уберите сервисы из listener.ora (статическая регистрация нужна только для удаленного входа системными аккаунтами на лежащую БД с целью её поднятия)
...
Рейтинг: 0 / 0
30.09.2019, 15:11
| Ответить | Цитировать | Написать  
падает листенер при переключении на экземляр
    #39869209
Фотография vava
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
vava
Участник
Да, вот ещё листенер статус:
Код: powershell
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
PS C:\Users\user> lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 30-SEP-2019 15:08:55

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pako)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date                30-SEP-2019 14:36:30
Uptime                    0 days 0 hr. 32 min. 24 sec
Trace Level               admin
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\user\product\12.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         C:\app\user\product\12.2.0\dbhome_1\log\diag\tnslsnr\Pako\listener\alert\log.xml
Listener Trace File       C:\app\user\product\12.2.0\dbhome_1\log\diag\tnslsnr\Pako\listener\trace\ora_1240_1316.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Pako)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=Pako)(PORT=5500))(Security=(my_wallet_directory=C:\APP\USER\admin\GLOB3\xdb_wallet))(Pr
esentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "GLOB3XDB" has 1 instance(s).
  Instance "GLOB3", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "glob3" has 2 instance(s).
  Instance "GLOB3", status READY, has 1 handler(s) for this service...
  Instance "glob3", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


Порт 5500 и пр. - это вроде административная консоль. Но вот "my_wallet_directory" - остатки опытов с SSL.
...
Рейтинг: 0 / 0
30.09.2019, 15:12
| Ответить | Цитировать | Написать  
падает листенер при переключении на экземляр
    #39869680
Als1973
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Als1973
Участник
vava,

Опять же переменная окружения TNS_ADMIN
...
Рейтинг: 0 / 0
01.10.2019, 09:23
| Ответить | Цитировать | Написать  
падает листенер при переключении на экземляр
    #39870359
Фотография vava
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
vava
Участник
Als1973,
TNS_ADMIN смотрит в орахоум.

По поотоколу BEQ подключается и sql+ и оракл девелопер на джаве.
...
Рейтинг: 0 / 0
02.10.2019, 09:27
| Ответить | Цитировать | Написать  
7 сообщений из 7, страница 1 из 1
Форумы / Oracle [игнор отключен] [закрыт для гостей] / падает листенер при переключении на экземляр
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение
NoSQL.ru       Новости, Чат       Фотоальбом: Участники, Встречи
Закрыть
start [/forum/topic.php?fid=52&msg=39869680&tid=1882024]:
 0ms
get settings:
 11ms
get forum list:
 14ms
check forum access:
 4ms
check topic access:
 4ms
track hit:
 40ms
get topic data:
 12ms
get forum data:
 3ms
get page messages:
 50ms
get tp. blocked users:
 1ms
others: 260ms
total:  399ms
созд. / загр.: 399ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]