My Oracle Support Banner

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

Last updated on MAY 02, 2024

Applies to:

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

Goal

**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 : 2.2.0.0.0 version, Product Installation


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

attempted to apply patch 27129131 > DB
<PATH>:\Users\Administrator\Documents\V2.2.0.0.0-27129131_MultiPlatform\database\ORACLE>ouafDatabasePatch.cmd
"CMDLINE::: <PATH>:\OUAF\prereqs\java\bin\java.exe -cp <PATH>:\OUAF\WAMJDEV\tools\bin\db\lib\*;<PATH>:\OUAF\WAMJDEV\tools\bin\db\config com.oracle.ouaf.database
.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:
192.168.11.219:1521:WAMDB
 - 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 : 192.168.11.219:1521:WAMDB
 - 2018-01-05 03:51:57,108 [main] DEBUG (database.patch.OUAFPatch) target db name : 192.168.11.219:1521:WAMDB
 - 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

Solution

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
Goal
Solution
References


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