Posts

Installation of Oracle AI Database Enterprise Edition

Phase 1: VirtualBox 7.2.20 Machine Setup 1. Download Oracle VirtualBox-7.2.20-175154-Win and Linux ISO image.  2. Install Oracle VirtualBox-7.2.20 2. Open Virtual Box -> Machine -> New  VM Name: OradbVM001 ISO Image: select downloaded image Select: Memory Size, No. of CPUs, Disk Size  VM Setting -> Network -> Adapter1 (Bridge) -> Adapter2 (NAT)  Phase 2: Installing Oracle Linux 10 U2 (Guest OS) Start the VM -> Choose Install Oracle Linux 10  ->  Installation Destination (Storage Partitioning) Choose Custom/Advanced LVM partitioning. /boot:  1 GB, ext4 swap:  8 GB   / root partition: 40 GB, xfs /u01: 100GB,  xfs Create your root password -> create a basic user account ->  Begin Installation -> Complete Phase 3: Preparing the Operating System 1. Update Host Table ( /etc/hosts) with hostname  2.  Execute Pre-Installation Routine dnf update -y dnf install -y oracle-ai-database-preinstal...
Post a Comment
Read more

RMAN Backup Setup

Backup Type: Archive Log Interval: Every 2 Hours Schedule Time: 2, 4, 8, 10, 14, 16, 22 Retention: 1 Day Compression: Yes Backup Type: Incremental (Level 1) Interval: Every 6 Hours Schedule Time: 6, 12, 18 Retention: 1 Day Compression: Yes Backup Type: Cumulative (Level 1) Interval: Daily Schedule Time: 0 (Midnight) Retention: 1 Week Compression: Yes Backup Type: Full (Level 0 Baseline) Interval: Weekly Schedule Time: Sundays at 20 (8 PM) Retention: 1 Month Compression: Yes Backup Directory: /backup/rman_backup  Script Directory: /home/oracle/scripts/rman_scripts Log Directory: /home/oracle/scripts/logfile  Step#1: Create a backup script file  # vi  /home/oracle/scripts/rman_scripts/rman_backup.sh  #!/bin/bash # Set up Oracle environment variables (Verify these match your env) export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 export ORACLE_SID=orcl export PATH=$ORACLE_HOME/bin:$PATH BACKUP_TYPE=$1 LOG_FILE="/home/oracle/scripts/lo...
Post a Comment
Read more

Table Storage

### BFILE ### 1. Setup the OS Directory in Oracle SQL> CREATE OR REPLACE DIRECTORY external_images_dir AS '/u01/app/oracle/oradata/os_images/';  SQL> GRANT READ ON DIRECTORY external_images_dir TO user1; 2. Create the Table Structure SQL> CREATE TABLE product_catalog (  product_id NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,  product_name VARCHAR2(100),  sku VARCHAR2(50),  image_file BFILE  ); 3. Inserting Data SQL> INSERT INTO product_catalog (product_name, sku, image_file) VALUES ('Running Shoes', 'RS-990', BFILENAME('EXTERNAL_IMAGES_DIR', 'shoes_v1.jpg')); ### Create Partition Table with Day Wise Interval Partition ### 1. Create Table  SQL> CREATE TABLE product_catalog_p ( product_id   NUMBER GENERATED BY DEFAULT AS IDENTITY, roduct_name VARCHAR2(100), sku VARCHAR2(50), image_file   BFILE, created_date DATE DEFAULT SYSDATE NOT NULL, -- The primary key must include the partition key if you want a local index...
Post a Comment
Read more

Oracle AI Database 26ai Free and Bucket Configuration in Linux Server

Step 1: Install the Oracle Preinstallation RPM wget https://yum.oracle.com/repo/OracleLinux/OL10/appstream/x86_64/getPackage/oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64.rpm dnf install -y oracle-ai-database-preinstall* wget https://download.oracle.com/otn-pub/otn_software/db-free/oracle-ai-database-free-26ai-23.26.3-1.el10.x86_64.rpm sudo dnf clean all sudo dnf install -y oracle-ai-database-free-26ai-23.26.3-1.el10.x86_64.rpm To configure Oracle AI Database Free,  sudo chown -R oracle:oinstall /u01 sudo chown -R oracle:oinstall /opt/oracle sudo chmod -R 775 /u01 sudo chmod -R 775 /opt/oracle /opt/oracle/product/26ai/dbhomeFree/root.sh Modify the parameters in '/etc/sysconfig/oracle-free-26ai.conf'  Run '/etc/init.d/oracle-free-26ai configure' as root. # --- Oracle Database 26ai Environment Variables --- export ORACLE_SID=FREE export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/opt/oracle/product/26ai/dbhomeFree export TNS_ADMIN=$ORACLE_HOME/network/admin exp...
Post a Comment
Read more

HTTPS Configuration in Linux Using Nginx

   User    ->  Cloudflare CDN (SSL/TLS Encryption, Edge Firewall, DDoS Protection)  ->  Contabo VPS (Nginx Reverse Proxy over port 443 only) Step 1: Cloudflare DNS & Basic Security Setup 1. Purchase a domain  2. Log into your domain registrar.  go to DNS > Records and add two records: Type: A | Name: @ | IPv4 address: YOUR_CONTABO_VPS_IP | Proxy status: Proxied (Orange cloud) Type: A | Name: www | IPv4 address: YOUR_CONTABO_VPS_IP | Proxy status: Proxied (Orange cloud) Step 2: Cloudflare Strict SSL & Origin Certificates Cloudflare ->  SSL/TLS > Configure ->   Encryption mode to Full (strict) . SSL/TLS > Origin Server  ->  Create Certificate . Keep the default settings (valid for webserver.com and *.webserver.com ). ->  Create . Copy  Origin Certificate and a Private Key in  text files require during Nginx configuration. Step 1: Install Nginx, ...
Post a Comment
Read more