Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Apr 27 2022
2 comments
218 views