Duplicate database until Point in Time recover, using backup location from RAC to single instance
Prepare by: Nurullah Sharif Scope: Point in Time Recovery Duplicate database until Point in Time recover, using backup location.…
7 years ago
CDB and PDB concepts in Oracle 12c
Oracle introduced PDB from 12c to minimize following drawbacks in 11g In 11g,sometimes we need to create numerous databases…
7 years ago
Index creation progress in oracle
----------Progress index creation-------------- set lines 200 col "Index Operation" for a60 select sess.sid as "Session ID", sql.sql_text as "Index Operation",…
7 years ago
Step by step Upgrade cloud control from 13cR1 to 13cR2 (13.2.0.0.0)
Prerequisites for Upgrading to Enterprise Manager Cloud Control 13c Release 2 1.First latest PSU patch needs to be applied in…
7 years ago
Oracle time stamp showing wrong timezone connecting TNS remote
Time stamp problem:- sqlplus system/****@ORCL SQL>alter session set nls_date_format='dd-mm-yyyy hh:mi:ss'; SQL>select instance_name from v$instance; SQL>select sysdate, current_timestamp, …
7 years ago
PostgreSQL Database Backup to S3 and Restore from S3 using simple shell script
Following topic will discuss how to Backup and Restore PostgreSQL Databases directly in S3. This topic will help you to…
7 years ago
BASIC SQL REFERENCE FOR ORACLE DBA
OVERVIEW OF SQL Please create the scott schema from the following GITHUB repository //github.com/oracle/dotnet-db-samples/blob/master/schemas/scott.sql EXECUTING SELECT STATEMENT SQL> SELECT *…
7 years ago
Error undefined symbol: JNU_ThrowByName during oracle 12c R2 installation
We faced this error during Oracle12cR2 installation. During our installation of oracle 12.2 in new home on existing Oracle 11g…
7 years ago
Add additional swap space in RHEL 7
This document describes process to add additional swap space in RHEL 7. 1.First partition your newly added disk [root@LinuxAcademy dev]#…
7 years ago
Extend LVM after adding new disk to the server Linux
This document describes the procedure to extend your existing mount point after adding the disk in RHEL 7 using LVM.…
7 years ago