RE: quick (hopefully) emcli question

From: Ruel, Chris <Chris.Ruel_at_lfg.com>
Date: Mon, 5 Jan 2015 18:55:26 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F1324D14788_at_NC2PWEX504.us.ad.lfg.com>



I see what you are saying...

I thought I would dig a little myself :)

Well, this is really obscure, and, maybe not helpful, but check this out:

SQL> select distinct cred_attr_name
  2 from sysman.EM_NC_CRED_COLUMNS
  3 order by 1;

CRED_ATTR_NAME



DBPassword
DBRole
DBUserName
HostPassword
HostUserName
PDPTYPE
Password
RUNAS
UserName
password
typePassword
typeUsername

It sort of matches what the help example shows...maybe this will give you something else to dig into for further research.

Chris..



Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482

From: Sweetser, Joe [mailto:JSweetser_at_icat.com] Sent: Monday, January 05, 2015 1:21 PM
To: Ruel, Chris; oracle-l_at_freelists.org Subject: RE: quick (hopefully) emcli question

Thanks, Chris. My first post was not clear....what I meant to say was that attribute-specific part of emcli help command only returns what is shown. Full output is almost identical to what you sent.

-joe

From: Ruel, Chris [mailto:Chris.Ruel_at_lfg.com] Sent: Monday, January 05, 2015 11:13 AM
To: Sweetser, Joe; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: RE: quick (hopefully) emcli question

I only have 12.1.0.4 installed. Maybe the 12.1.0.4 output will be of use to you:

$emcli help modify_named_credential
emcli modify_named_credential

        [-cred_owner="Credential owner"]
        [-cred_name="Credential name"]
        [-new_cred_name="Updated credential name"]
        [-cred_type="credential type"]
        [-cred_scope="credential scope"]
        [-cred_desc="Credential description"]
        [-target_name="Target name"]
        [-target_type="Target type"]
        [-test]
        [-test_target_name="Test target name"]
        [-test_target_type="Test target type"]
        [-input_file="FILE:file_path"]
        [-properties_file="Properties File"]
        [-attributes="attributes"]
        [-remove_old_attributes]

  Description
    Updates an existing named credential. The parameter's values to update can be provided     using command line arguments or an input file. It also supports     input_file tag for passwords and parameter values.

  Options
-cred_owner

        Credential owner.
-cred_name

        Credential name, Required if a properties file is not used.
                For example: "MyBackUpCreds"

-new_cred_name
The optional new credential name. For example: "MyNewBackUpCreds"
-cred_type
The credential type. Required if a properties file is not used. For example: HostCreds
-cred_scope
Credential Scope Valid values are "global" (default) or "instance".
-cred_desc
A description of the credential.
-target_name
Target Name. This is required when cred_scope is set to "instance".
-target_type
Target Type. This is required when cred_scope is set to "instance".
-test
Include to test the credential before saving.
-test_target_name
Use this option to supply the target name to test a global credential against. Required if -cred_scope is set to "global" and the -test option is included.
-test_target_type
Use this option to specify the target type to test a global credential against. Required if -cred_scope is set to "global" and the -test option is included.
-input_file
Reads contents of file and passes as property value.
-properties_file
Use this option to supply all parameters and their values from a multi-line Java properties file. Each line of the file should contain a single parameter=value entry. For example, prop.txt contains these entries: cred_name=MyCred1 attributes="HostUserName:aime;HostPassword:tag The argument will then be structured as: emcli modify_named_credential -properties_file=/tmp/mypropertiesfile.txt Note that values given via the -attributes option take precedence.
-attributes
The credential column values to update, specified as colname:colvalue. Separate multiple column values with a semi-colon (;) as shown: colname:colvalue;colname:colvalue
-remove_old_attributes
Deletes all existing credential column values. Exit Codes 0 On success Non-zero value means verb processing was not successful. Examples emcli modify_named_credential -cred_name=NC1 -attributes="HostUserName:foo;HostPassword:bar" Updates the credentials to foo/bar emcli modify_named_credential -cred_name=NC1 -attributes="HostPassword:bar" Updates password to bar emcli modify_named_credential -cred_name=NC1 -attributes="HostUserName:foo;HostPassword:tag" -input_file="tag:mypasswordfile.txt" Reads the password from mypasswordfile.txt file. emcli modify_named_credential -cred_name=NC1 -attributes="HostUserName:foo;HostPassword:" Prompts for the password from standard input. emcli modify_named_credential -properties_file=prop1.txt Where prop1.txt is a multi-line java properties file where each line contains parameter=value format You can add the password to the same file if you want. If you do not specify, you will be prompted for it. If you include special characters such as backslash, then make sure you escape it using one more backslash. e.g., On Microsoft Windows, when you specify the user name with a domain name, you must provide DOMAIN\\USER _____________________________________________________________________
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482

-----Original Message-----
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe Sent: Monday, January 05, 2015 12:01 PM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: quick (hopefully) emcli question

Em12c 12.1.0.3

I would like to see all available attributes for the modify_named_credential verb.

emcli help modify_named_credential simply shows:

-attributes

        Specify credential column as follows
        colname:colvalue;colname:colvalue

for the attributes. The documentation for the verb (from 12.1.0.4 - can't even find the 12.1.0.3 docs online, grrr) only shows an example like:

emcli modify_named_credential

        -cred_name=NC1
        -attributes="HostUserName:foo;HostPassword:bar"

Anybody know where to find (or how to list) all available attributes for a given emcli verb?

Thanks,
-joe

Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

--
http://www.freelists.org/webpage/oracle-l




Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 05 2015 - 19:55:26 CET

Original text of this message