How to check and implement best practice for Oracle Database 11g onwards
Author: Saibal Ghosh About author: I am an Oracle professional with twenty plus years of experience and have deep knowledge […]
General DBA
Backup and Recovery, Cloning
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.
oracle 12c
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
SCRIPTS
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”,
cloud control 13c
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
Troubleshooting
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,
AWS, PostgreSQL, SCRIPTS
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
PLSQL for DBA
BASIC SQL REFERENCE FOR ORACLE DBA
OVERVIEW OF SQL Please create the scott schema from the following GITHUB repository https://github.com/oracle/dotnet-db-samples/blob/master/schemas/scott.sql EXECUTING SELECT STATEMENT SQL> SELECT *
Troubleshooting
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
Linux
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]#