Named Credentials created by SYSMAN are not accessible via emcli for other em users - "Specified database credential for SYS user does not exist." (Doc ID 2019060.1)

Last updated on JUNE 10, 2015

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 to 12.1.0.4.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When using non SYSMAN EM user for emcli to run the verb
create_database
The named credentials for SYS,SYSTEM,DBSMP are not detected even if FULL
access has been granted to the EM user
running the verb results in -
Specified database credential for SYS user does not exist.

 

Example Test Case -

1.
Create a Template and store in the Software Library
Create Named Credentials for the target host as well as SYS, SYSTEM and DBSNMP as the SYYMAN EM user

2.
Then create another EM user (test)
Grant FULL access to these Named Credentials

3.
Login to emcli as the test EM user

4.
Then run something like -

emcli create_database -sysCreds=VCAP_SYSDBA_MANAGER1
-systemCreds=VCAP_SYSTEM_MANAGER1 -dbsnmpCreds=VCAP_DBSNMP_MANAGER1
-hostCreds=VCAP_ORACLE_GLOBAL -gdbName=TESTGUY -sid=TESTGUY
-oracleHome=/refresh/64bit/app/oracle/product/11.2.0
-templateName="Database_ORC112U_Guy - Database Template"
-dbType=SINGLE_INSTANCE -hostTargets=ccaabb123.us.oracle.com
-templateStageLocation=/tmp -storageType="FS" -templateInSwlib

You'll get -
Specified database credential for SYS user does not exist.

If you change the ownership of the Named Credential to test user for say
(SYS)
Then you'll get the error -
Specified database credential for SYSTEM user does not exist.

Cause

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