Re: On Unix, How do i find which is the SYSDBA and SYSOPER groups?
From: segfahlt <segfahlt_at_longboys.net>
Date: Fri, 18 Oct 2002 11:01:57 -0700
Message-ID: <GP-cnX1Ro5MH0C2gXTWcoQ_at_giganews.com>
>
> I created two groups, dba and oper. I added my Oracle user(oinstall) to
> these groups(he can successfully newgrp to dba and oper). I can connect
> to
> oracle okay just using the system login and not connecting as SYSDBA.
> When I query the v$pwfile_users, its empty.
>
> Should I recreate my database you think?
>
> When i try to connect to oracle using sys as SYSDBA, i get an insufficient
> privileges error.
>
> After numerous queries into the data dictionary, I was unable to determine
> which table the v$pwfile_users is actually going against. I was going to
> just manually insert my 'SYS', 'TRUE', 'TRUE' into the table. Any ideas
> if that will work?
>
> thanks.
>
> bill
Date: Fri, 18 Oct 2002 11:01:57 -0700
Message-ID: <GP-cnX1Ro5MH0C2gXTWcoQ_at_giganews.com>
segfahlt wrote:
> Hi Alex,
> Thanks for the reply.
>
>
> Alex Ivascu wrote:
>
>> segfahlt wrote: >>> I have just installed Oracle 9iR2 on my Linux Redhat 8.0 box. >>> >>> I created 2 groups, like the install said, dba, and oper. During >>> the install, i used these two groups as my SYSDBA and SYSOPER. >>> >>> After the Install, I cannot connect to my database as SYSDBA. I get >>> an "insufficient privileges" error. >>> >>> I reviewed the documents. It appears that I just need to have my account >>> have my the SYSDBA(dba) account as a secondary group. I have done that. >>> >>> I also used the orapwd utility to make sure my password is set >>> correctly. That didn't work. I connected as SYSTEM and did the alter >>> user SYS identified by <new password>. Still no joy. >>> >>> I guess now I need to find out which groups my Oracle database is >>> looking at for SYSDBA and SYSOPER? I'm sure its in the Data Dictionary >>> somewhere, just not sure where. >>> >>> Anybody got any help? >>> >>> I'll keep digging. >>> >>> TIA, >>> >>> bill >> >> I really don't understand your issue.... sorry. This is what I can tell >> you. >> >> SYSDBA and SYSOPER ar oracle groups. >> dba is an OS/Linux group. >> >> When you install Oracle, you first create two groups, oinstall and dba, >> then create user oracle (such as useradd oracle -g oinstall -G dba). >> Connect as oracle. Create your password file either as orapw (if >> shared) or orapwsidname ( if exclusive). Install your server and create >> a new database. Once connect to oracle, and database successfully >> installed, you can query the v$pwfile_users view which will tell you >> which users are part of the SYSDBA and SYSOPER groups (default SYS). >>
>
> I created two groups, dba and oper. I added my Oracle user(oinstall) to
> these groups(he can successfully newgrp to dba and oper). I can connect
> to
> oracle okay just using the system login and not connecting as SYSDBA.
> When I query the v$pwfile_users, its empty.
>
> Should I recreate my database you think?
>
> When i try to connect to oracle using sys as SYSDBA, i get an insufficient
> privileges error.
>
> After numerous queries into the data dictionary, I was unable to determine
> which table the v$pwfile_users is actually going against. I was going to
> just manually insert my 'SYS', 'TRUE', 'TRUE' into the table. Any ideas
> if that will work?
>
> thanks.
>
> bill
I just dropped and recreated the database. It works now. Must have been a geeked up db creation. thats what I get for using the GUI i guess ay? :) Received on Fri Oct 18 2002 - 20:01:57 CEST