Common Database Management Tasks
These are the tasks that can be performed to manage your database using Oracle Database Service for Azure.
Managing your database is done from the OracleDB for Azure portal, by selecting the icon that represents the database type that you want to manage, either an Oracle Autonomous Database, an Oracle Exadata Database, an Oracle Base Database, or Oracle HeatWave.
While there are different management tasks for each database type and those tasks are performed differently, there is a commonality on how those management functions are accessed from the OracleDB for Azure Portal after selecting the database type from the OracleDB for Azure Portal.
If a function is available for that database type, the icon representing that tasks will be active and highlighted. For example, the Delete task is not active until you select a database to delete.
The management functions directly on the blades are limited. To get to the additional management functions, unique to the database, select the link to the database you wish to managed.
Starting a Database
Starting a Database in OracleDB for Azure is accomplished from the blade for the database you wish to stop. Each blade is slightly different and so are the database details, but the process is similar.
- Go to the database blade for the database you wish to start.
- Select the specific database you want to start from the list. This will open the details for that specific database.
- Select the Start icon. If the Start icon is not active, the database is already started.
- Confirm that you want to Start the database by selecting the Yes button. If you do not wish to start that database, select the No button.
- The command to Start the database will be submitted. The database details will update when the database has been started. Use the Refresh icon to see this.
- For Oracle HeatWave, the HeatWave Cluster is automatically started and stopped when you start and stop the database system, but it can also be started and stopped on its own while the database system is running. If you have stopped the HeatWave Cluster on its own, you can start it again by selecting the HeatWave tab on the left menu bar, then selecting the Start icon.
Stopping a Database
Stopping a Database in OracleDB for Azure is accomplished from the blade for the database you wish to stop. Each blade is slightly different and so are the database details, but the process is similar.
- Go to the database blade for the database you wish to stop.
- Select the specific database you want to stop from the list. This will open the details for that specific database.
- Select the Stop icon. If the Stop icon is not active, the database is already stopped.
- Confirm that you want to Stop the database by selecting the Yes button. If you do not wish to stop that database, select the No button.
- The command to Stop the database will be submitted. The database details will update when the database has been stopped. Use the Refresh icon to see this.
- For Oracle HeatWave, the HeatWave Cluster is automatically started and stopped when you start and stop the database system, but it can also be started and stopped on its own while the database system is running. You can stop the HeatWave Cluster on its own by selecting the HeatWave tab on the left menu bar, then selecting the Stop icon.
Deleting a Database
Deleting a Database in OracleDB for Azure is accomplished from the blade for the database you wish to delete. Each blade is slightly different and so are the database details, but the process is similar.
Restarting a Database
Restarting a Database in OracleDB for Azure is accomplished from the blade for the database you wish to stop. Each blade is slightly different and so are the database details, but the process is similar.
- Go to the database blade for the database you wish to restart.
- Select the specific database you want to start from the list. This will open the details for that specific database.
- Select the Restart icon. If the Restart icon is not active, the database is already started.
- Confirm that you want to Restart the database by selecting the Yes button. If you do not wish to start that database, select the No button.
- The command to Restart the database will be submitted. The database details will update when the database has been started. Use the Refresh icon to see this.
- For Oracle HeatWave, the HeatWave Cluster is automatically restarted when you restart the database system, but it can also be restarted on its own while the database system is running. You can restart the HeatWave Cluster on its own by selecting the HeatWave tab on the left menu bar, then selecting the Restart icon.
Download a Wallet
Download a Wallet for a database in OracleDB for Azure is accomplished from the blade for the database you want to use. Each blade is slightly different and so are the database details, but the process is similar.
- Go to the database blade for the database you wish to download the wallet.
- Select the specific database you want to start from the list. This will open the details for that specific database.
- Select the Download wallet icon. If the Download wallet icon is not present, the database does not support this function. The task both downloads the wallet, and gives it a new password. The password for the new wallet must comply with the same password requirements you used during database provisioning. See the specific database provisioning tasks for these requirements.
- Confirm that you want to Download wallet for the database by selecting the OK button. If you do not wish to start that database, select the Discard button.
- The command to Download wallet for the database will be submitted. The wallet file will be downloaded locally to your machine.
Rotate a Wallet
Rotating a Wallet in OracleDB for Azure is accomplished from the blade for the database you wish to stop. Each blade is slightly different and so are the database details, but the process is similar.
- Go to the database blade for the database where you want to rotate the connection wallet.
- Select the specific database you want to start from the list. This will open the details for that specific database.
- Select the Rotate wallet icon. If the Rotate wallet icon is not present, the database does not support or require this activity.
- Confirm that you want to Rotate wallet for the database by selecting the Yes button. If you do not wish to rotate the wallet for that database, select the No button.
- The command to Rotate wallet the database will be submitted. The database details will update when the database has been started. Use the Refresh icon to see this.
Changing Database Password
Changing a Database Password in OracleDB for Azure is accomplished from the blade for the database you wish to change. Each blade is slightly different and so are the database details, but the process is similar.
Using Database Actions
Database Actions in OracleDB for Azure are only supported for Oracle Autonomous Databases.
- Go to the database blade for the database you wish to use Database Actions.
- Select the specific database you want to use Database Actions with from the list. This will open the details for that specific database.
- Select the Database Actions icon. If the Database Actions icon is not present, you are attempting to do this on an unsupported database type. Database Actions is only supported for Oracle Autonomous Databases.
- Login to Database Actions using the
ADMIN
user and password that you set during Oracle Autonomous Database provisioning. - When you login successfully, you will see the Database Actions Home page on the OCI portal. For more information, see the About Oracle Database Actions documentation.
Database Metrics
Viewing the Metrics for a Database in OracleDB for Azure is accomplished from the blade for the database you wish to stop. Each blade is slightly different and so are the database details, but the process is similar.
The following steps define the primary process for viewing your database metrics. In addition to this process, there is a mechanism provided through Microsoft Azure to view metrics. That process is defined at the end of these steps to provide a secondary approach, in desired.
Using Microsoft Azure for Database Metrics can be accomplished as follows:
Scale a Database
Scaling a Database in OracleDB for Azure is accomplished from the blade for the database you wish to stop. Each blade is slightly different and so are the database details, but the process is similar.
- Go to the database blade for the database you wish to scale.
- Select the specific database you want to scale from the list. This will open the details for that specific database.
- Select the Scale icon. If the Scale icon is not active, the database cannot be scaled. If the Scale icon is not present, this task is not available for this database type.
- Enter the scaling options. You might be able to scale down your storage if the storage used is less than the scaled down storage selected. You cannot scale down below the storage currently in use.
- Confirm that you want to Scale the database by selecting the Scale button. If you do not wish to start that database, select the Discard button.
- The command to Scale the database will be submitted. The database details will update when the database has been started. Use the Refresh icon to see this.
Restore a Database
Restoring a Database in OracleDB for Azure is accomplished from the blade for the database you wish to stop. Each blade is slightly different and so are the database details, but the process is similar.
Cloning a Database
Cloning a Database in OracleDB for Azure is accomplished from the blade for the database you wish to clone. Each blade is slightly different and so are the database details, but the process is similar.
- Go to the database blade for the database you wish to clone.
- Select the specific database you want to clone from the list. This will open the details for that specific database.
- Select the Clone icon. If the Clone icon is not present, the database type does not support cloning.
- Confirm that you want to Clone the database by selecting the Yes button. If you do not wish to start that database, select the No button.
- The command to Clone the database will be submitted. The database details will update when the database has been cloned. Use the Refresh icon to see this.
Editing a Database
Some of the settings for your database in OracleDB for Azure are edittable. The most common example is adding, changing, or deleting tags. Editing is accomplished from the blade for the database you wish to edit. Each blade is slightly different and so are the database details, but the process is similar.
- Go to the database blade for the database you wish to edit.
- Select the specific database you want to start from the list. This will open the details for that specific database.
- Select the Edit link. If there is not an Edit link, there may be edittable settings on other blades. If there is not an Edit link for those settings, it is not something that can be changing.
- Edit the settings as required.
Setting Account UI Settings
Oracle Database Service for Azure (OracleDB for Azure) Portal allows you to set account-specific settings for a number of UI items, including default language, default Microsoft Azure region, and the selection of the default OracleDB for Azure Portal layout.
- Subscriptions and locations
- Appearance
- Language
- Signing out
- To access your Settings, select the Settings icon at the top of the OracleDB for Azure Portal.
- To set the default subscription and location, click Subscriptions + locations from the left navigation menu.
- Default subscription: Choose a subscription that has been linked to your OCI tenancy through OracleDB for Azure as the default subscription. The value set here shows up as the default subscription value on the various Create Resource pages.
- Default location: For the selected subscription, choose a listed locations as the default provisioning location. The value set here shows up as a default location value on the various Create Resource pages.
- There are two options for Menu behavior under Appearance:
- Flyout: This is the default portal appearance.
- Docked: This option docks the menu on the left side of the portal.
- To change the Appearance, select the desire Appearance layout, and then select the Apply button. Exit the Settings when done.
- To select a default language, click Language in the left navigation menu. Choose a language from the drop down list as the default Language. The value set here is used across the OracleDB for Azure Portal.
- To select the signing out behavior, click Signing out in the left navigation menu. Choose a default signing out time for an inactive login. The value set here is used across the OracleDB for Azure Portal for this account.
- You can exit the Settings at any time by selecting Home from the menu or the X icon at the top of the Settings blade. Unapplied changes are discarded.