Re: Tools for remote DBA work

From: Martin Bach <development_at_the-playground.de>
Date: Sat, 24 Jul 2010 07:57:33 +0100
Message-Id: <20100724065735.A313A26D6745_at_oberon.hgrfactory.com>

I use different virtual machines depending on vpn client. Cisco's vpn client for example doesn't like VMWare virtual network cards and requires many attempts before connecting.

For those who prefer GUI over sql plus I suggest port forwarding for the listener.

Team collaboration is a bigger problem, it requires good will from all participants. Regular team meetings, ideally with video, are essential (imo). It is very easy to misunderstand email and instant messages, making it difficult to develop a "we" feeling. In thus respect, technology doesn't beet face to face encounters.

But that's just me, with how I experienced it. Your mileage may vary.

Regards,

Martin Bach

Oracle Certified Master 10g
http://martincarstenbach.wordpress.com
http://www.linkedin.com/in/martincarstenbach

• Reply message ----- From: "Andrew Kerber" <andrew.kerber_at_gmail.com> Date: Fri, Jul 23, 2010 22:33 Subject: Tools for remote DBA work To: <orclwzrd_at_yahoo.com> Cc: <don_at_seiler.us>, <howard.latham_at_gmail.com>, <mschmitt_at_uchicago.edu>, "oracle-l-freelists" <oracle-l_at_freelists.org>

I second the virtual machine solution. Some VPN software is very particular about its environment, at one point I was using one that had to be reinstalled every time windows update the OS. It lived in its own VM.

On Fri, Jul 23, 2010 at 4:18 PM, John D Parker <orclwzrd_at_yahoo.com> wrote:

> A VM machine that your vpn is loaded on keeps your local machine free and
> out of that special vpn black hole. Outside of that, ssh to host, run local
> sqlplus. keep your fav scripts on an ftp/www site that you can easily access
> to pull them over.
>
> John
>
> ------------------------------
> *From:* Don Seiler <don_at_seiler.us>
> *To:* howard.latham_at_gmail.com
> *Cc:* mschmitt_at_uchicago.edu; oracle-l-freelists <oracle-l_at_freelists.org>
> *Sent:* Fri, July 23, 2010 4:13:33 PM
> *Subject:* Re: Tools for remote DBA work
>
> VNC client, ssh client, irc client, IM client. Probably a VPN will be
> required. I usually ssh to a server and run sqlplus locally, but some
> might prefer to install Oracle client on their local machine and
> connect over TNS remotely.
>
> Don.
>
> On Fri, Jul 23, 2010 at 4:10 PM, Howard Latham <howard.latham_at_gmail.com>
> wrote:
> > I just vnc onto any box I need to work with.
> >
> > On 23/07/2010, Michael Schmitt <mschmitt_at_uchicago.edu> wrote:
> >> Hello,
> >>
> >> Can anyone recommend any tools or software that they have found useful
> when
> >> working remotely? Is a static IP address a must? My main concern is
> team
> >> collaboration, and any software that can help facilitate that aspect of
> the
> >> job when not in the office for long stretches.
> >>
> >> Thanks in advance
> >>
> >>
> >>
> >
> >
> > --
> > Howard A. Latham
> >
> > Sent from my Nokia N97
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
>
> --
> Don Seiler
> http://seilerwerks.wordpress.com
> ultimate: http://www.mufc.us
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jul 24 2010 - 01:57:33 CDT