Re: Strange behaviour "/ as sysdba"

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 20 Jul 2004 16:43:26 +0300

You need to change the OSDBA and OSOPER group names from dba to staff in
your $OH/rdbms/lib/config.s file and relink the executables.

Tanel.

----- Original Message ----- 
From: "Fuad Arshad" <fuadar@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, July 20, 2004 4:36 PM
Subject: RE: Strange behaviour "/ as sysdba"


> yes this is AIX
> TWO_TASK is unset.
> the only thing that i think is strange  that when i su to oracle the group
doesnt change to dba instead it is set to staff. need to talk to my
sysadmins about this.
> "Powell, Mark D" <mark.powell@xxxxxxx> wrote:
> IF you are on a UNIX version then when you set your Oracle environment do
> you set the TWO_TASK variable? If so unset TWO_TASK prior to attempting to
> create a sysdba session via sqlplus /nolog. Having TWO_TASK set when you
> attempt to connect / as sysdba using OS group security will result in a
> ORA-01031 error.
>
> HTH -- Mark D Powell --
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Fuad Arshad
> Sent: Tuesday, July 20, 2004 9:02 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Strange behaviour "/ as sysdba"
>
>
> We are movign all our accounts to su only authentication on the os level.
> one of the problems i'm seeing it that if i su into oracle and do a
> conenct / as sysdba
> i get a 1031 insufficient privileges.
> the remote_login_passwordfile is set to exclusive.
> i can connect thru sysdba if am logged in directly .
> any ideas any one have this issue.
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: