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 MorePosted 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 MorePosted 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 MorePosted 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 MorePosted 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 MorePosted 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 MorePosted 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 MorePosted by Abishek Kathiresan Introduction: Hi All, Here we will discuss Scripts related to TEMP TABLESPACE. To check instance-wise total allocated, total used TEMP for both rac and non-rac set…
Read MoreIntroduction If we want to show any report in excel format in page level with the different font of column values we can use this component script to achieve…
Read MoreIntroduction The Purpose of this component is to restrict the copy option from the user level of apex page. Context Consider in our apex application we are providing any confidential…
Read More