RE: quick (hopefully) emcli question
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-lReceived on Mon Jan 05 2015 - 19:55:26 CET