AWA: WP / CP / DB Load utility fails with 'ORA-00922: missing or invalid option'
Article ID: 187503
Updated On:
Products
Issue/Introduction
When starting the DB Load Utility to load a license file or any .jar file, DB Load utility fails with the following errors:
U00003594 UCUDB Ret: '3590' opcode: 'OPEN' SQL Stmnt: 'ALTER SESSION SET NLS_LENGTH_SEMA'
U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00922: missing or invalid option'
OR
When starting the WP / CP the following error is displayed in the log file:
20211126/090625.802 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20211126/090625.802 - U00003592 UCUDB - Status: '' Native error: '922' Msg: 'ORA-00922: missing or invalid option'
20211126/090625.802 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00922: missing or invalid option'
20211126/090625.802 - U00003594 UCUDB Ret: '3590' opcode: 'OPEN' SQL Stmnt: 'ALTER SESSION SET NLS__TERRITORY=AMERICA'
Environment
Release : 12.0, 12.1, 12.2, 12.3
Component : AUTOMATION ENGINE, DB Load Utilities
Cause
Configuration error in the DB string.
'ORA-00922: missing or invalid option is an Oracle error that is being reported by Automic Workload Automation DB Load Utility, WP or CP.
To fix the issue, verify that your DB connection string is correct and check for any extra or missing characters.
For example, in the example above you see the following line in the log:
'U00003594 UCUDB Ret: '3590' opcode: 'OPEN' SQL Stmnt: 'ALTER SESSION SET NLS_LENGTH_SEMA'''
In the uctbdbld.ini file you have the following connection string:
SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=AUTOMIC;UID=AUTOMIC;PWD=AUTOMIC;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15,NLS_LENGTH_SEMA;NTICS=CHAR
There is an additional semicolon in 'NLS_LENGTH_SEMA;NTICS=CHAR' that should be removed.
In the second example NLS__TERRITORY contains an additional underscore.
Resolution
Correct the DB connection string and restart the process.
Feedback
