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 a 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 asSEE DETAILS <span class="more...
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 184.108.40.206.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
Exadata Database machine consists of 3 ASM Disk Groups: +DATA for Database Files +RECO for Online Redo log and Archive log files +DBFS_DG for Cluster configuration files such as OCR and Voting disks In a Customized environment Customers can choose to have more than 3 Disk Groups. But it is recommended to have 3 Disk Groups. The DATA and RECO disk groups can be sized 80%-20% or 40%-60% respectively of over all storage capacity. Sometimes it is possible that +DATA disk group can be filled very fast if you haveSEE DETAILS
Exadata Database Machine consists of a storage grid, compute grid, and network grid. Each grid, or hardware layer, is built with multiple high-performing, industry-standard Oracle servers to provide hardware and system fault tolerance. The hardware components are subjected to failure. Most common failure on Exadata is Hard Disk failure on Storage Cells. With the latest generation of Exadata the hardware failures are very minimal and less troublesome. The Exadata Storage Cells and Compute nodes consists of several hardware components, such as: Hard disk Flash disk Physical Memory Processor IB portsSEE DETAILS <span class="more-link-h...
When Exadata database machine is installed by Oracle ACS the root file system size is set to 30GB. This space may not be sufficient for storing large files, logfiles, patches and so on and it can be filled very quickly. So you must consider increasing the root file system to avoid space issues. The root file system is built on volume group which makes it easy to resize the logical volume on which the root file system is mounted. Root file system is created on two system partitions LVDbSys1 andSEE DETAILS