Forum Stats

  • 3,826,885 Users
  • 2,260,721 Discussions
  • 7,897,114 Comments

Discussions

SSL configuration on same listener port no listener file found

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

[[email protected] 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)

  )

 )