My Oracle Support Banner

Primavera Gateway Installation Fails With Error "ORA-00922: missing or invalid option" For Creating GatewayUser (Doc ID 2683467.1)

Last updated on JUNE 23, 2020

Applies to:

Primavera Gateway - Version 18.8 and later
Information in this document applies to any platform.


When attempting to install Primavera Gateway,
the following error occurs.

Action:Domain Configuration failed with error:Creating the Gateway domain failed with the following message:[[
Error when executing this statement: CREATE user gatewayuser identified by 1p3c@dm1n!9 default tablespace PRIMAVERA_PDI_DATA temporary tablespace temp quota unlimited on PRIMAVERA_PDI_DATA quota unlimited on PRIMAVERA_PDI_INDEX
ORA-00922: missing or invalid option

The issue can be reproduced at will with the following steps:
1. Install Primavera Gateway by launching the installation wizard.
2. The installation fails at the Configuration Progress with above error.


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

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