cant connect to asm as sysdba by other user.
764422May 29 2010 — edited Jun 7 2010hi 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 ????