Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cant connect to asm as sysdba by other user.

764422May 29 2010 — edited Jun 7 2010
hi all

i want to connect to asm by using password file or any other means to ASM instance.

so far have done as below...
1. grant sysdba to user xx;
2 alter same password for user xx and sys.
3. recreate both password file +ASM, database.
4. reload of listener too.
5. i can connect to ASM like this

sqlplus sys/system@ASM as sysdba
but when i do
sqlplus xx/system@ASM as sysdba
it give me
insufficent previlege


SQL> startup
ASM instance started

Total System Global Area 83886080 bytes
Fixed Size 1217836 bytes
Variable Size 57502420 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE

TEST-> echo $ORACLE_SID
+ASM

TEST-> sqlplus xx/system@ASM as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 29 19:37:08 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:
TEST-> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 29 19:38:21 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> connect xx/system@ASM as sysdba
ERROR:
ORA-01031: insufficient privileges


Warning: You are no longer connected to ORACLE.
SQL> connect xx/system@ASM
ERROR:
ORA-15000: command disallowed by current instance type


SQL> exit
TEST-> sqlplus xx/system@ASM

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 29 19:40:52 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-15000: command disallowed by current instance type


Enter user-name:

THIS IS WORK FINE IN DATABASE INSTANCE
i can connect to database instace with user XX as sysdba
but not in asm

can somebody please help me what to do now ????
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2010
Added on May 29 2010
18 comments
8,560 views