You want to drop a database on Oracle Database Appliance (ODA) that is no more required or used. Use the “oakcli delete database” command to delete a database from ODA. In this article we will demonstrate how to delete a database on Oracle Database Appliance. Steps to Delete Database on ODA Step 1: List the database currently running on ODA [root@odanode01 ~]# oakcli show databases Name     Type       Storage   HomeName             HomeLocation                         SEE DETAILS <span class="more-link-...

You have files on an External USB drive that you want to connect to Exadata Compute node to copy them over to the server file system. This can be done for several reasons such as Database Migration. In this article I will demonstrate step by step how to mount an Exadata USB drive to Exadata Compute node. Steps to mount External USB on Exadata Compute node Connect the External USB drive to Exadata Compute node. This can be done easily by Data Center Engineer who has access to Data CenterSEE DETAILS

Here is the link to download Oracle Database Appliance Pocket Reference Guide Oracle Database Appliance Pocket Reference Guide

Oracle provides “Exachk” utility to conduct a comprehensive Exadata Health Check on Exadata Database Machine to validate hardware, firmware and configuration. Exachk Utility is available for Oracle engineered systems such as Exadata (V2 and above), Exalogic, Exalytics, SuperCluster, MiniCluster, ZDLRA & Big Data. Exachk utility performs the following checks: Configuration checks for Compute nodes, Storage cells and InfiniBand Switches Grid Infrastructure, Database and ASM and Operating System software checks MAA Scorecard which conducts an automatic MAA Review Exadata Software Planner, Software prechecks, Exadata and Database Critical Issue alerts It isSEE DETAILS ...

Here is the Link to the Exadata Pocket Reference. Click on the Link to Download the file. Exadata Pocket Reference

On Exadata Database Machine you can configure the following Compute Node and Storage Cell attributes to setup the database server and Storage cells to send notifications about alerts. smtpServer smtpFrom smtpFromAddr smtpToAddr snmpSubscriber notificationMethod notificationPolicy In this article we will demonstrate how to setup the database server and Storage cells to send notifications about alerts Compute Nodes: Configure Compute nodes SMTP email notification for alerts. This can be accomplished using dbmcli alter dbserver command # Compute node 1 DBMCLI>alter dbserver smtpFrom=’Exadata – dm01db01′ DBMCLI>alter dbserver smtpFromAddr=’dbmadmin@dm01db01.netsoftmate.com’ DBMCLI>alter dbserver smtpToAddr=’oradba@netsoftmate.com’ DBMCLI>al...

While working on Exadata Storage cell patching, the patching failed due to failed internal USB drive on a storage cell. Oracle uses internal USB drive to backup Exadata Storage cell automatically. We don’t have to backup Storage cell manually. In this article I will demonstrate how to replace a failed USB drive an Exadata Storage cell You will receive an automated smtp alert (if configured) similar to below. You can also use the following command to check for USB drive failure [root@dm01cel01 ~]# cellcli -e list alerthistory      SEE DETAILS

Oracle Database Appliance stack patching is very simple and straight forward. The ODA patching process is fully automated and single patch contains updates for all system components such as OS, Firmware, BIOS, ILOM, Storage, Grid Infrastructure and Database. ODA patches are released every quarter and one should always consult the MOS note 888888.1 for recommended patches. Oracle Database Appliance stack Patching consists of following major steps: Patching ODA Nodes (Includes Grid Infrastructure Patching) Patching Storage Shelve(s) Patching Database In this article we will demonstrate the steps for patching entire OracleSEE DETAILS <span class="more-link-hover-ima...

In previous articles Oracle DBCS: Create Virtual Image Database Deployment series we have learned how to: Oracle DBCS : Create Virtual Image Database Deployment – Part 1 https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.html Oracle DBCS : Create Virtual Image Database Deployment – Part 2 https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part2.html Oracle DBCS : Create Virtual Image Database Deployment – Part 3 https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part3.html In this article we will learn the final step on how to Create a Database in Virtual Image Database Deployment. Prerequisites Create Virtual Image Database Deployment Create Stora...

In previous articles we have learned how to create Virtual Image deployment and Scale Up Storage Using Oracle Database Cloud Service and Create one storage volume for the Oracle Database software and one storage volume for all database files, and prepare them for use.  Oracle DBCS : Create Virtual Image Database Deployment – Part 1 https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.html Oracle DBCS : Create Virtual Image Database Deployment – Part 2 https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part2.html In this article we will learn how to Install Oracle Database Software Prerequisites Create Virtual Image Database Deployment Create Storage Volumes for<a class="more-link" href="https...

In previous article “Oracle DBCS : Create Virtual Image Database Deployment – Part 1” we have learned how to Create Virtual Image Database Deployment using Create Service Wizard.https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.htmlIn this article we will Scale Up Storage Using Oracle Database Cloud Service and Create one storage volume for the Oracle Database software and one storage volume for all database files, and prepare them for use. This will be the part 2 and continuation of the previous article. Prerequisites Create Virtual Image Database Deployment Steps to Scale up Storage using Oracle Database CloudSEE DETA...

When you create an Oracle Database Cloud Service – Virtual Image Database Deployment, the following tasks are completed for you: Compute Allocated Storage Allocated Virtual Machine Image Installed Included software to create Oracle Database You are responsible for Connecting to VM, create Database, perform maintenance operations such as Backup , Patching and Upgrade. Note that Oracle Database 12c Release 2 (12.2) is not available for Oracle Database Cloud Service – Virtual Image service level. When you create a database deployment on Oracle Database Cloud Service using the Virtual Image serviceSEE DETAILS <span class="more-link-hover-imag...

You made some configuration changes to the Oracle Cloud Compute Node and it requires a restart/reboot take affect. In this article we will demonstrate how to restart a Database Cloud Service Database Deployment. Steps to Restart a Database Cloud Service Database Deployment. Method 1: Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account Enter your username and password On the home page, Click “Menu” under “Database” Cloud Service as shown below Click “Open Service Console” On the this page,SEE DETAILS

You want to start a Database Cloud Service Database Deployment after completing your maintenance work. When you start a database deployment, you can access it again and can perform any management operations. Starting a database deployment is very simple and it is similar to powering on a computer or laptop.  When database deployment is started, its CPU and RAM are allocated. As a result, it consumes OCPU and memory resources and so metering and billing of these resources are started. In this article we will demonstrate how to start aSEE DETAILS

You want to stop a Database Cloud Service Database Deployment as you are not using it or for some maintenance work. When you stop a database deployment, you can’t access it and can’t perform any management operations other than starting or deleting the Database Deployment. Stopping a database deployment is very simple and it is similar to powering off a computer or laptop.  It is important to note that when database deployment is stopped, its CPU and RAM are stopped. As a result, it consumes no OCPU or memory resourcesSEE DETAILS

When you create a Database Deployment in Oracle Database Cloud Service, the following tasks are completed for you: Compute Node Allocated Storage Allocated Virtual Machine Image Installed Set Keys and Privileges Install and Configure Database Configure Backup Configure Tools Configure Access Network access to the Compute Node associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. By default SSH port 22 is opened to allow access to the tools, utilities and other resources on the Compute Node associated with the Oracle Database Cloud Services.SEE DETAILS

When you create a database deployment in Oracle Database Cloud Service, a Compute node is created with a virtual machine image installed and the necessary operating system users are created. You can use the opc users to login to the compute node and execute root command by switching to root user. Since you have access to the compute node and root users access you can install the operating system packages based on your business needs. In this article we will demonstrate how to install operating system packages on a OracleSEE DETAILS

When a Oracle Database Cloud deployment is created, it creates following 3 OS users: opc: This user is authorized to login to compute and execute root commands. It can use sudo -s command to switch to root. root: This user is not authorized to login to the compute node. To perform operations that requires root user access, connect to the compute node as opc user and use the sudo command. oracle: This user is authorized to login to the compute node and execute user level commands but not root commands.SEE DETAILS