Hi,
My DB is exposed to the client application without any issues .
When I am connecting DB ,without the instance name like username/password , I am able to connect and when I am connecting by using the sid like username/password@instance_name, I am getting this error.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified.
My question is if the listener is not set how the aplication is able to connect , is it due to the driver of the java application.
If so when I am checking the lsnrctl status , how this is running in the server and also I am nt able to tnsping .
When I am checking echo $TNS_ADMIN , this variable is not setup also and I also dnt have any tnsnames.ora under $ORACLE_HOME/network/admin.
Please provide me the working logic of the listener.
I will really appreciate any suggestions and thoughts .
Thanks in advance .
Regards,
Ranjan