Re: On Unix, How do i find which is the SYSDBA and SYSOPER groups?
From: Alex Ivascu <alex_at_ivascu.comNOSPAM>
Date: Sat, 19 Oct 2002 04:39:14 GMT
Message-ID: <3DB0E214.1080002_at_ivascu.comNOSPAM>
>>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
Date: Sat, 19 Oct 2002 04:39:14 GMT
Message-ID: <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 Received on Sat Oct 19 2002 - 06:39:14 CEST