Oracle RMAN is a important tool used in Backup and recovery. Whenever you use RMAN tool in $ORACLE_HOME/bin and connect to database, it makes multiple connection to the database.Here are RMAN connection decoded Whenever we make RMAN connection to database for backup with or with out catalog,many processes are spawned and worked upon. RMAN always spawns …
Oracle RMAN connection decoded Read More »
1)Distributed AD offers improved scalability, performance, and resource utilization by allowing workers of the same AD session to be started on additional middle tier systems. 2)AD has always utilized a Parallel Jobs System, where multiple AD workers start and are assigned jobs. Information for the Jobs System is stored in the oracle database, and workers …
How to use Distributed AD to decrease the patching time in Oracle EBS Read More »
Here are ASM best practices to add disks which should be always used to manipulate the ASM disks (1) First check the newly added disk is visible in ASM disks select header_status,path from v$asm_disk where path= ‘<path>’; It should show the candidate (2) Create a new temporary diskgroup using those disks CREATE DISKGROUP TEST_DISK EXTERNAL REDUNDANCY …
When Oracle Instance is not running /u01/app/oracle/product> sysresv IPC Resources for ORACLE_SID “TEST″ : Shared Memory ID KEY No shared memory segments used Semaphores: ID KEY No semaphore resources used Oracle Instance not alive for sid “TEST″ When Oracle Instance is running /u01/app/oracle/product> sysresv IPC Resources for ORACLE_SID “TEST″ : Shared Memory: ID KEY 14437 …
how to find the semaphore for the Database instance Read More »
Introduction approx_count_distinct is the new function included in 12c to estimate the distinct values in the column in a faster manner without deviating much from actual values. It returns approximate number of rows that contain distinct values of expression. approx_count_distinct Definition We know that it take considerable time to project desired output using traditional COUNT(DISTINCT) …
We have a Grid Infrastructure Oracle Restart configuration on one oracle database server and Now we want to change the host-name of the server. Here we will be seeing the steps required to perform it without any loss of the database. Configuration Old Host Name: techgo New Host name: techgo-new Stop all the services $<11.2 …
Oracle Restart Configuration: How to change Hostname Read More »
