Posts by Abishek Kathiresan

Using Staged Applications System to reduce patching downtime in R12

Posted by Abishek Kathiresan Prerequisites Apply the latest AutoConfig template patch on the source system Update the Oracle Applications file system with the latest AutoConfig template files by applying the…

Read More

Oracle 12c New Features – Alter Database Move Datafile

Posted by Abishek Kathiresan Introduction: In previous versions of Oracle when DBAs needed to move datafiles to new storage, or migrate between ASM and filesystem they needed to first take…

Read More

Oracle 12c New Features – SQL*Loader Express

Posted by Abishek Kathiresan Introduction: Oracle 12c introduces Sql*Loader Express features, which allow users to run sqlldr with minimum configuration. The following example shows loading records into table EMPLOYEE from…

Read More

Oracle 12c – startup container AND pluggable databases.

Posted by Abishek Kathiresan In Oracle 12c we start the Container Database (CDB) the same as we started previous database versions. [oracle@rac1 lib]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production…

Read More

Oracle 12c Common and Local users – ORA-65096 ORA-65049

Posted by Abishek Kathiresan In 12c when you login to a CDB database you default to the CDB$ROOT container.   [oracle@rac1 db_1]$ echo $ORACLE_SID T12 [oracle@rac1 db_1]$ ps -ef |…

Read More

REP-3000: Internal error starting Oracle Toolkit

Posted by Sundaravel Ramasubbu  Issue: Recently we had issue with Concurrent requests which having print format of PDF or XML, and the exact error is “REP-3000: Internal error starting Oracle Toolkit”…

Read More

Data Guard Log Shipping Fails With Error Ora-16191 In 11g

Posted by Sundaravel Ramasubbu Issue: PING[ARC1]: Heartbeat failed to connect to standby ‘STANDBY’. Error is 16191. Sat Aug 06 02:06:52 2011 Error 1017 received logging on to the standby ———————————————————— Check…

Read More

Profile Options that are used commonly by APPS DBA’s

Posted by  Abishek kathiresan Introduction: Here we will see the Profile Options that are used commonly by APPS DBA’s Concurrent Related Profile Options Concurrent: Active Request Limit   Value: Numeric This…

Read More

How to create Oracle EBS (Applications User ) with only read privilege

Posted by Abishek kathiresan Introduction: Hi Everyone here will discuss how to create Oracle EBS(application user) with only read privilege Steps to be followed: 1.Connect to the Oracle EBS 2.…

Read More

Concurrent request running abnormally for very long time without completion

Posted by  Abishek kathiresan Introduction: In this document I will show you a solution for Concurrent request running abnormally for very long time without completion 1. Identified the long running…

Read More