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 laterOracle 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.
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
[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 |