RDC to Oracle Servers
Paladin
created: 2004-06-30 11:57:15
At work, I admin a half dozen or so different Oracle servers, and sometimes it's a pain to try and remember which particular DB is on which machine, so I wrote a small script to allow me to RDC to the correct machine given a DB name. Using wperl.exe rather than perl.exe gets rid of the console window opening up when you run it.
#!C:\perl\bin\wperl.exe -w
use strict;
use warnings;
use Win32::Process;
use Tk;

my $mw = MainWindow->new;
$mw->Label(-text => 'Oracle DB:')->pack;


my $db = $mw->Entry(
        -width    => 20,
)->pack;
$db->bind('Tk::Entry', '', \&connect);
$db->bind('Tk::Entry', '', sub { exit });
$db->focus;

my $message = $mw->Message(-justify => 'center', -text => '')->pack;
MainLoop;

sub connect {
    my $dbname = $db->get;
    my ($server) = `tnsping $dbname` =~ /HOST=([^)]*)/;
    if (defined $server) {
        my $ProcessObj;
        Win32::Process::Create($ProcessObj,
        "c:\\winnt\\system32\\mstsc.exe",
        "mstsc /v:$server",
        0,
        NORMAL_PRIORITY_CLASS,
        ".")|| die ErrorReport();
        exit;
    } else {
        $message->configure(-text => "The database \"$dbname\" can't be found");
    }
}

sub ErrorReport {
    print Win32::FormatMessage( Win32::GetLastError() );
}

Re: RDC to Oracle Servers
dba
created: 2004-07-06 13:13:35
If the problem is remembering db to host mapping, a simple solution would be to ask your network admin to alias db name to hostname in DNS server.
if your network admin won't allow, update in your XP hosts file.

perlmonks.org content © perlmonks.org and dba, Paladin

prlmnks.org © 2006 edmund von der burg (eccles & toad)

v 0.03