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 theinterconnect2
attribute is specified. Theinterconnect1
andinterconnect2
attributes must be specified ifinterconnect3
is specified, and so on. -
If
interconnectn
andipaddressn
are specified, then anipaddressn
entry is automatically written to the/etc/oracle/cell/network-config/cellinit.ora
file. -
Interconnects use the RDMA Network Fabric (
ibN
orreN
). -
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 forhttpsAccess
overwrites any previous value. You can use the following values forhttpsAccess
:ALL
— to allow access to all hosts (Default)NONE
— to disable the HTTPs port completelyIP1, 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"
Parent topic: CREATE