Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora-1031

Re: ora-1031

From: vnr1995 <vnr1995_at_gmail.com>
Date: Mon, 12 Mar 2007 17:09:53 -0400
Message-ID: <b86c876f0703121409q5735150dn41129a7c0e442a03@mail.gmail.com>


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
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 12 2007 - 16:09:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US