Scaling Autonomous Database on OCI Original Post First Appeared on my Medium Blog : https://shadabshaukat.medium.com/true-elasticity-of-oracle-autonomous-database-a4994b18a6c3 Introduction Oracle’s Autonomous Database is…
Tag Database
After searching on the internet long and hard I couldn’t find a quick shell script to access Oracle Autonomous Database…
Error : The request could not be mapped to any database. Check the request URL is correct, and that URL…
Oracle Autonomous Database now supports capturing of Data using an Extract and applying it to another Autonomous Database in another…
Connect to Autonomous Database Private Endpoint from On-Premise SQL Developer using SSH Local Port Forwarding Assumptions: Your Bastion/ServiceVM/Bastion Host is…
Architecture: Source : DBCS on Classic 12.1 Enterprise Edition Target : OCI gen2 Autonomous Data Warehouse 19c Pre-Req:———1. Install and…
Create Oracle Autonomous Transaction Processing Database(ATP) in your Oracle Cloud Account. Create wallet and down the wallet to your bastion…
Oracle has been an incumbent to the cloud space having lost a lot of ground to Amazon and Microsoft.But that…
Oracle Apex is a modern framework to quickly develop and deploy web apps sitting on top of Oracle Database. Apex…
If you have worked in any sort of Enterprise big or small, most likely you have worked on a Relational…
— If doing on Source Server — ::12c–>sqlplus “/as sysdba” set head off pages 0 feed off echo off verify…
This is caused by a mismatch between the character set in which the table radm_fptm$ is created and in which…
Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which…
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…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
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) —————————————- 12496643189 2) Flash back the…
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
Just finished installing Oracle 12c on Cent OS 6.3. From the looks of it 12c looks like a winner. Oracle…
————- Drop Database Manually Oracle ——————— 1. First get the datafiles, control files and redo log files location Login to…
This is a script to create a logon trigger for blocking third party tools like Toad, SQl Navigator etc from…
1. Install Latest OPatch clients from support.oracle.com – As Grid User — unzip p6880880_112000_SOLARIS64.zip -d $ORACLE_HOME ##Replace All – As…
Original Article on http://www.orafaq.com/node/2756 by Micheal Rajendran Introduction Oracle has leap forwarded the middleware technologies especially the database technology into the cloud.…
Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created…