Re: On Unix, How do i find which is the SYSDBA and SYSOPER groups?

Alex Ivascu <alex_at_ivascu.comNOSPAM> wrote in message news:<3DB0E214.1080002_at_ivascu.comNOSPAM>...
> segfahlt wrote:
> > 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? :)
> >
> >
>
> Just got the message... glad you figured it out. Might not hurt to read
> up on some security things, within oracle. Search on
> http://tahiti.oracle.com for some information, that may come in handy in
> the future....
>
> Take care.
>
> Alex Ivascu

After getting into sqlplus did you try 'connect sys/"password" as sysdba' and still could not?
Michael Tubuo Ngong Received on Mon Oct 21 2002 - 19:07:45 CEST