Auto Added by WPeMatico
By Akinola Idris, Hardy Chuks July 10, 2019 Future-proof your database with one of these awesome cloud providers Databases are just as an important part of cloud services as with normal IT operations. However, there are a variety of different ways that data can be stored for different database types, and the chances are that you’ll need…
Server virtualization currently is a trending topic in the IT world. Its popularity and adoption keeps growing, especially in enterprise environments. What makes virtualization possible are hypervisors. Server virtualization allows different operating systems running separate applications on one server while still using the same physical resources. These virtual machines make it possible for a system and…
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…
Oerr is an Oracle utility that extracts error messages with suggested actions from the standard Oracle message files. This utility is very useful as it can extract OS-specific errors that are not in the generic Error Messages and Codes Manual. Many Oracle products on UNIX have a utility called OERR that can be used to aid error investigation.…
Transparent Data Encryption (TDE) provides mechanism to encrypt the data stored in the OS data files. TDE enables the encryption of data at the storage level to prevent data tempering from outside of the database. New commands has been introduced in oracle 12c for enabling Transparent data encryption. ADMINISTER KEY MANAGEMENT will replace the previous commands like ALTER…
First of all, What is a Load Balancer A load balancer can be deployed as software or hardware to a device that distributes connections from clients between a set of servers. A load balancer acts as a ‘reverse-proxy’ to represent the application servers to the client through a virtual IP address (VIP). This technology is…
In this below tutorial, we will setup one-way goldengate replication for below two tables from database SRCDB to TRGDB. PRESPLAY.EMP; PRESPLAY.DEPT; PREREQUISITE: Make sure the goldengate installation is completed and manager process is running on both source and target hosts. 1. Enable supplemental logging for those tables.[SOURCE] 2. Prepare extract parameter file[ SOURCE ] Here –…
Below are the steps for adding a new table to the existing extract and replicat. In this example, we will add PRESPLAY.SAL table to existing replication. 1.stop extract and pump process [ SOURCE] GGSCI > info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:00 EXTRACT RUNNING…
ADRCI is the command line interface for diagnostic utility used for viewing diagnostics data like listener log , alert log ,incident and cor dump etc and creating incident packages. Below are the the list of useful commands. 1. Get current base location:( Also known as ADR_BASE) adrci> show base ADR base is “/u01/app/oracle/” 2. Set new…
by Jim Okla January 27, 2015 Posted in: How To I recently came across a very unusual situation. During an upgraded review, I noticed the dba_registry_sqlpatch was empty when it shouldn’t be: SQL> select patch_id, patch_uid, version, action, action_time, status, description from dba_registry_sqlpatch; no rows selected SQL> The expected output should be (from another CDB…