Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: administrative rights to Windows Server

Re: administrative rights to Windows Server

From: Anthony <akkha1234_at_gmail.com>
Date: 23 May 2007 14:55:03 -0700
Message-ID: <1179957303.885097.164580@x18g2000prd.googlegroups.com>


On May 23, 11:43 am, sybra..._at_hccnet.nl wrote:
> On 23 May 2007 11:01:00 -0700, Anthony <akkha1..._at_gmail.com> wrote:
>
> >I did go through the windows installation and platform guide briefly.
> >It mostly covers the initial installation and configuration part and
> >did not mention about daily operation. We already setup ORA_DBA group
> >for example.
>
> >Just to throw in a few ideas, when we were revoked system admin, we
> >can no longer get to scheduled tasks, we can not get to the oracle
> >database files and oracle dump files. A vbs script which extracts
> >event log breaks down etc.
> >Things like this we deal with on a daily basis. I hope some suggestion
> >from real life experience.
>
> I don't think your issue has much to do with Oracle. Your issue has
> everything to do with authority.
> Why would a non sys-admin need to fiddle around with scheduled tasks
> and parse the event log?
> Why would one need to have access to the Oracle database files?
> Apparently you don't use any tool Oracle provides to administer the
> database, but instead your sysadmin assumes you have seized control of
> the system (which is partly correct) and he doesn't like that.
> I must say I agree: either each of you have their own responsibility,
> or you take over all of the system, and you can turn it into whatever
> mess you prefer.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Obviously, we have different job requirements of DBA..

For me, I look into the event log to look for oracle related event (please read 6-6 of Oracle Documentation Platform Guide 10gr2 for Microsoft Windows (32Bit) B14304-05).

I also sometimes want to check the database files, examining the actual physical sizes and/or timestamps as reported by the window explorer. I also need to check oracle alert log and sometimes oracle trace files for performance tuning. I also schedule task which I do not think oracle job is the best tools. All of this I cannot do now when admin rights are taken away.

How about you? Received on Wed May 23 2007 - 16:55:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US