Как настроить tns oracle

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = «EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll»)
)
)

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

ADR_BASE_LISTENER = C:\app\Administrator

tnsnsmes.ora:

�� sqlplus �� .

Attempting to connect using userid: system
The test did not succeed.
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

There may be an error in the fields entered,
or the server may not be ready for a connection.

�� . 4 �� 14, 11:33��[15376130] �� | ��

Re: �� listener � tnsnames. [new]

UDW
Member

��: ��
��: 1098

� �� SQL*PLUS �� ? �� ?
�� , �� Listener?
�� ?

4 �� 14, 12:24��[15376188] �� | ��

Re: �� listener � tnsnames. [new]

wvetal
Member

��:
��: 548

UDW
� �� SQL*PLUS �� ? �� ?

�� system. �� Oracle. (�� )
�� , ��, �� (select name from v$database).

UDW
�� , �� Listener?

�� Listener?

4 �� 14, 12:36��[15376202] �� | ��

Re: �� listener � tnsnames. [new]

UDW
Member

��: ��
��: 1098

� ��
lsnrctl status
�� .

�� :
alter system register;
�� Listener ��.

4 �� 14, 13:22��[15376253] �� | ��

Re: �� listener � tnsnames. [new]

wvetal
Member

��:
��: 548

UDW,

�� alter system register — �� System altered.

�� , �� :
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

� �� . �� — 133Kb

4 �� 14, 16:17��[15376729] �� | ��

Re: �� listener � tnsnames. [new]

UDW
Member

��: ��
��: 1098

�� sqlnet.ora

4 �� 14, 18:29��[15377034] �� | ��

Re: �� listener � tnsnames. [new]

wvetal
Member

��:
��: 548

UDW
�� sqlnet.ora

�� — �� .

4 �� 14, 18:48��[15377079] �� | ��

Re: �� listener � tnsnames. [new]

UDW
Member

��: ��
��: 1098

�� Listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = «EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll»)
)
(SID_DESC =
(GLOBAL_DBNAME= ORCL)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME=ORCL
)

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

� � tnsnames.ora service_name �� sid.

4 �� 14, 19:09��[15377131] �� | ��

Re: �� listener � tnsnames. [new]

wvetal
Member

��:
��: 548

UDW,

�� — ��.

4 �� 14, 22:51��[15377683] �� | ��

�� 1 ��.

Re: �� listener � tnsnames. [new]

JIeXaXA
Member

��:
��: 4

�� !
� �� .
�� Oracle Enterprise 11.2.0 �� . �� Idea 2016 ��. �� SQLPlus � �� SQL-�� , � �� liquibase �� ORA-12505. lsnrctl status � �� .
�� .
�� plz �� .

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

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\user\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = «EXTPROC_DLLS=ONLY:C:\app\user\product\11.2.0\dbhome_1\bin\oraclr11.dll»)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

# sqlnet.ora Network Configuration File: C:\app\user\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# 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.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

# tnsnames.ora Network Configuration File: C:\app\user\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

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

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
#(SID_NAME = orcl)
)
)

� �� . �� — 119Kb

13 �� 19, 14:53��[21970431] �� | ��

Re: �� listener � tnsnames. [new]

dmdmdm
Member

��: ��
��: 1801

JIeXaXA
�� .

�� :
alter system register;
�� Listener ��.

13 �� 19, 15:06��[21970447] �� | ��

Re: �� listener � tnsnames. [new]

��
Member

� �� , �� localhost, � �� (�� 0.0.0.0 �� ), ��

13 �� 19, 15:10��[21970454] �� | ��

Re: �� listener � tnsnames. [new]

Als1973
Member

��:
��: 147

JIeXaXA,

localhost �� IP

13 �� 19, 15:33��[21970481] �� | ��

Re: �� listener � tnsnames. [new]

JIeXaXA
Member

��:
��: 4

alter system register; ��.
�� — ��!

13 �� 19, 16:55��[21970566] �� | ��

Re: �� listener � tnsnames. [new]

JIeXaXA
Member

��:
��: 4

�� .
�� SQL-�� .
�� liquibase?
�� . �� , � �� system.

13 �� 19, 17:13��[21970589] �� | ��

Re: �� listener � tnsnames. [new]

dmdmdm
Member

��: ��
��: 1801

JIeXaXA
�� SQL-�� .

�� , �� . � ��, � �� , � ��. «�� ».

13 �� 19, 17:24��[21970605] �� | ��

Re: �� listener � tnsnames. [new]

andrey_anonymous
Member

��: ��
��: 19690

� ��:
1. �� lsnrctl status �� , �� «�� ».
2. �� «�� liquibase» — �� , � �� .

13 �� 19, 17:51��[21970619] �� | ��

Re: �� listener � tnsnames. [new]

JIeXaXA
Member

��:
��: 4

��! �� .
�� SID.
�� -��.
�� !

16 �� 19, 19:27��[21971944] �� | ��

Re: �� listener � tnsnames. [new]

Dapohvapshe
Member

��:
��: 1

��,��, ��, �� SID. �� ORA-12505, TNS:listener does not currently know of SID given in connect descriptor :

1)# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-db.local)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

2)# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DBA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-db.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dba1)
)
)

3) lsnrctl status

LSNRCTL for Linux: Version 12.1.0.2.0 — Production on 21-DEC-2019 13:42:39

Источник

Как настроить tns oracle

Настройка сети (Настройка слущающего процесса Listener)

listener.ora

tnsnames.ora

Основные команды службы слушателя (Listener):

Информация о Listener из командной строки:

Информация о Listener из консоли sqlplus:

OFFTOPIC Listener для grid

Дополнительно

Способ настроить tnsnames, предложенный в чате:

Oracle DBA

Как настроить tns oracle