1. Command Line Interface
  2. Verb Reference
  3. EM CLI Verbs
  4. list_dbprofiles

list_dbprofiles

Lists all the database profiles.

Format

emcli list_dbprofiles 
      [-details]

[ ]  indicates that the parameter is optional.

Options

  • details

    Shows the details for each database profile.

Exit Codes

0 if successful. A non-zero value indicates that verb processing was unsuccessful.

Example

The following example lists all the existing database profiles in detail:

emcli list_dbprofiles -details
 
	Output:
	    Name=RMAN Profile,Location=Database Provisioning Profiles/11.2.0.4.0/linux_x64/,Type=RMAN,Status=Ready,Description=Database Reference Profile 04-11-2014 12:40 PM from database.mycompany.com
	    Version : 11.2.0.4.0,contains=Structure and Data,removalOverdue=0,sourceDatabaseName=database.mycompany.com.
	    Name=DB Template,Location=Database Provisioning Profiles/11.2.0.4.0/linux_x64/,Type=DBCA_TEMPLATE,Status=Ready,Description=Database Reference Profile 03-11-2014 04:55 PM from database.mycompany.com
	    Version : 11.2.0.4.0,contains=Structure only,removalOverdue=0,sourceDatabaseName=database.mycompany.com.
	    Name=Snapshot Profile,Location=Database Provisioning Profiles/11.2.0.4.0/linux_x64/,Type=SNAPSHOT,Status=Ready,Description=Database Reference Profile 05-11-2014 03:09 PM from database.mycompany.com
	    Version : 11.2.0.4.0,contains=Structure and Data,removalOverdue=2,sourceDatabaseName=database.mycompany.com.