Oracle Database Appliance X6-2-HA Скачать руководство пользователя страница 266

Страница: 266 / 473

•

odacli register-database

Use the

odacli register-database

command to register a migrated

database with the appliance.

•

odacli upgrade-database

Use the

odacli upgrade-database

command to upgrade a database from a

supported release.

•

odacli delete-database

Use the

odacli delete-database

command to delete a database.

odacli list-databases

Use the

odacli list-databases

command to list all databases on the appliance.

File Path

$ORACLE_HOME/opt/oracle/dcs/bin/odacli

Syntax

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

Display a list of databases:

# odacli list-databases

ID DB Name DB Version CDB

------------------------------------ ---------- ---------- ----

ad6c7326-e460-411e-94df-230dedbef743 rdb121a 12.1.0.2 true

fb4d02f3-2413-47ca-8584-a768e23ec2e7 ee12db 12.1.0.2 false

(Continued)

Class Shape Storage Status

------ ------- ----------

OLTP odb1 ACFS Configured

IMDB odb1 ASM Configured

odacli describe-database

Use the

odacli describe-database

command to display database details.

File Path

$ORACLE_HOME/opt/oracle/dcs/bin/odacli

Chapter 13

odacli Database Commands

13-57

Содержание Database Appliance X6-2-HA

Страница 1: ...Oracle Database Appliance X6 2 HA Deployment and User s Guide Release 18 3 for Linux x86 64 F10531 03 May 2019...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 15: ...Index xv...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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_...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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_...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Результаты поиска

Содержание Database Appliance X6-2-HA

Отзывы:

Бренды по названию

Популярные бренды

Oracle Database Appliance X6-2-HA, Руководство по развертыванию и инструкция пользователя

Результаты поиска

Содержание Database Appliance X6-2-HA

Отзывы:

Бренды по названию

Популярные бренды