Tags

, , , ,

You can catalog your named credentials quickly and easily with EM CLI.

emcli login -username=SYSMAN

emcli sync

NCCATALOG=/u01/oem/backups/named_credential_catalog.lst
[ $NCCATALOG ] && rm -f ${NCCATALOG}
touch ${NCCATALOG}

for thisNC in `emcli list_named_credentials | awk '{ print $1 }' | grep -v "Credential"`; do
emcli get_named_credential -cred_name=${thisNC} >>${NCCATALOG}
done

cat ${NCCATALOG}

 

Your results will look like this:

Credential Name:CRED_SYSDBA
Credential Owner:SYSMAN
Credential Type:DBCreds
Credential Target Type:oracle_database
Credential Username:sys
Credential Scope:global
Credential Guid:<string>
Credential Stripe:TARGETS
Credential Columns:
 DBPassword=******
 DBRole=sysdba
 DBUserName=sys

Credential Name:CRED_SUPERMAN
Credential Owner:SYSMAN
Credential Type:HostCreds
Credential Target Type:host
Credential Username:superman
Credential Description:Superman administrator account
Credential Scope:global
Credential Guid:<string>
Credential Stripe:TARGETS
Credential Columns:
 HostPassword=******
 HostUserName=superman
 PDPTYPE=SUDO
 RUNAS=oracle