sangeeta9189
asked on
Connect Oracle 10G client to server
I have a workgroup of 4 computers. In one PC, I have installed Oracle 10G server. On another PC I have installed Oracle 10G client.
When I try to login to SQL*Plus on client it gives me an error
TNS could not resolve connect identifier specified.
Can someone please let me know how to connect client to the server.
Thank you
When I try to login to SQL*Plus on client it gives me an error
TNS could not resolve connect identifier specified.
Can someone please let me know how to connect client to the server.
Thank you
ASKER
Thanks for replying.
I searched in the client installation and it does not have TNSNAMES.ora file.
It has SQLNET.ora
the server instllation has tnsnames.ora
Please suggest
I searched in the client installation and it does not have TNSNAMES.ora file.
It has SQLNET.ora
the server instllation has tnsnames.ora
Please suggest
ASKER
This is a fresh installation, so I just need the steps to connect client to server
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When i execute command
tnsping orcl.WORLD
it gives me message
Used parameter files:
C:\oracle\product\10.2.0\c
TNS-03505: Failed to resolve name
It is looking at sqlnet.ora.
The tnsnames.ora on client machine is inside SAMPLE directory
tnsping orcl.WORLD
it gives me message
Used parameter files:
C:\oracle\product\10.2.0\c
TNS-03505: Failed to resolve name
It is looking at sqlnet.ora.
The tnsnames.ora on client machine is inside SAMPLE directory
ASKER
I put the lines you mentioned inside sqlnet.ora, but still same problem.
the one in the sample directory is just that ... a sample. It is not the one used ... it must be in the C:\oracle\product\10.2.0\c
Also try the tnsping command on the server machine please.
Also try the tnsping command on the server machine please.
The lines I gave must be in the TNSNAMES.ora file. The sqlnet.ora file is a for configuration - not connections.
ASKER
On the client machine, I did the following on command prompt
----
telnet 172.16.1.116 1521
----
but gives me a message
-------------------
Connecting To 172.16.1.116...Could not open connection to the host, on port 1521
: Connect failed
-------------------
where 172.16.1.116 is the Oracle Server machine.
However, if I execute the same command in server machine, it succeeds
Could it be some connectivity problem?
----
telnet 172.16.1.116 1521
----
but gives me a message
-------------------
Connecting To 172.16.1.116...Could not open connection to the host, on port 1521
: Connect failed
-------------------
where 172.16.1.116 is the Oracle Server machine.
However, if I execute the same command in server machine, it succeeds
Could it be some connectivity problem?
telnet is a different protocol - nothing to do with Oracle databases.
tnsping is the command to use - this is Oracle's tool for testing database communications.
the fact that the telnet could connect - but not use port 1521 is a positive sign - but telnet will never be able to connect to that port.
try again with tnsping please.
tnsping is the command to use - this is Oracle's tool for testing database communications.
the fact that the telnet could connect - but not use port 1521 is a positive sign - but telnet will never be able to connect to that port.
try again with tnsping please.
create a tnsnames.ora file if it does not exist with an entry as suggested by lwadwell.
http://ora-12154.ora-code.com/