[Robelle-l] suprtool for hpux - acces to remote oracle db

Thu, 15 Aug 2002 20:47:06 -0500

Sorry - everyone - my first posting and I realized I didn't include a
'subject' line - I relisted this with an appropriate subject.

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

(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.

_______________________________________________