Check the authorities on the directory $ORACLE_HOME/rdbms/audit . This is,
by default, where the SVRMGRL used to put its audit files when you logged
into Internal. Probably does the same when you connect via SQLPlus. The
authorities on this directory on our system is drwxr-xr-x . This would make
the owner, ORACLE, have full create but the group and world would only have
Execute and Read. You should at least have your Group permissions set to
wxr.
-----Original Message-----
Sent: Tuesday, September 04, 2001 6:01 PM
To: Multiple recipients of list ORACLE-L
I can connect to sqlplus as "internal" if I am logged on to UNIX as the
oracle owner "oracle".
But I want to be able to logon to SQLPLUS as "internal" from another UNIX
user.
I had the SA's set up a user and assigned him to the group "dba" (database
group).
But I am having problems connecting :
SQL*Plus: Release 8.1.6.0.0 - Production on Tue Sep 4 14:56:13 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter user-name: internal
ERROR:
ORA-09925: Unable to create audit trail file
SVR4 Error: 13: Permission denied
Additional information: 9925
How do I configure this on my system ?
Environment :
Oracle 8.1.6
Sun Sparc Solaris 5.8
Thanks in advance
P Howe
Email : [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pat Howe
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).