Difference between Oracle 11g and 12c upgrades

Difference between Oracle 11g upgrade and 12c upgrade While running main upgrade script there is a difference between 11g upgrade and 12c upgrade. 11g upgrade $cd $ORACLE_HOME/rdbms/admin/ SQL> @catupgrd.sql  

CRS-6706: Oracle Clusterware Release patch on RAC

Error: CRS-6706: Oracle Clusterware Release patch level (‘689998692’) does not match Software patch level (‘3507432230’). Oracle Clusterware cannot be started. CRS-4000: Command Start failed, or completed with errors.   Solution

Oracle ASM configuration on RHEL 8 version

Oracle ASM configuration on RHEL 8 version.   Overview of the activity: Oracle 19c databases were running on RHEL 7.9 Before upgrade below packages were installed related to ASM. rpm

Purpose of Individual local users in administration

Advantages of Individual local users In database administration, having individual local users serves several important purposes: Granular Access Control: Local users allow for fine-grained control over permissions within a database. By

Connectivity with load balancer names in Oracle

Connection string in Oracle Server Active Passive setup   In active Passive OS cluster setup, we use load balancer names for connecting the databases on active hosts. For example, we

Oracle commands Vs PostgreSQL commands

  Oracle commands Vs PostgreSQL commands Feature/command Oracle Commands PostgreSQL Commands  Switch connection to a new database SQL>alter session set container=pdb1;  postgres=# \c test1  List available databases SQL> show pdbs

Oracle RAC DBA Interview Questions

Oracle RAC DBA Interview Questions. Question Which daemon is used to ensure the time synchronization between RAC nodes? Answer ctssd  — Oracle Cluster Time Synchronization daemon Question On a rac

Oracle Data Guard Interview Questions

Oracle Data Guard Frequently Asked Questions (FAQ). Question What is meant by real time apply in DataGuard  environment? If the transactions from Primary to secondary are applied by using the