Create User RXA_WS Fails During OLS 4.6.0 To OLS 4.6.2 DB Upgrade With ORA-00922
Last updated on MARCH 08, 2017
Applies to:Oracle Clinical - Version 4.6.2 and later
Information in this document applies to any platform.
ORA-922 during the upgrade from 4.6.0 to 4.6.2. Log file reports the error while the script oclupg46to462step1.sql is executed. Customer has a database rule which requires the password contains a special character.
When the installer tries to create the user RXA_WS, the PL/SQL block fails because the variable used to pass the password is not between double quote.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms