Client and Server on the same box

[badrinathn]

Hi,


Should we not have the oracle 8.1.7 server and client installed on the same box.

If we have,for the connections to db's outside this box which tnsnames.ora will be checked.

Badrinath

[Halo]

Yes. Typically, you would have tns entries of remote dbs in the same tns files on the server.

[kmesser]

SQL*PLUS is a "client" application. Thus the same tnsnames.ora file is checked no matter where you try to connect. In the case where client and server are installed on the same machine, they are often installed in the same ORACLE_HOME. However, regardless of that, the tnsnames.ora that your SQL*PLUS application uses to connect to your local DB is the exact same file it will use to connect to ANY DB ANYWHERE. Simply insure the correct entries exist in that file, and that global_names is set appropriately.

[badrinathn]

Case 1:


I had the client installed and was able to connect to
1. mndb/default@ewct
2. rei/nas@rel
(2 diff instances on 2 boxes)


Case 2:

I uninstalled client. and Installed oracle 8.1.7 EE on the same server. SID= ORCL.

In the server tnsnames.ora, I have added the entries for
(ewct and rel boxes)
I am able to connec to system/manager@orcl but not to ewct/rel

Case 3:
So I installed Client , with a diff oracle Home. And added the entries for ewct/rel.

Still I am unable to connect to EWCT and REL, while I get connected to ORCL.
TNSPING and Ping to the diff machines are OK.

Where Am i going wrong?
Badrinath

[Halo]

Did you check the name/IP of the remote node in the hosts file??

[badrinathn]

Thanks Halo,


I made an entry in the host file, It started working. But why is the hosts file entry required.

All these days, I did not have any entry in this file.
Please explain
Badrinath

[Halo]

It's needed by the host for it to identify which hosts it can possibly communicate with (on the n/w).

[badrinathn]

But so far, I had no entry, but it was working.