Account to install Oracle with on Windows platform
in [Oracle]
|
Prev: Identifying the MML used for a particular backup set
Next: Heteregenous connections client ==> oracle database ==>sqlserver
From: macdba321 on 20 Jun 2008 10:13 On Jun 12, 7:25 pm, sybra...(a)hccnet.nl wrote: > On Thu, 12 Jun 2008 13:34:55 -0700 (PDT),macdba321 > > <macdba...(a)gmail.com> wrote: > >Folks, > > I have always worked on Sun/HP platforms in the past. There it was > >clear to install the Oracle kernel under an "Oracle" OS account, as > >opposed to root. > > > However, now I have to install it on a Windows 2003 64-bit platform. > >Do most DBAs installing on MSWin install as the "administrator" > >account, or also create an "oracle" account and make it a member of > >the admin group? > >What are the pros/cons of it on MSWin? > > >11g/ASM/RAC in case it matters. > > >thanks. > > Most DBAs read the installation documentation and use the *local* > administrator account, as specified by the documentation. > > -- > Sybrand Bakker > Senior Oracle DBA Really? I'm guessing that you have not "read the installation documentation" then because it states: To install the Oracle Database software: 1. Log on as a member of the Administrators group to the computer on which you want to install Oracle components. If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group. as specified in: Oracle® Database Installation Guide,11g Release 1 (11.1) for Microsoft Windows,Part Number B32006-03 Since you read the documentation, please show me where it says to use the *local* administrator account. Because, nowhere that I have found does it state to use the "local administrator account". It states to be a "member of the Administrators group". So my question is still valid: Are most of you out there installing as "Administrator" or as an "Oracle" account that is a member of the administrators group?
From: Charles Hooper on 20 Jun 2008 18:54 On Jun 20, 10:13 am, macdba321 <macdba...(a)gmail.com> wrote: > Really? I'm guessing that you have not "read the installation > documentation" then because it states: > > To install the Oracle Database software: > 1. Log on as a member of the Administrators group to the > computer on which you want to install Oracle components. > If you are installing on a Primary Domain Controller (PDC) > or a Backup Domain Controller (BDC), log on as a member of the Domain > Administrators group. > > as specified in: Oracle® Database Installation Guide,11g Release 1 > (11.1) for Microsoft Windows,Part Number B32006-03 > > Since you read the documentation, please show me where it says to use > the *local* administrator account. Because, nowhere that I have found > does it state to use the "local administrator account". It states to > be a "member of the Administrators group". So my question is still > valid: Are most of you out there installing as "Administrator" or as > an "Oracle" account that is a member of the administrators group? Follow the install guide (or the Windows specific info) in the documentation. Please note: it is possible that domain administrators are not in the administrator's group on the server. The user performing the install must be a member of the local administrator's group. There is no concept of a local administrator's group on a PDC or BDC (NT 4 terms) or a DC (Active Directory term), so on such a computer Oracle must be installed using an account in the Domain Admins group. If the computer is not part of a domain, Oracle should be installed by a user with local Administrator permissions. Keep it simple. Log into the server as a domain admin, install Oracle, create a local user for use with Enterprise Manager - the user should be a member of the ORA_DBA group, and possibly the computer's Administrator group. This user must also have specific system permissions, as spelled out in the install guide. The Oracle services should be running using the "Local System Account". Charles Hooper IT Manager/Oracle DBA K&M Machine-Fabricating, Inc.
From: hpuxrac on 22 Jun 2008 19:17 On Jun 20, 10:13 am, macdba321 <macdba...(a)gmail.com> wrote: snip > Since you read the documentation, please show me where it says to use > the *local* administrator account. Because, nowhere that I have found > does it state to use the "local administrator account". It states to > be a "member of the Administrators group". So my question is still > valid: Are most of you out there installing as "Administrator" or as > an "Oracle" account that is a member of the administrators group? First advice is to run oracle on a unix/linux machine instead of windows. If you do have to use windows, then bottom line, what Mr. Bakker said aka recommending using a local admin account is pretty much dead on as good advice based on all the postings we have seen here in cdos over the years. You can use the google groups search interface against cdos and check yourself if you want to.
From: gazzag on 23 Jun 2008 08:20 On 23 Jun, 00:17, hpuxrac <johnbhur...(a)sbcglobal.net> wrote: > First advice is to run oracle on a unix/linux machine instead of > windows. > > If you do have to use windows, then bottom line, what Mr. Bakker said > aka recommending using a local admin account is pretty much dead on as > good advice based on all the postings we have seen here in cdos over > the years. > > You can use the google groups search interface against cdos and check > yourself if you want to. I believe that the OP is asking whether there's any merit in creating a Windows "Oracle" logon, as one would do on a Unix system. As far as I can see, that has not been addressed. -g
From: Arch on 23 Jun 2008 13:48
On Fri, 20 Jun 2008 07:13:15 -0700 (PDT), macdba321 <macdba321(a)gmail.com> wrote: >On Jun 12, 7:25�pm, sybra...(a)hccnet.nl wrote: >> On Thu, 12 Jun 2008 13:34:55 -0700 (PDT),macdba321 >> >> <macdba...(a)gmail.com> wrote: >> >Folks, >> > �I have always worked on Sun/HP platforms in the past. There it was >> >clear to install the Oracle kernel under an "Oracle" OS account, as >> >opposed to root. >> >> > �However, now I have to install it on a Windows 2003 64-bit platform. >> >Do most DBAs installing on MSWin install as the "administrator" >> >account, or also create an "oracle" account and make it a member of >> >the admin group? >> >What are the pros/cons of it on MSWin? >> >> >11g/ASM/RAC in case it matters. >> >> >thanks. >> >> Most DBAs read the installation documentation and use the *local* >> administrator account, as specified by the documentation. >> >> -- >> Sybrand Bakker >> Senior Oracle DBA > >Really? I'm guessing that you have not "read the installation >documentation" then because it states: > >To install the Oracle Database software: > 1. Log on as a member of the Administrators group to the >computer on which you want to install Oracle components. > If you are installing on a Primary Domain Controller (PDC) >or a Backup Domain Controller (BDC), log on as a member of the Domain >Administrators group. > >as specified in: Oracle� Database Installation Guide,11g Release 1 >(11.1) for Microsoft Windows,Part Number B32006-03 > >Since you read the documentation, please show me where it says to use >the *local* administrator account. Because, nowhere that I have found >does it state to use the "local administrator account". It states to >be a "member of the Administrators group". So my question is still >valid: Are most of you out there installing as "Administrator" or as >an "Oracle" account that is a member of the administrators group? I can't tell you for certain what is "right" or even what the documentation suggests. I have installed Oracle many, many times and teach others to do so. I always recommend - not using the Administrator account. That account will be shared by system administrators, will likely need to have the password changed when someone leaves the group. Some sites don't want dba's to have the Administrator password. Likewise most dba's don't want system administrators to have the oracle password. Whatever account you use to install Oracle, will, of course, need to be a member of the administrators group. Administrator does not need to be a member of the ora_dba group. My 2 cents worth, Arch |