Skip to Main Content

Oracle ssl setup not getting configured!!!!

chandra_1986Apr 27 2022

Am trying to create the ssl below is my tnsnames.ora in server side, found only one listener file in grid location: Need to configure SSL on 2484 port on TMSU 1521 port, 2485 port on MISU port, and 2486 port on LGNU port, need confirmation is that i need to add the entry in grid/network listener.ora file with below

(ADDRESS = (PROTOCOL = TCPS)(HOST = dztup)(PORT = 2484))
(ADDRESS = (PROTOCOL = TCPS)(HOST = dztup)(PORT = 2485))
 (ADDRESS = (PROTOCOL = TCPS)(HOST = dztup)(PORT = 2486))

Listener.ora below file found in grid/network/admin location:-

[oracle@DZTUPadmin]$ cat /u01/app/12.2.0/grid/network/admin/listener.ora
#Backup file is  /u01/app/12.2.0/grid/srvm/admin/listener.ora.bak.zdb-uat line added by Agent
# listener.ora Network Configuration File: /u01/app/12.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

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

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET                # line added by Agent

Below tnsnames.ora file found in ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/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 = DZTUP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = msu)
    )
  )

#LISTENER_TSU =
# (ADDRESS = (PROTOCOL = TCP)(HOST = DZTUP)(PORT = 1521))


msuAT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DZTUP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = msu)
    )
  )

LISTENER_LGNU =
  (ADDRESS = (PROTOCOL = TCP)(HOST = DZTUP)(PORT = 1521))


LISTENER_msu =
  (ADDRESS = (PROTOCOL = TCP)(HOST = DZTUP)(PORT = 1521))


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

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

LGNU =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DZTUP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = LGNU)
    )
  )

LGNUAT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DZTUP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = LGNU)
    )
  )
Comments
Post Details
Added on Apr 27 2022
2 comments
44 views