Install Oracle Apex 5.1.x, 18.1 on ORDS 3,17.4, 18.1

Oracle Apex is a modern framework to quickly develop and deploy web apps sitting on top of Oracle Database. Apex can be run directly from the database engine itself using a component called Mod PL/SQL. It is one of the easiest way to run Apex, but it is not a production ready setup. In a … Continue reading Install Oracle Apex 5.1.x, 18.1 on ORDS 3,17.4, 18.1

Series : MongoDB for Oracle DBA pt 1: Introduction

If you have worked in any sort of Enterprise big or small, most likely you have worked on a Relational Database Management Systems (RDBMS). They have been around for so long that we have taken the relational databases for granted. Relational in RDBMS stands for the relation which exists in a group of objects contained … Continue reading Series : MongoDB for Oracle DBA pt 1: Introduction

Script to SET NEWNAME for DATAFILES in RMAN for Cloning

-- If doing on Source Server -- ::12c-->sqlplus "/as sysdba" set head off pages 0 feed off echo off verify off set lines 200 spool rename_datafiles.lst select 'set newname for datafile ' || file_id || ' to ''/u01/oradata/' || substr(file_name,instr(file_name,'/',-1)+1) || ''';' from dba_data_files ; spool off exit; -- If doing on Target Server -- … Continue reading Script to SET NEWNAME for DATAFILES in RMAN for Cloning

EXPDP/IMPDP – ORA-04063 (view “SYS.KU$_RADM_FPTM_VIEW” Has Errors) on Full Export / Import

This is caused by a mismatch between the character set in which the table radm_fptm$ is created and in which the type ku$_radm_fptm$_t is created. This leads to the ORA-932 error when trying to recompile the view SYS.KU$_RADM_FPTM_VIEW, you have specified UTF8 for the national characaterset instead of the default AL16UTF16 national characaterset: To Check Character … Continue reading EXPDP/IMPDP – ORA-04063 (view “SYS.KU$_RADM_FPTM_VIEW” Has Errors) on Full Export / Import

Oracle 12c Transparent Data Encryption (TDE) on RAC Database with Physical Standby Database : Multiple Databases in Single Oracle Home

Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which we have to use parameter $ORACLE_UNQNAME for ENCRYPTION_WALLET_LOCATION in sqlnet.ora file In Oracle 12c ALTER SYSTEM and orapki has been deprecated and the correct method is to use ADMINISTER KEY MANAGEMENT commands. Many of the statements … Continue reading Oracle 12c Transparent Data Encryption (TDE) on RAC Database with Physical Standby Database : Multiple Databases in Single Oracle Home

Oracle Database Security Assessment Tool (DBSAT) (Doc ID 2138254.1)

Downloadable free tool from MOS for doing a Security assessment for Oracle Database (compatible with 10.2,11.2,12) https://support.oracle.com/epmos/faces/DocumentDisplay?id=2138254.1

RMAN — ORA-19909: datafile 1 belongs to an orphan incarnation in a Standby Database.

We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went missing and there was a gap. After doing the restore we got the below error in the RMAN recovery rman nocatalog target sys/******@mw auxiliary / connected to target database: MW (DBID=000000000) using target database control … Continue reading RMAN — ORA-19909: datafile 1 belongs to an orphan incarnation in a Standby Database.

Failed Primary Conversion to Physical Standby

1) Query on old standby database (new primary)SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;TO_CHAR(STANDBY_BECAME_PRIMARY_SCN)----------------------------------------124966431892) Flash back the failed primary database.SQL> shutdown immediate;SQL> startup mount;SQL> FLASHBACK DATABASE TO SCN 12496643189;Flashback complete.3) Convert old primary into standby databaseSQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;SQL> SHUTDOWN IMMEDIATE;SQL> STARTUP MOUNT;SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM … Continue reading Failed Primary Conversion to Physical Standby

Snapshots are not Backups

Very well explained article why Storage Snapshots are not the best way for backing up an Oracle database. http://www.oracle.com/technetwork/database/features/availability/rman-fra-snapshot-322251.html?utm_content=buffer67053&utm_medium=social&utm_source=facebook.com&utm_campaign=buffer