Upgrade from Exadata X4-2 11g (184.108.40.206) to Exadata X7-2 12CR1 (220.127.116.11.0) : ASM to ASM Oracle Database 18.104.22.168and 22.214.171.124 to Oracle 126.96.36.199 Direct upgrade is supported by Oracle. If you have Database lower than those version than you have to upgrade to 188.8.131.52 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
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 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
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
Setup for the Environment ------------------- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 184.108.40.206 DB Home Version : 220.127.116.11 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 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;
Oracle Version Affected : 18.104.22.168 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], , , , …