ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Items Checked
TNS_ADMIN environment variable is not defined
ORACLE_HOME environment variable is defined as "C:\app\client\product\12.1.0\client_1"
"C:\app\client\product\12.1.0\client_1\Network\Admin\tnsnames.ora" was located
Found in the tnsnames.ora file:
ORAPTCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.127)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
"C:\app\client\product\12.1.0\client_1\Network\Admin\sqlnet.ora" was located
NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file
Steps to Take
If the database was just started, wait a few moments and try again. The database may be initializing.
Verify that the connect descriptor for ORAPTCL has the correct SERVICE_NAME or SID component in the tnsnames.ora file
Verify that the listener is properly configured and that the database is registered with the listener
Try to TNSPing ORAPTCL using the TNS Ping button on the toolbar