Steps to add new hosts in OEM 13c
Logon as sysman in OEM console. 1. Choose: Setup, Add Target, Add Targets Manually. 2. Under “Add Host Targets” Click “Install Agent on Host” 3. Add Host Name: tst01.example.com &…
Read MoreOPATCHAUTO-72043: Failed to create bundle patch object
I have recently faced this issue, while applying the PSU patch encountered “OPATCHAUTO-72043: Failed to create bundle patch object”. Issue: OPATCHAUTO-72043: Failed to create bundle patch object opatchauto apply -analyze…
Read MoreWhat is Smart Scan in Oracle Exadata
It’s a feature that can be used with Exadata. Exadata is capable of offloading a large portion of a query’s workload to the storage cells. So how it works? Smart…
Read MoreRoCE in Exadata X8M
Oracle Exadata Database Machine X8M is on the way! Building on the Exadata X8 state-of-the-art hardware and software, the Exadata X8M family adopts two new cutting-edge technologies: RDMA over Converged…
Read MoreExadata Cell software components
In this article, let us go through the Exadata Storage Cell Processes (MS, RS and Cellsrv). There are three main Exadata Storage Cell Processes: Cell Services (cellsrv) Cell Services (cellsrv)…
Read MoreOracle ORA-21561 : OID generation failed
Solution: Then the problem is most likely in the machine hosts file. Check that there is machine full name and short name in the machine hosts file. If these are…
Read MoreDatabase spending most of the time in wait event “log file switch (checkpoint incomplete) Waits event”
The wait event “logfile switch checkpoint incomplete” indicates that Oracle needs to reuse a redo log file, but the current checkpoint position is still in that log. In this scenario,…
Read MoreUsers unable to query in SQL Developer
A user was unable to query data from tables in sql developer, the query worked fine in sqlplus and toad. Upon checking the NLS settings were different in the SQL…
Read MoreConvert physical standby to snapshot standby database
Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database. i. e we can convert the physical standby database to snapshot standby.…
Read MoreOracle GoldenGate: Resync Single Table with Minimum Impact to Other Tables Replication
1. Stop your Replicat on the Target side, most likely it already abended, goto step 2. ggsci>stop replicat <name> 2. Comment out the MAP statement of that table in your…
Read More