RAC

Relocating enabl database for oracle 19c

by

Relocating enabl database for oracle 19c 1:- After the upgrade add this hosting members as below $GRID_HOME/bin/crsctl modify resource ora.enabl.db -attr “HOSTING_MEMBERS=’server01 server02′ PLACEMENT=’favored'” -unsupported 2:- Create directories as show below and copy the tns enties on db1 mkdir -p /u01/app/oracle/diag/rdbms/enabl/enabl1/trace 3:-Relocate the enabl database to db1 crsctl relocate resource ora.enabl.db -c server01 -f -unsupported … Read more

Connect String

by

This property specifies connection information used to connect to an Oracle database. The Oracle installer generally places a sample tnsnames.ora file in your $ORACLE_HOME/network/admin directory, but you can see many sample tnsnames.ora file for use as a template. 

Change Archivelog Destination (FRA)

by

Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database. It can be done in up are running condition of DB . No downtime required.  For Real application cluster(RAC): In RAC, the archive destination is pointed to an ASM diskgroup. Change the archive destination: Before pointing the … Read more

RAC Tools

by

Cluster Verification Utility (CVU) … Oracle Enterprise Manager … SQL*Plus … Server Control (SRVCTL) … Database Configuration Assistant … Fleet Patching and Provisioning … Cluster Verification Utility (CVU): CVU is a command-line tool that you can use to verify a range of cluster and Oracle RAC components, such as shared storage devices, networking configurations, system … Read more

Categories RAC

ASH (Active Session History) Report in Oracle

by

Oracle ASH report introduced in Oracle 10g release 2. ASH collects samples of active sessions every second (waiting for non-idle events, or on the CPU working) from v$sessions (inactive sessions are not captured). You can run ASH reports to analyze transient performance problems with the database that only occur during specific times. This technique is … Read more

Flush SQL Statement from Shared Pool

by

If you flush the shared pool, all the statements in cursor will be flushed. Sometimes it is required to flush the bad SQL_PLAN from shared_pool so that new (or old) better execution plan can be picked by SQL_ID So if you want a SQL query to do hard parsing, then you can flush the particular … Read more