Re: How do you use SQL*NET to connect PC application to database on server?

wmorgan_at_nswc.navy.mil (William E. Morgan) writes: > I have developed some Oracle Developer/2000 Forms applications on my PC. I am
> currently using the Personal Oracle 7 database on my PC, but now I need to
> move the database to our database server, which is a DEC ALPHA machine. I
> know I need to use SQL*NET somehow to allow my PC applications to talk to the
> database on the server, but I have no idea how to accomplish this! I have
> SQL*NET loaded on my PC, and a listener is running on the server, but that's
> as far as I have gone. Our database administrator who was working out the
> details of how to do this suddenly left for another company, and of course, no
> one else knows anything about it! Thanks for any help anyone out there can
> give me on getting started. Please email responses. Thanks!
>
> ---------------------------------------------------------------------------
> William E. Morgan NAVAL SURFACE WARFARE CENTER

Hi there,

To install SQL*NET on a PC you need to following steps.

1. Try to PING your database server from PC. This is the basic step to ensure that connectivity is established.
2. Edit win.ini in C:\WINDOWS. Look out for [ORACLE] section. Check the path of ORA_CONFIG variable. It will be like the following

   [Oracle]
   ORA_CONFIG=c:\windows\oracle.ini

   Edit the above ini file and you can see the ORACLE_HOME directory.

3. Install Sql*Net Ver 2.x on your client.

4. On the above ORACLE_HOME\network\admin directory, create the following files.

   TNSNAMES.ora
   SQLNET.ora

   You can use ORACLE network manager to generate the above files.

5. Perform Oracle Nettest to see whether Oracle can connect to your

   remote database.

   Execute $ORACLE_HOME\network\admin\nettest.exe. You need to supply    a valid user, password and connect string.

If the above steps are completed successfully, then you can run your application against your database server.

For further instruction, please refer to Oracle Network Manager.

Regards

N.Prabhakar Received on Fri Nov 22 1996 - 00:00:00 CET