Re: DBA work without console access - possible ?

There is some poetic justice in what Sybrand recommends. Sometimes the best solution is to hold one's nose and let the fool sink. However, this really does not help your user community.

Cutting off your access impacts more than defining tables, performing imports, exports, etc. It also takes away your ability to monitor the various Oracle log and trace files, your ability to periodically purge archived log files, invoke the lsncntl program, etc..

This is an issue that I would escalate to the senior IS executive in the company - immediately. One foolish sysadmin on some kinda of powertrip should not be allowed to put the organization's database at risk.

"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 Wed Sep 13 2000 - 00:03:04 CDT