-
Connecting to Oracle Server
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
-
did you update TNSNAMES.ORA file with the IP Address and port Number?
-
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>
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|