Using the Console
To create a DB system
Open the navigation menu. Under Oracle Database, click Bare Metal, VM, and Exadata.
Click Create DB System.
On the Create DB System page, provide the basic information for the DB system:
Select a compartment: By default, the DB system is created in your current compartment and you can use the network resources in that compartment.
Name your DB system: A non-unique, display name for the DB system. An Oracle Cloud Identifier (OCID) uniquely identifies the DB system.
Select an availability domain: The availability domain in which the DB system resides.
Select a shape type: The shape type you select sets the default shape and filters the shape options in the next field.
Select a shape: The shape determines the type of DB system created and the resources allocated to the system. To specify a shape other than the default, click Change Shape, and select an available shape from the list.
Configure the DB system: Specify the following:
Total node count: The number of nodes in the DB system, which depends on the shape you select. For virtual machine DB systems, you can specify either one or two nodes, except for VM.Standard2.1 and VM.Standard1.1, which are single-node DB systems.
Oracle Database software edition: The database edition supported by the DB system. For bare metal systems, you can mix supported database releases on the DB system to include older database versions, but not editions. The database edition cannot be changed and applies to all the databases in this DB system. Virtual machine systems support only one database.
CPU core count: Displays only for bare metal DB systems to allow you to specify the number of CPU cores for the system. (Virtual machine DB system shapes have a fixed number of CPU cores.) The text below the field indicates the acceptable values for that shape. For a multi-node DB system, the core count is evenly divided across the nodes.
Note
After you provision the DB system, you can increase the CPU cores to accommodate increased demand. On a bare metal DB system, you scale the CPU cores directly. For virtual machine DB systems, you change the number of CPU cores by changing the shape.
Choose Storage Management Software: 1-node virtual machine DB systems only. Select Oracle Grid Infrastructure to use Oracle Automatic Storage Management (recommended for production workloads). Select Logical Volume Manager to quickly provision your DB system using Logical Volume Manager storage management software. Note that the Available storage (GB) value you specify during provisioning determines the maximum total storage available through scaling. The total storage available for each choice is detailed in the Storage Scaling Considerations for Virtual Machine Databases Using Fast Provisioning topic.
See Fast Provisioning Option for 1-node Virtual Machine DB Systems for more information about this feature.
Configure storage: Specify the following:
Available storage (GB): Virtual machine only. The amount of Block Storage in GB to allocate to the virtual machine DB system. Available storage can be scaled up or down as needed after provisioning your DB system.
Total storage (GB): Virtual machine only. The total Block Storage in GB used by the virtual machine DB system. The amount of available storage you select determines this value. Oracle charges for the total storage used.
Cluster name: (Optional) A unique cluster name for a multi-node DB system. The name must begin with a letter and contain only letters (a-z and A-Z), numbers (0-9) and hyphens (-). The cluster name can be no longer than 11 characters and is not case sensitive.
Data storage percentage: Bare metal only. The percentage (40% or 80%) assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups).
Add public SSH keys: The public key portion of each key pair you want to use for SSH access to the DB system. You can browse or drag and drop .pub files, or paste in individual public keys. To paste multiple keys, click + Another SSH Key, and supply a single key for each entry.
Choose a license type: The type of license you want to use for the DB system. Your choice affects metering for billing.
License Included means the cost of this Oracle Cloud Infrastructure Database service resource will include both the Oracle Database software licenses and the service.
Bring Your Own License (BYOL) means you will use your organization's Oracle Database software licenses for this Oracle Cloud Infrastructure Database service resource. See Bring Your Own License for more information.
Specify the network information:
Virtual cloud network: The VCN in which to create the DB system. Click Change Compartment to select a VCN in a different compartment.
Client Subnet: The subnet to which the DB system should attach. For 1- and 2-node RAC DB systems: Do not use a subnet that overlaps with 192.168.16.16/28, which is used by the Oracle Clusterware private interconnect on the database instance. Specifying an overlapping subnet will cause the private interconnect to malfunction.
Click Change Compartment to select a subnet in a different compartment.
Network Security Groups: Optionally, you can specify one or more network security groups (NSGs) for your DB system. NSGs function as virtual firewalls, allowing you to apply a set of ingress and egress security rules to your DB system. A maximum of five NSGs can be specified. For more information, see Network Security Groups and Network Setup for DB Systems.
Note that if you choose a subnet with a security list, the security rules for the DB system will be a union of the rules in the security list and the NSGs.
Hostname prefix: Your choice of host name for the bare metal or virtual machine DB system. The host name must begin with an alphabetic character, and can contain only alphanumeric characters and hyphens (-). The maximum number of characters allowed for bare metal and virtual machine DB systems is 16.
Important
The host name must be unique within the subnet. If it is not unique, the DB system will fail to provision.
Host domain name: The domain name for the DB system. If the selected subnet uses the Oracle-provided Internet and VCN Resolver for DNS name resolution, then this field displays the domain name for the subnet and it can't be changed. Otherwise, you can provide your choice of a domain name. Hyphens (-) are not permitted.
Host and domain URL: Combines the host and domain names to display the fully qualified domain name (FQDN) for the database. The maximum length is 64 characters.
Click Show Advanced Options to specify advanced options for the DB system:
Disk redundancy: For bare metal systems only. The type of redundancy configured for the DB system.
Normal is 2-way mirroring, recommended for test and development systems.
High is 3-way mirroring, recommended for production systems.
Fault domain: The fault domain(s) in which the DB system resides. You can choose which fault domain to use for your DB system. For two-node Oracle RAC DB systems, you can specify which two fault domains to use. Oracle recommends that you place each node of a two-node Oracle RAC DB system in a different fault domain. For more information on fault domains, see About Regions and Availability Domains.
Time zone: The default time zone for the DB system is UTC, but you can specify a different time zone. The time zone options are those supported in both the Java.util.TimeZone class and the Oracle Linux operating system. For more information, see DB System Time Zone.
Tip
If you want to set a time zone other than UTC or the browser-detected time zone, and if you do not see the time zone you want, try selecting "Miscellaneous" in the Region or country list.
Tags: If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see Resource Tags. If you are not sure if you should apply tags, then skip this option (you can apply tags later) or ask your administrator.
After you complete the network configuration and specify any advanced options, click Next.
Provide information for the initial database:
Database name: The name for the database. The database name must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.
Database image: This controls the version of the initial database created on the DB system. By default, the latest available Oracle Database version is selected. You can also choose an older Oracle Database version, or choose a customized database software image that you have previously created in your current region with your choice of updates and one-off (interim) patches. See Oracle Database Software Images for information on creating and working with database software images.
To use an older Oracle-published software image:
Click Change Database Image.
In the Select a Database Software Image dialog, select Oracle-published Database Software Images.
In the Oracle Database Version list, check the version you wish to use to provision the initial database in your DB system. If you are launching a DB system with a virtual machine shape, you have option of selecting an older database version.
Display all available versions: Use this switch to include older database updates in the list of database version choices. When the switch is activated, you will see all available PSUs and RUs. The most recent release for each major version is indicated with "(latest)". See Availability of Older Database Versions for Virtual Machine DB Systems for more information.
Note
Preview software versions: Versions flagged as "Preview" are for testing and subject to some restrictions. See Oracle Database Preview Version Availability for more information.
Click Select.
To use a user-created database software image:
Click Change Database Image.
In the Select a Database Software Image dialog, select Custom Database Software Images.
Select the compartment that contains your database software image.
Select the Oracle Database version that your database software image uses.
A list of database software images is displayed for your chosen Oracle Database version. Check the box beside the display name of the image you want to use.
After the DB system is active, you can create additional databases for bare metal systems. You can mix database versions on the DB system, but not editions. Virtual machine DB systems are limited to a single database.
PDB name: Not applicable to Oracle Database 11g (11.2.0.4). The name of the pluggable database. The PDB name must begin with an alphabetic character, and can contain a maximum of eight alphanumeric characters. The only special character permitted is the underscore ( _).
Create administrator credentials: A database administrator SYS user will be created with the password you supply.
Username: SYS
Password: Supply the password for this user. The password must meet the following criteria:
A strong password for SYS, SYSTEM, TDE wallet, and PDB Admin. The password must be 9 to 30 characters and contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be _, #, or -. The password must not contain the username (SYS, SYSTEM, and so on) or the word "oracle" either in forward or reversed order and regardless of casing.
Confirm password: Re-enter the SYS password you specified.
Select workload type: Choose the workload type that best suits your application:
Online Transactional Processing (OLTP) configures the database for a transactional workload, with a bias towards high volumes of random data access.
Decision Support System (DSS) configures the database for a decision support or data warehouse workload, with a bias towards large data scanning operations.
Configure database backups: Specify the settings for backing up the database to Object Storage:
Enable automatic backup: Check the check box to enable automatic incremental backups for this database. If you are creating a database in a security zone compartment, you must enable automatic backups.
Backup retention period: If you enable automatic backups, then you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The default selection is 30 days.
Backup Scheduling: If you enable automatic backups, then you can choose a two-hour scheduling window to control when backup operations begin. If you do not specify a window, then the six-hour default window of 00:00 to 06:00 (in the time zone of the DB system's region) is used for your database. See Backup Scheduling for more information.
Click Show Advanced Options to specify advanced options for the initial database:
Character set: The character set for the database. The default is AL32UTF8.
National character set: The national character set for the database. The default is AL16UTF16.
Click Create DB System. The DB system appears in the list with a status of Provisioning. The DB system's icon changes from yellow to green (or red to indicate errors).
After the DB system's icon turns green, with a status of Available, you can click the highlighted DB system name to display details about the DB system. Note the IP addresses. You'll need the private or public IP address, depending on network configuration, to connect to the DB system.
Lavakumar
https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/creatingDBsystem.htm
###############################################IMP POINT #############
console
under ORACLE DATABASE
SELECT BAREMATEL/VM/EXADATA
SELECT COMPARTMENT
SELECT SHAPE
UNDER SHAPE ONLY YOU CAN SET
TOTAL NODE COUNT (single node have these VM STANDARD 2.1 and 1.1 )
ORACLE DB EDITION (on baremetal you select older vrsion RELEASE but not edition,DB edition cannot change its default,VM only support one DB)
CPU CORE COUNT (ONLY BARE METAL you specify cpu core,FOR VM you can only change Shape if you want change cpu core)
**AFTER CREATION DBSYSTEM WE CAN INCREASE/DECREASE DB SYSTEM **
Choose Storage Management:
You can select GRID ( recomended for PROD Workload and Logical Volume for fast DB system access)
Configure Storage have below options
Avilable Storage(only for VM)
Total storage(Only for VM and oracle charges for total storage)
clustername (to enter name not more than 11charcters)
Data Storage percentage(Only for Bare Metal,Userdata and Db files we can define this value,rest of all percentage goes to RECO)
Add Public SSH Keys:
Choose License Type: BYOL or select licence
Specify Network information:
VCN(we can select optionally different compartment vcn for multinode)
Network Security Group( for more ingress/exgress and security firewalls we can select max 5NSG)
Hostname prefix:The maximum number of characters allowed for bare metal and virtual machine DB systems is 16
Host domain name:by deafult subnet uses oracle provided internet and VCN resolver for DNS Name Resolution)
Host and domain URL: Combines the host and domain names to display the fully qualified domain name (FQDN) for the database.
Disk redundancy: For bare metal systems only
Database name: The name for the database.
Database image: This controls the version of the initial database created on the DB system. By default, the latest available Oracle Database version is selected. You can also choose an older Oracle Database version
A strong password for SYS, SYSTEM, TDE wallet, and PDB Admin.
Enable automatic backup: Check the check box to enable automatic incremental backups for this database
Backup retention period: If you enable automatic backups, then you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The default selection is 30 days.
Backup Scheduling: If you enable automatic backups, then you can choose a two-hour scheduling window to control when backup operations begin. If you do not specify a window, then the six-hour default window of 00:00 to 06:00 (in the time zone of the DB system's region) is used for your database.
Character set: The character set for the database. The default is AL32UTF8
Click Create DB System. The DB system appears in the list with a status of Provisioning. The DB system's icon changes from yellow to green (or red to indicate errors).
Note that if you choose a subnet with a security list, the security rules for the DB system will be a union of the rules in the security list and the NSGs.
No comments:
Post a Comment