connection of oracle database in database server from application server
560656Feb 8 2007 — edited Feb 8 2007Hi,
I have two servers, one is application server and another one is database server…..
I want to connect oracle 10g database in database server to application server. In application server oracle 10g client is installed……In database server, I have set tnsnames.ora, Listener.ora …while checking in lsnrctl…the particular sid is running fine…
In application server, while I give as sqlplus
After giving username and password its showing error as
ORA-12545: Connect failed because target host or object does not exist
While surfing in net it shows check tnsnames.ora and listener.ora….. I have set the environmental variables here in application server…..
It’s connecting when I give
Sqlplus
Sql>username/password @ hostname: 1521/sid_name
Is it possible to connect with the username and password
I have set the host names in /etc/hosts….
If we are giving the hostname, port number and Sid name this connects without using tnsnames.ora…..
While pinging between two servers the connectivity is there between two servers…..
Could u pls help me out?
Thanks in advance