Re: Accessing remote ORACLE data from a PC.

p228_at_uni05.larc.nasa.gov (Bailey Bob) writes:

>In article <1992Dec8.212302.8619_at_esrican.uucp> aladak_at_esri.com writes:
>>I need to bring ORACLE data located on a SUN 360 to EXCEL for WINDOWS running
>>on a PC. We tried using a product called SECOND WIND which runs on EXCEL. The
>>product needs SQL*Net with TPC/IP installed on the PC. After trying almost
>>everything under the SUN, we still get a connect error.
>>
>>Has anyone done anything like this successfully with either of these or another
>>product? I would appreciate any suggestions or pointers.
 

>SQL*Net requires two files to be set up correctly before it will work:
 

> hosts
> services
 

>The hosts file should contain a list of the system names & IP addresses:
 

> IP ADDRESS HOSTNAME ALIAS
> 128.155.001.001 XYZSYSTEM XYZ
> 128.155.001.002 ABCSYSTEM ABC
 
>The services file must contain the following:
 

> ORASRV 1525/TCP
 
>NOTE: the TCP assumes you are using TCP/IP protocol.
 

>Bob Bailey

Also, you must specify the location of the hosts and services file in the Oracle "config.ora" file on the PC.

What network package are you using on the PC? I just setup SQL*Net on a PC running PC-NFS. It is required to start 'rtm', then 'sqltcp' otherwise my connection hung.

I installed sqlplus so I could test the PC -> HOST connection before running WINDOWS software. If you try to run SQL*Plus, you must also start 'sqlpme'. You must stop 'sqlpme' before firing up WINDOWS (I think the command is 'rempme').

Good luck.

---
  /_ _   /		sequent computer system, inc.	+-----+
 / / /  /__/ __		15450 sw koll parkway		|   # |
/ / /  / \__(_/_/_/	beaverton, or  97006-6063	|     |
mary kay petersen/	mkay_at_sequent.com 		+-----+
(503)578-5817 __/