Re: How to determine the OSDBA group?

"Richard Piasecki" <ogo_at_mailcity.com> wrote in message news:h0h6gu4542k376ajrc3eb2qmkrn4ql85c4_at_4ax.com...
> Quick question for anyone out there:
>
> How can I determine what the unix OSDBA/OSOPER groups are?
> I'm assuming Oracle 8i on a Solaris system.
> So, in other words, when I use svrmgrl and type "connect internal", what
> does oracle do to determine whether it should permit the connection or
> throw up the dreaded "Password:" prompt?
>
> I assume the group names are stored somewhere in the data dictionary but
> I've yet to find it. I've spent several hours looking over the docs and
> the internet, but have found nothing yet. Anybody know?
>
>
> --- Rich
>

The group name is NOT in the datadictionary, it is specified before link, and linked into the executables.
That said you should be able to find it in the installation log in the OraInventory directory.
By default the group name however is 'dba' (without quotes of course)
Improper file ownership and/or file system privileges will result either in ora-1031, insufficient privileges, or ora-1034 oracle not available. Also the oracle executable must have the setuid bit on.

If you are not in the dba group the settings of remote_login_passwordfile will determine the further cause of actions

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address