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
-- 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
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 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
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
There are scenarios where you cannot login to SQL*PLUS even with SYSDBA credentials to restart a hanged database. There is an option in sql*plus to connect, if such a scenario pop's up. sqlplus -prelim "/as sysdba" SQL> shutdown abort SQL> startup force Another syntax to the same cmd sqlplus /nolog SQL> set _prelim on SQL> … Continue reading Cannot login to SQL*PLUS as SYSDBA
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.