Re: How do you know whether you have SQL*Net installed

Winston Soon (student9_at_singnet.com.sg) wrote:
: I have access to all files in the server which contains oracle databases.
: I am trying to use MS-Access to access an oracle database in another host.
 

: How do I know whether SQL*net is installed on the server and how do i know
: whether a listener is installed?

On the server side, try this as oracle:

        lsnrctl status

It should tell yu whether you have a listener, and the protocol it is communicating in (TCP/IP etc).

On the client, you can check thru the Oracle installer - look at the list of installed products.

: If I am trying to use MSAccess as a client to access the database in the
: server are these 2 programs necessary to be installed in the server?

Many ways of doing this. The most common being ODBC or Oracle Ojbects for OLE.

--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081  Fax: +61-3-9892-9344
WWW: http://www.vut.edu.au/voug