Create User RXA_WS Fails During OLS 4.6.0 To OLS 4.6.2 DB Upgrade With ORA-00922

(Doc ID 1629590.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version 4.6.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE:
--------
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms