I'd suggest using port forwarding via SSH. Here's how you can can go about it:
On XP, using an SSH client, let's say putty
<http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html>,
create a 'tunnel' to forward all requests to standard Oracle port 1521
on db_A to a local port on XP, e.g. 1522. Then log in to server A.
Open another instance of putty and create a tunnel to forward all
requests to db_B's port 1521 to a local port, e.g. 1523, then log in.
Now on your XP, you can run your queries as if the 2 databases were local.
On 1 February 2010 09:38, Maq Tim <maqlists@gmail.com> wrote:
> Howdy guys,
> scenario:
> Am on my XP machine. I need to remotely access two different oracle
> databases(db_A and db_B) on two different unix servers via ssh. The whole
> idea is to be able to log into the databases, run some select queries so i
> can compare 'two' similar tables(table_AB contained in both db's) on the two
> databases to ensure they have the same no of rows & data.
> Note that usually, i can access the servers and the db's but separately and
> have to use two windows of my xshell access via ssh to display my query
> results.
> Que: how can i do a single script on my winXP machine without having to log
> into both servers then the db's separately?
>
> will appreciate some ideas on efficiency here....
>
> regards,
> Tim.
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
> Skunkworks Server donations spreadsheet
> http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
> ------------
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
> Other lists
> -------------
> Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
> Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
> kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
>
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
Other lists
-------------
Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general