Strange behaviour "/ as sysdba " 2004-07-20 - By April Wells
Yep, that would be it. Get SA to chgrp on oracle to DBA. Then connect '/as
sysdba ' should work fine.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@ >-- >-- >--
"Few people really enjoy the simple pleasure of flying a kite "
Adam Wells age 11
"Imagination is the highest kite one can fly. "
Lauren Bacall
-- --Original Message-- --
From: Fuad Arshad [mailto:fuadar@(protected)]
Sent: Tuesday, July 20, 2004 8:36 AM
To: oracle-l@(protected)
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@(protected) > 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 (See ORA-01031.ora-code.com) error.
HTH -- Mark D Powell --
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Fuad Arshad
Sent: Tuesday, July 20, 2004 9:02 AM
To: oracle-l@(protected)
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@(protected)
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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
