Re: DBA work without console access - possible ?

heheh

Sybrand, clearly we all have gone through this including you and you are planning some revenge in this sysadmin for whatever was done to you.

I like

lets see the sysadmin handles this.

george

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:968693321.25283.3.pluto.d4ee154e_at_news.demon.nl...
>
> <rock_cogar_at_my-deja.com> wrote in message
> news:8pj1eb$mff$1_at_nnrp1.deja.com...
> > I run a number of 8.1.5 instances on NT 4.0, sp5 boxes. I like to do
> > everything in script (avoid use of OEM, whenever possible) and until now
> > have had unrestricted access to the server consoles.
> >
> > Now, the NT sys admin says that "ONLY HE IS ALLOWED CONSOLE ACCESS" !
> >
> > So without using the server consoles, how do I:
> >
> > 1. Create tablespaces ?
> > 2. export/import ?
> >
> > Thanks,
> > Rock.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> 1 You don't need console access for that
> 2 You don't need console acces for that, however if you are forced to
 export
> over the network (assuming you can't access any drive on the server), it
> will be about 5 times slower. Just install a dba client on your system and
> you are there.
> This would btw also allow you to restart the database, provided you can
> reach init<sid>.ora
>
> Yes, it is possible, but I agree with you it is damn stupid of him to
> disallow you access.
>
>
> What I would recommend is doing the following:
>
> 1 switch to oem (you can use your scripts as usual, for many things you
 only
> need dba authority, and as Oracle is runnin in the administrator account
 on
> the server anyway, you can create any file you want), partly to have a
 good
> joke
> 2 Make sure you configure all appropiate up/down events in OEM
> 3 Make also sure you enter *his* pager and/or *his* email-address at
> appropiate places. This means he will have to deal with any disturbance,
 and
> as you aren't notified (you can enter only one address or number) you can
> pretend to know nothing.
>
> Now wait and see how quick you get access to the server room again.
>
> I would be interested to learn the outcome, and I might be willing to give
> you a hand configuring it.
>
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Tue Sep 12 2000 - 00:03:57 CDT