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

IIRC, the audit trail for SYSDBA/SYSOPER access (which you are attempting) is located in $ORACLE_HOME/rdbms or $ORACLE_HOME/rdbms/admin.

Try to connecting as an ordinary user first (using ORACLE_SID), from a different user than oracle. I'm guessing you will get ORA-1034 and the protection of your files and directories is incorrect.

Hth,
Sybrand Bakker, Oracle DBA

"Jennifer Chang" <jchang_at_uxb2b.com> wrote in message news:9029lt$pt0$1_at_news.seed.net.tw...
> user "oralab" is a member of group "dba"
>
> once I login in the Unix with any users belong to group dba, I simply key
> in
> "sqlplus [username] / [passwd] @ [the service name of an already-running
> DB] " to connect the database
> for example, ksh> sqlplus abc/abc_at_test
>
> since i didn't config the tnsname.ora for database "lab" (ORACLE_SID),
> >sqlplus sys/admin_at_lab wouldn't work.
> it should work if the ORACLE_SID is already set to "lab" in user oralab's
> profile
>
> I've tried to log in the Unix with user "oracle", and set ORACLE_SID into
> lab
> sqlplus worked find,
> I still don't know what's wrong with it.
>
> Thank you.
>
> Jennifer C
>
> <gmei_at_my-deja.com> ¼¶¼g©ó¶l¥ó news:901ue4$1ks$1_at_nnrp1.deja.com...
> > Looks like your unix login user "oralab" does not have the privilege.
> > Which group is "oralab" in? What is the unix login user for the already
> > running database? Try to use that user account to login to unix system,
> > set ORACLE_SID to lab and then try sqlplus or svrmgrl.
> >
> > Hope this helps.
> >
> > Guang
> >
> > In article <901o25$5ta$1_at_news.seed.net.tw>,
> > "Jennifer Chang" <jchang_at_mac.com> wrote:
> > > 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
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Nov 29 2000 - 01:48:58 CST