9.7.2.1 CREATE DBSERVER

Purpose

The CREATE DBSERVER command creates the DBSERVER object type.

Syntax

CREATE DBSERVER [name] 
    [interconnect1=intValue1 [, interconnect2=intValue2 ...]] 
    [ { , ipaddress1=ipValue1 [, ipaddress2=ipValue2 ...] }]
    [, attributeName = attributeValue ...]

Usage Notes

The attributes that can be set are shown as modifiable in DESCRIBE DBSERVER.

• This command can be used to assign the ASR value to the snmpSubscriber attribute.

• If a name is not provided, then the default is to set the database server name to the network host name of the server with hyphens in the network name replaced with underscores. You can display the network name with the uname -n command. If you change the database server name, then you must choose a unique database server name.

  If you provide a name, ensure that the name meets the guidelines.

• One to four interconnects can be specified. The interconnect1 attribute must be specified if the interconnect2 attribute is specified. The interconnect1 and interconnect2 attributes must be specified if interconnect3 is specified, and so on.

• If interconnectn and ipaddressn are specified, then an ipaddressn entry is automatically written to the /etc/oracle/cell/network-config/cellinit.ora file.

• Interconnects use the RDMA Network Fabric (ibN or reN).

• Starting with Oracle Exadata System Software release 19.1.0, the httpsAccess attribute can be used to specify a list of IP addresses or IP subnet masks that control who can access the RESTful service via HTTPs. The value you specify for httpsAccess overwrites any previous value. You can use the following values for httpsAccess:

  • ALL — to allow access to all hosts (Default)
  • NONE — to disable the HTTPs port completely
  • IP1, IP2,..., IPn — to only allow access to hosts with IP addresses IP1, IP2,..., IPn where IPn is a valid IP address in IPv4, IPv4 subnet, IPv6 or IPv4-embedded IPv6 format. You can specify a maximum of 512 IP addresses for the access control list.

  Additionally, instead of a single IP address, you can use the / character to specify a range of IP addresses using a subnet mask. For example the range '192.168.10.0/24' corresponds to hosts having IP addresses from 192.168.10.1 to 192.168.10.255. If you specify an IP address range, you need to enclose the IP address string in quotes.

Examples

Example 9-31 shows the CREATE DBSERVER command with the interconnectn attribute.

Example 9-32 shows how to create a DBSERVER object that restricts HTTPs access to the RESTful server to a set of hosts.

Example 9-31 Creating a DB Server and setting the interconnectn attribute for the DBSERVER object

For racks that use InfiniBand Network Fabric:

DBMCLI> CREATE DBSERVER interconnect1=ib0, interconnect2=ib1

For racks that use RoCE Network Fabric:

DBMCLI> CREATE DBSERVER interconnect1=re0, interconnect2=re1

Example 9-32 Creating a DBServer with Restricted HTTPs Access

This example shows how to create a DBSERVER object that allows HTTPs port access only from hosts having IP addresses in the range 192.168.10.1 to 192.168.10.255.

For racks that use InfiniBand Network Fabric:

DBMCLI> CREATE DBSERVER interconnect1=ib0, httpsAccess="192.168.10.0/24" 

For racks that use RoCE Network Fabric:

DBMCLI> CREATE DBSERVER interconnect1=re0, httpsAccess="192.168.10.0/24"