SQLPLUS does not work but JDBC is ok
Hi all,
I created a java app that can connected to a Oracle DB with JDBC, however, when I try to get connected to my DB using the SLQPLU I laways get this error:
[oracle@ipsm-sn01 ~]$ sqlplus myuser/mypass@orcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
The SID is properly exported:
export ORACLE_SID=orcl
The JDBC url looks like:
jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl
jdbc.username=myuser
jdbc.password=mypass
I have read a lot of entries about a file named TNSNAMES.ORA, I have no such file set; but the java app has been running for months without it, so I think that's not the root cause.
Thanks in advanced.