Posts by Sakthi Sethuperumal S

AWR Snapshots are not generated Automatically

Introduction Steps to solve when AWR  Snapshots are not generating automatically Posted by Saravanan Scenario: ———— Oracle Database 11.2.0.4. My AWR Snapshots were not being generated even though it was full…

Read More

EBS R12.2 Cloning Steps

Introduction Steps to clone EBS R12.2 Clonning Posted by Venkatesh R K  NOTE: The following Clone approach is applicable for the APPLICATION version from R12.2.1 To R12.2.4 ENVIRONMENT:- Source:- BASE_PATH=/s01/oracle/R122 RUN_FILE_SYSTEM=/s01/oracle/R122/fs1…

Read More

Alert Log: Shutdown Waiting for Active Calls to Complete.

Introduction Steps to solve Shutdown Waiting for Active Calls to Complete. Posted by JAYAKRISHNA  Alert Log: Shutdown Waiting for Active Calls to Complete. Error: You are attempting to shut down the…

Read More

OATM Migration Appears to Have Hung. How Can I Monitor It’s Progress?

Introduction Solution to fix OATM Migration Appears to Have Hung. Posted by JAYAKRISHNA OATM Migration Appears to Have Hung. How Can I Monitor It’s Progress? The Oracle Applications Tablespace Model was…

Read More

Software for Oracle Big Data

Introduction This blog has the information about software for oracle big data Posted by Jey  Software for Oracle Big Data The Oracle Linux operating system and Cloudera’s Distribution including Apache Hadoop (CDH) underlie all…

Read More

Software Component Overview for Oracle Big Data

Introduction This explains the Software Component Overview for Oracle Big Data Posted by Jey The major software components perform three basic tasks: Acquire Organize Analyze and visualize The best tool for…

Read More

Oracle Big Data SQL

Introduction Information about Oracle Big Data SQL Posted by Jey Oracle Big Data SQL supports queries against vast amounts of big data stored in multiple data sources, including Apache Hive, HDFS,…

Read More

Suspend and Resume in Oracle Database

Introduction Steps to Suspend and Resume in Oracle Database Posted by Sakthi Sethu Perumal The ALTER SYSTEM SUSPEND  statement stops all  input  and  output  (I/O)  to  datafiles (file header and…

Read More

Locking statistics for a table

Introduction Steps to create locking statistics for a table Posted by Unknown . You can lock the statistics for the table if you don’t want it be analyzed automatically by scheduled…

Read More

FNDCPASS was not able to decrypt password f useorr ‘ANONYMOUS’ during applsys password change

Introduction Steps to solve FNDCPASS was not able to decrypt password for user ‘ANONYMOUS’ during applsys password change Posted by Mahendran Cause: ===== While change Apps password, if we changed…

Read More