My Oracle Support Banner

Adding Monitor user failed. The following error occured: ORA-00922: missing or invalid option (Doc ID 1120374.1)

Last updated on SEPTEMBER 16, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Installing Grid Infrastructure fails at the point ASMCA attempts to create ASM instance:

Oracle Universal Installer (OUI) log, shows ((look under <ORACLE_BASE> for oraInventory and logs directories):

INFO: Started Plugin named: Automatic Storage Management Configuration Assistant
INFO: Found associated job
INFO: Starting 'Automatic Storage Management Configuration Assistant'
INFO: Starting 'Automatic Storage Management Configuration Assistant'
INFO: Executing ASMCA
INFO: Command <GRID_HOME>/bin/asmca -silent -oui_internal -configureASM -diskGroupName <DGNAME> -diskList /dev/<DIR>/<DISK1>,/dev/<DIR>/<DISK2> -redundancy EXTERNAL
INFO: ... GenericInternalPlugIn.handleProcess() entered.
INFO: ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: ... GenericInternalPlugIn: checking secretArguments.
INFO: ... GenericInternalPlugIn: starting read loop.
INFO: Read: SYS_PASSWORD_PROMPT
INFO: Processing: SYS_PASSWORD_PROMPT for argument tag -sysAsmPassword
INFO: Read: ASMSNMP_PASSWORD_PROMPT
INFO: Processing: ASMSNMP_PASSWORD_PROMPT for argument tag -asmMonitorPassword
INFO: End of argument passing to stdin
INFO: Read:
INFO: Read: Configuring ASM failed with the following message:
INFO: Read: Adding Monitor user failed. The following error occured:
INFO: Read: ORA-00922: missing or invalid option
INFO: Completed Plugin named: Automatic Storage Management Configuration Assistant
INFO: Automatic Storage Management Configuration Assistant failed.


ASMCA log shows (look under <grid_infrastructure_home> or <ORACLE_BASE> for cfgtoollogs):

[main] [ 2010-06-02 13:17:10.649 CDT ] [UsmcaLogger.logDebug:132] Message Add ASMSNMP
[main] [ 2010-06-02 13:17:10.650 CDT ] [UsmcaLogger.logEntry:113] Entering oracle.sysman.assistants.usmca.backend.USMInstance Method : addASMMonitorUser
[main] [ 2010-06-02 13:17:10.651 CDT ] [SQLEngine.done:2148] Done called
[main] [ 2010-06-02 13:17:10.653 CDT ] [UsmcaLogger.logException:171] SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstance:configureASM
[main] [ 2010-06-02 13:17:10.654 CDT ] [UsmcaLogger.logException:172] Adding Monitor user failed. The following error occured:
ORA-00922: missing or invalid option
[main] [ 2010-06-02 13:17:10.654 CDT ] [UsmcaLogger.logException:173] java.lang.Exception: Adding Monitor user failed. The following error occured:
ORA-00922: missing or invalid option

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.