2 min read
Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as...
RAC
2 min read
2 min read
Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private...
4 min read
Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for...
4 min read
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage...
5 min read
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name...
1 min read
While trying to rollback the conflicting patch 18893947 applying patch 21967332 $ opatch rollback -id 18893947 Oracle Interim Patch Installer...
7 min read
What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each other, so that they appear...
15 min read
SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle Database. A SQL profile is a database...
6 min read
IN PRIMARY DATABASE :- 1) Check Instance details :- select status,instance_name,database_role from v$database,v$instance; ------------------------------------------------------------------------------------------------------------------------------------ 2) Check redo log and standby...
2 min read
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be used to improve performance. It...
1 min read
CAUSE ALTER TABLESPACE TB1 add datafile '+WHALE_DG1' size 10g autoextend on next 500M * ERROR at line 1: ORA-00059: maximum...
3 min read
It is small xml file located in $GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is used to establish the correct global...
1 min read
Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster . It should have a...
3 min read
Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways...
2 min read
During the Creation of database via DBCA , SPFILE is created in the file location that we specify. This location...
1 min read
Grid-Installation-ASRBLG-1Download Hope it helped !! :)
1 min read
SQL> select comp_id, status, version from dba_registry; COMP_ID STATUS VERSION ------------ ----------- -------------- CATALOG INVALID 11.2.0.3.0 CATPROC INVALID 11.2.0.3.0 SQL>...
3 min read
Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid User # useradd -u 54331...
2 min read
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done...
9 min read
Check the status of the cluster $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready...
1 min read
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...
1 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
This property specifies connection information used to connect to an Oracle database. The Oracle installer generally places a sample tnsnames.ora...
1 min read
