# listener.ora Network Configuration File: C:\app\Grokholskaya\product\11.2.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.


LISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=DSUD-ORACLE.LANIT)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
)
)


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SALUT)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = SALUT))


(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = TEST))

(SID_DESC =
(GLOBAL_DBNAME = PNPPK2016)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = PNPPK2016))

(SID_DESC =
(GLOBAL_DBNAME = PNPPK2015)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = PNPPK2016))

(SID_DESC =
(GLOBAL_DBNAME = plsextproc)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = extproc))

(SID_DESC =
(GLOBAL_DBNAME = RNKB)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = RNKB))

(SID_DESC =
(GLOBAL_DBNAME = VEARCFO)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = VEARCFO))

(SID_DESC =
(GLOBAL_DBNAME = CEARL)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = CEARL))


(SID_DESC =
(GLOBAL_DBNAME = BEVALEX)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = BEVALEX))

(SID_DESC =
(GLOBAL_DBNAME = SHVABECNT)
(ORACLE_HOME = C:\app\Grokholskaya\product\11.2.0\dbhome_2)
(SID_NAME = SHVABECNT))

)


#ADR_BASE_LISTENER = C:\app\Grokholskaya

C:\Windows\system32>sqlplus -l sys/sys as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on ╤Ё ╤хэ 20 16:20:19 2017

Copyright (c) 1982, 2010, Oracle. All rights reserved.


╧Ёшёюхфшэхэ ъ:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn Dbo/dbo@PNPPK2015
^C

# tnsnames.ora Network Configuration File: E:\app\grokholskaya\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.


TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)

UOMZ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORASRV.LANIT)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = UOMZ)
)
)


MOEK2015 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = moek2015)
)
)

PNPPK2016 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PNPPK2016)
)
)

PNPPK2015 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PNPPK2015)
)
)

ADMTVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORASRV)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ADMTVER)
)
)

CEARAM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ADMTVER)
)
)


RNKB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RNKB)
)
)


SALUT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SALUT)
)
)

SHVABECNT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SHVABECNT)
)
)

SHVBF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SHVBF)
)
)

CNTSVABE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CNTSVABE)
)
)

BEVALEX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DSUD-ORACLE.LANIT)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = BEVALEX)
)
)

C:\Windows\system32>set NLS_LANG=AMERICAN_CIS.UTF8

C:\Windows\system32>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Produc
:15

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST
1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory

C:\Windows\system32>set NLS_LANG=AMERICAN_CIS.UTF8

C:\Windows\system32>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-SEP-2017 17:01
:15

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSUD-ORACLE.LANIT)(PORT=
1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory

C:\Windows\system32>lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 21-SEP-2017 08:47
:22

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Їрщыюь ёшёЄхьэ√ї ярЁрьхЄЁют  ты хЄё  C:\app\Grokholskaya\product\11.2.0\dbhome_2
\network\admin\listener.ora
ёююс∙хэш  яЁюЄюъюыр чряшёрэ√ т c:\app\grokholskaya\diag\tnslsnr\DSUD-ORACLE\list
ener\alert\log.xml
╧Ёюёыє°штрхЄё : (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DSUD-ORACLE.LANIT)(POR
T=1521)))
╧Ёюёыє°штрхЄё : (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\extprocip
c)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSUD-ORACLE.LANIT)(PORT=
1521)))
TNS-01153: Failed to process string: └

C:\Windows\system32>set | findstr /I /R ".*ora"
COMPUTERNAME=DSUD-ORACLE
LOGONSERVER=\\DSUD-ORACLE
ORACLE_HOME=C:\app\Grokholskaya\product\11.2.0\dbhome_2
USERDOMAIN=DSUD-ORACLE
USERDOMAIN_ROAMINGPROFILE=DSUD-ORACLE

21T10:41:36.065+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DSUD-ORACLE'
host_addr='::1'>
<txt>21-СЕН-2017 10:41:36 * 12502
</txt>
</msg>
<msg time='2017-09-21T10:41:46.135+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DSUD-ORACLE'
host_addr='::1'>
<txt>TNS-12502: TNS:прослушиватель не получил CONNECT_DATA от клиента
</txt>
</msg>
<msg time='2017-09-21T10:41:56.217+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DSUD-ORACLE'
host_addr='::1'>
<txt>21-СЕН-2017 10:41:36 * service_update * pnppk2016 * 0
</txt>
</msg>
<msg time='2017-09-21T10:42:06.320+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DSUD-ORACLE'
host_addr='::1'>
<txt>21-СЕН-2017 10:41:36 * service_update * bevalex * 0
</txt>
</msg>
<msg time='2017-09-21T10:42:16.425+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DSUD-ORACLE'
host_addr='::1'>
<txt>21-СЕН-2017 10:41:36 * service_update * pnppk2015 * 0
</txt>
</msg>
<msg time='2017-09-21T10:42:26.544+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DSUD-ORACLE'
host_addr='::1'>
<txt>21-СЕН-2017 10:42:26 * 12502
</txt>
</msg>
<msg time='2017-09-21T10:42:36.627+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DSUD-ORACLE'
host_addr='::1'>
<txt>TNS-12502: TNS:прослушиватель не получил CONNECT_DATA от клиента
</txt>
</msg>
<msg time='2017-09-21T10:42:46.724+03:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DSUD-ORACLE'
host_addr='::1'>
<txt>21-СЕН-2017 10:42:26 * service_update * pnppk2016 * 0
</txt>
</msg>