Re: ora-1031
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: vnr1995@xxxxxxxxx
- Date: Mon, 12 Mar 2007 16:07:35 -0700
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@xxxxxxxxx> 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@xxxxxxxxx> 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@apc:sqlplus "sys/abc@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
Other related posts:
