Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Oracle RAC Release Update 19.24 on RHEL8.10 Issues Whille applying the RU on base 19.3 Oracle RAC version on RHEL 8.10 we faced the below issue Error#1——– [root@oraclehost bin]# …
Read More »RAC Release Update 19.24 on RHEL8.10 Issues
Oracle ODA Reboots
Troubleshooting KVM Reboots on Oracle ODA Due to OOM Kills and HugePages Misconfiguration Recently, I encountered an unusual behavior in one of our Oracle Database Appliance (ODA) environments that I …
Read More »Implementing Class of Secure Transport (COST) in Oracle RAC 11.2
Implementing Class of Secure Transport (COST) in Oracle RAC 11.2 Introduction:Class of Secure Transport (COST) is a security feature introduced in Oracle Database 11g Release 2 (11.2) that enhances …
Read More »Disabling and Uninstalling AWR
Disabling and Uninstalling AWR (Doc ID 1909073.1) Some reference on it?– How To Avoid the AWR Usage Without Having Diagnostic Pack License (Doc ID 2276199.1)– Controlling Diagnostic and Tuning …
Read More »Disable SYS Auto Jobs from the Database
Disable SYS Auto Jobs from the Database ======================================== DBMS_AUTO_TASK_ADMIN.DISABLE still shows the client_name enabled in DBA_AUTOTASK_CLIENT view (Doc ID 1565768.1) for Reference: Disable database jobs (DBMS_SCHEDULER , AUTOTASKS and …
Read More »Switchover to Production ODA Environment
Switchover to Production ODA Environment Standby———- SQL> SELECT PROCESS FROM V$MANAGED_STANDBY WHERE PROCESS LIKE ‘MRP%’; PROCESS———MRP0 SQL> set lines 133 pages 133select database_role,db_unique_name,open_mode,protection_mode from gv$database; DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE PROTECTION_MODE—————- …
Read More »Configuring AdminServer for High Availability
Configuring AdminServer for HA 1. Check the current Network Configuration [root@test1 u01]# ifconfig -aens34: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500inet 192.168.131.200 netmask 255.255.255.0 broadcast 192.168.131.255inet6 fe80::250:56ff:feab:e4e prefixlen 64 scopeid 0x20<link>ether 00:50:56:ab:0e:4e txqueuelen …
Read More »How to Change Password file in Oracle RAC
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 »