| Author |
Configuring a client to connect to database server
|
|
| pkweisi 2002-02-07, 11:04 pm |
| Hi folks,
I have a 2 computer peer-to-peer network. I have installed Oracle 9i Ent. edition on the server computer as the database server. On the other computer I have installed the oracle9i client version.
Through the net 8 Assistant I configured the client computer in order to access the database on the database server.
Unfortunately the client does not seem to be able to connect to the database server.
Perhaps I have missed some steps in the configuration. Any advice?
Thanks in advance folks. | |
| siddharth_k 2002-02-09, 1:06 am |
| could you please describe steps you took to configure ??? | |
| laloca 2002-02-09, 8:14 am |
| Hi,
why did you use the net8 assistant for a 9i database?
There is a testing utility in the net-assistant - any error codes? Can you ping the other host? Have you tried tnsping <SID> ? Result? | |
| pkweisi 2002-02-11, 7:16 pm |
| Hi IaLoca,
yes I actually used the Oracle Net Manager and the error code I get is:
ORA-12560:TNS: protocol adapter error.
There may be an error in the fields entered, or the server may not be ready for a connection.
When I tried to use tnsping the result was:
Used parameter files:
c:\oracle\ora90\network\admin\
sqlnet.ora
c:\oracle\ora90\network\admin\
tnsnames.ora
TNS-03505: Failed to resolve name
When I use ping the result is:
Unknown host
My home network is made up of 2 computers. The server computer has an IP address as it is connected to the internet by cable. i don't know if this has any effect.
I hope you have an idea what I can do to resolve this. | |
| laloca 2002-02-12, 4:11 am |
| Hi pkweisi,
The ping error could be the answer. If you don't use host-entries (e.g. in c:\winnt\system32\drivers\etc\
hosts) or a dns-service the hostname of your server can't be resolved --> your machine don't know the ip-adress of the server resp. can't resolve it from the hostname.
Assuming your peer-to-peer network works propery (ping ip-adress) simply use the ip-adress in the Oracle Net Manager instead of the hostname of your server. |
|
|
|