Re: UNIX and sqlplus

From: Pascal Byrne <byrne_at_nospam.net>
Date: Fri, 18 Oct 2002 09:20:15 +0200
Message-ID: <3DAFB62F.3050105@nospam.net>

The easy way is to configure tnsnames.ora and listner.ora to allow remote connection from a local sqlplus. e.g.

tnsnames.ora

---

db.remote =

(DESCRIPTION =(ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP)(HOST = remote)(PORT = 1521))
     )
     (CONNECT_DATA =(SERVICE_NAME = db.remote))

)

listner.ora

---

LISTENER =
(DESCRIPTION_LIST =

     (DESCRIPTION =
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
         (ADDRESS = (PROTOCOL = TCP)(HOST = remote)(PORT = 1521))
       )
     )

   )

See Oracle Net8 Administrator's Guide

-Pascal

Mike Tinney wrote:

> I looking for the correct syntax or a easy way to do a select from a 
> remote
> system on UNIX to be used via a sqript.
>
> Listed below is the current syntax that I have but I can't get it to work.
>
> Is there an easier way to include the sql script file in the original
> script?  or should I have it on the remote system ?
>
>
>
>
> remsh entorap -l ods_dba -n ". /u01/entitle/app/oracle/.profile \;
> sqlplus -s system/passwd  < queue_count.sql" >
> /opt/apache_sd/cgi-bin/count.log 2>&1
>
> Thanks
> Mike
>
>
>
>

Received on Fri Oct 18 2002 - 02:20:15 CDT