get_db_profile
Shows the database profile details as profile, resource name, resource type and limit for a given search criteria.
Format
emcli get_db_profile -target_name="tname" -connect_as= "DBUserName:uname;DBPassword:upassword[;DBRole:SYSDBA]" or "[DBCredsOwner:ucredsowner;]DBNamedCreds:unamedcreds" [-target_type="ttype"] [-profile=profile default ""] [-resource=resource default "" ] [-limit_rows=limit_rows default 25 [-noheader] [-script | -format= [name:<pretty|script|csv>]; [column_separator:"column_sep_string"]; [row_separator:"row_sep_string"]; ] [-input_file="tag1:file_path1;tag2:file_path2;..."] [-validate_only="yes/no" default "no"] [ ] indicates that the parameter is optional.
Options
-
target_name
Name of the target.
-
profile
Profiles to be searched for. You can include multiple profiles separated by a semicolon (;). The default value of this option is an empty string with all profiles shown in the result. The profile is case sensitive.
-
target_type
Type of the target. The possible values for target type in this verb are:
-
oracle_database
-
rac_database
The default value for this argument is oracle_database.
-
-
resource
Resource name of the database profile for which you want to search. The default value of this option is an empty string. Profiles with any resource name will be shown in the result.
-
limit_rows
Maximum rows to be shown in the result. The default value of this option is 25.
-
script
This option is equivalent to -format="name:script".
-
format
Format specification (default is -format="name:pretty"). You can use the parameter in the following configurations:
-
-format="name:pretty" prints the output table in a readable format but is not intended to be parsed by scripts.
-
-format="name:script" sets the default column separator to a tab and the default row separator to a newline. The column and row separator strings may be specified to change these defaults.
-
-format="name:csv" sets the column separator to a comma and the row separator to a newline.
-
-
noheader
Display tabular output without column headers.
-
connect_as
Connect to the target database as. It should be specified in one of the following two formats:
-
DBUserName:uname;DBPassword:upassword[;DBRole:SYSDBA]
-
[DBCredsOwner:ucredsowner;]DBNamedCreds:unamedcreds
-
-
input_file
Use this option to hide passwords. Specify the path to the file containing the old and new passwords. Each path must be accompanied by a tag that is referenced in the password options.
-
validate_only
Indicates whether to validate the options mentioned without doing the actions. Choose from one of the following options:
-
Yes - Validate the options mentioned. Do not do any actions.
-
No - do the actions as per the mentioned options.
The default value of this option is No.
-
Output
Output columns: Profile Resource Name Resource Type Limit
Examples
Refer to the following examples:
Example 1
Use the following example to get details of all resources of a profile DEFAULT using SYS_myDB named credentials.
emcli get_db_profile -target_name=myDB -profile=DEFAULT -connect_as="DBNamedCreds:SYS_myDB"
Example 2
Use the following example to get the details of resource of profile DEFAULT using sysdba credentials.
emcli get_db_profile -target_name=myDB -profile=DEFAULT -resource=CONNECT_TIME -connect_as="DBUserName:sys;DBPassword:welcome;DBRole:sysdba"