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

(Doc ID 2357438.1)

Last updated on MARCH 15, 2018

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

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
C:\Users\Administrator\Documents\V2.2.0.0.0-27129131_MultiPlatform\database\ORACLE>ouafDatabasePatch.cmd
"CMDLINE::: C:\OUAF\prereqs\java\bin\java.exe -cp C:\OUAF\WAMJDEV\tools\bin\db\lib\*;C:\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

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