[Robelle-l] (no subject)

[Leslie Tsukamoto]

I am trying to utilize suprtool to extract data from a remote oracle
database - currently we have suprtool loaded on an HP9000 and accessing a
local 7.3.4 oracle database - I have exported that database and imported it
onto a seperate unix box in an oracle 8.1.7 instance.  I have made the
appropriate oracle configuration changes by adding the new database
connection information in the local hp9000 tnsnames.ora file.  I have been
successful in connecting all other applications on the hp9000 to this remote
database but continue to fail in my attempts to have suprtool see it.
 
 
For Oracle's sqlplus - we connect this way:
 

$ sqlplus sched1/tstpass@simtst
 
SQL*Plus: Release 3.3.4.0.0 - Production on Thu Aug 15 17:13:30 2002
 
Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.
 

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL>

 
Now, - having done all of that this is what I have attempted this far with
suprtool:
 

$ suprtool
SUPRTOOL/UX/Copyright Robelle Consulting Ltd. 1981-1999.  Type H for help.
(Version 4.2)  THU, AUG 15, 2002,  5:15 PM
Licensee:  SimuFlite Training International [91N]
>open oracle sched1@simtst tstpass
 
Error:  Unable to connect to the Oracle database
 
Error:  ORA-12154: TNS:could not resolve service name
 
>open oracle sched1 tstpass@simtst
 
Error:  Unable to connect to the Oracle database
 
Error:  ORA-12203: TNS:unable to connect to destination
 
>

 I would like to know if anyone out there has ever tried to have suprtool
for HPUX access a remote oracle database and if so, what version of suprtool
was required and how was the open statement coded.