My Oracle Support Banner

Error Invalid user in WFM_OPT_VAL (CISADM) when ran ouafDatabasePatch.cmd (Doc ID 2357438.1)

Last updated on OCTOBER 23, 2021

Applies to:

Oracle Utilities Work and Asset Management Enterprise Edition - Version and later
Information in this document applies to any platform.


**Any examples provided in this article do not represent real life personal/confidential information**
**Disclaimer:** This KM article may include the following abbreviations:

WAM - Oracle Utilities Work and Asset

On : version, Product Installation

Error Invalid user in WFM_OPT_VAL (CISADM) when ran ouafDatabasePatch.cmd

attempted to apply patch 27129131 > DB
"CMDLINE::: <PATH>:\OUAF\prereqs\java\bin\java.exe -cp <PATH>:\OUAF\WAMJDEV\tools\bin\db\lib\*;<PATH>:\OUAF\WAMJDEV\tools\bin\db\config
.patch.OUAFPatch "
 - 2018-01-05 03:51:20,796 [main] DEBUG (database.patch.OUAFPatch) Opening file: CDXPatch.ini
 - 2018-01-05 03:51:20,796 [main] DEBUG (database.patch.OUAFPatch) CDXPatch.ini: 27129131
 - 2018-01-05 03:51:20,796 [main] INFO (database.patch.OUAFPatch) Enter the target database type (O/M/D) [O]:o

Enter the username that owns the schema: WAMADM

Enter the password for the WAMADM user:
 - 2018-01-05 03:51:32,797 [main] INFO (database.patch.OUAFPatch) Enter the name of the Oracle Database Connection String:
 - 2018-01-05 03:51:55,780 [main] DEBUG (database.patch.OUAFPatch)

Connecting to the Target Database ...
 - 2018-01-05 03:51:55,780 [main] DEBUG (database.patch.OUAFPatch)
User Name : WAMADM
 - 2018-01-05 03:51:55,780 [main] DEBUG (database.patch.OUAFPatch)
Database Name :
 - 2018-01-05 03:51:57,108 [main] DEBUG (database.patch.OUAFPatch) target db name :
 - 2018-01-05 03:51:57,108 [main] DEBUG (database.patch.OUAFPatch) connection : oracle.jdbc.driver.T4CConnection@1442d7b5
 - 2018-01-05 03:51:57,467 [main] ERROR (database.patch.OUAFPatch) 'Invalid user in WFM_OPT_VAL (CISADM). Synonym WAMADM.CI_WFM_OPT does not exist


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.