Category Archives: Uncategorized

The following tables list the required MINIMUM values according to the oracle documentation. Parameter name in /etc/sysctl.conf Description MINIMUM value kernel.sem “semmsl semmns semopm semmni” kernel.sem:semmsl total semaphores for each set 250 kernel.sem:semmns total number of semaphores systemwide 32000 kernel.sem:semopm Maximum number of operations for semop call 100 kernel.sem:semmni total semaphore sets 128 kernel.shmall total …

Continue reading “Parameter Values required by Oracle according to the documentation”

Oracle recommends that you collect and save CBO statistics and swap them whenever you see a major change in workloads. The dbms_stats export and import utilities are perfect for matching your statistics to a changing workload. You can use the Oracle dbms_stats and export utilities to migrate schema statistics from your PROD instance to your TEST instance. …

Continue reading “Export Import Optimizer Statistics”

Flashback table feature is used to return a table to the Past. This feature as a DBA so often, because developers or business IT staffs are able to drop some tables by mistake, so if flashback is on, we can return this table to the past with flashback table feature. In order to use this …

Continue reading “Flashback Table in Oracle Database”

Dataguard is Oracle’s Disaster Recovery solution.You can open dataguard  in case of a disaster and make the database available as soon as possible. You can perform switchover between production database and dataguard, in case of any disaster or any maintenance (ram, disk exchange etc) on the server on the Production side. This operation we call …

Continue reading “Dataguard Switchover in Oracle”

Complementary specialization is the approach that NetApp takes with NetApp® Active IQ®, Cloud Insights, and Active IQ Unified Manager (formerly OnCommand® Unified Manager). Each has a differentiated purpose, but they’re complementary products that help you simplify monitoring, management, protection, and optimization of your hybrid multicloud infrastructure. At a high level, I think of these products …

Continue reading “How to simplify management of your NetApp environment”

Step 1: Hardware setup Steps to Setup Cluster Mode Netapp  First step is to unpack your package (Hardware Parts). Netapp hardware package will come all parts are individually. Separate all the hardware parts and select the position of Racking space from Netapp rack. Then attach the racking kit to the rack and load the chassis. …

Continue reading “Steps to Setup Cluster Mode Netapp”

SnapMirror Volume Replication Setup The following section discusses in-depth the steps to setup ONTAP SnapMirror Volume Replication using OnCommand System Manager. Set up peering between the Source and Destination Cluster and SVM. For information on setting cluster and SVM peering, refer the following documentation. Create a protection policy which controls the behavior of the relationship and …

Continue reading “Disaster Recovery Workflow Using ONTAP SnapMirror Volume”

We have recently upgraded our database from 11g to 12c. And when one of the developer ran some job, the job got killed and got the below error in log. These jobs were running fine in 11g without any issues. ORA-00028: your session has been killed ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMITPGA …

Continue reading “ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT”

Transparent Data Encryption (TDE) feature was introduced for the first time in Oracle 10g R2. TDE can be used in Enterprise edition and is a feature that can be used with the Advanced Security license. It  provides mechanism to encrypt the data stored in the OS data files. TDE enables the encryption of data at the …

Continue reading “Transparent Data Encryption in Oracle”

Getting error while installing Oracle 12C: [FATAL]  [DBT-08001] Unable to check for available memory. [FATAL] [DBT-08002] Unable to check the value of kernel parameter {0} Basically this error comes in while installing Oracle DB on RHEL. We can consider it as a BUG. Resolution: Then Install again and will resolve this issue: ******************************************************************** Our Website : https://www.ksplsoft.com/ …

Continue reading “Error while installing Oracle 12C DBT-08001 & DBT-08002”