Changing Password file in Oracle RAC 1. First check the current configuration of the system and the password file location . [oracle@rac1-test ~]$ srvctl config database -d testdbDatabase unique …
Read More »Implement in-memory in your RAC database
Implement in-memory in your RAC database Oracle has provided In-memory feature at base_level for free. You use 16GB allocation limit for this feature to be used without the licence. …
Read More »Configuring EM Express on 19c Rac Database
Configuring EM Express on 19c Rac Database SQL> select dbms_xdb_config.getHttpPort() from dual; DBMS_XDB_CONFIG.GETHTTPPORT()—————————–0 SQL> select dbms_xdb_config.getHttpsPort() from dual; DBMS_XDB_CONFIG.GETHTTPSPORT()——————————0 SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); PL/SQL procedure successfully completed. SQL> select dbms_xdb_config.getHttpsPort() …
Read More »Updating OS in Oracle RAC
Updating OS in Oracle RAC running on Azure using Flashgrid Software In this blog post we will talk about on how to update the OS for nodes running Oracle RAC …
Read More »April CPU JDK Upgrade on DB
April CPU JDK Upgrade on DB and Grid Homes in Oracle 19c Real Application Cluster Setup Current Version:- GRID HOME:- grid> cd $GRID_HOME/jdk/bin grid> ./java -version java version “1.8.0_311” …
Read More »Manually remove ODA DB HOME
Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. Check if any running jobs currently: # odacli list-jobs. 2. If none, then stop the …
Read More »Removing Old Grid Home
Manually Remove an Old Grid Home After Upgrading/Patching to a Higher Grid Home on ODA 1. Check the components and their versions [root@testlinux ~]# odacli describe-componentSystem Version—————19.20.0.0.0 System node Name—————testlinux …
Read More »Materialized View refresh error
Materialized View refresh error generating huge Archive Logs after Database Upgrade to 19c. Issue:- A huge amount of archive log generation when materialized view refreshing after database upgrade from 11g …
Read More »ODA Space Utilization Issue
Oracle Database Appliance Space Utilization Issue One of the basic issue when having ODA (Oracle Database Appliance) system is space utilization in /opt mount point. Recently I was facing …
Read More »Switchover MySQL
Switchover MySQL Source 199Replica 198 SOURCE SET GLOBAL read_only=ON; set global super_read_only=ON; show variables like '%super%read%'; show variables like '%read_only%'; flush tables;flush logs; SHOW MASTER STATUS; REPLICA stop slave; …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner