Skip to content

Instantly share code, notes, and snippets.

@dincosman
Last active October 7, 2023 06:24
The users used in Flex ASM
We have this privileged database users in a healthy cluster :
ASMCMD> lspwusr
Username sysdba sysoper sysasm
SYS TRUE TRUE TRUE
CRSUSER__ASM_001 TRUE FALSE TRUE
ASMSNMP TRUE FALSE FALSE
What do we have :
ASMCMD> lspwusr
Username sysdba sysoper sysasm
SYS TRUE TRUE FALSE
We used below commands to fix it.
[oracle@exadb01 ~]$ asmcmd orapwusr --grant sysasm SYS
[oracle@exadb01 ~]$ asmcmd orapwusr --add CRSUSER__ASM_001
Enter password: ********* ---> I used welcome1
[oracle@exadb01 ~]$ asmcmd orapwusr --grant sysasm CRSUSER__ASM_001
[oracle@exadb01 ~]$ asmcmd orapwusr --grant sysdba CRSUSER__ASM_001
[oracle@exadb01 ~]$ asmcmd lspwusr
Username sysdba sysoper sysasm
SYS TRUE TRUE TRUE
CRSUSER__ASM_001 TRUE FALSE TRUE
[oracle@exadb01 ~]$ asmcmd orapwusr --add ASMSNMP
Enter password: *********
[oracle@exadb01 ~]$ asmcmd orapwusr --grant sysdba ASMSNMP
[oracle@exadb01 ~]$ asmcmd lspwusr
Username sysdba sysoper sysasm
SYS TRUE TRUE TRUE
CRSUSER__ASM_001 TRUE FALSE TRUE
ASMSNMP TRUE FALSE FALSE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment