2 Preparing for Oracle Database Appliance Installation and Deployment

Use these topics as a checklist to complete setup tasks before Oracle Database Appliance is delivered.

Tasks:

Registering Your Support Identifier on My Oracle Support

Add your hardware Support Identifier (SI) to your My Oracle Support account profile.

Your hardware SI is supplied when you purchase Oracle Database Appliance. If you acquire new software licenses, then you must also register your new software SIs. The SI registration process can take up to 24 hours to complete.

Note:

You cannot obtain support or software from Oracle without registered SIs.

Planning Oracle Database Appliance Configuration Options

Use these topics to help you to make decisions about your Oracle Database Appliance configuration.

These topics help you to select the correct Oracle Database Appliance and plan for deployment. Record your decisions and the information that you require before you proceed to complete system configuration checklists.

Caution:

Do not use Oracle Database Configuration Assistant (DBCA) to create databases on Oracle Database Appliance. Only use Oracle Appliance Manager for database configuration. Deploying Oracle Database instances using Oracle Appliance Manager ensures that these databases are properly configured, optimized, and supported on Oracle Database Appliance.

Topics:

Selecting an Oracle Database Appliance Configuration

Compare and select an Oracle Database Appliance X6-2S, X6-2M, or X6-2L hardware configuration.

  • Oracle Database Appliance X6-2S is a small configuration designed for smaller or entry-level deployments.

  • Oracle Database Appliance X6-2M is a medium-sized configuration designed for performance.

  • Oracle Database Appliance X6-2L is a large configuration designed for larger databases and database consolidation.

You cannot expand or reconfigure Oracle Database Appliance to a different configuration. For example, you cannot expand Oracle Database Appliance X6-S to Oracle Database Appliance X6-2M. For Oracle Database Appliance X6-2 configuration details, see the Oracle Database Appliance Owner's Guide.

Selecting Database Deployment Options

See the Oracle Database editions that are available for deployment.

Oracle Appliance Manager installs Oracle Database software on mirrored disks that are internal to Oracle Database Appliance. You specify the database edition in the Web Console during the initial deployment. You cannot use both Oracle Database Enterprise Edition and Standard Edition on the same appliance.

The following Oracle Database editions are available:

  • Oracle Database Enterprise Edition

    Oracle Database Enterprise Edition provides the performance, availability, scalability, and security required for mission-critical applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications.

    • Single-instance Oracle Database Enterprise Edition home

    • Oracle Database options are available

  • Oracle Database Standard Edition 2

    Oracle Database Standard Edition 2 delivers unprecedented ease of use, power, and performance for workgroup, department-level, and Web applications.

  • Oracle Database Standard Edition

    Oracle Database Standard Edition delivers the unprecedented ease of use, power, and performance of Standard Edition One, with support for larger machines and clustering of services with Oracle Real Application Clusters (Oracle RAC).

  • Oracle Database Standard Edition One

    Oracle Database Standard Edition One delivers unprecedented ease of use, power, and performance for workgroup, depart ment-level, and Web applications.

Note:

Review the Oracle Database licensing guide for supported options and products.

Selecting Database Shapes for Oracle Database Appliance

Oracle Database Appliance software includes preconfigured templates, known as shapes, that incorporate Oracle best practices with optimization for different classes of databases.

Because of differences in CPU counts, memory size, and other resources available with different Oracle Database Appliance models, some shapes are not supported on all models.

Each Oracle Database shape has different workload profile and performance characteristics:

  • Memory requirements, which are calculated from the System Global Area (SGA), and Program Global Area (PGA) sizes

  • Processing requirements, which are calculated from the number of processes

  • Logging requirements, which are based on log buffer size, and online redo log size

Oracle Database Appliance shapes are tuned for the size of each database instance workload and are designed to run on a specific number of cores.

Note:

Oracle strongly recommends that you use the Oracle Database Appliance shapes. These shapes implement best practices, and are configured specifically for Oracle Database Appliance.

Gathering System Requirement Information

Use these checklists to collect information before deploying Oracle Database Appliance.

Topics:

List of Information You Need Before Deployment

Collect security, storage, and network information required to prepare for deploying Oracle Database Appliance.

Review your security requirements for root passwords, determine your storage requirements and network administration requirements, and complete any required configuration before your Oracle Database Appliance hardware is delivered.

Security Requirements

  • What root password should you use for Oracle Database Appliance? Root passwords should comply with your system security requirements.

  • Secure operating systems are an important basis for general system security. Ensure that your operating system deployment is in compliance with common security practices.

Storage Administration Requirements

Storage administration is integrated into Oracle Database Appliance. No additional storage configuration is required.

Oracle Database Appliance X6-2S, X6-2M, and X6-2L use Oracle Automatic Storage Management Cluster File System (Oracle ACFS) or Oracle Automatic Storage Management (Oracle ASM) and include the following:

  • Integrated storage for operational files (operating system, Oracle Grid Infrastructure home, Oracle Database homes, tools). Operational files are stored on mirrored internal system disks.

  • DATA (user data and database files)

  • RECO (database redo logs, archive logs, and recovery manager backups)

  • Operational files are stored on mirrored internal system disks.

You can configure for External, Internal, or Custom backup location. Depending on backup location, you can select one of the following configuration options to divide the storage capacity between DATA diskgroup and RECO diskgroup:

  • External: Storage capacity is split between 80% for DATA and 20% for RECO.

  • Internal: Storage capacity is split between 40% for DATA and 60% for RECO.

  • Custom: Storage capacity is configurable from 10% to 90% for DATA and the remainder for RECO.

Note:

Oracle Database Appliance X6-2S and X6-2M ship with two 3.2 TB non-volatile memory express (NVMe) drives for a total of 6.4 TB of NVMe storage. With Oracle Database Appliance X6-2M, you have the option to expand the system to a 4 disk configuration, which doubles the NVMe storage capacity. Oracle Database Appliance X6-2L ships with six 3.2 TB non-volatile memory express (NVMe) drives with the option to add three (3) disks for a total of nine (9) NVMe disks.

Network Administration Requirements

The network administration requirements and recommendations are as follows:

  • Determine the type of network interface for your public network and know the details for your generic and public network.

  • Oracle recommends that you resolve addresses using Domain Name System (DNS) servers.

  • All names must conform to the RFC 952 standard, which permits alphanumeric characters and hyphens ("-"), but does not allow underscores ("_").

  • Provide an IP address for the public interface. The following are the public interfaces:

    • Oracle Database Appliance X6-2S: btbond1 or sfpbond1

    • Oracle Database Appliance X6-2M: btbond1, btbond2 and sfpbond1

    • Oracle Database Appliance X6-2L: btbond1, btbond2 and sfpbond1

Depending on your network setup, you can use one of the following available bonds:

  • btbond are bonded interface based on onboard NIC 10GBase-T (copper) ports

  • sfpbond is bonded interface based on the 10GbE SFP+ (fiber) PCIe card

When you use the configure-first command during the initial setup, you can choose one of the bonded interfaces for the public network. Use one of the remaining bonded interfaces for management, backup, data guard, or other network. Be prepared to provide a netmask and gateway for each network, as both are required when you configure a network connection for Oracle Database Appliance. VLAN is not supported.

Answer These Questions

Determine the answers to the following questions:

  • What is your domain name?

    For example: example.com.

  • Do you want to use DNS?

    (Optional) Ensure that the names and addresses that you provide for network configuration are configured in your Domain Name System (DNS) servers. DNS is optional, but recommended. If you want to use DNS, then obtain your DNS server addresses. The addresses that you provide are configured in the /etc/hosts file to provide IP name and address resolution, even if a DNS server is not available.

  • Do you have a Network Time Protocol (NTP) service configured for each server, so that the local system time for each server is synchronized?

  • Which network interface do you want to use for your public network?

    • 10GBase-T (copper)

    • 10GbE SFP+ (fiber)

  • What are the details for your public network? To connect to the system, you require the following information:

    • Host name

      For example: myhost

    • IP address

      For example: 192.0.2.18

    • Netmask for the public network

      For example: 255.255.252.0

    • Gateway for the public network

      For example: 192.0.2.1

  • Do you want the ability to configure additional networks?

  • Do you want to use Oracle Integrated Lights Out Manager (Oracle ILOM) to manage Oracle Database Appliance independent of the operating system?

    (Optional) Collect the following ILOM details from your network administrator:

    • Oracle ILOM host name

      For example: myilom1

    • Oracle ILOM IP address

      For example: 10.0.0.3

    • Netmask for the Oracle ILOM network

      For example: 255.255.255.0

    • Gateway for the Oracle ILOM network

      For example: 10.0.0.1

Displaying the MAC Addresses

Use the ifconfig -a command to display the MAC addresses for various interfaces.

When you deploy Oracle Database Appliance, you must provide an IP address for the primary client access network. In addition, you can configure the following networks during deployment, each of which requires an IP address:

  • (Optional) Additional network

  • (Optional) ILOM network

To display the MAC address, start the system and run the ifconfig -a command.

# ifconfig eth1

eth1      Link encap:Ethernet  HWaddr 00:19:2E:97:E1:4C

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:0 errors:0 dropped:0 overruns:0 frame:0

          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000

          RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)

Checklist for System Details

Use the checklist to gather system information that you need to obtain for Oracle Database Appliance. Record the values for your system.


Table 2-1 Checklist for System Configuration Information for Oracle Database Appliance

System Information Description

Host Name

The name for the Oracle Database Appliance System. The name must conform with the RFC 952 standard, which allows alphanumeric characters and hyphens ( - ), but does not allow underscores ( _ ). The name should not begin with a numeral or hyphen and should not end in a hyphen. The maximum length is 30 characters. Oracle recommends that you use all lowercase characters for the host name.

Domain Name

Your domain name. For example: example.com

Master Password

The password set for the root password of the system, OS users, database users, and pdbadmin. The password is also used to set the database SYS and SYSTEM passwords. Ensure that the password you provide is in compliance with common security practices.

DNS Server

(Optional) DNS server details.

NTP Server

(Optional) Network Time Protocol (NTP) service details.

Region

The region where you plan to operate the Oracle Database Appliance system.

Timezone

Select the time zone where you plan to operate the Oracle Database Appliance system.

Database Edition

Select an Oracle Database edition, either Enterprise Edition or Standard Edition. You cannot mix editions. The database edition you select determines the database editions that you create in the appliance. To change editions, you must redeploy Oracle Database Appliance.

Backup Location

Determine the backup location you want: External, Internal, or Custom.

  • External reserves 80% of the storage for DATA and 20% for RECO.

  • Internal reserves 40% of the storage for DATA and 60% for RECO.

  • Custom reserves anywhere from 10% to 90% of the storage for DATA, and the remainder is reserved for RECO.

Percentage of Storage Reserved for Data

If you select a Custom backup location, determine the amount of reserves for DATA storage. The percentage must be a whole number between 10 and 90.

Diskgroup Redundancy

If the machine has 4 NVMe, select normal redundancy (two way mirror) or high redundancy (three way mirror). If the machine has 2 NVMe, redundancy is automatically set to normal and this field does not appear.

Network Information

Obtain network information:

  • Public network

  • (Optional) Additional network

  • (Optional) Oracle Integrated Lights Out Manager (Oracle ILOM) network

Initial Database Details (if you want to create one during deployment)

  • Database name

  • Normal or container database

  • Class (database template)

  • Database characterset

  • Database language

  • Database version

  • Shape (for example: odb1 or odb2)

  • Storage (Oracle ASM or Oracle ACFS)

  • Configure Oracle Enterprise Manager console


Checklist for Custom Network Address Configuration

Use the checklist to identify the IP addresses required for Oracle Database Appliance.

Note:

Oracle does not recommend changing the default Host Private Address. If there is a business need to change the address, such as an IP address conflict, use the odacli update-network command to update the private network before using the Web Console to deploy the appliance. You cannot change the private network after deploying the appliance.

Table 2-2 Default IP Address Requirements for Oracle Database Appliance

Type of IP IP Address Default Values Your Values As Applicable

Client Access Network

No default

No default

Additional Network

No default

No default

Oracle Integrated Lights Out Manager (ILOM)

No default

No default

Host Private Addresses

192.168.16.24

Not applicable: the private addresses are defined before deployment and should not be changed