ORACLE GOLDENGATE ARCHITECTURE
Oracle Goldengate supports the replication of data for various heterogeneous platforms. It provides support for IBM Informix and extended support for Microsoft SQL Server and MySQL. Oracle GoldenGate is now …
Read MoreIn Oracle 12c Sql tuning advisor is not running even though its enabled
Faced a strange issue in oracle 12c. In automated maintenance task, sql tuning advisor was enabled. However, it was still not running. Validated dba_autotask_operation, that “sql tuning advisor” is enabled.…
Read Moreutlrp hangs after upgrade to 12c ERP database
We were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…
Read MoreSOA webservices not working after 12c ERP db upgrade
After upgrading database from oracle 11g to 12c in Oracle Apps R12.1.3, got a strange issue where SOA webservices- SOAP, REST stopped. The following url showed 404 http://host.domain:8000/webservices/SOAProvider/?testquery The issue…
Read MoreOracle apps adpatch fails
Many times , when applying patch using adpatch in oracle apps, the patch session session gets terminated because of network problems. The best way to continue the patch is to…
Read MoreFind the current patchset levels for products in Oracle Apps
To obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,”Oracle Applications Manager”, menu “OAM Support Cart”)…
Read MoreQueries Related to Undo in Oracle
To find retention guarantee for undo tablespace select tablespace_name,status,contents,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To find Undo Space Availability select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select…
Read MoreLocking and Disabling User Accounts in Linux
Locking and Disabling User Accounts in Linux 1. Locking the user account To lock a user account use the command usermod -L or passwd -l. Both the commands adds…
Read MoreSetup a password less SSH Connectivity Quickly on Linux
We can use ssh to connect between servers, but many times it is required to setup a password less connectivity between the servers. We can follow below steps to…
Read MoreRMAN Issues and Solutions – (ORA-00020) and (ORA-00245)
RMAN Issues and Solutions – (ORA-00020) and (ORA-00245) Error-1: RMAN failed to connect target database with ORA-00020: maximum number of processes (150) exceeded Solution: Here, we can see…
Read More