Oracle has provided the verify_roce_cables.py to verify if the rack is cabled correctly for Transport Layer systems based on a RDMA over Converged Ethernet (RoCE) Network Layer network on Exadata Database Machine X8M-2/X8M-8 and later hardware. Here is the step by step procedure to verify RoCE cabling on Oracle Exadata X8M Database Machine. Exadata Infrastrure details: Exadata Model : Exadata X8M-2 half rackExadata Software version: 126.96.36.199.0 Step 1: Download 30323660 for your Exadata smart software. In my case I have downloaded it for 19.3.3 Step 2: Copy the patch to staging area and unzip [root@dm01db01 ~]#SEE DETAILS
Netsoftmate experts are back again with another interesting article which will help you setup and restore compute node from snapshot backup of Oracle Exadata. In our previous blog we have demonstrated a step-by-step process of how to take a snapshot based back-up of compute node to NFS share.If you haven’t yet read the previous article, here’s the link for reference – Step-by-step guide of exadata sanpshot based backup of compute node to nfs shareIn this article, we will be focussing on how to setup and restore the compute node from theSEE DETAILS
Backing up file systems on Oracle Exadata compute can be a daunting task if you are unaware of the prerequisites and best practices. To help you backup your file systems effectively and with least discrepancies, we are bringing you this interesting step-by-step guide on how to back up your file system using Oracle Exadata Sanpshot Based Backup of Compute Node to NFS Share It is very important to take file system backup on Oracle Exadata compute nodes before we make any major changes to the operating system or critical software.SEE DETAILS
What is Oracle Autonomous Database?Oracle Autonomous Database allows you rapidly & easily create mission critical databases, It protects data from both external and internal threats, automates all infrastructure & database maintenance, recovers from any failure without downtime and scales online for highest performance & lower cost. Components of Oracle Autonomous Database:An Oracle Autonomous database comprises of 3 components:Oracle ExadataOracle databaseAutomated Data Center Operations and Machine Learning How Does Oracle Database Works:An Oracle Autonomous Database is self driving, self securing and self repairing.Self Driving: It Automates all databases and infrastructure management, Patching,<a class="more-link" href="https://netsoftmate.com/oracle-autonomous-database-clo...
You will end up performing storage cell rescue under the following situations:Improper Battery ReplacementImproper Card SeatingCard Damage During Battery ReplacementCorrupted Root File SystemIn this article we will demonstrate step by step process to Rescue an Exadata Storage Cell or server. Open a browser and enter the ILOM hostname or IP address of the Storage cell you want to rescuehttps://dm01cel02-ilom.netsoftmate.com Enter root crendentials On the left pane under “Remote Control”, click “Redirection”. Select “Use video redirection” and click “Launch Remote Console” button Click OK Click OK Click Continue Click Run Click Continue (not recommended) From the<a class="more-link" href="https://netsoftmate.com/step-by-step-exadata-stora...
Database Management Services, Oracle Database Appliance - ODA, Oracle Database Management Solution, Oracle Databases, Remote Database Management, Uncategorized
ODA is basically a 2-node RAC cluster database system running Oracle Linux operating (OEL), Oracle Database Enterprise Edition or Standard Edition, Oracle Grid Infrastructure (Clusterware and ASM). All these together provides the Oracle Database high availability running on ODA. In 2016, Oracle added 3 new models to expand Oracle Database Appliance portfolio. These 3 new models are:Oracle Database Appliance X6-2S (single-instance database)Oracle Database Appliance X6-2M (single-instance database)Oracle Database Appliance X6-2L (single-instance database) The High Available ODA X6-2 is now known as X6-2 HA which consists of 2 nodes and a storage shelfSEE DETAILS
In this article we will demonstrate quick steps to deploy Exadata Database Machine in Oracle Cloud Infrastructure (OCI). Prerequisites:Exadata Cloud SubscriptionCredentials to Login Oracle CloudAccess to Deploy Exadata in OCI CompartmentVCN & Subnet Steps to Deploy Exadata on OCIOpen a browser and enter the URL you have received from Oracle to connect to the Oracle Cloud Enter your Oracle Cloud credentials Click on “Create Instance” Click on “All Services” and search for Exadata keyword. Click on Create. Select your “Compartment” on left and Click on “Launch DB System” Enter the details as perSEE DETAILS <span class="m...
An engineered system comprising of Compute Nodes, Storage Cells and Infiniband – all of it packaged inside a single physical cabinet called “Exadata Rack”Exadata Hardware Generation At A Glance Exadata Database Machine X8-2
Oracle announced the next-generation Oracle Exadata X8 with significant hardware and software enhancements in overall performance, storage capacity, network bandwidth, and automation. Exadata X7 delivers extreme performance and reliability to run the largest, most business-critical database workloads.Exadata X8-2 quick glance: Latest Intel Xeon (8260) Processors (2.4GHz) 2*24 cores per database server (384 core in a Full Rack) Exadata X8 Capacity-on-Demand enables at least 14 cores per server Delivers up to 60 percent faster throughput than previous models NO changes in Database server Physical memory (upto 12TB in a full Rack)SEE DETAILS <span class="more-link...
Before we talk about Dbvisit Standby and it’s components, let’s talk little bit about about Disaster Recovery and Business Continuity. What is Business Continuity?In the event of a disaster, the process of failing over your server from the primary to the secondary site is known as Disaster Recovery. A disaster recovery solution provides your Company with Business Continuity.The main purpose of Dbvisit Standby is to provide the Organizations with greater Business continuity. What is Physical Replication?The process of creating a Standby database from the source or primary database is knownSEE DETAILS
The patchmgr or dbnodeupdate.sh utility can be used for upgrading, rollback and backup Exadata Compute nodes. patchmgr utility can be used for upgrading Compute nodes in a rolling or non-rolling fashion. Compute nodes patches apply operating system, firmware, and driver updates.Launch patchmgr from the compute node that is node 1 that has user equivalence setup to all the Compute nodes. Patch all the compute nodes except node 1 and later patch node 1 alone. In this article I will demonstrate how to perform upgrade Exadata Compute nodes using patchmgr andSEE DETAILS
Overview The Exadata network grid consists of multiple Sun QDR InfiniBand switches. IB Switches are used for the storage network as well as the Oracle RAC interconnect. Exadata compute nodes and storage cells are configured with dual-port InfiniBand ports and connect to each of the two leaf switches. You can access IB Switches using command line and Web ILOM IB Switches run Linux operating system. In this article I will demonstrate how to patch or upgrade Oracle Exadata IB Switches. About Infiniband Switch Patching Starting with release 188.8.131.52.0, the patchmgrSEE DETAILS
The patchmgr utility can be used for upgrading, rollback and backup Exadata Storage cells. patchmgr utility can be used for upgrading Storage cells in a rolling or non-rolling fashion. Non-Rolling is default. Storage server patches apply operating system, firmware, and driver updates.Launch patchmgr from the compute node that is node 1 that has user equivalence setup to all the storage cells. In this article I will demonstrate how to perform upgrade Exadata Storage cells using patchmgr utility.MOS NotesRead the following MOS notes carefully. Exadata Database Machine and Exadata Storage ServerSEE DETAILS
I was working on changing password for the administrative user accounts on all Exadata Components. I encountered a strange issue while changing the root password on Infiniband Switch. We were unable to change the root password on IB Siwtch using command line method. We used couple different command line methods to change the root password on IB switches but all of them failed. This could be a BUG, firmware issue or something else.In this article we demonstrate how to change the root password on an Exadata infiniband switch using BrowserSEE DETAILS
IntroductionWe had a FAN failure on Exadata Infiniband Switch (FAN2). Scheduled the faulty hardware replacement with Oracle. The Oracle Feild Engineer came to the Customer Data Center and replaced the faulty FAN on Infiniband Switch. The FAN replacement was successful however the fault was not cleared automatically. We can still see the FAN was marked faulted from Infiniband BUI and CLI.From Infiniband Browser User Interface In this article we will demonstrate how to clear the fault on Infiniband Switch after hardware replacement. Login to the Infiniband switch using Putty asSEE DETAILS
In this article we will demonstrate how to update the Power Distribution Unit (PDU) firmware on Exadata Database MachineYou may update the firmware on a PDU if you are running an older version in some cases you need to update the firmware after replacing a hardware component. Get the current PDU Firmware version Using a web browser login to the PDU using the hostname or IP address https://dm01sw-pdua01.netsoftmate.com/ Click on “Module Info” Under “System Info”, look for “Firmware Version”. In my case the PDU firmware version is 2.01. StepsSEE DETAILS
When creating a new database deployment on Oracle Database Cloud Service, you have option to choose whether you want to configure automatic backup or not. The options are as follows: Both Cloud Storage and Local Storage 30 days worth of backups are kept and the 7 most recent days worth available directly on the compute node’s local storage. Cloud Storage Only 30 days worth of backups are kept with all backups on cloud storage container. None No automatic Backup are configured In this article we will demonstrate how to CreateSEE DETAILS
When the Exadata Database Machine is installed by Oracle ACS, you will see the following default file system created: / /dev/shm /boot /u01 There is a plenty of space available in the volume group and this can be used to increase the existing file system size or you can create a new file system. In this article we will demonstrate how to create a new file system (named /u02) on Exadata Compute node. Connect to the compute node as root user login as: rootroot@dm01db01’s password:Last login: Mon Nov 19 13:11:39SEE DETAILS
Oracle Transparent Data Encryption (TDE) enables the organizations to encrypt sensitive application data on storage media completely transparent to the application. TDE protects the data at rest. TDE encrypts the data in the datafiles so that in case they are obtained by hacker or theft it will not be possible to access the clear text data. In the databases where TDE is configured any user who has access on an encrypted table will be able to see the data in clear text because Oracle will transparently decrypt the data forSEE DETAILS
In this article we will demonstrate how to flashback a database and recover the truncated table without loosing data. In other words we will be performing the following steps to recover a truncated table: Simulate table truncate Make note of the table truncate time Flashback the database before truncate, Open the database in read only Export the table using traditional export utility Shutdown the database Open the database with reset logs option Import the table data Verify the table data Prerequisites Database must in using Fast Recovery Area Database mustSEE DETAILS