Skip to Main Content

Database Software

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!

How to connect with non-default user in ASM

User416084Dec 12 2013 — edited Dec 12 2013

Hi

We have created a non-default user in ASM. Please let me know how to connect to the ASM instance using that user on the server.

ASMCMD> lspwusr

   Username sysdba sysoper sysasm

        SYS   TRUE    TRUE   TRUE

    ASMSNMP   TRUE   FALSE  FALSE

TOAD_CLTEST   TRUE   FALSE  FALSE

When connected it is showing user as "SYS" not TOAD_CLTEST

SQL> conn TOAD_CLTEST/ssss as sysdba

Connected.

SQL> sho user

USER is "SYS"

SQL> conn TOAD_CLTEST/xxxxxxx

ERROR:

ORA-15000: command disallowed by current instance type

Please let me know how to connect to TOAD_CLTEST.

Thank You.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2014
Added on Dec 12 2013
1 comment
422 views