Re: ORA-1031 if database is not open, fine otherwise
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: "taral desai" <taral.desai@xxxxxxxxx>, "development" <development@xxxxxxxxxxxxxxxxx>
- Date: Mon, 4 Oct 2010 11:59:48 -0400
I have seen this in 2 other scenarios:
1. Db failed to a different node and there was no password file in that oracle
hom
2. Password file ended up out of sync with what was in db. Resetting the sys
password fixed it.
Joe
Sent from the crackberry, so please excuse the typos and terseness.
----- Original Message -----
From: Taral Desai [taral.desai@xxxxxxxxx]
Sent: 10/04/2010 10:42 AM EST
To: development@xxxxxxxxxxxxxxxxx
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: Re: ORA-1031 if database is not open, fine otherwise
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@xxxxxxxxxxxxxxxxx>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@db as sysdba
> SQL> conn sys/orcl@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:
>
> @ > conn / as sysdba
> Connected to an idle instance.
> SYS@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@orcl AS SYSDBA> conn sys/orcl@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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Thanks & Regards,
Taral Desai
Other related posts:
