RE: Strange behaviour "/ as sysdba"
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 20 Jul 2004 07:29:12 -0700 (PDT)
sorry my mistake when setting up su
the gid is dba whereas the groups is staff which seems right.
anything else i should look for
Fuad Arshad <fuadar@xxxxxxxxx> wrote:
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" 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:
