Re: can't connect to the database by using Sqlplus

Hi:

Sounds like the $ORACLE_HOME/bin/oracle executable has the wrong permissions. Make sure that they are 4755 and that the owner of the executable is "oralab". If the permissions are correct, check the permissions on the /oracle/oracle_dba/OraHome1/rdbms/audit directory. They should be 755 and the owner should be "oralab".

As an aside, this problem has nothing to do with sqlplus. Any other client program will encounter the same problem.

                                  Rick

"Jennifer Chang" <jchang_at_mac.com> writes:

> hi,
> I created a database whose SID is "lab" on a Solaris machine in addition
> to an already-running database.
> I used account "oralab" whose environment variable ORACLE_SID is "lab" to
> log in to the Solaris.
> but I couldn't use sqlplus to connect to the database "lab" (command:
> sqlplus /nolog
>
> connect / as sysdba )
> here is the error message:
>
> ERROR:
> ORA-09925: Unable to create audit trail file
> SVR4 Error: 13: Permission denied
> Additional information: 9925
>
> I've tried to change the directory
> "/oracle/oracle_dba/OraHome1/rdbms/audit" into writable so that I could
> connect to the database, but I didn't think this is the solution.
> please help, thank you.
>
>
> Jennifer C
>
>
 

-- 
                                Thanks,
                                Rick
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.