Skip to Main Content

SSL configuration on same listener port no listener file found

chandra_1986Apr 25 2022

Hi Experts,

Oracle version: 12.2.0.2
Having below tnsnames.ora configuration, with no listener file in network admin location how to configure SSL i need to add the lines like for both the instances respectively
(ADDRESS = (PROTOCOL = TCPS)(HOST = DZTUPG)(PORT = 2484))
(ADDRESS = (PROTOCOL = TCPS)(HOST = DZTUPG)(PORT = 2485))
to connect TSU and MSU both
[oracle@dztupg admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

MSU =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DZTUPG)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = msu)
)
)

LISTENER_TSU =
(ADDRESS = (PROTOCOL = TCP)(HOST = DZTUPG)(PORT = 1521))

MSUAT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DZTUPG)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = msu)
)
)

LISTENER_MSU =
(ADDRESS = (PROTOCOL = TCP)(HOST = DZTUPG)(PORT = 1521))

TSUAT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DZTUPG)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TSU)
)
)

TSU =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DZTUPG)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TSU)
)
)

Comments
Post Details
Added on Apr 25 2022
0 comments
29 views