@ Zach, i will definitely give your suggestions a go. thanks.
@Dickson, i actually use toad but have always accessed the different db's separately, guess its time to explore its ability to run a single query on multiple db's. Thanks.

more ideas are welcome.
cheers.



On Mon, Feb 1, 2010 at 1:33 PM, Ukang'a Dickson <ukanga@gmail.com> wrote:




On Mon, Feb 1, 2010 at 1:22 PM, Maq Tim <maqlists@gmail.com> wrote:
Thanx zach.
And from where do you suggest i run my queries in XP? application etc...

you could use toad to connect to both databases, I am not sure about it but its the best frontend for oracle I have worked with, it should have the capability to run queries on multiple oracle dbs. http://www.toadsoft.com/
Regards

Ukang'a Dickson

On Mon, Feb 1, 2010 at 12:53 PM, Zacharia Gatu <zkgatu@googlemail.com> wrote:
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


_______________________________________________
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