How to determine the OSDBA group?

[Richard Piasecki]

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

[Sybrand Bakker]

"Richard Piasecki" <o...@mailcity.com> wrote in message
news:h0h6gu4542k376ajr...@4ax.com...

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

[Richard Piasecki]

Well, that's interesting. I wouldn't have expected Oracle to do it that
way. So, that also means that, once you've installed the software, there
is no way of changing those group designations. Interesting.

Thanks very much for the information, Sybrand.

--- Rich

[Sean M]

Richard Piasecki wrote:
>
> Well, that's interesting. I wouldn't have expected Oracle to do it that
> way. So, that also means that, once you've installed the software, there
> is no way of changing those group designations. Interesting.

No, you should be able to simply relink with a new OSDBA group name,
without having to reinstall.

Regards,
Sean

[Jonathan Lewis]

I'm not sure it's 100% standard across all unix
flavours - but look for:

$ORACLE_HOME/rdbms/lib/config.c

This will contain a couple of defines like:

#define SS_DBA_GRP "dba"
#define SS_OPER_GRP "dba"

char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP};

Some platforms may have an assembler equivalent.

You can probably change the groups by editing
this file, deleting config.o, then relinking, which
usually requires a command like:

make -f ind_rdbms.mk oracle
(does not replace oracle executable)
or
make -f ind_rdbms.mk ioracle
(replaces oracle executable in $ORACLE_HOME/bin)

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
UK June / July
Australia July / August
http://www.jlcomp.demon.co.uk/seminar.html

Richard Piasecki wrote in message ...