Enable Trace and take tkprof
Introduction Steps to see how to enable trace and tkprof Posted by Sakthi Sethu Perumal Step 1 : Check Request ID from Find Concurrent request screen (In my case Request…
Read MoreAdd,drop and rebalance ASM diskgroups
Introduction Steps to see how we can add, drop and rebalance diskgroups Posted by Karthick Adding Disks to a Disk Group ALTER DISKGROUP DATA_DG ADD DISK ‘/devices/DiskA1’,’/device/DiskB1’; Dropping Disks and Disk…
Read MoreHow to add the disk to existing diskgroups
Introduction Steps to add new disk to existing groups. Posted by Karthick Steps: Connect as sqlplus / as sysasm; TO CHECK DISKGROUP NAME: select group_number,name from v$asm_diskgroup; GROUP_NUMBER NAME ———— —————————— …
Read MoreOracle – Data Guard Broker Setup
Introduction Steps to configure Oracle – Data Guard Broker Posted by Sundaravel Ramasubbu In this document, Primary Server: Chennai Secondary Server: Trichy Primary DB Unique Name : PROD_DGP Standby DB Unique…
Read MoreSteps to Modify Scan listener port number
Introduction Steps to Modify Scan listener port number using a different port than default for the listener Posted by Selvakumar Raja Due to security reasons some of environment require using a…
Read MoreEnable SQL Trace in Oracle Apps R12
Introduction SQL trace can be enabled in any E-Business module via different ways. The following table shows all possible ways for enabling trace in a form, self-service page, concurrent program,…
Read MoreReparing the OCR
Introduction we can use ocrconfig -repair command to repair ocr configuration on a node which was not up when the configuration was modified on the other nodes. Posted by Pushparaj Current…
Read MoreSGA Resizing history
SGA resizing history Summary You can find all the resizing history of the SGA by querying the view V$SGA_RESIZE_OPS. As you know if you have set the parameter sga_target then…
Read MoreSteps to create ORACLE_HOME after copying oracle binaries from source to destination.
WE ARE GOING TO COPY THE ORACLE BINARIES FORM SOURCE TO DESTINATION. Step 1 : Tar the ORACLE_HOME in the source instance. tar -cvf /DUMP_TABLE/backup/11203_PROD.tar /prddb01/oracle/PROD/db/tech_st/11.2.0.3/ Step 2 : Scp…
Read MoreImport fails with ORA-39126,ORA-06512,ORA-01403
WE ARE GOING TO SEE THE IMPORT FAILURE with ORA-39126,ORA-06512,ORA-01403 . Cause: The issue happen when we migrate using export from 11gR2 windows and import it in 12cR2 Linux server.…
Read More