ORA-1031 if database is not open, fine otherwise

From: Martin Bach <development_at_the-playground.de>
Date: Mon, 04 Oct 2010 16:18:04 +0100
Message-ID: <4CA9F02C.3070609_at_the-playground.de>

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

Received on Mon Oct 04 2010 - 10:18:04 CDT