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

User787000-Oracle

Any update on this?

Gianni Ceresa

Isn't that the same exact thing as How to connect to 12C SSL DB using SQL Developer?  ?

Or this time it is an OBIEE question?