Hi;
I have a problem that drives me mad. I have both PL SQL developer and Oracle Sql developer installed. I can connect local database with both PL SQL developer and Oracle Sql developer. When I try to connect a remote database, I can connect with Oracle Sql developer but I can't with PL SQL developer. When I try to connect via PL SQL developer, it returns
"ORA-12154: TNS:could not resolve the connect identifier specified"
error. OracleServiceORCL is up and running in services.msc. When I try to connect via command prompt, I run
sqlplus/nolog ,
it gives
ORA-12560: TNS protocol adapter
error. I tried large and small many things, however there is no solution. Could you please help me? Thanks in advance.
Diognostic information:
My database : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
My Operation system :windows 7
contents of tnsnames.ora:
content of listener.ora:
thanks in advance.
Message was edited by: tahasozgen makeup
Message was edited by: tahasozgen implement makeup over the post.