Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to Oracle 12.2.0.1 Direct upgrade is supported by Oracle. If you have Database lower than those version than you have to upgrade to 11.2.0.4 first and you can upgrade to 12cR2 In our Scenario We will … Continue reading Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

Drop those Indexes and see the Magical Unicorn of Exadata do it’s Magic !

Now that I have got your attention with my sales pitch. Let me quote a sales pitch we have heard quite often from Exadata Sales rep "Drop the indexes on Exadata ; It is a magical unicorn and it will guarantee performance even without them"  Well, 50 years of computer science begs to differ. This … Continue reading Drop those Indexes and see the Magical Unicorn of Exadata do it’s Magic !

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

Check ASM Diskgroup Space and Directory Size

The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each Disk Group The script is written by somebody at Pythian but i cannot re-collect the original link to the blog. eg: ./asmcmd_du.sh DiskGroup Total_MB Free_MB % Free --------- -------- ------- ------ DATAC1 15962112 11215880 70 … Continue reading Check ASM Diskgroup Space and Directory Size

Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Setup for the Environment ------------------- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home Version : 12.1.0.2 Primary, 2 Node RAC, db_unique_name = primeprd Instance 2 : primeprd1 Instance 2 : primeprd2 TNS entry: PRIMEPRD, but below entry in tnsnames.ora files on both node with DB Home user, most … Continue reading Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Query to check sessions writing to flashcache on Exadata

Query to check sessions writing to flashcache on Exadata select se.sid, sn.name, s.value, se.program from v$sesstat s natural join v$statname sn left join v$session se on (s.sid = se.sid) where sn.name in ('physical write requests optimized', 'cell writes to flash cache', 'cell overwrites in flash cache') and s.value <> 0 order by s.sid,name;

ORA-12801: error signaled in parallel query server P001 ORA-00600: internal error code, arguments: [kxspoac : EXL 1], [32], [1], [], …

Oracle Version Affected : 12.1.0.2 OS : OEL 6 Update 7, x64 This error is related to Parallel Query and we encountered it many times, once on test and once on production. The solution is to apply below patch Patch 19201867: SR12.2PX_HYBRID_LOAD - TRC - ORA-600 [KXSPOAC : EXL 1] It is due to a … Continue reading ORA-12801: error signaled in parallel query server P001 ORA-00600: internal error code, arguments: [kxspoac : EXL 1], [32], [1], [], …

Create ACFS Filesystem Oracle 12c Linux 12.1.0.2

-- Create ACFS filesystem on 12c Linux Exadata -- 1. Create a volume in ASM ASMCMD [+] > volcreate -G datac1 -s 500G ACFS_VOL If you get like below error ORA-15032: not all alterations performed ORA-15479: ASM diskgroup does not support volumes ORA-15221: ASM operation requires compatible.asm of 12.1.0.2.0 or higher (DBD ERROR: OCIStmtExecute Check … Continue reading Create ACFS Filesystem Oracle 12c Linux 12.1.0.2

Enable WriteBack Cache for Exadata

Writeback cache is a feature of cache where the blocks are written to flash first before flushing to the disk. Writethrough is the default setting for Exadata cells, where the data is written first to disk and moved to flashcache for read purpose. Download the setWBFC.sh script from Oracle support website [root@exatestdbadm01 ~]# dcli -g cell_group … Continue reading Enable WriteBack Cache for Exadata

Install GUI X11 packages and VNC Server on Exadata Compute Nodes

Recently we patched our Exadata machines to the April 2016 QFSP. On running DBCA we got X11 forwarding error and upon further investigation we discovered that X11 related packages RPM are removed in the new compute node patches. Image version: 12.1.2.3.1.160411 On Oracle support website there is a note about it: Refer MOS for more … Continue reading Install GUI X11 packages and VNC Server on Exadata Compute Nodes