On Unix, How do i find which is the SYSDBA and SYSOPER groups?
Date: Thu, 17 Oct 2002 19:49:45 -0700
Message-ID: <rbednQoeE7lH6jKgXTWcqQ_at_News.GigaNews.Com>
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,