but i don't find any tnsnames.ora on the client station.

Can some one telle he how can we reach the host and connect to the database which is installed on a server?

Should we use the tnsnames of the server?

but i don't find any tnsnames.ora on the client station.

Can some one telle he how can we reach the host and connect to the database which is installed on a server?

Should we use the tnsnames of the server?

i haven't understood:ok, how my distant client can recognize the host?

Hello Michel,
I suppose you speak French. I way you're based in France!
Communicate in French is simpler, as it is no ambiguity. In fact my concern is that not only tracks how I can connect from a computer installed oracle xe 10g (client version) to my oracle db 10g xe installed on a server (which it is virtual).
The sole is tnsnames.ora on the server (unless I have two).
Here are the steps by which I passed:
- Install Oracle 10g xe on Virtual Server
- Creating a db via scripts using
- Connecting to this new db from a software program installed on a workstation with a client oracle 9: Connection OK
* Config Tnsnames the client (aka, host, port, instance)
* Setup the alias in the software
- Installation of Oracle 10g xe client on another computer (virtual mac) with my software installed on it
- And here I block, because I have neither tnsnames or a tool for configuring the body style: "Oracle Net Configuration Assistant".

How?


Thank you in advance for your response.
Sak.

et là je bloque, puisque je n'ai ni tnsnames ni un outil permettant de configurer l'instance style : "Assistant configuration oracle net".

<nom à utiliser dans la chaîne de connexion> =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = tcp)(HOST = <nom de la machine db>)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = <SID de l'instance Oracle>))
  )