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 220.127.116.11.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/u01There 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 userlogin as: rootroot@dm01db01’s password:Last login: Mon Nov 19 13:11:39 2018 from 10.xx.xxx.xxxList the exisint file systemSEE 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
You can access database servers remotely by using tools such as PuTTY and Virtual Network Computing (VNC) which are freely available for download. In most cases, accessing a database server in a command-line mode via PuTTY is enough. Sometimes we may need to access a database server to run GUI-based software. For example, to run runInstaller to install Oracle software or DBCA to create databases. In these cases, VNC comes handy as it support GUI-based interface. VNC allows you to run GUI interface on database server. It allows you toSEE DETAILS
While working on an Exadata database machine X4-2 half rack we found that the Smart Flash Cache on a storage cell was missing. We ran an Exachk and found the Smart Flash cache was indeed missing on Storage Cell 05. Here is the message printed in the Exachk report. FAIL Storage Server Check Storage Server Flash Memory is not configured as Exadata Smart Flash Cache dm01cel05 Exadata Smart Flash Cache: Oracle first introduced Exadata Flash Cache in the version Exadata V2. Exadata Smart Flash Cache, caches the data on flashSEE DETAILS
During the Oracle Database Appliance Deployment you can optionally configure CloudFS file system. The default mount point is /cloudfs and set to default size of 50GB. Oracle Database Appliance uses the Oracle Automatic Storage Management Cluster File System (Oracle ACFS) for database and virtual machine files storage. ACFS can only be used to configure shared storage file system on ODA. Oracle ACFS provides both servers with concurrent access to /cloudfs shared file system. The default size of 50GB may not sufficient and must be increased to store big files forSEE DETAILS
Oracle Database Appliance (ODA) is an entry level Engineered System. ODA is a pre-configured, highly available Oracle Database Engineered system. ODA system consists of hardware, software, storage and networking. The hardware configuration is designed to provide redundancy and protection against single points of failures in the system. ODA consists of two physical servers (Node 0 and Node 1), a storage shelf and optionally an additional storage shelf. The two independent physical servers are interconnected and direct attached to SAS and SSD storage. ODA is basically a 2-node RAC cluster database system running OracleSEE DETAILS <span class="more-link-hove...
During Oracle Database Appliance Deployment you can optionally configure CloudFS file system. The default mount point is /cloudfs and set to default size of 50GB. Oracle Database Appliance uses the Oracle Automatic Storage Management Cluster File System (Oracle ACFS) for database and virtual machine files storage. ACFS can only be used to configure shared storage file system on ODA. Oracle ACFS provides both servers with concurrent access to /cloudfs shared file system. The default size of 50GB may not sufficient and must be increased to store big files for businessSEE DETAILS
Overview Amazon Web Services is a comprehensive, evolving cloud computing platform provided by Amazon. Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. In this article we demonstrate how to establish connection to AWS RDS Oracle Database Using SQL Client. PrerequisitesInstall Oracle SQL Client on your client machine (Windows/Linux)Use can also use Oracle SQL*Developer tool to establish connectionProcedure to Connect to AWS RDS Oracle DatabasePut tns entry in tnsnames.ora file client machine. Review the blog articleSEE DETAILS <span class="more-link-hover-ima...
About ODA Snapshot Database ODA Snapshot Database is created using oakcli command line utility ODA automates the entire snapshot database creation process Snapshot Database is created by taking a snapshot of the Oracle ASM Cluster File System (ACFS) where the source data files reside The Source Database can be: Non-RAC RAC RAC One Node Snapshot Database requires less time and Storage No downtime for source database for creating snapshot database You can create an Oracle RAC database from an Oracle RAC One Node database Create snapshot database feature is notSEE DETAILS