If you are creating your Pearson VUE account and you have already passed some Oracle certifications earlier, you need to put your old Prometric id so that your old certifications at Prometric get merged automatically with the new Pearson account. But, if you forgot your old Prometric id, as happened to me, you can probably get it…
Author: Saurabh Sood
Worked with prestigious Financial Institutions and Product Based MNCs e.g. Swiss Bank (UBS), CitiBank, Qatar Central Bank (QCB), Societe Generale, Oracle Corporation & Dell.
An Oracle DBA who is up-skilling himself to help large enterprises move their data to cloud and get more insights into data to make it useful for them.
GoldenGate Setup for Real-Time Data Synchronization
In this post we discussed about GoldenGate(GG) concepts and setting GG without DataPump Process. Now I will talk about DataPump process and show how to setup GG replication which also uses DataPump. In GG environment, extract process will write the data to local trail files and then pump process reads from this local trail file…
ORA-7445 core dump [kokscold()+849] from EM 12c
The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact message: Sun Feb 19 12:09:41 2012 Errors in file /u01/app/oracle/diag/rdbms/pkldb/pkldb/trace/pkldb_j035_14712.trc (incident=52961): ORA-07445: exception encountered: core dump [kokscold()+849] [SIGSEGV] [ADDR:0x50] [PC:0x115E16F] [Address not mapped to object] [] Incident details in: /u01/app/oracle/diag/rdbms/pkldb/pkldb/incident/incdir_52961/pkldb_j035_14712_i52961.trc From the incident trace…
Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c
This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c (12.1.0.1.0). The Complete Upgrade process will be carried out under 3 different stages: 1. Patch existing 11g OMS to get the 12c upgrade console. 2. Deploy and Configure 12c agents. 3. Upgrade 11g OMS to 12c. The approach used…
Optimizer Choosing Nested-Loop Joins Instead of Hash-Joins
In one of my databases, one application query suddenly started to pick Nested-Loop joins instead of Hash-Joins and took almost 6 hours to complete which gets completed in less than 10 secs with Hash-Joins. The same query in another similar database with same configuration and same data is doing fine and using hash joins. There is…
Oracle Database Appliance Introduced
Oracle has introduced it new product: ODA (Oracle Database Appliance) I was not able to join Oracle President Mark Hurd’s webcast where he supposed to announce a new Oracle product[It was at 1AM my time and I was sleeping], now viewing this webcast HERE Kerry Osborne has shared information about this product, click link to…