@ 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<http://www.chiark.greenend.org.uk/%7Esgtatham/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-dHlQVTMxU1VBdU1BSWJxdy1f...
------------ 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-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ 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-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ 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-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ 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