Platform: Windows 7 Professional -- 32 Bit
Oracle client 32 Bit -- C:\oracle\instantclient_12_1
The server could not be reached. 10013: [10013] Access denied
TNSping is ok
pinging through command prompt is okay,
Items Checked
TNS_ADMIN environment variable is defined as "C:\oracle\instantclient_12_1"
"C:\oracle\instantclient_12_1\tnsnames.ora" was located
The following connect descriptor was found for PROD1 in the tnsnames.ora file
PROD1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp)
(PROTOCOL = TCP)
(Host = 10.10.100.241)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = PROD1)
)
)
"C:\oracle\instantclient_12_1\sqlnet.ora" was located
NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file
Steps to Take
Try to ping 10.10.100.241 using the Ping button on the toolbar
Try to TNSPing PROD1 using the TNS Ping button on the toolbar