Re: ora-1031

There is a Note on MetaLink about that.

The file name must conform to the standard, or the password file is not used.

Strange that no errors are thrown until you try to login.

On 3/12/07, vnr1995 <vnr1995_at_gmail.com> wrote:
>
> I have figured out. When I created password file with orapwd, I gave
> file=pwd<sid_name>.ora
> I deleted it, and recreated with file=orapw<sid_name>. Now I can connect.
>
> Thanks
>
>
> On 3/12/07, vnr1995 <vnr1995_at_gmail.com> wrote:
> >
> > Hi folks,
> >
> > I have created an auxiliary instance. And I am trying to test net
> > connection for RMAN to duplicate.
> >
> > I created password file using orapwd on auxiliary, and set
> > remote_login_passwordfile='EXCLUSIVE'. And I also added entries in
> > listener.ora
> >
> > I have started the auxiliary instance in NOMOUNT mode. When I try to
> > connect this auxiliary instance from different host, I got ORA-01031 error.
> >
> > oracle_at_apc:sqlplus "sys/abc_at_AUXI_BOHR as sysdba"
> >
> > SQL*Plus: Release 10.2.0.2.0 - Production on Mon Mar 12 16:55:27 2007
> >
> > Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
> >
> > ERROR:
> > ORA-01031: insufficient privileges
> >
> >
> > In target's tnsnames.ora , I kept SID entry.
> >
> > Anyhelp is appreciated.
> >
> > Thanks, Ven
> >
> >
> >
> >
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l