Connecting to Oracle Server

[elifeinchrist]

Hi

I have Oracle Client installed on my workstation which has Windows XP OS.

And I have Oracle Database running on UNIX on a different machine.

I am trying to connect to the Database which is running on UNIX, from the Windows based Oracle Client (Using SQL Plus). It is not connecting. "error: could not resolve service name"

My query is, Is it possible to connect the way I am trying to connect. If not can you tell how can I connect to the Oracle Database in UNIX from my Windows XP workstation

Thanks for your response in advance.
Robert

[MAK]

did you update TNSNAMES.ORA file with the IP Address and port Number?

[jkoopmann]

couple things to try.
1. log on to the database server and try and connect from there
2. on the database server issue a tnsping against the listener to see if it is up and running for that database and if your local tnsnames.ora entry matches what is expected.
3. as MAK stated, check your tnsnames.ora file
4. you can try and bypass the tns entry with a connection string like :
sqlplus <user>/<password>@//<machine>:<port>/<service_name>

[skhanal]

First test will be to ping the Oracle server to see if you can reach it from your desktop.

If that works try

telnet oracleip 1521

If you get blank command prompt, the port is not blocked by firewall. Then you can continue with other tests.