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.
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-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
Thanx zach. And from where do you suggest i run my queries in XP? application etc... 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
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
@ 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
You can run your SQL queries from the a DOS prompt, or an application like SQL Developer. Anywhere on XP really, as the access will be 'local'. On 1 February 2010 10:22, Maq Tim <maqlists@gmail.com> wrote:
Thanx zach. And from where do you suggest i run my queries in XP? application etc...
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-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
participants (3)
-
Maq Tim -
Ukang'a Dickson -
Zacharia Gatu