Re: ORA-1031 if database is not open, fine otherwise

From: Taral Desai <taral.desai_at_gmail.com>
Date: Mon, 4 Oct 2010 10:42:19 -0500
Message-ID: <AANLkTimuuMeyxoK+JfqTzJNAy4YAnJuQ7_TyzB5rDbj1_at_mail.gmail.com>



Hi Martin,

I don't know but just to try

Did you try setting up password file.

On Mon, Oct 4, 2010 at 10:18 AM, Martin Bach <development_at_the-playground.de>wrote:

> Hello all,
>
> I have scratched my head for a long time now and can't get to the bottom of
> this problem. Facts:
> - OEL5.5 64bit
> - RDBMS 11.2.0.2 (with Grid Infrastructure 11.2.0.2 aka Oracle Restart)
>
> I would like to connect as sys via Net*8: sqlplus sys/foo_at_db as sysdba
> SQL> conn sys/orcl_at_orcl as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> The same in rman and dgmgrl. I have set
> *.remote_login_passwordfile='EXCLUSIVE'
>
> The funny part is here: when I connect "/ as sysdba" on the box, it works
> (no surprise). So I start the database past nomount (the problem exists in
> nomount as well) and voila:
>
> _at_ > conn / as sysdba
> Connected to an idle instance.
> SYS_at_orcl AS SYSDBA> startup mount
> ORACLE instance started.
>
> Total System Global Area 313159680 bytes
> Fixed Size 2226072 bytes
> Variable Size 188745832 bytes
> Database Buffers 117440512 bytes
> Redo Buffers 4747264 bytes
> Database mounted.
> SYS_at_orcl AS SYSDBA> conn sys/orcl_at_orcl as sysdba
> Connected.
>
> Nothing in sqlnet.ora by the way, the file doesn't exist. I have statically
> registered the ORCL database in $GRID_HOME/network/admin/listener.ora as
> well.
>
> Any idea and help greatly appreciated.
>
> Martin
>
> --
> Martin Bach
> OCM 10g
> http://martincarstenbach.wordpress.com
> http://www.linkedin.com/in/martincarstenbach
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Thanks & Regards,
Taral Desai

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 04 2010 - 10:42:19 CDT

Original text of this message