foalabs

Smart Savings:Optimizing Cloud Costs Through Service Shutdown-Automatic Script to Stop and Start My DB System DBCS on OCI Cloud providers offer a pay-as-you-go model, allowing businesses to scale resources up and down based on demand. While this elasticity is advantageous, it also necessitates careful management to prevent unnecessary expenditure. Many services run 24/7 by default, consuming resources even during periods of inactivity. Here's where the concept of "service shutdown" becomes a powerful strategy. Implementing Service Shutdowns 1. Analyze Usage Patterns: Identify usage patterns for various services to pinpoint periods of low demand. Utilize cloud monitoring tools to gain insights into when services are least active. 2. Set Up Automation: Leverage automation tools and scripts to schedule service shutdowns during predefined time frames. Automation ensures consistency and reduces the chances of human error. 3. Monitor and Adjust: Continuously monitor the impact ...

Step-by-Step Guide to Installing Chrony on Linux 8 Chrony is a time synchronization tool for Linux 8 that ensures accurate and consistent timekeeping across networked devices. It surpasses the conventional Network Time Protocol (NTP) by mitigating network delay variations, resulting in superior accuracy. Chrony is particularly useful in cloud environments where IP addresses can change dynamically, ensuring smooth transitions without abrupt time shifts. By leveraging hardware timestamping and innovative features, Chrony optimizes time synchronization, enhancing the reliability and efficiency of your system. In this article, I will provide a, step-by-step walkthrough for installing Chrony on a Linux 8 system, empowering you to enhance time synchronization in your environment.  Prerequisites: A Linux 8 system (e.g., CentOS 8, RHEL 8). Administrative privileges (sudo or root access). Step 1: Update Package Repositories: Open a terminal. Update the package repositories using the follow...

Oracle Cloud OS Management Service: Simplifying and Streamlining OS Management on OCI Compute The Oracle Cloud OS Management Service is a powerful tool designed to streamline the management of operating systems (OS) on virtual machines in Oracle Cloud Infrastructure (OCI). This service provides administrators with the ability to automate tasks related to OS updates, patching, configuration, and monitoring. In this article, we will delve into the features, benefits, and step-by-step guide to setting up the Oracle Cloud OS Management Service. Features and Benefits: Automated OS Updates: The service automates the process of applying updates, security patches, and bug fixes to your VM instances. Centralized Management: Administrators can manage OS updates and patches across multiple VM instances from a single, centralized location. Configurable Policies: Define policies to control when and how updates are applied to VM instances. Security Enhancement: Keep your VM instances up to date w...

Understanding ORAENV_ASK in Oracle: Managing Environment Variables In Oracle database administration, managing multiple instances on a single machine can be challenging. The oraenv script is a valuable tool provided by Oracle to streamline the process of setting environment variables for different Oracle instances. The behavior of this script can be influenced by a variable called ORAENV_ASK, which determines whether or not the script will prompt for input during the environment setup process. What is ORAENV_ASK? ORAENV_ASK is an environment variable that potentially affects the behavior of the oraenv script. While not a standard Oracle variable, its possible purpose is to control whether the script asks for user input when configuring environment variables for an Oracle instance. When set to "yes," the script may prompt for input. When set to "no," the script might avoid interactive prompts and could use predefined values or defaults. Using ORAENV_ASK Setting ORAEN...

Shell Script for Daily to Identify New Invalid generated daily in Oracle Database In this post, I am sharing a shell script to daily identify if there are any new invalids generated in oracle database. You can modify and change as you want. Scripts: vi invalids.sh #!/bin/bash # Set environment variables (adjust as needed based on env) export ORACLE_SID=FOA12 export PATH=$ORACLE_HOME/bin:$PATH export ORAENV_ASK=NO #Mail functionality RECIPIENTS=support@funoracleapps.com send_mail() { mailx -s "New Invalid Objects Detected" ${RECIPIENTS} < mail_body.txt } # Directory to store previous invalids list PREVIOUS_INVALIDS_FILE="/tmp/previous_invalids.txt" # Directory to store current invalids list CURRENT_INVALIDS_FILE="/tmp/current_invalids.txt" # Get current invalid objects sqlplus -S "/as sysdba" <<EOF SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SPOOL $CURRENT_INVALIDS_FILE SELECT object_name FROM dba_objects WHERE status =...

In Place Upgrade for an EBS 12.1.3 database 12c to 19c Multitenant in DBCS(DB System) on OCI In this article I am explained in demo how I upgraded an 12c database on OCI to 19c. This is inplace upgrade which means on same DBCS system without creating/migrating any other DBCS system. This is totally based on experience and method. Always test the method in your development environment before trying it in live production environment. System Information: EBS : 12.2.7 Database: 12.1.0.1 DBCS Linux version: 7.9 Target database version.19.19 Where ever # sign is before the commands , means I have run the commands from root user. You should know some dbcli basic commands As per your environment and setup their might be additional steps required. 1) Apply the pre-requisites patches on EBS a) Apply code level AD/TXK patches - 33600809, 33602997 Copy adgrants.sql to Database $ORACLE_HOME/appsutil/admin . /u01/app/oracle/product/12.1.0.2/dbhome_1/TEST19C_foaserver.env export ORACLE_PDB_SID=TEST19...