Database wallet operations

Generates a database wallet file for a specified database or for all databases in the source VM cluster. This eliminates the need to provide the database SYS and TDE passwords during the following operations: migrate database, switchover, failover, and reinstate.

There are two methods available to generate the database wallet file. Option 2 requires access to any database server in the source VM cluster.

Option 1: exacloudmigration generate_dbwallet
Option 2: ecmasshutility generate_dbwallet

Note:

The generated wallet file, created using either option, securely stores both the SYS and TDE passwords for the databases and is protected with a file password.

Parent topic: Exadata Cloud Infrastructure Migration Automation Utility Functionality

Option 1: exacloudmigration generate_dbwallet

Ensure that the input template for database(s) has been generated and modified according to the target platform requirements.

The generate_dbwallet command supports the following options:

Syntax

exacloudmigration generate_dbwallet [-ahV] -i <inputFile> [a | -l <dbNames>]

Table 2-17 exacloudmigration generate_dbwallet Commands

Command	Description
`-a, --all`	Generates password wallet for all databases in the source VM cluster.
`-i, --inputFile`	Specifies the database input file name with the complete path.
`-l, --dbNames`	Specifies a comma-delimited list of database names to generate the password wallet. Examples: To generate the password wallet for a database: `-l dbname1` To generate the password wallet for multiple databases: `-l dbname1,dbname2,dbname3`
`-h, --help`	Displays help information about the command and its options.
`-V, --version`	Displays the version of the utility.

Examples:

To generate password wallet for all databases in source VM cluster:
```
/home/opc>./exacloudmigration generate_dbwallet -a -i inputs/infra_phxref/vmcluster_vmcluster1/database_inputs
```
Specify the SYS and TDE passwords for the databases along with a secure password for the wallet file and file will be generated with the default file name ewallet.p12.
To generate password wallet using a comma-delimited list of Database names:
```
/home/opc>./exacloudmigration generate_dbwallet -i inputs/infra_phxref/vmcluster_vmcluster1/database_inputs -l dbname1,dbname2
```
Specify the SYS and TDE passwords for the dbname1, dbname2, along with a secure password for the wallet file and file will be generated with the default file name ewallet.p12.

Parent topic: Database wallet operations

Option 1: exacloudmigration edit_dbwallet

If database wallet is already generated using the option generate_dbwallet, then this helps in adding or updating password for a given database in database wallet file

The edit_dbwallet command supports the following options:

Syntax

exacloudmigration edit_dbwallet [-hV] -a <add>|-u <update> -w <walletFile> -d <dbName>

Table 2-18 exacloudmigration edit_dbwallet Commands

Command	Description
`-a, --add`	Adds a password for a given database in the wallet file.
`-u, --update`	Updates the password for a given database in the wallet file.
`-w, --walletFile`	Specifies the database wallet file name with the path.
`-d, --dbName`	Specifies the database name to perform edit operation.
`-h, --help`	Displays help information about the command and its options.
`-V, --version`	Displays the version of the utility.

Examples:

To add password for a specified database in the wallet file:
```
/home/opc>./exacloudmigration edit_dbwallet -a -w ewallet.p12 -d dbnamenew
```
Specify wallet file password to unlock the file for adding databasenew SYS and TDE password to the wallet.
To update password for a specified database in the wallet file:
```
/home/opc>./exacloudmigration edit_dbwallet -u -w ewallet.p12 -d dbname1
```
Specify wallet file password to unlock the file for updating dbname1 SYS and TDE passwords.

Parent topic: Option 1: exacloudmigration generate_dbwallet

Option 1: exacloudmigration list_wallet_dbs

Display the list of database names having password stored in database wallet file.

The list_wallet_dbs command supports the following options:

Syntax

exacloudmigration list_wallet_dbs [-hV] -w <walletFile>

Table 2-19 exacloudmigration list_wallet_dbs Commands

Command	Description
`-w, --walletFile`	Specifies the database wallet file name with the path.
`-h, --help`	Displays help information about the command and its options.
`-V, --version`	Displays the version of the utility.

Examples:

To display the list of database names having password stored in the password wallet file:
```
/home/opc>./exacloudmigration list_wallet_dbs -w ewallet.p12
```

Parent topic: Option 1: exacloudmigration generate_dbwallet

Option 2: ecmasshutility to generate database password wallet

Running this utility requires access to any database server of the source VM cluster:

Transfer the ecmasshutility binary from client machine to any database server of the source VM cluster.
For example:
```
scp /home/opc/ecmasshutility opc@[ip address of db server ]:/tmp
```
.
Log in to the source VM Cluster database server where the utility is copied.
Grant the required permissions on the /tmp/ecmasshutility directory to the oracle user.
Switch to the oracle user and navigate to the directory where the utility was copied (for example, /tmp).

The ecmasshutility command supports the following operations:

Syntax

ecmasshutility [-hV] [command]

Table 2-20 ecmasshutility Commands

Command	Description
`generate_dbwallet`	Specifies to create exacloud migration password wallet file for database migration.
`edit_dbwallet`	Specifies to edit exacloud migration password wallet file for database migration.
`list_wallet_dbs`	Displays the list of database names having password stored in the wallet file.
`get_patches`	Creates patches file for the `exacloudmigration` utility.
`-h, --help`	Displays help information about the command and its options.
`-V, --version`	Displays the version of the utility.

Parent topic: Database wallet operations

Option 2: ecmasshutility generate_dbwallet

The generate_dbwallet command supports the following options:

Syntax

ecmasshutility generate_dbwallet [-hV] [-l <dbNames>]

Table 2-21 ecmasshutility generate_dbwallet Commands

Command Description

Command	Description
`-l, --dbNames`	Specifies a comma-delimited list of database(s) to generate the password wallet. Examples: To generate the password wallet for a database: `-l dbname1` To generate the password wallet for multiple databases: `-l dbname1,dbname2,dbname3`
`-h, --help`	Displays help information about the command and its options.
`-V, --version`	Displays the version of the utility.

-l, --dbNames

Specifies a comma-delimited list of database(s) to generate the password wallet.

Examples:

To generate the password wallet for a database: -l dbname1
To generate the password wallet for multiple databases: -l dbname1,dbname2,dbname3

-h, --help Displays help information about the command and its options.

-V, --version Displays the version of the utility.

Examples:

To generate password wallet for all databases in source VM cluster:
```
/tmp>./ecmasshutility generate_dbwallet
```
Specify secure password for the wallet file and generates with name ewallet.p12.
To generate wallet for selected database(s) in Source VM cluster:
```
/tmp>./ecmasshutility generate_dbwallet -l dbname1,dbname2
```
Specify secure password for the wallet file and file will be generated with the default file name ewallet.p12.

Note:

The /tmp/ewallet.p12 file will be generated. Copy this file to the utility location on the client machine.

Parent topic: Option 2: ecmasshutility to generate database password wallet

Option 2: ecmasshutility edit_dbwallet

If database wallet is already generated using the generate_dbwallet option, then this helps in add or update password for a given database in database wallet file

The edit_dbwallet command supports the following options:

Syntax

ecmasshutility edit_dbwallet [-hV] -a <add>|-u <update> -w <walletFile> -d <dbName>

Table 2-22 ecmasshutility edit_dbwallet Commands

Command	Description
`-a, --add`	Specifies to add a password for a given database in the wallet file.
`-u, --update`	Updates password for a given database in the wallet file.
`-w, --walletFile`	Specifies the database wallet file name with the path.
`-d, --dbName`	Specifies the database name to perform edit operation.
`-h, --help`	Displays help information about the command and its options.
`-V, --version`	Displays the version of the utility.

Examples:

To add password for a given database in wallet file:
```
/tmp>./ecmasshutility edit_dbwallet -a -w ewallet.p12 -d dbnamenew
```
Specify database wallet file password to unlock the file for adding databasenew database password.
To update password for a given database in wallet file:
```
/tmp>./ecmasshutility edit_dbwallet -u -w ewallet.p12 -d dbname1
```
Specify database wallet file password to unlock the file for updating dbname1 password.

Parent topic: Option 2: ecmasshutility to generate database password wallet

Option 2: ecmasshutility list_wallet_dbs

Display the list of database names having password stored in the database wallet file.

The list_wallet_dbs command supports the following options:

Syntax

ecmasshutility list_wallet_dbs [-hV] -w <walletFile>

Table 2-23 ecmasshutility list_wallet_dbs Commands

Command	Description
`-w, --walletFile`	Specifies the database wallet file name with the path.
`-h, --help`	Displays help information about the command and its options.
`-V, --version`	Displays the version of the utility.

Examples:

To show the list of database names having password stored in the database wallet file:
```
/tmpc>./ecmasshutility list_wallet_dbs -w ewallet.p12
```

Parent topic: Option 2: ecmasshutility to generate database password wallet