how to create a os user and allow user to login as sysoper in open suse-10g
we create a os user and db user with same name and tried to login as sysoper but the new os user can not able to login as sysoper.. can u plz help me??
sudo /usr/sbin/useradd testdba -p XXXXXX
sudo /usr/sbin/usermod -g oinstall -G oper testdba
user: oracle as sysdba
SQL> show parameter os_au
os_authent_prefix string ops$
remote_os_authent boolean FALSE
create user ops$testdba identified by xxxxx;
grant connect,sysoper to ops$testdba;
when i login as testdba
sqlplus "/as sysoper"
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 29 08:10:12 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux Error: 13: Permission denied
Additional information: 9925
ORA-01031: insufficient privileges
there is plenty of disk space in systems.. can u help me how to enable a os user to login as sysoper but not sysdba!
Can u help me please thanks in advance.