TNS listener oracle 12 / Oracle

ReSQL.ru

Мобильная версия Контакт Правила FAQ Помощь

Гость

Войти | Регистрация | Профиль | Очистить

Новые сообщения | Избранное

Форумы | Пользователи | Статистика | Мод. лог | Поиск

Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр

Форумы / Oracle [игнор отключен] [закрыт для гостей] / TNS listener oracle 12

13 сообщений из 13, страница 1 из 1

TNS listener oracle 12

#38594537

daaapd

Участник

Сообщения: 187

Рейтинг: 0 / 0

Здравствуйте форумчане
Поставил Oracle 12c и периодически не могу к TNS не одной из клиентских программ(в том числе и sqlplus) не могу подключиться, захожу на сервере подключаюсь локально все работает, через TNS также не работает.
Перезагружаю Listener на сервере все нормально работает
Переодичность где 1,2 раза в неделю

...

Рейтинг:

0 / 0

24.03.2014, 13:51

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38594545

tru55

Участник

Откуда: СПб

Сообщения: 16 884

Рейтинг: 0 / 0

как минимум, listener.log

...

Рейтинг:

0 / 0

24.03.2014, 13:52

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38595293

daaapd

Участник

Сообщения: 187

Рейтинг: 0 / 0

tru55, Вот лог в момент когда не подключался и до перезапуска listener
Mon Mar 24 14:39:17 2014
24-MAR-2014 14:39:11 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53721)) * establish * PROD01 * 0
Trace information written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\trace\ora_3376_3992.trc
24-MAR-2014 14:39:38 * trace * 0
24-MAR-2014 14:39:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * services * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=OR01-HQ.aesi.loc)(PORT=5500))(Security=(my_wallet_directory=E:\ORACLE\admin\PROD01\xdb_wallet))(Presentation=HTTP)(Session=RAW))
System parameter file is E:\oracle\product\12.1.0\db_1\network\admin\listener.ora
Trace information written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\trace\ora_3376_3992.trc
Trace level is currently 0
Log messages written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\alert\log.xml
24-MAR-2014 14:40:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * reload * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=OR01-HQ.aesi.loc)(PORT=5500))(Security=(my_wallet_directory=E:\ORACLE\admin\PROD01\xdb_wallet))(Presentation=HTTP)(Session=RAW))
24-MAR-2014 14:40:02 * service_register * prod01 * 0
24-MAR-2014 14:40:12 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53722)) * establish * PROD01 * 0
24-MAR-2014 14:40:38 * (CONNECT_DATA=(SERVICE_NAME=prod01.aesi.loc)(CID=(PROGRAM=D:\studio\oracle\product\11.2.0\cl_2\bin\sqlplus.exe)(HOST=GRECHISHNIKOV-W)(USER=OV.Grechishnikov))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.88)(PORT=12240)) * establish * prod01.aesi.loc * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OR01-HQ.aesi.loc)(PORT=1521)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=OR01-HQ.aesi.loc)(PORT=5500))(Security=(my_wallet_directory=E:\ORACLE\admin\PROD01\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Listener completed notification to CRS on stop
24-MAR-2014 14:40:49 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)(CRS=ON)) * stop * 0
Mon Mar 24 14:40:56 2014
System parameter file is E:\oracle\product\12.1.0\db_1\network\admin\listener.ora
Log messages written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\alert\log.xml
Trace information written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\trace\ora_3592_2952.trc
Trace level is currently 0

Started with pid=3592
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OR01-HQ.aesi.loc)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
24-MAR-2014 14:41:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * status * 0
24-MAR-2014 14:41:12 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53723)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:13 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53724)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:13 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53725)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:14 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53726)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:14 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53727)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:15 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53728)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:15 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53729)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:16 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53730)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:16 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * services * 0
24-MAR-2014 14:41:16 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53731)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:17 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53732)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:17 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53733)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:18 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53734)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:18 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53735)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:19 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53736)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:19 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53737)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:20 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53738)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:20 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53739)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:21 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53740)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:21 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53741)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:22 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53742)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:22 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53743)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:23 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53744)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:23 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53745)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:24 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53746)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:24 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53747)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:25 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53748)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:25 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53749)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:26 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53750)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:26 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53751)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:27 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53752)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:27 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53753)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:28 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53754)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:28 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53755)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:28 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * services * 0
24-MAR-2014 14:41:29 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53756)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:29 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53757)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:30 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53758)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:30 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53759)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:31 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53760)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

...

Рейтинг:

0 / 0

25.03.2014, 06:38

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38596778

daaapd

Участник

Сообщения: 187

Рейтинг: 0 / 0

daaapd,Кто подскажет в чем проблема

...

Рейтинг:

0 / 0

26.03.2014, 12:18

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38596809

Изя Кацман

Участник

Откуда: Великий Эксперимент

Сообщения: 2 015

Рейтинг: 0 / 0

daaapdtru55,

Вот лог в момент когда не подключался и до перезапуска listener

Код: 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.

Mon Mar 24 14:39:17 2014
24-MAR-2014 14:39:11 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53721)) * establish * PROD01 * 0
Trace information written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\trace\ora_3376_3992.trc
24-MAR-2014 14:39:38 * trace * 0
24-MAR-2014 14:39:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * services * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=OR01-HQ.aesi.loc)(PORT=5500))(Security=(my_wallet_directory=E:\ORACLE\admin\PROD01\xdb_wallet))(Presentation=HTTP)(Session=RAW))
System parameter file is E:\oracle\product\12.1.0\db_1\network\admin\listener.ora
Trace information written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\trace\ora_3376_3992.trc
Trace level is currently 0
Log messages written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\alert\log.xml
24-MAR-2014 14:40:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * reload * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=OR01-HQ.aesi.loc)(PORT=5500))(Security=(my_wallet_directory=E:\ORACLE\admin\PROD01\xdb_wallet))(Presentation=HTTP)(Session=RAW))
24-MAR-2014 14:40:02 * service_register * prod01 * 0
24-MAR-2014 14:40:12 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53722)) * establish * PROD01 * 0
24-MAR-2014 14:40:38 * (CONNECT_DATA=(SERVICE_NAME=prod01.aesi.loc)(CID=(PROGRAM=D:\studio\oracle\product\11.2.0\cl_2\bin\sqlplus.exe)(HOST=GRECHISHNIKOV-W)(USER=OV.Grechishnikov))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.88)(PORT=12240)) * establish * prod01.aesi.loc * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OR01-HQ.aesi.loc)(PORT=1521)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=OR01-HQ.aesi.loc)(PORT=5500))(Security=(my_wallet_directory=E:\ORACLE\admin\PROD01\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Listener completed notification to CRS on stop
24-MAR-2014 14:40:49 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)(CRS=ON)) * stop * 0
Mon Mar 24 14:40:56 2014
System parameter file is E:\oracle\product\12.1.0\db_1\network\admin\listener.ora
Log messages written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\alert\log.xml
Trace information written to E:\oracle\diag\tnslsnr\OR01-HQ\listener\trace\ora_3592_2952.trc
Trace level is currently 0

Started with pid=3592
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OR01-HQ.aesi.loc)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
24-MAR-2014 14:41:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * status * 0
24-MAR-2014 14:41:12 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53723)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:13 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53724)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:13 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53725)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:14 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53726)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:14 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53727)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:15 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53728)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:15 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53729)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:16 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53730)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:16 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * services * 0
24-MAR-2014 14:41:16 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53731)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:17 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53732)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:17 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53733)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:18 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53734)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:18 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53735)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:19 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53736)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:19 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53737)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:20 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53738)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:20 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53739)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:21 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53740)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:21 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53741)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:22 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53742)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:22 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53743)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:23 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53744)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:23 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53745)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:24 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53746)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:24 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53747)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:25 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53748)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:25 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53749)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:26 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53750)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:26 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53751)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:27 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53752)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:27 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53753)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:28 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53754)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:28 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53755)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:28 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=OraAdmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375424)) * services * 0
24-MAR-2014 14:41:29 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53756)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:29 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53757)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:30 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53758)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:30 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53759)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
24-MAR-2014 14:41:31 * (CONNECT_DATA=(SID=PROD01)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Администратор))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.98.0.7)(PORT=53760)) * establish * PROD01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

...

Рейтинг:

0 / 0

26.03.2014, 12:41

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38596812

daaapd

Участник

Сообщения: 187

Рейтинг: 0 / 0

Что надо сделать чтобы этого не происходило?

...

Рейтинг:

0 / 0

26.03.2014, 12:44

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38596933

Изя Кацман

Участник

Откуда: Великий Эксперимент

Сообщения: 2 015

Рейтинг: 0 / 0

Камрад, в доке пишут:
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID for an instance (usually a database instance) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.

Action:
- Wait a moment and try to connect a second time.
- Check which instances are currently known by the listener by executing: lsnrctl services <listener name>
- Check that the SID parameter in the connect descriptor specifies an instance known by the listener.
- Check for an event in the listener.log file.

Выполни на сервере

Код: plaintext

lsnrctl services

и покажи результат

Когда ета бяда-12505 у тебя снова начнется, опять выполни на сервере

Код: plaintext

lsnrctl services

и снова покажи результат

...

Рейтинг:

0 / 0

26.03.2014, 13:56

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38597615

daaapd

Участник

Сообщения: 187

Рейтинг: 0 / 0

Вот сейчас выполнил, когда будет ошибка выложу
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 27-MAR-2014 07:26
:34

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=OR01-HQ.aesi.loc)(PORT=1
521)))
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 "PROD01.AESI.LOC" has 1 instance(s).
Instance "prod01", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:945 refused:0 state:ready
LOCAL SERVER
Service "PROD01XDB.AESI.LOC" has 1 instance(s).
Instance "prod01", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: OR01-HQ, pid: 1852>
(ADDRESS=(PROTOCOL=tcp)(HOST=OR01-HQ.aesi.loc)(PORT=49191))
The command completed successfully

...

Рейтинг:

0 / 0

27.03.2014, 06:27

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38602607

daaapd

Участник

Сообщения: 187

Рейтинг: 0 / 0

Вот дождались
Microsoft Windows [Version 6.1.7600]
(c) Корпорация Майкрософт (Microsoft Corporation), 2009. Все права защищены.

C:\Users\Администратор>lsnrctl services

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 02-APR-2014 11:49
:17

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=OR01-HQ.aesi.loc)(PORT=1
521)))
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 "PROD01.AESI.LOC" has 1 instance(s).
Instance "prod01", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:2111 refused:0 state:ready
LOCAL SERVER
Service "PROD01XDB.AESI.LOC" has 1 instance(s).
Instance "prod01", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: OR01-HQ, pid: 1852>
(ADDRESS=(PROTOCOL=tcp)(HOST=OR01-HQ.aesi.loc)(PORT=49191))
The command completed successfully

C:\Users\Администратор>

...

Рейтинг:

0 / 0

02.04.2014, 09:48

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38602615

daaapd

Участник

Сообщения: 187

Рейтинг: 0 / 0

Изя Кацман,
Можете помочь

...

Рейтинг:

0 / 0

02.04.2014, 09:55

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38602772

Изя Кацман

Участник

Откуда: Великий Эксперимент

Сообщения: 2 015

Рейтинг: 0 / 0

daaapdВот сейчас выполнил, когда будет ошибка выложу

Код: 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.

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 27-MAR-2014 07:26
:34

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=OR01-HQ.aesi.loc)(PORT=1
521)))
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 "PROD01.AESI.LOC" has 1 instance(s).
  Instance "prod01", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:945 refused:0 state:ready
         LOCAL SERVER
Service "PROD01XDB.AESI.LOC" has 1 instance(s).
  Instance "prod01", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: OR01-HQ, pid: 1852>
         (ADDRESS=(PROTOCOL=tcp)(HOST=OR01-HQ.aesi.loc)(PORT=49191))
The command completed successfully

...

Рейтинг:

0 / 0

02.04.2014, 11:27

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38602775

Изя Кацман

Участник

Откуда: Великий Эксперимент

Сообщения: 2 015

Рейтинг: 0 / 0

daaapdВот дождались

Код: 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.

Microsoft Windows [Version 6.1.7600]
(c) Корпорация Майкрософт (Microsoft Corporation), 2009. Все права защищены.

C:\Users\Администратор>lsnrctl services

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 02-APR-2014 11:49
:17

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=OR01-HQ.aesi.loc)(PORT=1
521)))
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 "PROD01.AESI.LOC" has 1 instance(s).
  Instance "prod01", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2111 refused:0 state:ready
         LOCAL SERVER
Service "PROD01XDB.AESI.LOC" has 1 instance(s).
  Instance "prod01", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: OR01-HQ, pid: 1852>
         (ADDRESS=(PROTOCOL=tcp)(HOST=OR01-HQ.aesi.loc)(PORT=49191))
The command completed successfully

C:\Users\Администратор>

Тегом SRC етого фороума нгаучись пользоваться, камрад

...

Рейтинг:

0 / 0

02.04.2014, 11:28

| Ответить | Цитировать | Написать

TNS listener oracle 12

#38671181

daaapd

Участник

Сообщения: 187

Рейтинг: 0 / 0

Уважаемые форумчане помогите в решение данной проблемы

...

Рейтинг:

0 / 0

17.06.2014, 07:51

| Ответить | Цитировать | Написать

13 сообщений из 13, страница 1 из 1

Форумы / Oracle [игнор отключен] [закрыт для гостей] / TNS listener oracle 12

Цитировать

Написать

Автор*:

Ввести пароль для входа

Тема*:

Сообщение

Данное сообщение тематическое

Сообщение содержит картинки или видео 18+

Автор:

ВНИМАНИЕ! На данном подфоруме действуют строгие правила. Удостоверьтесь, что ваше сообщение соответствует им!

Форум или тема закрыты для гостей. Необходима авторизация!

Загрузить последнюю сохраненную версию

Вложение:

Вставить как галерею

Максимальный размер вложений: 4,0 МБ, аудио/видео: 8,0 МБ. Картинки большего размера ужимаются, если возможно.

Введите код, изображенный на картинке. Если код нечитаемый, кликните картинку, чтобы загрузить другой вариант.

Отправляя сообщение, я выражаю свое согласие с правилами форума и принимаю пользовательское соглашение.

Читали тему (0):

Читали форум (0):

Пользователи онлайн (0):

start [/forum/topic.php?fid=52&tid=1894142]:	0ms
get settings:	11ms
get forum list:	12ms
check forum access:	3ms
check topic access:	3ms
track hit:	40ms
get topic data:	12ms
get forum data:	2ms
get page messages:	45ms
get tp. blocked users:	1ms
others:	12ms

total:	141ms