Creating LVM In Oracle Linux 1. Ask the System Admin to add a raw disk into the Server 2. Check if the new RAW disk is available / …
Read More »How to redact a Column in a Table Object in Oracle Database 19c
How to redact a Column in a Table Object in Oracle Database 19c Important Considerations 1. Oracle Redaction use requires license for Oracle Advance Security for Oracle Database2. Identify the …
Read More »Oracle Home 19c Cloning
Oracle Home 19c Cloning 1. Check the groups assigned to the Oracle Home owner [oracle@test ~]$ . db.env[oracle@test ~]$ cd $ORACLE_HOME/rdbms/lib/[oracle@test lib]$ cat config.c |grep define/* SS_DBA_GRP defines the …
Read More »RAC Release Update 19.24 on RHEL8.10 Issues
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 »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 »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner