ORA-01031: insufficient privileges and Connected to an idle instance, when connecting with conn / as sysasm


Cause:-
============
1) Setting up incorrectly all the home paths
2) you are not using a user which is in the asmadmin group "Connected to an idle instance" is for incorrect set up of ASM instance .
Solution:- We need to export all the home paths corectly
ORACLE HOME should be grid home and also Grid home should be grid home..
export ORACLE_SID as +ASM1/+ASM2 .... See following scenarios 1) Wrong …..
========================== [oracle@rac1 ~]$
[oracle@rac1 ~]$ export ORACLE_SID=+ASM1
[oracle@rac1 ~]$
[oracle@rac1 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 26 20:36:07 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL>
SQL> conn / as sysasm
ERROR:
ORA-01031: insufficient privileges
2) Wrong …..
==========================
[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/11.2.0/grid
[oracle@rac1 ~]$ export ORACLE_SID=+ASM
[oracle@rac1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[oracle@rac1 ~]$
[oracle@rac1 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 26 20:46:29 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> conn / as sysasm
Connected to an idle instance.
SQL>
SQL> exit
3) Right …..
==========================
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ export ORACLE_SID=+ASM1
[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/11.2.0/grid
[oracle@rac1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[oracle@rac1 ~]$
[oracle@rac1 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 26 20:47:10 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> conn / as sysasm
Connected.
SQL>
SQL> select * from v$pwfile_users; USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE TRUE
ASMSNMP TRUE FALSE FALSE SQL>
SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS
---------------- ------------
+ASM1 STARTED SQL>
SQL>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: