Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Strange behaviour "/ as sysdba"

Re: Strange behaviour "/ as sysdba"

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 20 Jul 2004 16:43:26 +0300
Message-ID: <30a801c46e5f$913d7910$0a879fd9@porgand>


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.

> 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_at_eds.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fuad Arshad
> Sent: Tuesday, July 20, 2004 9:02 AM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 20 2004 - 08:40:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US