2 Replies Latest reply on Nov 15, 2017 10:55 AM by Gianni Ceresa

    Not able to connect to SSL DB

    User787000-Oracle

      Hi All,

      I have setup a SSL DB by following this link, i am not able to establish the connection and I get below err.  Could you please let me know if i am missing anything here?

       

       

      Link - https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=295425186377625&id=762286.1&_afrWindowMode=0&_adf.ctrl…

       

      [aime@den02smw bin]$ ./sqlplus sys/Welcome1@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=den02smw.us.oracle.com)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=orclssl)))' as sysdba

       

       

      SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 14 08:24:12 2017

      Copyright (c) 1982, 2014, Oracle.  All rights reserved.

      ERROR:

      ORA-12514: TNS:listener does not currently know of service requested in connect

      descriptor

       

       

      tnsname.ora:

      bash-4.1$ cat tnsnames.ora

      # tnsnames.ora Network Configuration File: /scratch/aime/OBIEE11119/oracledb/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

      # Generated by Oracle configuration tools.

       

       

      ORCLDBA =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = den02smw.us.oracle.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = orcldba.us.oracle.com)

          )

        )

       

       

      ORACLEDBSSL =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCPS)(HOST = den02smw.us.oracle.com)(PORT = 2484))

          )

          (CONNECT_DATA =

              (SERVER = DEDICATED)

            (SERVICE_NAME = orclssl)

          )

        )

       

       

      Listener.ora:

      bash-4.1$ cat listener.ora

      # listener.ora Network Configuration File: /scratch/aime/OBIEE11119/oracledb/product/12.1.0/dbhome_1/network/admin/listener.ora

      # Generated by Oracle configuration tools.

       

       

      SSL_CLIENT_AUTHENTICATION = FALSE

       

       

      WALLET_LOCATION =

        (SOURCE =

          (METHOD = FILE)

          (METHOD_DATA =

            (DIRECTORY = /scratch/aime/OBIEE11119/DBSSLCERT/Wallets/server_wallet)

          )

        )

       

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = den02smw.us.oracle.com)(PORT = 1521))

          )

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

          )

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCPS)(HOST = den02smw.us.oracle.com)(PORT = 2484))

          )

        )

       

       

      ADR_BASE_LISTENER = /scratch/aime/OBIEE11119/oracledb

       

      sqlnet.ora:

      bash-4.1$ cat sqlnet.ora

      # sqlnet.ora Network Configuration File: /scratch/aime/OBIEE11119/oracledb/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

      # Generated by Oracle configuration tools.

       

       

      SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS, NTS)

       

       

      #SSL_VERSION = 0

       

       

      NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

       

       

      SSL_CLIENT_AUTHENTICATION = FALSE

       

       

      WALLET_LOCATION =

        (SOURCE =

          (METHOD = FILE)

          (METHOD_DATA =

            (DIRECTORY = /scratch/aime/OBIEE11119/DBSSLCERT/Wallets/server_wallet)

          )

        )

       

       

      ADR_BASE = /scratch/aime/OBIEE11119/oracledb

       

       

      Thanks

      Saravanan

       

       

       

      Enter user-name: Saravanan