Use ODACLI commands or the Browser User Interface to create a database system in a KVM deployment.
• Listing Database Systems in a KVM Deployment
Use ODACLI commands or the Browser User Interface to list database systems in a KVM deployment.
• Describing a Database System in a KVM Deployment
Use ODACLI commands or the Browser User Interface to describe a database system in a KVM deployment.
• Starting a Database System in a KVM Deployment
Use ODACLI commands or the Browser User Interface to start a database system in a KVM deployment.
• Stopping a Database System in a KVM Deployment
Use ODACLI commands or the Browser User Interface to stop a database system in a KVM deployment.
• Deleting a Database System in a KVM Deployment
Use ODACLI commands or the Browser User Interface to delete a database system in a KVM deployment.
Creating a Database System in a KVM Deployment
Use ODACLI commands or the Browser User Interface to create a database system in a KVM deployment.
Important:
Your bare metal deployment must be on Oracle Database Appliance release 19.10 before you create a KVM database system. If your system is patched to Oracle Database Appliance release 19.10, then download Oracle Grid Infrastructure and Oracle Database clone files separately, before you create the Oracle KVM Database System.
Using ODACLI to Create a KVM Database System
Use the command odacli create-dbsystem to create a KVM database system.
1. Download the Oracle Database Appliance KVM DB System Image (patch 32451228) from My Oracle Support to a temporary location on an external client. Refer to the release notes for details about the software for the latest release.
p32451228_1910000_Linux-x86-64.zip
2. Unzip the software — it contains README.html and one or more zip files for the patch.
unzip p32451228_1910000_Linux-x86-64.zip
odacli-dcs-19.10.0.0.0-210217.2-ODAVM-19.10.0.0.zip
3. Update the repository with the image. The database system version must be the same as the Oracle Database Appliance version.
# /opt/oracle/dcs/bin/odacli update-repository -f /tmp/odacli- dcs-19.10.0.0.0-210217.2-ODAVM-19.10.0.0.zip
4. Run the odacli describe-dbsystem-image command to query the
supported Oracle Grid Infrastructure and Oracle Database versions for this database system KVM image.
# odacli describe-dbsystem-image DB System Image details
--- ---
Component Name Supported Versions Available Versions
--- --- --- DBVM 19.10.0.0.0 not-available
GI 19.10.0.0.210119 19.10.0.0.210119 DB 19.10.0.0.210119 19.10.0.0.210119
5. If the odacli describe-dbsystem-image command output shows any component
as not-available on the system, then download the component with supported versions and run the odacli update-repository to import the component to the
repository.
6. Create the prov.json file as per examples provided in this chapter.
7. Run the odacli create-dbsystem command with the prov.json file on the
host.
# odacli create-dbsystem -p prov.json
Using Browser User Interface to Create a KVM Database System
Follow these steps:
1. Log into the Browser User Interface:
https://host-ip-address:7093/mgmt/index.html 2. Click the Appliance tab.
3. Click DB Systems to display the DB Systems page.
4. In the page, if no DB System exists, then click Create DB System.
5. In the Create DB System page, provide the DB system values.
6. If you want to use an existing configuration file, click Browse and select the configuration file. The system information from the file is populated in the relevant fields.
7. In the System Information section, specify the values as follows.
• DB System Name: Enter the DB System name. The name cannot end with a
dash (-). Do not exceed 15 characters.
• Domain Name: Enter the domain name.
• Region: Select the region of the world where the Oracle Database Appliance
is located.
• Time Zone: Select the time zone where the Oracle Database Appliance is
located.
• Disk Group for VM Storage: Select the disk group that is used for hosting the
KVM storage. Note that this is different from the database file storage for the database that runs in the KVM.
• System Password and Confirm Password: Enter the system password
in both fields. The system password is the password set for UNIX and
root users. The password must contain at least two characters each from:
uppercase letters, lowercase letters, numbers (0-9), and allowed special characters #, - or _. The password must have a minimum of 9 characters and a maximum of 30 characters.
• (Optional) DNS Servers: Enter addresses for one or more DNS servers.
• (Optional) NTP Servers: Enter addresses for one or more NTP servers.
8. In the Network Information section, specify the client access network details, depending on whether it is a single-node or two-node Oracle Database Appliance deployment:
• Node Name: For Node0, enter the host name for the primary client access
network.
• IP Address: Enter the virtual IP address and is shared between the nodes.
• Subnet Mask: Enter the subnet mask address for the primary client access
network.
• Gateway: Enter the gateway address for the primary client access network.
For two-node deployments, provide the above values for both nodes. In addition, you must also specify the following:
• VIP: Specify the Virtual IP address.
• SCAN: Specify the Single Client Access Name (SCAN).
9. Determine how you want to configure your users and groups and whether or not you want to allow operating system role separation:
• Two users with six groups: Customize Users and Groups, select No. Allow OS Role Separation, select Yes. This is the default configuration.
• Two customized users with six customized groups: Customize Users and Groups, select Yes. Allow OS Role Separation, select Yes.
• Single user with two groups: Customize Users and Groups, select No. Allow OS Role Separation, select No.
• Single user with six groups: Customize Users and Groups, select Yes. Allow OS Role Separation, select No.
• Specify the GI User, DB User, Install Group, DBA Oper Group, DBA
Group, ASM Admin Group, ASM Oper Group, ASM DBA Group, and the
User and Group IDs.
10. Enter the following information to configure the database:
• DB Name: Enter a name for the database. The name must contain
alphanumeric characters and cannot exceed 8 characters.
• (Optional) DB Unique Name: Enter a globally unique name for the database. Databases with the same DB Name within the same domain (for example, copies of a database created for reporting or a physical standby) must have a different DB Unique Name that is unique within the enterprise. The name must begin with a lowercase or uppercase letter, and contain only alphanumeric characters and underscores(_). The name must not contain dollar ($), and pound (#) characters. The name cannot exceed 30 characters.
• CDB: Select Yes or No to specify whether or not you want a Container
Database (CDB).
• PDB Name: Enter a name for the pluggable database (PDB).
• PDB Admin User: Enter an Admin user name for the pluggable database
(PDB). The name must begin with an alphanumeric character. You can specify alphanumeric characters and underscore (_) in the name.
• Database Edition: Select the Oracle Database edition, either Standard
Edition and Enterprise Edition. Your license determines which database edition you are eligible to create in the DB System.
• Password and Confirm Password: Provide a password for the database.
• Shape: Select a database shape from the list.
• In the Database Class field, select a database class from the drop-down list. If an option is not available in the list, it is not supported for the database edition on the Oracle Database Appliance or the version that you selected. The default is OLTP.
• Configure EM Express: Select Yes or No. Select Yes to configure the Oracle
Enterprise Manager Database Express (EM Express) console for Oracle Database 12.2.1.0 or 12.1.0.2.
• Character set: Select a character set.
• National Characterset: Select a national characterset.
• Language: Select the database language.
• Territory: Select a territory or location from the list.
• For Oracle Database Enterprise Edition 18c or later, you can choose to enable Transparent Database Encryption (TDE). Select Yes or No in the Enable TDE option. Specify and confirm the TDE Password. By default, the TDE option is disabled.
11. Click Create.
12. When you submit the job, the job ID and a link to the job appears. Click the link to display the job status and details.
13. Validate that the job completed. You can track the job in the Activity tab in the Browser User Interface, or run the command odacli describe-job with the
job ID.
Related Topics
• Example JSON File to Create a High-Availability DB System
Follow the JSON file example to create a JSON file to deploy a two-node DB System, with role separation, with the command odacli create-dbsystem.
• Example JSON File to Create a Single-Node DB System
Follow the JSON file example to create a JSON file to deploy a single-node DB System, with role separation, with the command odacli create-dbsystem.
• odacli describe-dbsystem-image
Use the odacli describe-dbsystem-image command to view the supported
Oracle Grid Infrastructure and Oracle Database versions and the availability of the clone files and Database System KVM image in the Oracle Database Appliance system.