1. Created directory - /home/app/tns
2. Created 2 files in it as sqlnet.ora and tnsnames.ora.
3. In sqlnet.ora it shows as :
# sqlnet.ora Network Configuration File: /oraclient/product/12.1.0.2.0/client/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /home/app/appstore)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
4. In tnsnames.ora :
connect_db =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Dbhost)(PORT = 61901))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = service_name_io2)
)
)
5. export TNS_ADMIN=/home/app/tns.
6.
mkdir -p /home/app/appstore
mkstore -wrl /home/app/appstore -create
mkstore -wrl /home/app/appstore -createCredential connect_db username password.
7. Chmod 777 to all files.
8. tnsping avalon_res
Used TNSNAMES adapter to resolve the alias
Attempting to contact : ................................
OK (20 msec).
But when trying to connect as
9. sqlplus /@connect_db
failing with below error:
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 18 18:08:14 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Checked client and server both are in 12.1.0.2.0