我正在尝试创建下面的ssl是我的tnsnames。ora在服务器端,在网格位置仅找到一个侦听器文件:
需要在TMSU 1521端口的2484端口、MISU端口的2485端口和LGNU端口的2486端口上配置SSL,需要确认的是我需要在grid/network listener中添加条目。ora文件如下
(ADDRESS = (PROTOCOL = TCPS)(HOST = dztup)(PORT = 2484))
(ADDRESS = (PROTOCOL = TCPS)(HOST = dztup)(PORT = 2485))
(ADDRESS = (PROTOCOL = TCPS)(HOST = dztup)(PORT = 2486))
听众。在grid/network/admin位置找到以下文件:-
[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
在斯奈姆斯下面。ora文件位于ORACLE_HOME/u01/app/ORACLE/product/12.2.0/dbhome_1/network/admin/tnsnames中。奥拉
# 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)
)
)
有什么建议吗