Re: Remote login on closed database ORA-01031

I find the reason !!

On my Linux server, Oracle is installed with a user oracle817 and my database is created with a user victoria (To be sure to have different environments in case of several base on the same server). Both of them are in the same group, dba.

I created my password file in $ORACLE_HOME/dbs but with user victoria and after that, add the right of writing for the group or I get an error at the local startup.

In fact, the password file has to be created with the user oracle817 to be also fonctionnal when the base is closed. I think it's a problem with net8 processes. I will make some tests about that when I will have some time.

Thanks all for your time.
Yannick

"Howard J. Rogers" <hjr_at_dizwell.com> a écrit dans le message de news:4057601e$0$3955$afc38c87_at_news.optusnet.com.au...
>
> "Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
> news:40571552.796140A9_at_remove_spam.peasland.com...
> > > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> >
> > Try commenting out this line and see if it fixes your problem.
>
> Dang! Brian beat me to it.
>
> Exactly why I asked to see your sqlnet.ora in the first place.
>
> Regards
> HJR
>
>
Received on Thu Mar 18 2004 - 06:35:48 CST