0
Login/Register

Month: June 2025

  • Home
  • Month: June 2025
Shape Image One

Oracle DBA Interview Questions

Oracle DBA Interview Questions What are the different responsibilities of a Oracle DBA? Answer: Oracle DBA is the database administrator who performs all administrative tasks. Administrative tasks include:1 .User-level administration i.e. creates users, remove existing users or modifies user permissions.2 .Maintains database security.3 .Manages database storage & objects.4 .Tunes performance of a database.5. Performs backups &

Oracle 19C Dataguard installation using Active Duplicate Method

📦 Oracle 19C Dataguard installation using Active Duplicate Method In this blog , we will learn about the oracle 12c dataguard installation using active duplicate method. We are using oracle enterprise linux as database server PRIMARY STANDBY Hostname : node1.learnomate.org node2.learnomate.org IP 192.168.56.50 192.168.56.60 DB Unique Name node1 node1 We are assuming that primary database

Upgrade 12.2.0.1 to 19c Oracle Database Manually

📄 pgrade from 12.2.0.1 to 19 Assume that , 12c Already Installed Steps to upgrade Database ======================== 0. Check Compatibility Before Upgrading Oracle Database 1. Environment PRE-UPGRADE TASKS2. Backup3. Run preupgrade script4. View Preupgrade log5. Minimum tablespace sizes for upgrade6. Update INITIALIZATION PARAMETERS7. Gather DICTIONARY STATS8. Purge Recyclebin9. Refresh MVs10. Run preupgrade_fixups.sql11. Verify archive log

ASM Installation

ASM Installation ASM on vmware workstation   Prerequisites:- Step 1: Set up Oracle Database Server on VMware Workstation using( OEL) Linux 7.6 OS Platform? Step 2: Connect to OEL 7.6 server via putty and install the below packages 1  yum -y install -y oracle-database-preinstall-19c 1 yum -y install oracleasm* 1 yum -y install kmod-oracleasm* Add below OS

Patching Process In Oracle

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

RMAN oracle database 12c backup script

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

Oracle Data Pump (EXPDP & IMPDP)

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

Tablespaces in oracle database | Tablespaces script

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

Oracle User Management

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

LISTENER

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