Patching Process In Oracle 1 [oracle@node1 ~]$ mkdir-p /data/patch 2 . By Winscp move the patch zip file to /data/patch this location. 3. Now check the current opatch version. 123 [oracle@node1 ~]$ $ORACLE_HOME/OPatch/opatch versionOPatch Version: 12.2.0.1.17OPatch succeeded. #if the opatch version is old , then you have to replace it with the latest version. here it
admin
RMAN oracle database 12c backup script Change RMAN backup location configure channel device type disk format ‘/data/backup/%U’ maxpiecesize 2 G; SPFILE backups The SPFILE can be automatically backed up with the control file during database backups by configuring the CONTROLFILE AUTOBACKUP parameters To backup up the SPFILE explicitly use: RMAN> BACKUP SPFILE; Controlfile backups The
admin
Oracle datapump utility -EXPDP IMPDP In this post we will be looking for logical backup of oracle database. datapump (EXPDP and IMPDP) utilties are used to take import and export of oracle databases. Mode of Datapump Use of Datapump Create Directory and Grant permission on directory. 1 CREATE OR REPLACE DIRECTORY test_dir AS ‘/data/backup’; 1
admin
Tablespaces in oracle database | Tablespaces script Script for Tablespace current utilization. 1234567891011121314151617181920212223242526272829303132 set linesize 1234 pages 1234col tablespace format a24col free heading ‘Free(Mb)’ format 99999999.9col total heading ‘Total(Mb)’ format 999999999.9col used heading ‘Used(Mb)’ format 99999999.9col pct_free heading ‘Pct|Free’ format 99999.9col largest heading ‘Largest(Mb)’ format 99999.9compute sum of total on reportcompute sum of free on
admin
Oracle User Management User Management in Oracle In this Blog , we will see Different types of users in Oracle. Starting from Oracle 12C , there are two types of user. Common user Local User COMMON USER: A common user is a DB user, which work perform an activity in all the containers including root container of
admin
The Databases/services needs to be registered with listener in order to establish connection.There are two types of registration Namely  1.Dynamic Registration 2.Static Registration Dynamic registration : As the name suggests,dynamic means the Database/Service registration is done Automatic. As soon as the listener is started Automatically the dynamic registration happens which is TRUE .but it will
admin
Oracle 19c Database Installation (on Oracle Linux 7.6) on VMware Workstation Section-1 Download and unzip Oracle 19c Software Create a staging directory Description Command / Details / Screenshots let’s create a staging directory for all oracle software Login to server as oracle Create a new staging directoryWhat is the Staging Directory?It is temporary directory to
admin
Install VirtualBox Guest Additions on OEL | Kernel Headers Not Found For Target Kernel Update all packages 1 yum update -y Install below Package 1 yum install kernel-header* glibc-header* glibc-devel* gcc-4* cpp* kernel-uek-devel* -y 1 yum -y install kernel-uek-devel-`uname -r` Reboot Server Run the vbox edition 1 [root@node1 VBox_GAs_6.1.32]# ./VBoxLinuxAdditions.run Go to virtual box setting
admin
🖥️ Oracle Enterprise Linux 7.9 Installation – A Complete Step-by-Step Guide ORACLE ENTERPRISE LINUX (OEL 7.9 ) INSTALLATION 1. Download Virtual box : Download & Install Latest virtual box on windows machine. 2. Download LINUX 7.9 iso files Goto google.com -> edelivery.oracle.com Click on Sign In Login with Your Credentials Search with oracle linux It is
admin
Introduction to Big Data: Database, Data Warehouse, and Data Lake In today’s data-driven world, organizations generate and manage massive volumes of data. To effectively store, process, and analyze this data, different systems have evolved — each with its own purpose and structure. In this blog, we’ll explore the fundamentals of three key data systems: Databases, Data Warehouses,
admin
Your information will never be shared with any third party
