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

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:03:55 CST