Re: gui tool for oracle.. what is client when installation?

1 & 2: Yes, you add tcp.validnode_checking=yes and tcp.invited_nodes=(...) into either your sqlnet.ora or protocol.ora (no need to add to both) and then restart listener so that setting takes effect. Now only nodes listed in tcp.invited_nodes will be able to connect. 3,4 & 5: Your friends actually only need to install any X-Windows server and ssh client that supports tunneling. They need to setup ssh client to tunnel X-Windows, that's it. There are plenty of free and shareware X-Windows servers for Windows.
Now YOU install the GUI tools of your choice. Your friends will use X-Windows client over secure channel to work with your database on YOUR machine. They don't need Oracle client installed.

Now about your question on 'what is oracle client' - this is a set of libraries and executables which provide connectivity with the database server. Every database server provides such set, Oracle is no exception, and in almost all cases this set is called 'client' because it is necessary to enable client nodes to connect to the database server. Oracle Client software also includes a lot of utilities and libraries which are not essential for database connectivity, these are mostly useful for DBAs and developers. Hope this makes matter clear.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"eugene kim" <eugene1977_at_hotmail.com> wrote in message news:alit3l$91b$1_at_newsreader.mailgate.org...


> thanks again..

> 

> can u give me some more detailed steps?

> i feel like learning cd/rm/compile stuff for the first time

> 

> 

> 1.i add

> tcp.validnode_checking=yes

> tcp.invited_nodes=(list of IPs that are allowed to connect, comma-separated)

> $ORACLE_HOME/network/admin sqlnet.ora protocol.ora

> 

> 2. restart listner

> lsnrctl stop

> lsnrctl start

> 

> 3.let my friends install desired gui tools and oracle client

> 

> -----???

> 4.let them connect to my comp through ssh?

> 5.they run the gui tool?

> 

> ....

> sorry, i'm such a newbie ...

> thanks for help