From: oracle <oracle@nightmare.com>
Subject: Re: Help on SQL*Net connection (HP-UX <-> NT)
Date: 1997/01/26
Message-ID: <32EC35C8.3073@nightmare.com>#1/1
references: <5cdvrb$p73@lana.zippo.com>
content-type: text/plain; charset=us-ascii
organization: Internet Access Group, Orlando, Florida
mime-version: 1.0
newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc
x-mailer: Mozilla 3.0 (Win95; I)



oracle@echo.ifc.pi.cnr.it wrote:
> 
> I've to realize a connection between a PC with Windows NT
> and an application yet unknown,
> and an HP 9000 with HP-UX, Oracle 7.2.3 and SQL*Net v2.
> I'm a newbie.
> Do I need an ODBC to make the connection

Depends on the client tool.  

> or the tools supplied by SQL*Net are sufficient?

If it is an Oracle based product or the tool is written
to work with SQL*NET then you will need it installed on
both sides.

> Do I need SQL*Net at both ends of the connection?
> Also I'm not sure if the installation (not made by me) is complete:
> listener.ora is present,

The tnsnames.ora is only needed on the client end.  You should have
a copy of it on the server end though so you can test SQL*NET with
a loop-back test.  That is you make server-server connection to 
verify it is working on the server end.

> tnsnames.ora and initlst.ora aren't.
> Then, I must send and retrieve big files (format .avi),
> so in the column of my table I will put the path to the file.
> What is the best way to do this automatically?
> A PL/SQL procedure?
> Any help, also elementary, highly appreciated!
> 
> Fabrizio Vassallo