Hi All,
I know it is already been asked several times but in my case it is still not working even after trying all the given solution.
Please find the details below :
I am oracle 12c server(placed remotely, 12.1.0 64 bit) and 12c client(12.1 32bit)
Whenever i am trying to connect from client net manager i am able to connect but whenever i am trying to connect by MFC client
it is throwing an exception ORA-12154: TNS:could not resolve the connect identifier specified.
I have verified sqlnet.ora and tsnames.ora on both client as well as server side.
Everything seems fine but it is not working.
Please have a look at my connection string Connection string = Provider=OraOLEDB.Oracle; PLSQLRSet=1; User ID=system; Password=Nihal@01;Data Source=oracle
Client's sqlnet.ora details :
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME, LDAP, NIS)
ADR_BASE = C:\app\oracle
Client's tsnames.ora details:
WITHOUTSSL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.39.116)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle.asia.com)
)
)
Server's sqlnet.ora details:
SQLNET.AUTHENTICATION_SERVICES= (TCPS, NTS)
SSL_VERSION = 0
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Server's tsnames.ora details:
ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.39.116)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle.asia.com)
)
)
SSL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = 172.26.39.116)(PORT = 2484))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SSL.asia.com)
)
)
LISTENER_ORACLE =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.39.116)(PORT = 1521))
)
LISTENER_SSL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = 172.26.39.116)(PORT = 2484))
)
Server's listener details:
LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = 172.26.39.116)(PORT = 2484))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = oracle.asia.com)
(ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
(SID_NAME = oracle)
)
)
SSL_CLIENT_AUTHENTICATION = FALSE
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SSL.asia.com)
(ORACLE_HOME = C:\app\oracle\product\12.1.0\dbhome_1)
(SID_NAME = SSL)
)
)
ADR_BASE_LISTENER1 = C:\app\oracle\product\12.1.0\dbhome_1\log
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\app\oracle\product\12.1.0\dbhome_1\wallet)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.39.116)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
I have configured two listeners.One for TCP/IP and another for TCP/IP with SSL
Can somebody help me in resolving the issue.
thanks
Message was edited by: 3281606