Re-image Oracle Database Appliance (ODA)Oracle Database Appliance comes preinstalled with the most current version of the Base Metal Operating System. It is not be necessary to re-image the ODA operating system. However, if there is a OS corruption or if you want to update the ODA software quickly or a large period of time has passed between ODA shipment and deployment, a latest version of Bare Metal image may have been released. You can also reimaging ODA if you want to convert a ODA Virtualized platform back to ODA BareSEE DETAILS

Introduction: To Deploy ODA you need GUI interface, to do this you make use of VNC server to connect with ODA and open GUI interface. In this article I will demonstrate how to configure VNC on Oracle Database Appliance. Configure VNC: 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 runSEE DETAILS

Oracle Database Appliance:Oracle Database Appliance (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.The Oracle Database Appliance saves time and money by simplifying deployment, maintenance, and support of high availability Database solutions. 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 attachedSEE DETAILS <...

Once the ODA cabling is completed, it is very important to verify the cabling connection. Oracle recommends that you run oakcli to validate the cabling before starting the ODA network configuration. The following oakcli command is used to validate the cabling:# /opt/oracle/oak/bin/oakcli validate -c storagetopologyIf the oakcli validate -c storagetopology command reports any issue, One possible cause is that the cables to all the nodes were not fully connected. verify that the cables to all the nodes are fully connected.  Unplug/plug them back in as needed for verification.You should alsoSEE DETAILS

Oracle Database Appliance provides a utility called “cleanupDeploy.pl” that is used to: If you encounter deployment issues and wants to cleanup to perform a fresh deployment. If you want to wipe out everything on you ODA If you want to redeploy the ODA base image To perform a ODA cleanup we make use of the utility “cleanupDeploy.pl’. It located under /opt/oracle/oak/onecmd directory.[root@odanode1 ~]# locate cleanupDeploy.pl/opt/oracle/oak/onecmd/cleanupDeploy.pl cleanupDeploy.pl utility wipes out everything on your ODA and you can rerun the deployment process again using oakcli utility. Execute ODA cleanup utility:For Bare-Metal setupSEE DETAILS ...

About Firstnet UtilityThe “oakcli configure firstnet” command is used to configure an initial network on Oracle Database Appliance (ODA) that enables you to copy ODA End User Bundle software to ODA server.oakcli configure firstnet allows you to establish the network interfaces for the Oracle Database Appliance upon first usage.Once you have completed the reimaging of ODA servers, you should log onto the one of the node ILOM console and do the initial configuration of the Oracle Database Appliance network using the command firstnet.The bond0 interface is configured when execute theSEE DETAILS

Introduction:AWS Import/Export is a service that accelerates transferring large amounts of data into and out of AWS using physical storage appliances, bypassing the Internet. AWS Import/Export supports transfers data directly onto and off of storage devices you own using the Amazon high-speed internal network. Refer http://docs.aws.amazon.com/AWSImportExport/latest/DG/whatisdisk.html Scenario 1: Take export dump  on AWS database Server for some of the schemas. Use following parfile to take export on aws database server directory=<directory name>dumpfile=<dumpfile name>logfile=<logfile name>schemas=<schema name>compression=all For example we are using AWSNSMP  database to take schemas export and keep the dumpfile<a class="more-link" href="https://netsoftmat...

Oracle Database Appliance (ODA) Configurator: The standalone Oracle Appliance Manager (ODA) configurator is a Java-based tool that enables you to generate your ODA deployment plan and validate your network settings before the actual ODA deployment. ODA Configurator option:  ODA Congigurator can be run in offline or online mode.Offline: Use the standalone ODA configurator to create an offline deployment plan and validate your network settings before the actual deployment.Online: You can configure your system at the time of deployment. In that case, you can use the online ODA Configurator which isSEE DETAILS

Some times we encounter Infiniband Port related issues. These alerts can be triggered from  from OEM or any other monitoring tools.   Sample Alert from OEM 12c: Example 1: Port xx on dm01sw-ib3.netsoftmate.com is disconnected from port xx  Example 2: Cable is present on Port xx but the port is disabled. This document provides the steps to resolve Infiniband Switch Port related issues mentioned above. Unless otherwise stated, run all the commands from compute node 1. Identify the Problematic Infiniband Switch Port Using OEM 12c Log in to OEM 12cSEE DETAILS

When working with Oracle Support on a Infiniband Switch Hardware Service Request, Oracle Support request you to upload ILOM SNAPSHOT to properly assess the hardware failure. Starting with Exadata X4 and higher, you can now collect snapshot for Infiniband Switch using web browser interface.  In this article I will demonstrate the steps to collect ILOM snapshot data for an Infiniband Switch. You connect to Infiniband Switch using a web browser to collect the ILOM snapshot. Steps to collect ILOM Snapshot for IB Switch Open a web browser (use something otherSEE DETAILS

We received the following error message from OEM that port 36 on IB Switch dm01sw-iba01 has errorsAlert message from OEM 12c:Host=dm01db01.netsoftmate.com Target type=Oracle Infiniband Switch Target name=dm01sw-iba01.netsoftmate.com Categories=Error Message=Port 36 has 10 total errors, crossed warning (10) or critical ( ) threshold. Severity=Warning Event reported time=May 29, 2017 2:11:14 AM CDT Target Lifecycle Status=Production Here are the few IB commands that can be used to identify the problem with IB Port.Troubleshooting steps: Login to problematic IB switch using putty as root user login as: rootroot@dm01sw-iba01.netsoftmate.com’s password:Last login: Wed May 17SEE DETAILS <span class="mor...

What is oplan?Oplan utility helps you generate step by step patching instructions for your environment. Traditionally the patches are applied by using steps provided in the README file that comes with the patch.Oplan utility automatically generates the patching steps based on the target configuration information. It provides both patching and rollback steps and provides multiple patching options such as In-place and out-of-place methods.Download oplan utility?Download OPlan from My Oracle Support (https://support.oracle.com). Search for patch 6880880 and download. More on oplan utilityOracle Software Patching with OPLAN (Doc ID 1306814.1)    In thisSEE DETAILS <span class="more-link-imag...

Introduction By default Oracle ACS configure root file system with 30GB space on Exadata Computed nodes X2 and above. In most of the cases this space is sufficient to store operating system, Exadata software, log file and diagnostic files. Over time if you store patches, software and log files are not purged this space will be filled faster. Exadata X2 and above uses volume group and it is easy to extend the logical volume space on which the root file system is mounted. Root file system is created on twoSEE DETAILS

Introduction:In Oracle databases, it is recommended to multiplex you controlfile to safeguard against different failures like corruption, accidentally removing control file and so on.In this article I will demonstrate how to multiplex/duplicating a controlfile into Automatic Storage Management (ASM).Current SetupExadata 8-node RAC using ASM. Current controlfile is stored in ASM.Database is using SPFILE.There are diffferent ASM Disk Groups available such as DATA, RECO, DBFS_DG, ACFS_DG.  dm01db01-orcldb1 {/home/oracle}:srvctl status database -d orcldbInstance orcldb1 is running on node dm01db01Instance orcldb2 is running on node dm01db02Instance orcldb3 is running on node dm01db04Instance orcldb4...

OverviewYou can install Oracle GoldenGate for Oracle RAC using: Shared Storage  NFS, OCFS2, DBFS, OCFS Local file system You can Install Oracle GoldenGate 12c in 2 ways: Graphical User Interface (GUI) Using response file (Silent) In this article I will demonstrate how to Install Oracle GoldenGate 12c using GUI on a full Rack Exadata Database Machine using ACFS file system.What is ACFS?Automatic Storage Management Cluster File System (ACFS) was introduced in Oracle database 11gR2. ACFS is a general purpose single-node or cluster file system on top of ASM. ACFS canSEE DETAILS

OverviewIn one of previous article I have demonstrated how to configure ACFS on Exadata database running Oracle database 12.1.0.2 using standard ASM. Now I have an opportunity to configure Oracle GoldenGate on Exadata running Oracle database 12.2.0.1. So I have decides to configure ACFS on Exadata running Oracle database 12.2.0.1 using ASM Flex Architecture.In this article I will demostrate how to configure Oracle ACFS on Exadata Database machine running Oracle  Database 12.2.0.1 using Flex ASM. For details on ACFS and how to configure ACFS on Standard ASM look at mySEE DETAILS

Overview Oracle ASM disk groups are built on a set of Exadata grid disks. Exadata uses ASM disk groups store database files.  ASM Provides 3 Types of Redundancy: External: ASM doesn’t provide redundancy. External redundancy is not an option on Exadata. You must either use normal or high redundancy. Normal: It provides two-way data mirroring. It maintains two copies of data blocks in separate failure groups High: It provides three-way data mirroring. It maintains three copies of data blocks in separate failure groups In this article I will demonstrate howSEE DETAILS

Overview You can create a database on Exadata using DBCA or Manually using Create Database Command. Creating a database using dbca is easy and straight forward. Creating a database on Exadata is no different from creating a database on RAC. You will select the nodes on which you want to create the database. In Exadata since the storage option is only ASM, you must select to ASM for database files.Environment Exadata database machine Full Rack X5-2 8 Compute nodes, 14 Storage cells and 2 IB Switch Steps to create DatabaseSEE DETAILS

Overview Upgrading Grid Infrastructure and Database is a very lengthy process and it is obvious that you might encounter issues due to missing prerequisites or BUGS in the upgrade process. If you are lucky or if you meet all the prerequisites before starting the upgrade then it is possible that you might not fall in to issue. When I upgraded Grid Infrastructure recently from 11.2.0.4 to 12.1.0.2 I encountered an issue which was preventing me from upgrade the Database as a Cluster database. The entire GI upgrade process when smooth,SEE DETAILS

Overview In my previous article I have demonstrated how to Install and Upgrade Oracle Grid Infrastructure to 12.1.0.2 on Exadata Database Machine. Now it is time to Upgrade Database to 12.1.0.2.Take a look at the link below for the steps required to Install and Upgrade Oracle GI to 12.1.0.2:http://netsoftmate.blogspot.in/2017/03/exadata-upgrade-oracle-grid.htmlThis article covers the following steps: Install Database 12.1.0.2 Software  Upgrade Database to 12.1.0.2 using DBCA & Post Upgrade Steps Install Oracle Database 12.1.0.2 SoftwareOracle Database 12.1.0.2 software will be installed in a new Oracle Home without any downtime. The databases currentlySEE DETAILS </spa...