oracle - Oracle SSL 支持

Question

我正在尝试为 Oracle 配置 SSL 支持，但是我在启动监听器时遇到了麻烦。我不断收到错误“TNS-01150：指定的侦听器名称的地址不正确”，但在我看来地址是正确的。当我使用没有 TCPS 的配置时，侦听器正常启动，但是当我使用 SSL 添加配置时，它无法启动。

我不是预言机专家，我只需要为我们的测试目的设置它，所以我的知识也有点有限。我已经按照教程进行操作，但没有任何效果.. 你能发现我的配置有什么问题吗？

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (TCP, TCPS, NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

WALLET_LOCATION = 
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA = 
      (DIRECTORY = "C:\ora_wallet\")
    )
)
SSL_CLIENT_AUTHENTICATION=FALSE

监听器.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\Administrator\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\12.1.0\dbhome_1\bin\oraclr12.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zmrao.swdev.local)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCPS)(HOST = zmrao.swdev.local)(PORT = 2484))
    )
    (SECURITY=(MY_WALLET_DIRECTORY="C:\ora_wallet\"))
  )

WALLET_LOCATION = 
 (SOURCE=
  (METHOD=File)
  (METHOD_DATA=
   (DIRECTORY="C:\ora_wallet\")))
   
SSL_CLIENT_AUTHENTICATION=FALSE
SSL_VERSION = 1.2

tnsnames.ora

ZMRAORA =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = zmrao.swdev.local)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = zmraora)
    )
  )

ZMRAORA_SSL=
  (DESCRIPTION=
   (ADDRESS=(PROTOCOL=TCPS)(HOST=zmrao.swdev.local)(PORT=2484))
   (CONNECT_DATA=(SERVICE_NAME=zmraora)))

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

电子钱包.p12

C:\app\Administrator\product\12.1.0\dbhome_1\BIN> orapki wallet display -wallet C:\ora_wallet
Oracle PKI Tool : Version 12.1.0.2
Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.

Requested Certificates:
User Certificates:
Subject:        CN=zmrao,OU=DPA,O=Company,L=City,ST=State,C=XX
Subject:        CN=zmrao.swdev.local,OU=DPA,O=Company,L=City,ST=State,C=XX
Trusted Certificates:
Subject:        CN=zmrao.swdev.local,OU=DPA,O=Company,L=City,ST=State,C=XX
Subject:        CN=zmrao,OU=DPA,O=Company,L=City,ST=State,C=XX

标签： oraclessloracle-wallet