manualshive.com logo in svg

Oracle Database Appliance X6-2-HA, Deployment And User'S Manual

The Oracle Database Appliance X6-2-HA is a high-availability solution designed for efficient database deployment. For detailed instructions on deployment and user management, download the free manual from manualshive.com. Ensure seamless integration and optimal performance with this comprehensive user's guide. Download your manual today for hassle-free setup.

Share
Download
background image

•

transportable tablespaces

•

RMAN

You can also use the RMAN utility to back up and recover databases on Oracle
Database Appliance.

Working with Databases

Use the Web Console to display a list of databases, database details, and create and
delete databases.

•

Viewing Databases

Use the Oracle Appliance Manager Web Console to display a list of Oracle
databases and database details, create, upgrade, and delete a database in Oracle
Database Appliance.

•

Creating a Database

Use the Oracle Appliance Manager Web Console to create a database in Oracle
Database Appliance.

•

Creating a Database Instance

Create an instance only database from the command-line interface.

•

Cloning a Database from Backup

Use the Web Console to clone a database from a backup.

•

Cloning a Database

Create a database from an existing Oracle ACFS database.

•

Upgrading a Database

Use the Oracle Appliance Manager Web Console to upgrade an Oracle database
to a different database home version.

•

Deleting a Database

Use the Oracle Appliance Manager Web Console to delete an Oracle database.

Viewing Databases

Use the Oracle Appliance Manager Web Console to display a list of Oracle databases
and database details, create, upgrade, and delete a database in Oracle Database
Appliance.

On the Oracle Database Appliance Virtualized Platform, see the command 

oakcli

list databases

.

1.

Log into the Web Console:

https://host name or ip-address:7093/mgmt/index.html

2.

Click the Database tab.

Chapter 9

Working with Databases

9-3

Summary of Contents for Database Appliance X6-2-HA

Page 1: ...Oracle Database Appliance X6 2 HA Deployment and User s Guide Release 18 3 for Linux x86 64 F10531 03 May 2019...

Page 2: ...se terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information manage...

Page 3: ...etal Options 2 2 Selecting Oracle Database Appliance Virtualized Platform Options 2 2 Selecting Database Configuration Options 2 3 Selecting Database Deployment Options for Oracle Database Appliance 2...

Page 4: ...Provisioning an Oracle Database Appliance Virtualized Platform Determining if the System is Configured with a Virtualized OS Image 5 1 Setting Up the Virtualized Platform 5 2 Installing Virtualized Pl...

Page 5: ...ion Options for Oracle Database Appliance 9 2 Working with Databases 9 3 Viewing Databases 9 3 Creating a Database 9 4 Creating a Database Instance 9 6 Cloning a Database from Backup 9 7 Cloning a Dat...

Page 6: ...d 11 17 Backing Up a Database with the CLI 11 18 Recovering a Database with the CLI 11 19 Restoring a Database with the CLI 11 21 12 Managing an Oracle Database Appliance Virtualized Platform About Or...

Page 7: ...Platform 12 24 Listing the Virtual Machines in Your Repositories 12 24 Creating a Virtual Machine 12 26 Configuring a Virtual Machine 12 26 Starting and Stopping a Virtual Machine 12 27 Externally Co...

Page 8: ...describe component 13 11 odacli describe latestpatch 13 13 odacli create prepatchreport 13 13 odacli describe prepatchreport 13 14 odacli update agentconfig parameters 13 17 odacli list agentconfig pa...

Page 9: ...13 56 odacli list databases 13 57 odacli describe database 13 57 odacli create database 13 58 odacli clone database 13 63 odacli modify database 13 64 odacli register database 13 64 odacli upgrade dat...

Page 10: ...nds 13 102 odacli configure asr 13 103 odacli update asr 13 105 odacli describe asr 13 106 odacli test asr 13 107 odacli delete asr 13 108 odacli OS Commands 13 108 odacli list osconfigurations 13 109...

Page 11: ...figure network 14 11 oakcli configure oda_base 14 11 oakcli configure repo 14 12 oakcli copy 14 13 oakcli create commands 14 13 oakcli create cpupool 14 14 oakcli create database 14 14 oakcli create d...

Page 12: ...14 43 oakcli show env_hw 14 43 oakcli show expander 14 44 oakcli show ismaster 14 44 oakcli show fs 14 45 oakcli show memory 14 45 oakcli show network 14 45 oakcli show power 14 45 oakcli show process...

Page 13: ...e 14 77 oakcli import vmtemplate 14 78 oakcli modify vmtemplate 14 80 oakcli show vmtemplate 14 80 oakcli VLAN Management Commands for Virtual Platform 14 81 oakcli create vlan 14 81 oakcli delete vla...

Page 14: ...3 C Oracle Database Appliance Storage Defaults About Oracle Database Appliance Storage C 1 Oracle ACFS Mount Points and Storage Space C 2 Displaying Mounted Disk Details C 3 Determining Usable Storage...

Page 15: ...Index xv...

Page 16: ...chine Templates from an External Repository Assembly File 12 18 12 14 Example of Importing a Virtual Machine Template from Dom0 12 18 12 15 Example of Importing a Virtual Machine Template Using an Ext...

Page 17: ...Reports 13 21 13 17 Deleting A Patch Pre Checks Report 13 22 13 18 Updating an Oracle Database Home 13 23 13 19 Updating the Agent 13 24 13 20 Updating the Repository 13 26 13 21 Updating the Server 1...

Page 18: ...3 54 13 52 Disable Scheduled Database Backups 13 54 13 53 Displaying a List of Cores 13 55 13 54 Displaying the Current Core Configuration 13 55 13 55 Enabling CPU Cores 13 56 13 56 Displaying a List...

Page 19: ...Listing Jobs to Purge Logs 13 99 13 93 Displaying Log Cleanup Jobs 13 100 13 94 Creating Automatic Jobs to Purge Logs 13 101 13 95 Listing Jobs to Purge Logs 13 102 13 96 Configuring Oracle ASR with...

Page 20: ...unning the Offline Configurator with Advance Mode 14 25 14 8 Preloading an Existing Configuration File 14 25 14 9 Changing a User Group Name or ID 14 25 14 10 Viewing the Log File 14 26 14 11 Expandin...

Page 21: ...14 43 Cloning a Virtual Disk 14 64 14 44 Displaying Information for All Virtual Disks 14 65 14 45 Displaying Information for a Single Virtual Disk 14 65 14 46 Creating a Virtual Machine Image 14 68 1...

Page 22: ...ed Location 15 4 C 1 Oracle ACFS Storage Space C 3 C 2 Determining Storage on the DATA Disk Group C 4 D 1 JSON File to Create a Single Node Oracle Database Appliance with Role Separation D 3 D 2 JSON...

Page 23: ...Architecture 12 3 12 2 Architecture Overview of Oracle Database Appliance Virtualized Platform Shared Repositories 12 6 12 3 Basic Virtual Machine Local Area Network 12 8 12 4 Oracle Database Applian...

Page 24: ...3 4 Description of Callouts for Powering On Oracle Database Appliance 3 9 8 1 Command Options for Cleanup Utility 8 2 9 1 Operating System Groups and Users on Oracle Database Appliance 9 2 12 1 Parame...

Page 25: ...ators Application administrators and users This book does not include information about Oracle Database architecture tools management or application development that is covered in the main body of Ora...

Page 26: ...cle Database Appliance Owner s Guide Oracle Database Appliance Service Manual Oracle Database Appliance Series Safety and Compliance Guide For more information about using Oracle Database go to http d...

Page 27: ...italic Italic type indicates book titles emphasis or placeholder variables for which you supply particular values monospace Monospace type indicates commands within a paragraph URLs code in examples t...

Page 28: ...base Appliance hardware models deployment plans and database options About Oracle Database Appliance Hardware Models Choose the Oracle Database Appliance hardware model that suits your business needs...

Page 29: ...iance X6 2 HA is a two node system with the option to deploy as a bare metal platform or a virtualized platform Starting with with Oracle Database Appliance release 18 3 systems deployed as bare metal...

Page 30: ...are patches available for Oracle Database Appliance The table describes the Oracle Database Appliance patches that are available for download and the purpose of the patch Note Some hardware models may...

Page 31: ...e Database Appliance Manager oakcli command line interface Oracle Database Appliance Manager Configurator Oracle Linux Hardware drivers Required for Virtualized Platform deployments on multi node high...

Page 32: ...Oracle Appliance Manager Web Console to deploy and manage the appliance databases networks and jobs The Web Console assists you in deploying Oracle Databases that follow Optimal Flexible Architecture...

Page 33: ...ions that are available but not yet installed on the appliance Run patch prechecks before applying the patch Update the server and storage components Use the links in the top navigation to view and ma...

Page 34: ...About to view the Oracle Database Appliance release that is installed on the appliance Click Update ILOM Setting to change the root password To enable first time login and access to Oracle ILOM a defa...

Page 35: ...rt 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 acq...

Page 36: ...for these options such as shared disks and virtual local area networks Before you implement virtual machines you must decide how and where you want them to run Based on your requirements you can selec...

Page 37: ...xactly like a separate physical connection Note You must configure virtual LANs on the physical switches before you use them Selecting Database Configuration Options Select the database templates and...

Page 38: ...e During the initial deployment you can either create a database or you can defer database creation to a later time Options Enterprise Edition Oracle Database 18c Enterprise Edition no automated failo...

Page 39: ...es Processing requirements which are calculated from the number of processes Logging requirements which are based on log buffer size and online redo log size 1 Review the types of database templates f...

Page 40: ...support the templates Oracle Database Appliance templates are configured and tuned for specific types of Oracle Database workloads Generic templates Online analytic transaction templates OLTP Decision...

Page 41: ...ecurity 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 Ad...

Page 42: ...resolve to the SCAN for the cluster 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 publ...

Page 43: ...le 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 dat...

Page 44: ...ich you provide during installation Also when you use Oracle Appliance Manager Configurator the addresses for the public IP addresses can be automatically assigned in a sequence starting with the addr...

Page 45: ...irtual Machine Not Applicable No default No default No Minimum IP Address Requirements for Oracle Database Appliance Virtualized Platform Deployment Table 2 3 Minimum IP Address Requirements for Oracl...

Page 46: ...Counts IP Address Default Values Your Values As Applicable Same Subnet Single Client Access Name SCAN 2 No default No default Yes Oracle Integrated Lights Out Manager ILOM 2 No default No default No...

Page 47: ...r a newly installed Oracle Database Appliance or to start up the appliance after you power it down Configuring Oracle Integrated Lights Out Manager Configure Oracle Integrated Lights Out Manager Oracl...

Page 48: ...fiber cards instead of InfiniBand cards Attaching Cables for Oracle Database Appliance X6 2 HA Use the diagram in this topic to understand how to attach cable connections between ports on Oracle Datab...

Page 49: ...nce to Connect to Fiber Public Networks Optional You can configure Oracle Database Appliance X6 2 HA to use 10GbE SFP fiber connections for the public network if you ordered the configuration that con...

Page 50: ...bles You can purchase the following copper cables from Oracle These cables have built in SFP connectors Name Length Part Number TwinAx 1m 1m X2130 1M N TwinAx 3m 3m X2130 3M N TwinAx 5m 5m X2130 3M N...

Page 51: ...ss when adding a storage expansion shelf to Oracle Database Appliance with existing databases Do not attach cables to Ethernet ports in the I O modules labeled SERVICE ONLY when cabling the system The...

Page 52: ...Shelf Callout Number Description 7 Dark blue SAS cable From Node 1 PCIe slot 2 SAS0 To Storage expansion shelf top I O port 0 8 Light blue SAS cable From Node 1 PCIe slot 3 SAS1 To Storage expansion s...

Page 53: ...llation in Chapter 4 of Oracle Database Appliance Owner s Guide 3 Use the figures in this topic to assist you to cable the storage expansion shelf for your Oracle Database Appliance model Caution Inco...

Page 54: ...power button once Attaching Power Cords and Initializing Components Attach power cords for Oracle Database Appliance Powering On Oracle Database Appliance the First Time Use this procedure the first...

Page 55: ...age in the rear of each storage shelf push the recessed power button to turn on the server nodes Note The fully initialized state is indicated by the green SP OK LEDs staying steadily lit If any of th...

Page 56: ...llowing items first to configure Oracle ILOM A name and IP address A password to replace the default Oracle ILOM password Access to a management network using an assigned netmask An Ethernet cable con...

Page 57: ...assword changeme The Oracle ILOM CLI prompt appears Troubleshooting the ILOM Configuration If the ILOM is not working then ensure that the ILOM NIC is enabled and that ipv4 is enabled You can configur...

Page 58: ...g Oracle Database Appliance Software Download Oracle Database Appliance software and copy to a temporary location before applying updates to your appliance Installing Oracle Database Appliance Softwar...

Page 59: ...leasing active interface em3 Example 4 2 Example of a Non Bonded Configuration To create a non bonded configuration and disable VLAN capabilities answer no to using a bonding public interface opt orac...

Page 60: ...wn interface p1p2 OK Shutting down loopback interface OK Bringing up loopback interface OK Bringing up interface em1 OK Bringing up interface em2 Determining if ip address 10 1 10 2 is already in use...

Page 61: ...nly on Oracle Database Appliance HA models 1 Log into the Oracle Database Appliance console and access the server node with user name as root and password welcome1 2 Run validation scripts on both nod...

Page 62: ...ber of External SCSI controllers found 2 INFO Check for Controllers correct PCIe slot address SUCCESS Internal RAID controller SUCCESS External LSI SAS controller 0 3b 00 0 SUCCESS External LSI SAS co...

Page 63: ...level 0x00000000 0 Link detected yes Downloading Oracle Database Appliance Software Download Oracle Database Appliance software and copy to a temporary location before applying updates to your applian...

Page 64: ...files are copied to the temporary location on the appliance You can update the repository and create the appliance as explained in the next topic Installing Oracle Database Appliance Software Install...

Page 65: ...appliance 3 Click Create Appliance 4 In the Create Appliance page if you want to create the appliance from a saved configuration click Browse and select the JSON file The information from the saved co...

Page 66: ...system password is the password set for UNIX and root users The password must begin with an alpha character and cannot contain quotation marks Do not exceed 30 characters 6 In the Network Information...

Page 67: ...or select No and go to Step 10 9 Enter the following information to configure an initial database a DB Name Enter a name for the database The name must contain alphanumeric characters and cannot exce...

Page 68: ...cannot specify the database redundancy If your disk group redundancy is Flex and you choose Oracle ACFS storage for the database then the database redundancy is set to Mirror n Storage Select ACFS or...

Page 69: ...select Yes if you require authentication If you do not require authentication select No h Proxy User Name If you are using a proxy for upload enter the proxy user name i Optional Proxy Password If yo...

Page 70: ...e Activity tab Click the job number to view the tasks After deployment the root and database users SYS SYSTEM and PDBADMIN are set to the system password The oracle and grid passwords are set to the d...

Page 71: ...d operating system on both nodes and configure the initial public network Installing Virtualized Platform Software and Deploying the Appliance Deploy the ODA_BASE domain for a virtualized platform and...

Page 72: ...ce 18 3 Virtualized OS ISO Image a From an external client machine log on to My Oracle Support b Locate the patch for the Oracle Database Appliance Virtualized OS ISO Image Refer to the Oracle Databas...

Page 73: ...You can reimage both nodes at the same time 8 Verify that the host name in the Console is oak1 for Node0 and oak2 for Node1 If the host name is something other than oak1 or oak2 then reboot the node Y...

Page 74: ...Address Subnet Gateway net1 static 192 0 2 18 255 255 252 0 192 0 2 1 Node 1 Host Name odax7 2ha brm06 a n1 Domain Name example com Network BootProto IP Address Subnet Gateway net1 static 192 0 2 18...

Page 75: ...e download Do not change the file name cat oda_base_18 3 gz01 oda_base_18 3 gz02 oda_base_18 3 gz03 oda_base_18 3 gz04 oda_base_18 3 tar gz Make a note of the file name and location You need to specif...

Page 76: ...ng LSI HBA PCI Cards on node 0 INFO Validating LSI HBA PCI Cards on node 1 INFO Validating LSI HBA PCI Cards on node 1 INFO Deployment in local mode INFO Deployment in local mode templateBuild 2017 02...

Page 77: ...n information Using config file OVS Repositories odabaseRepo VirtualMachines oakDom1 vm cfg Started domain oakDom1 id 1 INFO Storing the odabase configuration information The ODA_BASE setup is complet...

Page 78: ...any errors or warnings in the output If the cabling validation fails connect the cables correctly and rerun the command until the command runs without any errors or warnings Do not deploy Oracle Data...

Page 79: ...wing command root test0 oakcli show version detail 10 If all the component versions are not either up to date or at a higher version then unpack the patch bundle on both nodes root test0 tmp oakcli un...

Page 80: ...pleted confirm that all appropriate components are updated oakcli show version detail 13 Deploy the Oracle Grid Infrastructure and Oracle Database software on the appliance a Confirm you are in ODA_BA...

Page 81: ...erform network validation b Click Save Validation Output to save the validation output c Click Next 18 On the Summary page review your configuration options and deploy your configuration a Optional Cl...

Page 82: ...Oracle Database Appliance The standalone Oracle Appliance Manager Configurator is a Java based tool that enables you to generate your virtualized platform deployment plan and validate your network set...

Page 83: ...option if you want to configure additional or alternate network interfaces or if you want to override the default values To see the default values for your version of Oracle Database Appliance softwar...

Page 84: ...and time zone In the New Root Password and New Root Password confirm fields enter a new password for the root user Click Next The password is encrypted in the configuration file It is temporarily decr...

Page 85: ...2 20 Node 1 virtual IP VIP address 192 0 2 21 SCAN addresses two addresses resolving to the SCAN VIP name 192 0 2 22 192 0 2 23 6 Optional On the Database Information page determine if you want to cr...

Page 86: ...RAC Data File Size GB If you indicate that you want to build a container database then provide a database data file size in the final field on this page This field does not accept input unless the Is...

Page 87: ...rk administrator later Select Skip Network Validations to by pass the validation step If the network validation fails and you want to continue with the configuration then select this option 8 On the S...

Page 88: ...pliance and you have completed the preliminary steps to configure your initial network and install the software or deploy ODA_BASE then you can click Install to deploy the configuration Chapter 5 Crea...

Page 89: ...iguring CPU Core Count Oracle Database Appliance is delivered with all 36 cores on each server enabled Follow this procedure to reduce the number of cores if required 1 To reduce the number of cores r...

Page 90: ...e system password After deployment the oracle and grid passwords are also set to the system password Change the passwords to comply with your enterprise user security protocols Refer to the Oracle Dat...

Page 91: ...4 Click About then click Sign Out 5 Log back into the Web Console with the new password Chapter 6 Changing Oracle Database Appliance Passwords 6 3...

Page 92: ...using the Web Console Patching Database Homes to the Latest Release Use the Web Console to upgrade database homes to the latest release Patching Oracle Database Appliance Bare Metal Systems Using the...

Page 93: ...nt patches for the entire system including the following BIOS Hardware drivers Hardware Management Pack HWM and firmware drivers for various components Oracle Appliance Manager Oracle Linux Oracle VM...

Page 94: ...the patches for this release your bare metal deployments of Oracle Database Appliance are migrated from the OAK stack to the DCS stack No additional configuration steps are required You migrate the O...

Page 95: ...Verified by Patching Pre Checks Check Component Verified System update pre checks Checks that the agent is online on all nodes Checks that there is sufficient space for the update Validates the minimu...

Page 96: ...Update Pre Checks Before Applying Patches After updating the repository with patches use the pre checks to reduce potential update problems and then apply patches Note Follow the procedure in this top...

Page 97: ...and password https Node0 host ip address 7093 mgmt index html 3 Click Patch Manager 4 In the Update Patch Repository page enter the absolute file path and patch name then click Update Repository to st...

Page 98: ...For high availability environment you can select the Rolling check box to perform rolling patching of storage components 7 Click Activity to monitor the progress and verify that the job completes suc...

Page 99: ...re metal system using CLI commands 1 Download the Oracle Database Appliance Server Patch for the ODACLI DCS stack patch 28864520 from My Oracle Support to a temporary location on an external client Re...

Page 100: ...ate is successful using the ODACLI command root oda1 opt opt oracle dcs bin odacli describe job i job_ID 6 Update the storage components Specify the rolling option to patch shared disks in a rolling f...

Page 101: ...Notes Patching Oracle Database Appliance Virtualized Platform Follow these steps to apply patches to Oracle Database Appliance OAKCLI Virtualized Platform using CLI commands 1 Download the Oracle Dat...

Page 102: ...er update root oda1 opt opt oracle oak bin oakcli update patch version server For example for 18 3 root oda1 opt opt oracle oak bin oakcli update patch 18 3 0 0 0 server 5 Update the storage component...

Page 103: ...nt runs the latest diagnostic data collection version If you are deploying Oracle Database Appliance for the first time then TFA is installed with the new release in the location opt oracle tfa tfa_ho...

Page 104: ...d to add a repository odacli update agentconfig parameters n OSPatchRepos v http public yum oracle com repo OracleLinux OL6 latest basearch a Provide the public location within quotation marks For add...

Page 105: ...Appliance to perform a bare metal restore of Oracle Database Appliance Performing Secure Erase of Data on Storage Disks With this release you can securely erase data from storage devices Running the...

Page 106: ...Deployment perl cleanup pl griduser grid_user dbuser db_user groups comma separated list of groups erasedata f When the grid_user and db_user are the same roleSeparation false you must run the script...

Page 107: ...on Node 0 to remove ODA_BASE and the initial network configuration opt oracle oak tools cleanOdabase py Restoring an Oracle Database Appliance Baremetal System Re image Oracle Database Appliance to pe...

Page 108: ...Power Control in the Host Management menu b Select Power Cycle then click Save When the node comes back after the power cycle re imaging starts automatically The Oracle Linux page appears followed by...

Page 109: ...rase tool removes data from storage disks permanently If you have any data on the disk then take a backup of your storage disk before running the secure erase tool Follow the steps to run the secure e...

Page 110: ...ealth Check Tool performs proactive heath checks for the Oracle software stack and scans for known problems If you have re imaged your appliance then manually run the RPMs for re installing Oracle ORA...

Page 111: ...database to your Oracle Database Appliance About Managing Multiple Database Instances Using Instance Caging Use instance caging to manage your system resources on Oracle Database Appliance Oracle EM...

Page 112: ...and SYSTEM users is the Master Password that you set in the Web Console To change the Group Name and GID from the default values on the Oracle Database Appliance X7 2 HA Virtualized Platform use the a...

Page 113: ...mmand line interface Cloning a Database from Backup Use the Web Console to clone a database from a backup Cloning a Database Create a database from an existing Oracle ACFS database Upgrading a Databas...

Page 114: ...database Oracle Database Home ORACLE_HOME for the database or select an existing ORACLE_HOME that you created earlier Oracle Database 18 3 is supported on both Oracle Automatic Storage Management Orac...

Page 115: ...s The name pdb1 appears in the field in italic text as an example but it is not populated You must enter a name g In the PDB Admin User field enter a name The field shows pdbadmin as an example you mu...

Page 116: ...t is America 6 Click Create When prompted click Yes to confirm that you want to start the job to create the database The job is submitted and a confirmation page appears with a link to the job Click t...

Page 117: ...ase home when creating the database To create an instance only database named PRODDB with database version 18 3 0 0 0 that uses an existing database home with ID b727bf80 c99e 4846 ac1f 28a81a725df6 o...

Page 118: ...ckup Encryption Passwords field and the Confirm Backup Encryption Passwords field If your backup destination is Network File System NFS a Select Backup Destination as External FRA b Specify the Extern...

Page 119: ...rce database Following are the prerequisites to clone a database Ensure that Oracle Clusterware is running on all nodes and the source database is up and running The source database must use Oracle AC...

Page 120: ...anager Web Console to delete an Oracle database 1 Log into the Web Console https host name or ip address 7093 mgmt index html 2 Click the Database tab 3 Click Actions next to the database that you wan...

Page 121: ...an use the Web Console or the command line interface to create and manage databases Use ODACLI commands to create list describe and delete databases on Oracle Database Appliance The odacli create data...

Page 122: ...atabase home 1 Log in to the Web Console https ip address 7093 mgmt index html 2 Click the Database tab then click Database Home 3 Click Create Database Home 4 Select a database version from the list...

Page 123: ...ed on an Oracle Database Appliance environment If you do not have network connectivity between the source and the target environments you can use the offline migration method Offline migration uses RM...

Page 124: ...then migrate it Configuring a Static Listener Configure a static listener before you duplicate a database The static listener is only required when using RMAN Duplicate command Perform the following s...

Page 125: ...m dual exit EOF The following example uses the Welcome_12 password for myhost on port 1521 for PRODDB example com sqlplus sys Welcome_12 myhost 1521 PRODDB example com as sysdba EOF select 1 from dual...

Page 126: ...elcome__12 source database hostname PORT Continued Service Name auxiliary sys Welcome_12 Hostname of the target database 1521 service name RUN SET NEWNAME FOR DATABASE TO NEW duplicate target database...

Page 127: ...es applied to the source database that are not part of the installed Oracle Database Bundle patch BP 3 Register the database with Oracle Database Appliance odacli register database c OLTP s odb1 sn pr...

Page 128: ...se instance workload They are designed to run on a specific number of cores Instance caging ensures that each database workload is restricted to the set of cores allocated by the template enabling mul...

Page 129: ...o manage your database The EM Express console is available for Oracle Database 18c 12 2 0 1 and 12 1 0 2 The DB Console is available for Oracle Database 11 2 0 4 Both consoles are web based tools for...

Page 130: ...ty About Managing Storage You can add storage at any time without shutting down your databases or applications Oracle Database Appliance uses raw storage to protect data in the following ways Flash or...

Page 131: ...performance impact of the automatic storage balancing The addition of the storage expansion shelf includes checks across both nodes It is important to confirm that SSH does work across the nodes and a...

Page 132: ...is case the usable disk capacity is 1 2 TB See the procedure Adding the Storage Expansion Shelf for steps to add the expansion shelf About Storage Disk Replacement You can completely replace your 1 6...

Page 133: ...Run the odaadmcli orachk command on each node If there is a problem connecting to either node then check the etc bashrc file and remove or remark out any values in the profile for root oracle grid us...

Page 134: ...se Appliance is on the latest update version 1 Insert disks one at a time in slots 10 through 19 Note Allow at least one minute between inserting each disk to avoid flooding of disk events into oakd A...

Page 135: ...sk dev mapper SSD_E0_S11_1399764284p1 name SSD_E0_S11_1399764284p1 dev mapper SSD_E0_S12_1399765076p1 name SSD_E0_S12_1399765076p1 dev mapper SSD_E0_S13_1399765116p1 name SSD_E0_S13_1399765116p1 dev m...

Page 136: ...to confirm that SSH does work across the nodes and all users can connect as expected using their shared password Note Oracle recommends that you add a storage expansion shelf when you have relatively...

Page 137: ...l confirm if the two server nodes are properly cabled to the base storage shelf and all disks are online with a good status and added to the existing diskgroups on both nodes If there any failures the...

Page 138: ...rrectly Oracle Database Appliance E0 SUCCESS JBOD1 Nickname set correctly Oracle Database Appliance E1 Fix any errors before proceeding 6 Run the odaadmcli show disk command to ensure that all disks i...

Page 139: ...n the command odaadmcli add jbod asm on the master node first and then on the slave node Wait for the command to finish It takes about 2 to 3 minutes Then verify that the expansion storage shelf disk...

Page 140: ...e odaadmcli show validation storage failures 16 Run the odaadmcli show version command to verify that all firmware components in the storage expansion are current odaadmcli show version detail 17 If n...

Page 141: ...a Backup Policy Attach a backup policy to a database to define the database backup attributes and destination Updating a Database Backup Policy Use the Web Console to update the recovery window or ch...

Page 142: ...Saturday You can edit or disable the schedule The dcs agent generates and saves a backup report for each backup The backup report contains the metadata required to recover or restore a database Note Y...

Page 143: ...vel 0 backup on Level 0 Backup Day by default on Sunday and level 1 on the remaining days of the week You can display a list of scheduled backups edit your backup schedule or disable a scheduled backu...

Page 144: ...manual backups You can specify manual backup options in the Web Console or using ODACLI commands 5 Manage obsolete backups 6 Restore from backup When you save your backups to NFS you can restore the...

Page 145: ...by the operating system instead it uses APIs to access the storage at the application level The following is a high level overview of the workflow for backup and recovery when using Oracle Object Sto...

Page 146: ...7 sqlPatches 25811364 26609817 backupLogLoc https swiftobjectstorage us phoenix 1 oraclecloud com v1 dbaasimage backupbucket scaoda702c1n1 rmanlog HRDbOu 2717054291 2017 11 08 rman_backup_2017 11 08_1...

Page 147: ...the end point is specified as an SCN the database applies the redo logs and stops after each redo thread or the specified SCN whichever occurs first When the end point is specified as a time the data...

Page 148: ...follows Disk 1 14 days Object Storage 1 31 days Creating a Mount Point for NFS Backup Location Create a mount point for the Network File System NFS location to set up the NFS backup and recovery optio...

Page 149: ...the Object Store IP address is accessible through proxy setup only from the Oracle Database Appliance server then define the proxy setting for the agent so that the agent can access the Object Store T...

Page 150: ...line interface to create a backup policy to use the ObjectStore location for backup Related Topics odacli update agentconfig parameters Use the odacli update agentconfig parameters command to modify c...

Page 151: ...hows the Create Backup Policy page 5 Click Create Click Yes to confirm that you want to create the backup policy A link to the job appears When the job completes successfully the backup configuration...

Page 152: ...he crosscheck select or deselect Enable Crosscheck 6 Click Update Click Yes to confirm that you want to update the backup policy A link to the job appears When the job completes successfully the backu...

Page 153: ...n the Recover Database page select any of the following recovery options Recover Full Database to the specified Backup Select the existing backup from which you want to recover the database Recover Fu...

Page 154: ...ort json odacli delete backup i 20576eb1 bc32 4e34 bf97 fda0b60ca15b br backupreport json Deleting a Backup Policy Use the Web Console to delete a database backup policy 1 Click the Database tab in th...

Page 155: ...Internal FRA option in the Web Console requires a lot of disk space up to two to three times the size of the database Follow these steps to create a backup policy through the command line interface 1...

Page 156: ...iguration defines the backup including the location where you want to store the backups and the recovery window The following example creates a backup configuration named mkg1dailydiskwith a backup to...

Page 157: ...ce skip to Step 2 odacli create objectstoreswift e swift end point URL n Object Store Swift name p swiftpassword t Object Store tenant name u Object Store user name For example odacli create objectsto...

Page 158: ...backup configuration file to a database the dcs agent automatically schedules daily backups for the database The day and time are based on the Oracle Database Appliance time zone The AutoSchedule tri...

Page 159: ...in time recovery PITR a system change number SCN or from the latest backup time Recovering a database in Oracle Database Appliance is a full RMAN database recovery Recovering from a backup report req...

Page 160: ...1542M dbRedoSize 16403M 3 To recover from a backup report based on PITR identify the database ID and the backup report for recovery In the following example the JSON input file for the backup report i...

Page 161: ...tial ID and the SYS user password Follow these steps to restore a database using the command line CLI 1 Display a list of backup reports and locate the latest Backup Report in Oracle Object Storage fo...

Page 162: ...te the Swift Object Store credential ID for the database backup odacli list objectstoreswifts 5 Save the backup report as a JSON file in a folder in the bin directory on the appliance For example back...

Page 163: ...same network port or bond How to Create and Manage Shared Repositories These topics describe how to use OAKCLI to create and manage shared repositories on Oracle Database Appliance Virtualized Platfo...

Page 164: ...o supported on Oracle Database Appliance Virtualized Platform Supported operating systems include Linux Windows and Solaris x86 Note All new systems are currently shipped from the factory with the non...

Page 165: ...ase Appliance hardware About Virtual Machines and Oracle Database Appliance Virtualized Platforms Oracle Database Appliance Virtualized Platform is designed to run and deploy virtual machines to manag...

Page 166: ...Database Appliance Virtualized Platforms Oracle Database Appliance Virtualized Platform is designed to run and deploy virtual machines to manage system resources Configure virtual machines on Oracle...

Page 167: ...resources that are essential to creating and managing virtual machines These resources include virtual machine templates and assemblies ISO files virtual DVD images virtual machine configuration file...

Page 168: ...s to create and manage shared repositories virtual disks and their virtual machines and the underlying architecture shown in the illustration Note Virtual machine VM repositories on Oracle Database Ap...

Page 169: ...at supports tagged VLANs uses VLAN IDs to identify the packet including to which network the packet belongs Configuration Overview of Oracle Database Appliance Virtual Machine Local Area Networks To s...

Page 170: ...ualized Platform with Virtual Local Area Networks shows a typical Oracle Database Appliance configuration using VLANs The illustration shows the same configuration as in Basic Virtual Machine Local Ar...

Page 171: ...how repo command to display information about virtual machine repositories on Oracle Database Appliance Virtualized Platforms Starting a Shared Repository Use the oakcli start repo command to start a...

Page 172: ...amed repo1 in the ASM DATA disk group data with 30 gigabytes of available storage oakcli create repo repo1 dg data size 30 Showing the Status of Shared Repositories Use the oakcli show repo command to...

Page 173: ...by using the option node nodename where nodename is the name of the node on which the repository is located Example 12 3 Example of Starting a Shared Repository This command starts the shared reposito...

Page 174: ...size of the increase that you want to configure where size is the size in gigabytes that you want to add to the configured size Example 12 6 Example of Increasing the Size of a Shared Repository The...

Page 175: ...ecify the vdisk size in gigabytes where sizeG is the size in gigabytes that you want to add to the configured size If you want to configure the vdisk as a shared disk then use the option type shared t...

Page 176: ...me where name is the name of the vdisk you create Identify the repository in which you create the vdisk by using the repo reponame option where reponame is the name of the repository where the origina...

Page 177: ...ndicates the shared repository on which the virtual disk is located where reponame is the name of the shared repository Example 12 12 Example of Deleting a Virtual Disk from a Shared Repository This e...

Page 178: ...After you create the repository the repository becomes available to both nodes regardless of which node performs the import Templates imported into local nodes use the repository name supplied in the...

Page 179: ...file OVS Repositories odarepo1 Te mplates otml_sample1_odarepo1 Syste m img xvda w file OVS Repositorie s odarepo1 Templates otml_sample1_o darepo1 u01 img xvdb w Domain XEN_PVM Keyboard en us MaxMem...

Page 180: ...tory assembly file located at the URL http example com assemblies OEL6 OVM_OL6U1_x86_PVHVM ova to a new template named OL6U1 in a new repository named odarepo1 oakcli import vmtemplate OL6U1 assembly...

Page 181: ...ap 40 memory 1536M maxmemory 2G os OTHER_LINUX vcpu 2 sets the number of CPUs to be assigned when the virtual machine starts up to 2 maxvcpu 4 sets the maximum number of CPUs that can be assigned to t...

Page 182: ...plate If you will be deploying only one virtual machine or many virtual machines but with different characteristics then set required values in the virtual machines with the oakcli configure vm comman...

Page 183: ...other cloning approaches You can create virtual machines that are a complete clone of the template or assembly or you can create virtual machines that are snap clones Snap clones contain only the meta...

Page 184: ...o clone where name is the name of the template Use the snap option to designate that you want to create a snap clone Example 12 17 Example of Creating a Snap Clone From a Virtual Machine Template This...

Page 185: ...lly Configuring a Virtual Machine You can initially configure your virtual machines externally without connecting to the virtual machine console by using Oracle VM Guest Additions by passing key value...

Page 186: ...elete the virtual machine to regain storage Note Do not modify the default settings for the following parameters in the guest virtual machine xen_blkfront max Max Indirect Descriptors default 32 xen_b...

Page 187: ...vm1_odarepo1 Resource vm1_odarepo1 AutoStart restore CPUPriority 100 Disks file OVS Repositories odarepo1 Vi rtualMachines vm1_odarepo1 System i mg xvda w file OVS Repositories o darepo1 VirtualMachi...

Page 188: ...the virtual machine to run by default and a failover clause to indicate if you want the virtual machine to use the other node when the preferred node is not available either at startup or while alread...

Page 189: ...resources in the virtual machine named myol15u oakcli configure vm myol5u vcpu 2 cpuprio 150 cpucap 20 memory 1G cpupool linpool keyboard en us mouse USB_MOUSE Related Topics oakcli configure vm Use t...

Page 190: ...re information Related Topics http www oracle com technetwork database database appliance overview oda automatedvmprovisioning 2348232 pdf Opening a Virtual Machine Console for a Virtual Machine Use t...

Page 191: ...modify vm vmol6u3 addnetwork priv1 oakcli start vm vmol6u3 oakcli modify vm vmol6u3 s com oracle linux network device 0 eth0 oakcli modify vm vmol6u3 s com oracle linux network onboot 0 yes oakcli mo...

Page 192: ...s to the process of moving a running virtual machine between physical machines without disconnecting the client or application running in the virtual machine Memory storage and network connectivity of...

Page 193: ...user domain that has special privileges and responsibilities for a particular piece of hardware When you use the driver domain option the newly created virtual disks are mounted directly from ODA_BAS...

Page 194: ...import a template that you will use to create the clone Determine the virtual machine template you want the method to import the template and the naming convention for the template This example import...

Page 195: ...ASE 1 Use the oakcli stop command to shut down the virtual machine For example stop the virtual machine named vm dom0_ol5u7 Shutting down the virtual machine ensures that there is consistent data from...

Page 196: ...he boot driver You can create a guest virtual machine by cloning an existing guest or use one of the templates such as OL6U7_x86_64_PVHVM or OVM_OL5U7_X86_64_PVM_10GB tgz that are available in the OVS...

Page 197: ...te that you want to create a snapshot of the source virtual machine and the driverdomain option to indicate that the new virtual machine will use the driver domain oakcli clone vm OL6U7 vm OL6U7_x86_6...

Page 198: ...following example shows the newboot virtual disk disk u file OVS Repositories odarepo1 ACFS snaps OL6U7 VirtualMachines OL6U7 15f96d92a66c4b808035116ab6348d0d img xvda w u file u01 app sharedrepo oda...

Page 199: ...e newboot boot disk mkdir newbootmount dev xvdc1 newboot b Get the single blockID blkid dev xvdc1 dev xvdc1 UUID 3d7a177b 0fa0 4212 9c0c c5554bb1817a TYPE ext4 8 Copy the original boot content to the...

Page 200: ...cking if grub e2fs_stage1_5 exists yes Running embed grub e2fs_stage1_5 hd0 27 sectors are embedded succeeded Running install grub stage1 hd0 hd0 1 27 p hd0 0 grub stage2 grub grub conf succeeded Done...

Page 201: ...the following u file OVS Repositories rcrepo ACFS snaps OL6U7 VirtualMachines OL6U7 15f96d92a66c4b808035116ab6348d0d img xvda w original boot root disk u file u01 app sharedrepo rcrepo ACFS snaps oak...

Page 202: ...OL6U7 VirtualMachines OL6U7 newboot img xvdc w maxvcpus 2 maxmem 8192 The following is an example of the vm cfg after the edit where the new boot device xvdc is the first device and xvda is the driver...

Page 203: ...correct information about the disk You can create a temporary duplicate snapshot of the virtual machine to fix the output oakcli stop vm vm_name oakcli clone vm tmp_vm_name vm vm_name snap driverdomai...

Page 204: ...VirtualMachines OL6U7 newboot img xvda w file u01 app sharedrepo rcrepo ACFS snaps OL6U7 VirtualMachines OL6U7 15f96d92a66c 4b808035116ab6348d0d img xvdb w oak Dom1 Domain XEN_PVM DriverDomain True Ex...

Page 205: ...atically restarts after a hardware or software failure or whenever your database host computer restarts Use the oakcli configure vm command to start a virtual machine on a preferred node by using the...

Page 206: ...r this pool are removed from the default unpinned pool ODA_BASE is the only domain allowed to use the CPUs in the odaBaseCpuPool When you start other virtual machines the virtual machines run on CPUs...

Page 207: ...bed This is because two of the CPUs are supporting both virtual machines When oversubscribing a CPU pool assess the performance of the virtual machines in that pool Reassign one or more virtual machin...

Page 208: ...resources assigned to the CPU are six oakcli configure cpupool linpool numcpu 6 node 1 Assigning a Virtual Machine to a CPU Pool on Oracle Database Appliance Virtualized Platform Use the command oakc...

Page 209: ...Database Appliance Virtualized Platform This oakcli configure vm example pins the virtual machine named wintest to the CPU pool named winpool oakcli configure vm wintest cpupool winpool Chapter 12 How...

Page 210: ...iance Commands Use the odacli appliance commands to perform lifecycle activities for the appliance odacli Backup and Recovery Commands Use the odacli backup and recover commands to backup to and resto...

Page 211: ...form lifecycle management tasks and the odaadmcli commands to perform storage and hardware monitoring maintenance Many tasks related to managing Oracle Databases are also required with databases on Or...

Page 212: ...are case sensitive An odacli or odaadmclicommand uses the following command syntax odacli command options command is an action you want to perform on the appliance For example odacli list networks or...

Page 213: ...ault ACFS dbterritory dt Database Territory default AMERICA Default AMERICA dbtype y Database Type SI Default SI help h get help instanceonly io Create Instance Only For Standby json j json output nls...

Page 214: ...User Access Using SUDO In environments where system administration is handled by a different group than database administration or where security is a significant concern you may want to limit access...

Page 215: ...ou can also create different rules on each host Note Before database creation you must set up user equivalency with SSH for the root user on each server If you do not set up user equivalency and confi...

Page 216: ...Edition EE DNS Servers 10 200 76 198 10 200 76 199 192 0 2 254 NTP Servers 10 200 0 1 10 200 0 2 Disk Group Information DG Name Redundancy Percentage Data Normal 90 Reco Normal 10 In this example the...

Page 217: ...as a Bonded Network Configure the first network to use a btbond1 interface without configuring DHCP Complete the IP address netmask address and gateway address Values that you need to provide are show...

Page 218: ...K Bringing up interface p1p2 Determining if ip address 192 168 17 24 is already in use for device p1p2 OK INFO Restarting the network Select the Interface to configure the network on em2 em3 em2 Confi...

Page 219: ...ted patch versions for each component odacli create prepatchreport Use the odacli create prepatchreport command to run pre checks for patching odacli describe prepatchreport Use the odacli describe pr...

Page 220: ...output will display the version details for each of the installed homes You can use this command to check the component version after applying a patch File Path ORACLE_HOME opt oracle dcs bin odacli...

Page 221: ...1 12 1 0 2 170814 up to date OraDB11204_home1 11 2 0 4 170814 up to date ILOM 4 0 0 22 r120818 up to date BIOS 41017100 up to date OS 6 8 up to date Example 13 7 List DB Home Details odacli describe c...

Page 222: ...d json j Optional Displays JSON output The default is false Example 13 9 Listing the Latest Supported Versions odacli describe latestpatch componentType availableVersion gi 12 1 0 2 170117 db 11 2 0 4...

Page 223: ...tes Use the odacli create prepatchreport command to generate a pre check report Use the node or local option to run the patch pre checks on specific nodes or the local node Example 13 10 Creating Pre...

Page 224: ...e Check report for patching GI ILOM OS Status COMPLETED Result One or more pre checks failed for GI Node Name node n1 Pre Check Status Comments __OS__ Validate patching tag Success Validated patching...

Page 225: ...error encountered specified location Patch verification Failed Internal error encountered Unable to get patch number on node n1 Opatch updation Success Successfully updated the opatch in GiHome u01 a...

Page 226: ...s Successfully validated location Patch verification Success Patch 26710464 not applied on DB home Is patch rollback required Success No DB patch is required to rollback Opatch updation Success Succes...

Page 227: ...ate agentconfig parameters command to modify configuration variables used by the appliance The supported configuration parameters are HttpsProxyHost HttpsProxyPort and OSPatchRepos Multiple values can...

Page 228: ...n Specifies the name of the parameter Usage Notes Use the odacli list agentconfig parameters command to list configuration variables used by the appliance Example 13 14 Example Command odacli list age...

Page 229: ...odacli list availablepatches command to display all available patches for Oracle Database Appliance File Path ORACLE_HOME opt oracle dcs bin odacli Syntax odacli list availablepatches h j Parameters...

Page 230: ...t is false Usage Notes Use the odacli list prepatchreports command to display all pre check reports Example 13 16 Displaying All Patch Pre Checks Reports odacli list prepatchreports ID Description Cre...

Page 231: ...2 8813 782367f1e6fd odacli update dbhome Use the odacli update dbhome command to update a specific RDBMS Home to the latest patch bundle version File Path opt oracle dcs bin odacli Syntax odacli updat...

Page 232: ...nt command to update the agent File Path ORACLE_HOME opt oracle dcs bin odacli Syntax odacli update dcsagent v version j h Parameters Parameter Description version v Defines the Oracle Database Applia...

Page 233: ...iles Note The file names in the examples might not reflect actual file names 1 Optional Create a temporary directory in the u01 directory You will upload your Oracle Database Appliance software to thi...

Page 234: ...RACLE_HOME opt oracle dcs bin odacli Syntax To unpack and copy the patch bundle to the correct locations in the file system odacli update repository f filename j h Parameters Parameter Description fil...

Page 235: ...firmware Oracle Appliance Kit Oracle Clusterware and all other infrastructure components File Path opt oracle dcs bin odacli Syntax odacli update server v version j h Parameters Parameter Description...

Page 236: ...t till node restart reports createTimestamp July 26 2018 14 13 45 PM CST resourceList description Server Patching updatedTime July 26 2018 14 13 45 PM CST odacli update storage Use the odacli update s...

Page 237: ...ut components installed on the system odacli list featuretracking Use the odacli list featuretracking command to display the latest feature tracking report odacli create appliance Use the odacli creat...

Page 238: ...he agent CLI build details help h Optional Displays help for using the command json j Optional Displays JSON output no details no d Optional Displays no detailed information Use this flag if you do no...

Page 239: ...splays JSON output help h Optional Displays help for using the command bom b Optional Displays the bill of materials for the installed components on the appliance details d Optional Display on the com...

Page 240: ...ystem 10 0 4 0 1 el6 noarch bash 4 1 2 48 el6 x86_64 bc 1 06 95 1 el6 x86_64 bind libs 9 8 2 0 62 rc1 el6_9 5 x86_64 bind utils 9 8 2 0 62 rc1 el6_9 5 x86_64 binutils 2 20 51 0 2 5 47 el6_9 1 x86_64 b...

Page 241: ...4 7 18 el6 x86_64 cpupowerutils 1 3 2 el6 x86_64 cpuspeed 1 5 22 0 1 el6 x86_64 cracklib 2 8 16 4 el6 x86_64 cracklib dicts 2 8 16 4 el6 x86_64 crash 7 1 4 1 0 1 el6_7 x86_64 crda 3 13_2015 10 22 3 el...

Page 242: ...lays JSON output help h Optional Displays help for using the command Example 13 25 Example Command to View the Features Report from the Command Line odacli list featuretracking DCS Feature Tracking Re...

Page 243: ...mum number of Single Instance Databases 0 Database Maximum number of PDBs 0 Database Maximum number of Datafiles 7 Database Maximum number of Database Homes 1 Database Maximum number of Flashback Data...

Page 244: ...Maximum ASM Disk Groups compatibility 18 0 0 0 0 Storage Minimum ASM Disk Groups compatibility 18 0 0 0 0 Storage Maximum number of non ACFS file systems 4 Storage Maximum size of non ACFS file syste...

Page 245: ...ther system from ObjectStore based on a LongTerm BackupReport odacli list backupreports Use the command odacli list backupreports to display a list of all backup reports odacli list backupconfigs Use...

Page 246: ...the name of the backup A tag is alphanumeric up to 30 characters Required for Longterm Backup Type Usage Notes Use the command odacli create backup for a specified Database Resource ID and provide a t...

Page 247: ...da0b60ca15b odacli create backup i20576eb1 bc32 4e34 bf97 fda0b60ca15b bt Regular L0 t 2017Dec22ProductionLevel0 odacli create backupconfig Use the command odacli create backupconfig to create a backu...

Page 248: ...config d Disk n production w 14 Example 13 29 Create a Backup Configuration for NFS Location Create a backup configuration named production that backs up to NFS with a 2 day recovery window odacli cre...

Page 249: ...e not validated against endpoint URL and tenancy odacli delete backup Use the command odacli delete backup to delete backups File Path ORACLE_HOME opt oracle dcs bin odacli Syntax odacli delete backup...

Page 250: ...a15b br backupreport json odacli delete backupconfig Use the command odacli delete backupconfig to delete a backup configuration File Path ORACLE_HOME opt oracle dcs bin odacli Syntax odacli delete ba...

Page 251: ...fines the Object Store Swift identifier ID Usage Notes You cannot delete the Object Store credentials if they are attached to a backup configuration Example 13 33 Deleting the Oracle Object Store Cred...

Page 252: ...n 12 2 0 1 170814 26723265 26609817 sqlPatches 25811364 26609817 backupLogLoc https swiftobjectstorage example com v1 dbaasimage backupbucket scaoda702c1n1 rmanlog ExampleDBu 2717054291 2018 01 08 rma...

Page 253: ...3 35 Display Schedule Details odacli describe schedule i scheduleid odacli irestore database Use the command odacli irestore database to restore a database from one system to other system from ObjectS...

Page 254: ...he NFS or local directory path where backups are available dbRedundancy rd Specifies the database redundancy value that is HIGH MIRROR To specify the dbRedundancy option at least one disk group of FLE...

Page 255: ...mmand odacli irestore database with the backup report Enter the SYS user password when prompted odacli irestore database r backupreport json oid Object Store ID m odacli list backupreports Use the com...

Page 256: ...ying a List of Backup Configuration Display a list of backup configurations odacli list backupconfig d Disk n production w 14 odacli list objectstoreswifts Use the command odacli list objectstoreswift...

Page 257: ...output The default is false Usage Notes The command lists all of the schedules in the system including database backup schedules and some internal maintenance schedules Example 13 41 Display a List of...

Page 258: ...or System Change Number SCN as input You can also recover a database from a Backup Report provided as JSON input file This command performs various environment and validation checks in order to attem...

Page 259: ...N output The default is false name n Defines the backup configuration name no crosscheck no cr Optional Disable crosscheck objectstoreswiftId o Optional Defines the swift object store credential ID re...

Page 260: ...utput The default is false bkuppassword bp Optional Defines the RMAN backup encryption password databaseid id Optional Defines the database identifier stored in database file headers levelzerobackupda...

Page 261: ...g example the Database Resource Name is mydb and the backup configuration name is mybcfg odacli update database in mydb bin mybcfg bp odacli update objectstoreswift Use the command odacli update objec...

Page 262: ...e odacli update objectstoreswift i Object Store Swift id u Object Store user name odacli update schedule Use the command odacli update schedule to update the schedule for a database or to disable the...

Page 263: ...cores and display current and historical CPU core configurations odacli list cpucores Use the odacli list cpucores command lists the history of core configuration changes in the system odacli describe...

Page 264: ...h opt oracle dcs bin odacli Syntax odacli describe cpucore h Parameters Parameter Description help h Optional Displays help for using the command Example 13 54 Displaying the Current Core Configuratio...

Page 265: ...escription CPU cores service update updatedTime 1469410799194 odacli Database Commands Use the odacli database commands to perform database lifecycle operations odacli list databases Use the odacli li...

Page 266: ...yntax To display a list of all databases odacli list databases h Parameters Parameter Description help h Optional Displays help for using the command Example 13 56 Displaying a List of Databases Displ...

Page 267: ...tabase i ac48e0d2 a7b0 4ffd a27e f8e42b028c5f Database details ID ac48e0d2 a7b0 4ffd a27e f8e42b028c5f Description rdb1 DB Name rdb1 DB Version 12 1 0 2 DBID 1339792271 CDB true PDB Name r1pdb1 PDB Ad...

Page 268: ...l Defines a unique name for the database dbclass cl OLTP DSS IMDB Defines the database class The default is OLTP The options are as follows Enterprise Edition OLTP DSS or IMDB Standard Edition OLTP db...

Page 269: ...redundancy value that is HIGH MIRROR To specify the dbRedundancy option at least one disk group of FLEX redundancy must exist and dbStorage must be ASM and the dbVersion or dbHomeVersion must later th...

Page 270: ...ctory Use the following option to specify the adminpassword Interactive mode Use the m option and enter the password when prompted For the version you can specify the database version either 18 3 0 0...

Page 271: ...YS SYSTEM and PDB Admin jobId f12485f2 dcbe 4ddf aee1 de24d37037b6 status Created message null reports createTimestamp July 26 2018 03 54 03 AM EDT description Database service creation with db name h...

Page 272: ...For example odb1 and odb2 The default is odb1 dbtype y SI Defines the database type The default database type is SI help h Optional Displays help for using the command json j Optional Displays JSON o...

Page 273: ...meid n Defines the database ID of the destination database home help h Optional Displays help for using the command json j Optional Displays JSON output Example 13 61 Modifying a Database odacli modif...

Page 274: ...tabase The database type is Single Instance The default is SI help h Optional Displays help for using the command hostname o Defines the host name Default local host name json j Optional Displays JSON...

Page 275: ...c parameters The database being registered must use Oracle Managed Files and the file location must match the DATA Location REDO Location and RECO Location of the odacli describe dbstorage command As...

Page 276: ...gust 8 2016 5 57 36 AM EDT Success August 8 2016 5 57 49 AM EDT Success odacli upgrade database Use the odacli upgrade database command to upgrade a database from a supported release File Path ORACLE_...

Page 277: ...mand odacli upgrade databases to upgrade the 11 2 0 4 database After the upgrade is complete you can run the command odacli list databases again to verify the upgrade odacli list databases ID DB Name...

Page 278: ...ommand json j Optional Displays JSON output Usage Note The delete database command deletes the database the file system and the underlying advm volumes assigned to the database For example deleting a...

Page 279: ...ectories odacli describe dbhome Use the odacli describe dbhome command to display Oracle Database Home details odacli create dbhome Use the odacli create dbhome command to create an Oracle Database Ho...

Page 280: ...ribe dbhome command to display Oracle Database Home details File Path ORACLE_HOME opt oracle dcs bin odacli Syntax To display details about Oracle Database Home odacli describe dbhome i dbhomeid h j v...

Page 281: ...acli Syntax To create an Oracle Database Home odacli create dbhome v version j h Parameters Parameter Description v version number Defines the database bundle patch number json j Optional Displays JSO...

Page 282: ...i create dbhome v 12 1 0 2 170718 odacli delete dbhome Use the odacli delete dbhome command to delete database home that is not associated with a database File Path ORACLE_HOME opt oracle dcs bin odac...

Page 283: ...the odacli create dbstorage command to create the file system for database migrations odacli delete dbstorage Use the odacli delete dbstorage command to delete database storage that is not associated...

Page 284: ...orage command to display storage configuration details File Path ORACLE_HOME opt oracle dcs bin odacli Syntax odacli describe dbstorage i j h Parameters Parameter Description id i Identifies the datab...

Page 285: ...ly 22 2016 12 26 39 PM SGT Example 13 71 Displaying Database Oracle ASM Storage Details The following example displays Oracle Automatic Storage Management Oracle ASM storage details odacli describe db...

Page 286: ...pporting directory structure for storing non database files The default is ASM help h Optional Displays help for using the command Usage Notes The odacli create dbstorage command registers the storage...

Page 287: ...the database storage using a database identifier ID help h Optional Displays help for using the command Usage Notes You can only use the delete dbstorage when the storage is not associated with any da...

Page 288: ...resent in the system Example 13 74 Displaying Disk Group Storage odacli list dgstorages r redundancy Diskgroup storage details Diskgroup DATA Redundancy extern normal high flex Physical Free Space wGB...

Page 289: ...Unique Name rdbx Location u02 app test fast_recovery_area Used Space dGB acfsutil total acfsutil freespace Free Space dGB acfsutil freespace Database Unique Name rdby Location DATA rdby Used Space zGB...

Page 290: ...the values EXTERN NORMAL HIGH Use any of these options to specify the redundancy for FLEX disk groups In the example below Physical Total Space is the total space in the disk group V ASM_DISKGROUP to...

Page 291: ...date and time stamp odacli list scheduled executions odacli list jobs Use the odacli list jobs command to display a list of jobs including the job IDs status and the job created date and time stamp F...

Page 292: ...cribes a job created ahead of a specific date In the format YYYY MM DD or YYYY MM DD HH mm ss such as 2018 01 01 or 2018 01 01 01 00 00 Example odacli list jobs t 2018 08 07 tail tl Optional Describes...

Page 293: ...led Backup Report August 5 2018 2 01 07 AM UTC Success 64828852 bb16 4f06 aca9 4bdf9fe7b6f2 Create regular 5 Backup with TAG iD5UNjBZ8HN2FYL for Db igIyoz August 5 2018 2 14 19 AM UTC Success Example...

Page 294: ...ess 2f648f5a c9c5 42ec adb0 98cf6497c89e Discover System Components system August 8 2018 3 28 12 AM UTC Success a5755f43 509d 4d4c b7ef 9f99660c4de7 DB Home Patching Home Id is 97df26b3 42f2 4189 805b...

Page 295: ...d json j Optional Displays JSON output help h Optional Displays help for using the command Example 13 79 Displaying Details for a Job To display details of a specific job with jobid 02df22c8 c21f 4162...

Page 296: ...Continued Status Executed Time Executed February 4 2018 12 00 00 AM UTC Executed February 4 2018 12 00 00 AM UTC Executed February 5 2018 12 00 00 AM UTC To learn more about a scheduled backup run th...

Page 297: ...erface odacli list networkinterfaces Use the odacli list networkinterfaces command to display network interfaces odacli list networks Use the odacli list networks command to display networks File Path...

Page 298: ...help h Optional Displays help for using the command nodeNumber u Optional Displays the network interface information for the specified node By default the node number is always the first node Node0 E...

Page 299: ...splays JSON output networktype w Defines the type of network Options are Public Private Dataguard Backup Other no defaultnetwork no d Identifies a network as not the default network Use defaultnetwork...

Page 300: ...Defines the network gateway ipaddress p Optional Defines the network IP address json j Optional Displays JSON output networktype w Public Dataguard Backup Other Optional Defines the type of network su...

Page 301: ...Deleting a Network The following example deletes a backup network with a network ID of 55db39db d95c 42c5 abbd b88eb99b83ec odacli delete network i 55db39db d95c 42c5 abbd b88eb99b83ec jobId c26d217e...

Page 302: ...nterface File Path ORACLE_HOME opt oracle dcs bin odacli Syntax To display the details of a specific network interface odacli describe networkinterface i id j h u Parameters Parameter Description id i...

Page 303: ...ay network interfaces File Path ORACLE_HOME opt oracle dcs bin odacli Syntax odacli list networkinterfaces j h u Parameters Parameter Description json j Optional Displays JSON output help h Optional D...

Page 304: ...isplay the log file usage odacli create logcleanjob Use the odacli create logcleanjob command to create a job to purge log files for a specified time period odacli list logcleanjobs Use the odacli lis...

Page 305: ...r example when the dataMask option is used all instances of a sensitive name such as a database name called payrolldb are replaced with in the TFA collection For example when the dataSanitize option i...

Page 306: ...a list of components odacli list logspaceusage Timestamp July 25 2018 7 31 39 PM UTC Component Size MB Partition LogUsagePercentage PartitionFreePercentage dcs 477 00 dev mapper VolGroupSys LogVolOpt...

Page 307: ...than parameter Default is Day if it is not specified Example 13 91 Creating Jobs to Purge Logs To create jobs to purge logs odacli create logcleanjob Job details ID e03d90b5 41dd 45e0 8b7a 1480d6d7f86...

Page 308: ...tatus odacli list logcleanjobs h Parameters Parameter Description help h Optional Displays help for using the command Example 13 92 Listing Jobs to Purge Logs To list jobs to purge logs odacli list lo...

Page 309: ...display log cleanup jobs odacli describe logcleanjob i e03d90b5 41dd 45e0 8b7a 1480d6d7f86f JobId Files Deleted Size Freed Component Top Path TimeStamp e03d90b5 41dd 45e0 8b7a 1480d6d7f86f 0 0 bytes d...

Page 310: ...paceBelowPercentage f Starts purge when free disk space is below the specified number of percentage of the total partition size Valid range is 20 50 Default is 20 usageOverMB uMB Starts purge when log...

Page 311: ...nents separated by comma The values are gi database dcs For example gi dcs Example 13 95 Listing Jobs to Purge Logs To list jobs to purge logs odacli list auto logclean policy Component UsageOverPerce...

Page 312: ...actively When using this option do not enter the password in the command line asrtype e internal external Defines the Oracle ASR Configuration Type The default is internal help h Optional Displays hel...

Page 313: ...tion Configure ASR Status Created Created August 9 2016 6 12 19 AM WSST Message Task Name Start Time End Time Status Example 13 97 Configuring an External Oracle ASR This example configures Oracle Dat...

Page 314: ...al external Defines the Oracle ASR Configuration Type The default is internal help h Optional Displays help for using the command json j Optional Displays JSON output proxypassword ppwd Optional Defin...

Page 315: ...are prompted to enter the password during configuration The proxy server is updated to www proxy2 example com odacli update asr u scott tiger example com asrpassword proxyserver www proxy2 example com...

Page 316: ...ath ORACLE_HOME opt oracle dcs bin odacli Syntax odacli test asr h Parameters Parameter Description help h Optional Displays help for using the command Usage Notes This command internally invokes the...

Page 317: ...c4a 48da 8196 1364105db99d status Running message null reports createTimestamp 1469409622451 description Delete ASR updatedTime 1469409622458 odacli OS Commands Use the odacli OS commands to list and...

Page 318: ...values for HugePage and memlock from the etc sysctl conf and etc security limits conffiles Based on the total available space suggested values are calculated for the parameters Example 13 102 Displayi...

Page 319: ...Suggested Values odacli update osconfigurations jobId 954cf7a5 9cad 451c 8820 3140a716af26 status Created message Successfully submitted a request to configure OS parameters reports createTimestamp Fe...

Page 320: ...using the command odaadmcli Hardware Monitoring Commands Use the hardware monitoring commands to display hardware configurations odaadmcli show cooling Use the odaadmcli show cooling command to show...

Page 321: ...ormation about the environment and hardware File Path ORACLE_HOME opt oracle dcs bin odaadmcli Syntax To display environment and hardware details odaadmcli show env_hw h Parameters Parameter Descripti...

Page 322: ...Total DG Space Free DG Space ext3 30237M 7763M ext3 484M 416M ext3 60475M 38149M ext3 100793M 22060M acfs 102400M 102158M 4894016M 2418668M acfs 102400M 100501M 4894016M 2418668M acfs 102400M 100601M...

Page 323: ...DIMM_8 OK 3A4K40BB1 CRC 00CE01154602EADBA0 Continued LOCATION MANUFACTURER MEMORY_SIZE CURR_CLK_SPEED ECC_Errors P0 D0 Samsung 32 GB 2400 MHz 0 P0 D1 Samsung 32 GB 2400 MHz 0 P0 D3 Samsung 32 GB 2400...

Page 324: ...ower command to display power supply details File Path ORACLE_HOME opt oracle dcs bin odaadmcli Syntax Run this command on the master node to display power supply details on Oracle Database Appliance...

Page 325: ...tails odaadmcli show processor NAME HEALTH HEALTH_DETAILS PART_NO LOCATION MODEL CPU_0 OK 060F P0 CPU 0 Intel R Xeon R CPU E5 2630 Continued MAX_CLK_SPEED TOTAL_CORES ENABLED_CORES 2 200 GHz 10 10 oda...

Page 326: ...odaadmcli show disk Use the odaadmcli show disk command to display the status of a single disk or of all disks on the system odaadmcli show diskgroup Use the odaadmcli show diskgroup command to list c...

Page 327: ...ing the command ndisk Defines the number of disks to be added in the enclosure Usage Notes On high availability HA Oracle Database Appliance hardware models run the command only on the master node Var...

Page 328: ...Optional Displays help for using the command Example 13 111 Displaying the Status of All Disks To display the status of all the disks on the system odaadmcli show disk NAME PATH TYPE STATE STATE_DETAI...

Page 329: ...Num 0 SmartDiskWarnin 0 SmartTemperatur 37 State Online StateChangeTs 1465263789 StateDetails Good TotalSectors 6251233968 TypeName 0 UsrDevName NVD_S00_S2LHNAAH101026 VendorName Samsung gid 0 mode 66...

Page 330: ...tions odaadmcli show diskgroup DATA ASM_DISK PATH DISK STATE STATE_DETAILS data_00 dev NVD_S00_S2LHNAAH101026p1 pd_00 ONLINE Good data_01 dev NVD_S01_S2LHNAAH101008p1 pd_01 ONLINE Good odaadmcli show...

Page 331: ...8 sun product name MS1PC2DD3ORA3 2T pci slot number 11 nvme power control 1 sun nac name SYS DBP NVME1 odaadmcli show raidsyncstatus Use the odaadmcli show raidsyncstatus command to display the RAID S...

Page 332: ...ys help for using the command Example 13 117 Displaying Storage Devices The following example displays details about the storage devices on an appliance odaadmcli show storage BEGIN STORAGE DUMP Host...

Page 333: ...Express NVMe odaadmcli stordiag n h Parameters Parameter Description n disk_name Defines the disk resource name The resource name format is pd_ 0 3 help h Optional Displays help for using the command...

Page 334: ...to get the status of disk pd_00 odaadmcli power disk status pd_00 The disk is powered ON odacli adm set credential Use the odacli adm set credential command to change the oda admin user credentials Sy...

Page 335: ...s Example 13 121 Resetting the oda admin Password in Interactive Mode To reset the oda admin user password to a new password in interactive mode odacli adm set credential password username oda admin A...

Page 336: ...e the oakcli add disk local command to add a local disk to the system after physically replacing a failed disk oakcli configure commands Use the oakcli configure commands to configure components on Or...

Page 337: ...size the space used for a storage structure that was created for the purpose of migrating databases from Oracle ASM to Oracle ACFS oakcli restart oda_base Use the oakcli restart oda_base command to st...

Page 338: ...ds to list and manage virtual local area networks VLANs on an Oracle Database Appliance virtualized platform About the Oracle Appliance Manager Command line Interface OAKCLI The oakcli commands are th...

Page 339: ...command Options can consist of one or more options that extend the use of the oakcli command carried out on an object Options include additional information about the action that you want to perform...

Page 340: ...and arguments as part of your security and compliance protocol A SUDO security policy is configured by using the file etc sudoers Within the sudoers file you can configure groups of users and sets of...

Page 341: ...for DB creation Please enter the SYSASM password Please re enter the SYSASM password INFO 2015 08 05 14 41 10 Installing a new home OraDb12102_home3 at u01 app oracle product 12 1 0 2 dbhome_3 Please...

Page 342: ...the failed drive and replace it with a new drive before running the oakcli add disk local command The new disk must be inserted into the slot before you run this command The oakcli add disk local comm...

Page 343: ...configure repo Use the oakcli configure repo command to increase the size of a shared repository oakcli configure additionalnet Use the oakcli configure additionalnet command to configure any unconfi...

Page 344: ...its own ASR Manager internal Oracle ASR or use Oracle ASR Manager configured on another server in the same network as your appliance external Oracle ASR If you already have Oracle ASR Manager configur...

Page 345: ...lized Platform oakcli configure cpupool twonode numcpu 2 node 1 oakcli configure firstnet Use the oakcli configure firstnet command to configure an initial network on Oracle Database Appliance that en...

Page 346: ...t be executed from Dom0 on virtualized platforms publicNet Configures the network after you have swapped the public network from copper to fiber and vice versa You must run the oakcli configure networ...

Page 347: ...Node 0 ODA Base configured with new vcpus INFO Changes will be incorporated after the domain is restarted on Node 0 INFO Node 1 ODA Base configured with new memory INFO Node 1 ODA Base configured with...

Page 348: ...Specifies the full path name of the configuration file h Optional Display help for using the command Example 14 1 Preparing a Copy of the Configuration File If you created a configuration file previou...

Page 349: ...i create cpupool Use the command oakcli create cpupool to create a CPU pool on one Oracle Database Appliance Virtualized Platform node Syntax oakcli create cpupool poolname numcpu cpu_count node noden...

Page 350: ...se home params params_file Optional Name of the configuration file By default Oracle Database Appliance uses the default configuration file storage ASM ACFS Optional Creates an Oracle 12c database wit...

Page 351: ...ase 1 12 1 0 2 you can create an Oracle Database in Oracle ASM Oracle ASM is the default storage Examples This section shows different scenarios for using the command oakcli create database Example 14...

Page 352: ...1204_home2 Example 14 4 Creating a New Database from a Template Create a database called sales2 from the salesdbtemplate bconf file by appending the default file extension to the file name provided Th...

Page 353: ...create dbstorage command requests user input to determine the size of the storage structure to create as shown in this example oakcli create dbstorage db sales Please enter the root password Please re...

Page 354: ...f newconf dbconf oakcli create db_config_params conf newconf Please select one of the following for Database Block Size 1 4 1 4096 2 8192 3 16384 4 32768 2 Selected value is 8192 Specify the Database...

Page 355: ...create repo command to create a new shared repository on Oracle Database Appliance Virtualized Platform Syntax oakcli create repo repo_name size size M G dg DATA RECO h Parameters Parameter Descriptio...

Page 356: ...to be created from source_dbname Name of the source database h Optional Display help for using the command Example Create a new snapshot database name snapprod from the database named prod oakcli cre...

Page 357: ...olname Name of the CPU pool to be deleted node nodenum Node from which the CPU pool will be deleted 0 or 1 h Optional Display help for using the command Example Delete the CPU pool named twonode from...

Page 358: ...Appliance Syntax oakcli delete dbhome oh oracle_home h Parameters Parameter Description oh oracle_home The database home to be uninstalled h Optional Display help for using the command Example Delete...

Page 359: ...ame h Parameter Parameter Description repository_name The name of the shared repository to be deleted h Optional Display help for using the command Example Delete the testrepo01 shared repository oakc...

Page 360: ...mple 14 7 Running the Offline Configurator with Advance Mode To run the offline Configurator with advance mode update the config sh file and add advance cat config sh bin sh java Djava util logging co...

Page 361: ...wait for 30 seconds and execute from the slave nodes It takes about 10 to 12 minutes to add all of the disks Review the procedure for how to add the storage shelf for detailed steps on how to add the...

Page 362: ...me Optional Enable disk write cache for named disk status Optional Show the write cache status of all disks h Optional Display help for using the command Example 14 12 Displaying the Write Cache Statu...

Page 363: ...th Monitor This is the default option crs Collect Oracle Clusterware diagnostic information crshome crs_home_dir Specifies the location of the Oracle Clusterware home directory core Package core files...

Page 364: ...for any storage issues The logs can be used when you are experiencing any problems with storage and need support to diagnose the logs h Optional Display help for using the command oakcli describe sys...

Page 365: ...the database size class h Optional Displays help for using the command Usage Notes Note When you resize the database the redo log file size is not modified automatically Change the size of the redo lo...

Page 366: ...displayed on the screen For use only when working with Oracle Support Services clusternodes list list is a comma delimited list containing the names of the nodes where the command should run localonly...

Page 367: ...hange the value to the suggested value Syntax oakcli reconfigure osparams h Parameters Parameter Description h Optional Displays help for using the command Usage Notes After you change or expand memor...

Page 368: ...93000000 Suggested value for memlock is 193000000 Configured and suggested values are same Configured value for vm nr_hugepages is 67815 Suggested value for vm nr_hugepages parameter is 67748 Do you w...

Page 369: ...cerned about the current status of ODA_BASE because it performs a forced shutdown You must run this command from Dom0 Typically if ODA_BASE needs to be restarted then you must restart it on both nodes...

Page 370: ...ase home name and location and database version oakcli show db_config_params Use the oakcli show db_config_params command to display configuration file names and parameters oakcli show dbhomes Use the...

Page 371: ...yncstatus command to display the status of the RAID rebuild after a failed local disk is replaced oakcli show repo Use the oakcli show repo command to display information about virtual machine reposit...

Page 372: ...ple Display the cooling unit information for the node where the command is executed oakcli show cooling NAME HEALTH HEALTH_DETAILS LOCATION FAN FAN SPEED Fan_0 OK FM0 30 6300 RPM Fan_1 OK FM0 19 3800...

Page 373: ...i show cpupool Use the oakcli show cpupool command to display core allocations to virtual machine mappings Syntax oakcli show cpupool node nodenum nodenum is the number of the Oracle Database Applianc...

Page 374: ...2_home1 u01 app oracle product 12 1 0 2 dbhome_1 12 1 0 2 160719 23054246 23054327 Example 14 21 Displaying Database Details for Four Databases oakcli show databases Name Type Storage HomeName HomeLoc...

Page 375: ...ig_params detail Available DB configuration files are Default DATABASE_BLOCK_SIZE 8192 DATABASE_LANGUAGE AMERICAN DATABASE_CHARACTERSET AL32UTF8 DATABASE_TERRITORY AMERICA COMPONENT_LANGUAGES en oakcl...

Page 376: ...acle product 12 1 0 2 dbhome_1 ee43 SINGLE OraDb12102_home1 12 1 0 2 5 21359755 21359758 u01 app oracle product 12 1 0 2 dbhome_1 one120 RACOneNode OraDb12102_home1 12 1 0 2 5 21359755 21359758 u01 ap...

Page 377: ...red_disk_name asm all h Parameters Parameter Description local Optional Display information for all of the local disks shared Optional Display information for all of the shared disks shared_disk_name...

Page 378: ...hould be displayed If you do not specify this parameter then information for all of the Oracle ASM disk groups is displayed h Optional Display help for using the command oakcli show enclosure Use the...

Page 379: ...cli show expander expander_id h Parameter Parameter Description expander_id Optional Identifies the specific SAS expander h Optional Display help for using the command oakcli show ismaster Use the oak...

Page 380: ...oakcli show memory command to display information about memory modules Syntax oakcli show memory h Parameter Optional h displays help for using the command oakcli show network Use the oakcli show netw...

Page 381: ...E004J PS1 Present 89 watts 37 000 degree C 39 438 degree C oakcli show processor Use the oakcli show processor command to display information about CPU processors Syntax oakcli show processor h Parame...

Page 382: ...al machine repositories Syntax oakcli show repo reponame node 0 1 h Parameters Parameter Description reponame Optional Identifies a specific repository name node Optional Identifies the node number 0...

Page 383: ...Size 102400 State Online oakcli show server Use the oakcli show server command to display information about the server subsystem Syntax oakcli show server h Parameter Optional h displays help for usi...

Page 384: ...command to show hard storage errors Hard errors include having the wrong type of disk inserted into a particular slot an invalid disk model or an incorrect disk size Syntax oakcli show validation stor...

Page 385: ...plying the patch use the oakcli update patch version verify command to verify the contents of the patch instead of issuing oakcli show version detail Displaying the Oracle Database Appliance Version T...

Page 386: ...update command to apply Oracle Database Appliance patches oakcli start commands Use the oakcli start commands to start a virtual machine to start a shared repository on a node or to start ODA_BASE on...

Page 387: ...either 0 or 1 If node is not specified the shared repository is started on both nodes h Optional Displays help for using the command Example 14 34 Starting a Shared Repository on Node 0 Start the shar...

Page 388: ...p vm vm_odarepo1 force Example 14 36 Stopping a Shared Repository Stop the shared repository named repo1 on Node 0 oakcli stop repo repo1 node 0 Example 14 37 Stopping the Local ODA_Base Connect to Do...

Page 389: ...cted a storage shelf and optional storage expansion shelf use the format e 0 1 pd_ 0 23 to identify the disk to be diagnosed Example 14 38 Running Diagnostic Tests on a Disk in the Expansion Storage S...

Page 390: ...anager Repository Unpack the p13982331_23000_Linux 86 62 zip package which was previously copied to tmp on the current node into the node s Oracle Appliance Manager command line interface repository o...

Page 391: ...ucture upgrade is not required For example after applying the patch for Oracle Database Appliance 18 3 Oracle Grid Infrastructure is upgraded to 18 0 0 0 The local option then works oakcli update patc...

Page 392: ...27 2082 24828633 ASR 5 5 1 Up to date oakcli update patch Command Examples Update the appliance with the 18 3 patch oakcli update patch 18 3 0 0 0 Patch the Oracle Database homes on both nodes oakcli...

Page 393: ...nabling 12 CPU Cores for Oracle Database Appliance The following command enables 12 CPU cores on an Oracle Database Appliance system oakcli update cpucore cores 12 Please enter the root password Pleas...

Page 394: ...You must include either a db parameter or a from parameter Running the command with a db parameter upgrades only the named databases regardless of their current Oracle Database homes If you include a...

Page 395: ...mance issues d Run only the default checks The default checks are NetworkComponents OSDiskStorage SharedStorage and SystemComponents The NetworkComponents validation check is not available on Oracle D...

Page 396: ...Virtual Machine SUCCESS Type of environment found Virtual Machine ODA BASE SUCCESS Number of External LSI SAS controller found 2 INFO Check for Controllers correct PCIe slot address SUCCESS External L...

Page 397: ...Fine RESULT Registered with ASR backend RESULT test connection successfully completed RESULT submitted test event for asset 10 139 154 17 RESULT bundle com sun svc asr sw is in active state RESULT bun...

Page 398: ...irtualized Platform Syntax oakcli create vdisk vdisk_name repo repository_name size size type shared local sparse h Parameters Parameter Description vdisk_name Name assigned to the virtual disk that i...

Page 399: ...ies vm_repo_name ACFS snaps vm_name VirtualMachines vm_name ODA_BASE app sharedrepo vm_repo_name ACFS snaps vm_name VirtualMachines vm_name Example 14 43 Cloning a Virtual Disk Clone a virtual disk na...

Page 400: ...y_name Required parameter if a virtual disk is specified in the command h Optional Display help for using the command Examples Here are examples of how to use the oakcli show vdisk command Example 14...

Page 401: ...nother node oakcli modify vm Use the oakcli modify vm command to modify an existing virtual machine oakcli show vm Use the oakcli show vm command to display information about virtual machines oakcli s...

Page 402: ...al machine force Optional When cloning a source virtual machine the force option enables you to make a change from the source virtual machine For example if the source file does not use a driver domai...

Page 403: ...ual machine is configured in driver domain mode use the oakcli show vm vmname command When the virtual machine is in driver mode the output for the DriverDomain attribute is TRUE Example 14 46 Creatin...

Page 404: ...ine 1 to 248 G to 1 to 760 G or 1 253952 M to 1 778240 M based on RAM The default is M os sys Operating system used by the virtual machine WIN_2003 WIN_2008 WIN_7 WIN_VISTA OTHER_WIN OL_4 OL_5 OL_6 RH...

Page 405: ...and to work When you create a virtual machine select the Processor Cap as a percentage between 10 and 100 The default is 100 This value is then converted to a CPU utilization limit in the vm cfg file...

Page 406: ...lp for using the command Example Delete the ovu22 virtual machine from Node 1 oakcli delete vm ovu22 server 1 oakcli migrate vm Use the oakcli migrate vm command to migrate a currently running virtual...

Page 407: ...he detachvdisk option with the addnetwork deletenetwork or s parameters Include only one of the addnetwork deletenetwork or s parameters when you use this command Example 14 48 Sending a Message to a...

Page 408: ...repo1 vm2_odarepo2 2048 2 OFFLINE odarepo2 win_vm1 1500 1 ONLINE odarepo1 Example 14 50 Displaying Information for a Single Virtual Machine Display information about the vm1_odarepo1 virtual machine o...

Page 409: ...using the command Example 14 51 Opening a Virtual Machine Console Open a console for the virtual machine named vm1_odarepo1 oakcli show vmconsole vm1_odarepo1 oakcli start vm Use the oakcli start vm c...

Page 410: ...kcli import vmtemplate Use the oakcli import vmtemplate command to import virtual machine templates oakcli modify vmtemplate Use the oakcli modify vmtemplate command to add networks to or delete netwo...

Page 411: ...be fr ca hr hu is it ja lt lv mk nl n be no pl pt pt br ru sl sv th or tr mouse mouse_type Mouse type used by virtual machines cloned from the template OS_DEFAULT PS2_MOUSE USB_MOUSE or USB_TABLET dom...

Page 412: ...cpu 4 The maximum number of CPUs that can be assigned to the virtual machine is 4 cucap 40 The maximum percentage of a CPU s capacity that will be assigned to the virtual machine is 40 memory 1536M Th...

Page 413: ...es image_files is one of the following A single template file name A comma separated list of files that comprise a single template A URL enclosed in single quotation marks that links to a template fil...

Page 414: ...m a Remote Server Import a template from a remote server using a URL to identify the server and the template file oakcli import vmtemplate OL5U6 files http example com vm template OEL 5 OVM_OL5U6_X86_...

Page 415: ...template with the net1 network oakcli modify vmtemplate gc_11g addnetwork net1 oakcli show vmtemplate Use the oakcli show vmtemplate command to display information about virtual machine templates Synt...

Page 416: ...cli delete vlan command to delete a virtual local area network oakcli show vlan Use the oakcli show vlan command to display information about virtual local area networks VLANs configured on Oracle Dat...

Page 417: ...bond1 node 1 Duplicating a VLAN on the Second Node Create a VLAN named sample10 on Node 0 oakcli create vlan sample10 vlanid 10 if bond1 node 0 oakcli delete vlan Use the oakcli delete vlan command to...

Page 418: ...14 59 Displaying Details of Available Virtual Area Networks VLANs Display the names tag ID numbers networks and node assignments for the available virtual local area networks oakcli show vlan NAME ID...

Page 419: ...Clusters systems Running Trace File Analyzer TFA Collector Commands Understand the installed location of tfactl and the options for the command Running the Disk Diagnostic Tool Use the Disk Diagnostic...

Page 420: ...schedule and stored in the location opt oracle dcs Inventory for bare metal deployments and in the opt oracle oak Inventory directory for virtualized platforms The file is stored in the format oda_bo...

Page 421: ...el6_6 x86_64 bzip2 1 0 5 7 el6_0 x86_64 bzip2 libs 1 0 5 7 el6_0 x86_64 ca certificates 2017 2 14 65 0 1 el6_9 noarch cairo 1 8 8 6 el6_6 x86_64 celt051 0 5 1 3 0 el6 x86_64 checkpolicy 2 0 22 1 el6 x...

Page 422: ...4 16 el6_8 2 x86_64 crontabs 1 10 33 el6 noarch cryptsetup luks 1 2 0 11 el6 x86_64 cryptsetup luks libs 1 2 0 11 el6 x86_64 cups libs 1 4 2 78 el6_9 x86_64 Example 15 2 Example Command to View the Bi...

Page 423: ...oda admin password then a message is displayed advising you to change the default password to comply with your system security requirements 5 If you have not added an exception for the agent security...

Page 424: ...ck and scans for known problems Oracle ORAchk Health Check Tool audits important configuration settings for Oracle RAC two node deployments in the following categories Operating system kernel paramete...

Page 425: ...f required opt oracle SupportTools orachk orachk_oak_091918_182425 zip Running orachk on Oracle Database Appliance Baremetal Systems for Releases Earlier than 18 3 1 Open the command line interface as...

Page 426: ...stic output to a single node in Oracle Database Appliance if desired On Demand Scans of all log and trace files for conditions indicating a problem Real Time Scan Alert Logs for conditions indicating...

Page 427: ...view the diagnostic logs for Oracle Data Guard component of the Appliance odaprovisioning Optional Use this option to view provisioning logs for the Appliance odaconfig Optional Use this option to vi...

Page 428: ...ise Manager deployment acfs Optional Use this option to view the diagnostic logs for Oracle ACFS storage install Optional Use this option to view the diagnostic logs for installation cfgtools Optional...

Page 429: ...the following command odaadmcli stordiag n For example to display detailed information for NVMe pd_00 odaadmcli stordiag pd_00 Running the Oracle Database Appliance Hardware Monitoring Tool The Oracle...

Page 430: ...DETAILS PART_NO SERIAL_NO Power Supply_0 OK 7047410 476856F 1242CE0020 Power Supply_1 OK 7047410 476856F 1242CE004J Continued LOCATION INPUT POWER OUTPUT POWER INLET TEMP EXHAUST TEMP PS0 Present 88 w...

Page 431: ...the command output The following is an example of collecting log file information odaadmcli manage diagcollect dataMask dataSanitize Current TFA version is 183000 Current TFA supports dataMask or dat...

Page 432: ...sks performed on the database Database Home Commands ODACLI and OAKCLI commands for common tasks performed on the database home Database Storage Commands ODACLI and OAKCLI commands for common tasks pe...

Page 433: ...t ODA_BASE on the local node Not Applicable oakcli start oda_base Change password odacli adm set credential Not Applicable Audit configuration settings with the ORAchk utility No comparable command Us...

Page 434: ...ist databases oakcli show databases Display database details odacli describe database oakcli show databases db Create a new database odacli create database oakcli create database Register a migrated d...

Page 435: ...OAK Stack List of all of the database storage configured in the appliance odacli list dbstorages Not Applicable Display storage configuration details odacli describe dbstorage oakcli show dbstorage Cr...

Page 436: ...plicable Display details about the VLAN odaadmcli show vlan Not Applicable Storage Commands ODACLI and OAKCLI commands for configuring and managing storage Task Command to Run on the DCS Stack Command...

Page 437: ...SDs for data storage into the existing base configuration to fully populate the base storage shelf Not Applicable oakcli expand storage Display internal RAID and local disk information Not applicable...

Page 438: ...show memory Show network details odaadmcli show network oakcli show network Display power supply details odaadmcli show power oakcli show power Display processor details odaadmcli show processor oakc...

Page 439: ...nd to Run on the OAK Stack Configure Oracle Auto Service Request Oracle ASR after deploying the appliance odacli configure asr oakcli configure asr Edit Oracle Auto Service Request Oracle ASR configur...

Page 440: ...e Database Appliance Locate the storage and mount configuration file paths for Oracle Database Appliance Oracle homes on Oracle Database Appliance follow Optimal Flexible Architecture guidelines Direc...

Page 441: ...file opt oracle oak log hostname oak oakd log For example opt oracle oak log myhost oak oakd log Use the odaadmcli manage diagcollect command to collect diagnostic logs for storage components The fil...

Page 442: ...ry system privileges group oinstall GID 1001 Oracle ASM Administrators system privileges asmadmin GID 1004 Oracle ASM Users system privileges asmdba GID 1006 Oracle ASM Operator system privileges asmo...

Page 443: ...and virtual machine files Oracle ACFS provides both servers with concurrent access to some or all of the shared storage on Oracle Database Appliance Oracle ACFS supports space efficient storage snapsh...

Page 444: ...ts for Oracle Database Appliance The storage shelf in the base Oracle Database Appliance X6 2 HA system is half populated with 10 solid state drives SSDs for data storage totaling 12TB of raw storage...

Page 445: ...mple df k Filesystem 1K blocks Used Available Use Mounted on dev mapper VolGroupSys LogVolRoot 30963708 14203568 15187276 49 tmpfs 65952292 647800 65304492 1 dev shm dev sda1 495844 43872 426372 10 bo...

Page 446: ...roups Each of the SSD usable storage is approximately 1 1TB This is calculated by the storage usable capacity of the drive converted to TB 1 2 TB divided by 1 0244 1 1TB The following tables provide t...

Page 447: ...3TB The Reserved Space values represent the amount of storage required to maintain full redundancy in case of disk failure The REDO disk group uses 800 GB raw Solid State Drives or 0 8TB total usable...

Page 448: ...ble in the disk group to restore full redundancy after the worst failure that can be tolerated by the disk group Usable space required to restore full redundancy When storage is consumed higher than t...

Page 449: ...n dev mapper VolGroupSys LogVolRoot 30963708 14203568 15187276 49 tmpfs 65952292 647800 65304492 1 dev shm dev sda1 495844 43872 426372 10 boot dev mapper VolGroupSys LogVolOpt 61927420 18594420 40187...

Page 450: ...nce with the command odacli create appliance Loading and Saving Appliance Configurations You can load a saved JSON file and use it to configure your appliance and save an existing configuration as a J...

Page 451: ...is located in the opt oracle dcs sample directory Review the readme carefully along with the provided JSON example files Create a JSON file with the necessary changes based on your environment and re...

Page 452: ...0 0 4 11 10 0 4 12 domainName example com isRoleSeparated true osUserGroup groups groupId 1001 groupName oinstall groupRole oinstall groupId 1002 groupName dbaoper groupRole dbaoper groupId 1003 group...

Page 453: ...entage 80 diskGroupName RECO redundancy NORMAL diskPercentage 20 scan scanName odambox scan ipAddresses 10 0 1 11 vip nodeNumber 0 vipName odambox vip ipAddress 10 0 1 11 language en enableAFD TRUE da...

Page 454: ...SON File to Create a Single Node Oracle Database Appliance without Role Separation The following is an example of a JSON file that creates an Oracle Database Appliance without using role separation Th...

Page 455: ...subNetMask 255 255 240 0 gateway 10 0 0 1 grid diskGroup diskGroupName DATA redundancy NORMAL diskPercentage 80 diskGroupName RECO redundancy NORMAL diskPercentage 20 scan scanName odambox scan ipAdd...

Page 456: ...roxy password snmpVersion v2 Example JSON File to Create a Multi Node Appliance with the CLI Follow the JSON file example to create a JSON file to deploy a multi node appliance with the command odacli...

Page 457: ...ts instance name odahabox instanceBaseName odahabox dbEdition EE timeZone UTC ntpServers 10 0 3 14 dnsServers 10 0 4 10 10 0 4 11 10 0 4 12 domainName example com isRoleSeparated true osUserGroup grou...

Page 458: ...faultNetwork true ilom ilomName odahabox2 c ipAddress 10 31 16 140 subNetMask 255 255 240 0 gateway 10 31 16 1 nodeNumber 1 nodeName odahaboxc1n1 network nicName btbond1 ipAddress 10 31 98 132 subNetM...

Page 459: ...ber 0 vipName odahaboxc1n2 vip ipAddress 10 31 98 159 nodeNumber 1 vipName odahaboxc1n1 vip ipAddress 10 31 98 158 language en enableAFD TRUE database dbName myTestDb databaseUniqueName myTestDb_sea1k...

Page 460: ...CFS dbCharacterSet characterSet AL32UTF8 nlsCharacterset AL16UTF16 dbTerritory AMERICA dbLanguage AMERICAN dbConsoleEnable false backupConfigId null asr null Appendix D Example JSON File to Create a M...

Page 461: ...s are already tuned for the size of each database instance workload They are designed to run on a specific number of cores Caging ensures that each database workload is restricted to the set of cores...

Page 462: ...Database Appliance X6 2 HA generic database templates if your database is on Oracle Database Appliance X6 2 HA The templates provide general guidelines about the maximum number of databases on a fully...

Page 463: ...00 64 MB 4 GB Oracle Database Appliance DSS Database Template Sizes Table E 2 Oracle Database Appliance DSS Database Template Sizes Template CPU Cores SGA GB PGA GB Processe s Redo log file size GB Lo...

Page 464: ...In Memory GB Process es Redo log file size GB Log buffer MB odb 02 2 8 4 4 400 1 16 odb 04 4 16 8 8 800 1 32 odb 06 6 24 12 12 1200 2 64 odb 12 12 48 24 24 2400 4 64 odb 16 16 64 32 32 3200 4 64 odb...

Page 465: ...ect Store 11 10 bill of materials 15 1 bond network interface 12 6 bridge network interface 12 6 C cabling 3 2 validate 13 111 checklist for system requirements 2 6 tasks to complete before deployment...

Page 466: ...ils 14 40 database language 5 13 database snapshot create 14 21 database storage C 1 commands 13 74 create 13 76 display details 13 75 13 78 list 13 74 database template See template database database...

Page 467: ...E 3 Integrated Lights Out Manager See Oracle ILOM interconnect cables attach 3 2 storage expansion shelf 3 7 internal FRA 11 1 ISO image virtualized 5 1 5 2 J JSON file D 2 D 7 K kernel parameters adj...

Page 468: ...23 delete dbhome 14 23 oakcli commands continued delete dbstorage 14 23 delete repo 12 12 14 24 delete vdisk 12 15 delete vlan 14 82 delete vm 14 71 delete vmtemplate 12 20 14 77 deploy change group...

Page 469: ...3 116 show storage 13 123 odaadmcli commands continued storage 13 117 stordiag 13 124 odacli commands appliance 13 28 apply patch 13 10 backup 13 35 clone database 13 63 configure asr 13 103 CPU core...

Page 470: ...torage topology 13 111 validate storagetopology 13 111 odacli create appliance example JSON files D 2 D 7 readme D 2 odacli adm commands set credential 13 125 odaeraser py 8 5 odarepo1 local repositor...

Page 471: ...ng 7 13 appliance 7 1 using web console 7 6 7 7 patching Oracle Database Appliance 7 8 7 10 patching Virtualized Platform 7 10 performance tuning 12 45 12 46 physical disk LED identifier 14 27 plumb n...

Page 472: ...tabase Appliance 3 9 U uninstall 8 1 update pre checks 7 5 update rpms 7 13 usable storage C 3 C 4 V validation errors display 14 49 names and addresses on the DNS 5 12 validation failures display 14...

Page 473: ...Web Console continued actions 1 5 web interface Oracle Enterprise Manager Database Express 9 19 web interface continued Windows and virtualization 12 2 Index 9...

Reviews:

No comments

Related manuals for Database Appliance X6-2-HA

Ebyte E43-900T13S3 Manual preview
E43-900T13S3
Brand: Ebyte Pages: 8
JCG Q8 Quick Start Manual preview
Q8
Brand: JCG Pages: 2
Lanner NCA-2510 Installation Manual preview
NCA-2510
Brand: Lanner Pages: 2
Mylex eXtremeRAID 1100 Installation Manual preview
eXtremeRAID 1100
Brand: Mylex Pages: 74
Supermicro SAS-827HD User Manual preview
SAS-827HD
Brand: Supermicro Pages: 16
ZyXEL Communications XS1920 Series User Manual preview
XS1920 Series
Brand: ZyXEL Communications Pages: 422
ActionTec GT704WR User Manual preview
GT704WR
Brand: ActionTec Pages: 115
MFJ MFJ-492 Manual preview
MFJ-492
Brand: MFJ Pages: 11
QTech QSW-2900 User Manual preview
QSW-2900
Brand: QTech Pages: 406
MSNswitch UIS-322b Quick Installation Manual preview
UIS-322b
Brand: MSNswitch Pages: 2
B&B Electronics PCMCIA High Speed Serial Card CE 232HSPCC User Manual preview
PCMCIA High Speed Serial Card CE 232HSPCC
Brand: B&B Electronics Pages: 14
Keil RTX51 Manual preview
RTX51
Brand: Keil Pages: 68
Billion BiPAC 5200S RC Series User Manual preview
BiPAC 5200S RC Series
Brand: Billion Pages: 79
Nvidia GEFORCE RTX 4090 Quick Start Manual preview
GEFORCE RTX 4090
Brand: Nvidia Pages: 160
AMC DSP 88 User Manual preview
DSP 88
Brand: AMC Pages: 28
Crest Audio NC-MCO - TECHNICAL Technical Data preview
NC-MCO - TECHNICAL
Brand: Crest Audio Pages: 2
Cypress Semiconductor CY7C68023 Specification Sheet preview
CY7C68023
Brand: Cypress Semiconductor Pages: 9
Tripp Lite SmartRack SR42UBEXPKD Assembly Instructions Manual preview
SmartRack SR42UBEXPKD
Brand: Tripp Lite Pages: 8

Brands by name

Popular brands

Load more brands