Top 30 Most Useful Concurrent Manager Queries

      Concurrent Manager troubleshooting is a major part of Oracle apps administration. Here are the Top 30 Most Useful Concurrent Manager Queries to help you in resolving issues To check the setting of the ICM in the Concurrent Manager environment select ‘PCP’ “name”, value from apps.fnd_env_context where variable_name = ‘APPLDCP’ and concurrent_process_id = (select … Continue reading Top 30 Most Useful Concurrent Manager Queries »

Awesome Free Remote Desktop Manager

Remote Desktop Protocol (RDP), developed originally by Microsoft, is a network protocol that provides a way for people to get access to a computer remotely with a nice lightweight user interface along with input devices like keyboard and mouse. Both Windows 7 and 8 come with a native Remote Desktop Client that lets you connect … Continue reading Awesome Free Remote Desktop Manager »

5 Simple (But Important) Things To Remember About Oracle Database 12c views ,parameters and packages

5 Simple (But Important) Things To Remember About Oracle Database 12c views ,parameters and packages Multitenant Database Oracle is doing every thing to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this feature. There is a radical change and a major change in the core database … Continue reading 5 Simple (But Important) Things To Remember About Oracle Database 12c views ,parameters and packages »

Top 10 Oracle Database Security Tips for DBA

Critical data are stored in database and data leaks can jeopardize the organization. So database security is very important. Database Security has always been a concern for a Database Administrator. However, Oracle Database is very much secure, even then there are gaps which has to be filled by DBA to make Oracle Database Secure. Oracle … Continue reading Top 10 Oracle Database Security Tips for DBA »

Bigdata, Nosql, Hadoop terms explained

What is BigData? Big Data refers to technologies and initiatives that involve data that is too diverse, fast-changing or massive for conventional technologies, skills and infra- structure to address efficiently. Said differently, the volume, velocity or variety of data is too great ‘Big Data’ describes data sets so large and complex they are impractical to … Continue reading Bigdata, Nosql, Hadoop terms explained »

Top Enterprise Manager 13c Features

Enterprise Manager  13c is the latest release of Oracle on enterprise side. This release enable lot of new interesting to ease the administration,migration and monitoring. Top new features are 1. Gold image based agent lifecycle management Enterprise Manager administrators spend a lot time on various agent life cycle operations starting from a fresh installation through … Continue reading Top Enterprise Manager 13c Features »

Top Oracle 12c New Features for developers

Oracle has released 12c with lot of new fetaures. Here in this article,I would presenting the top Oracle 12c New Features for developers I have categorized the features in the broad category to make it easier to understand and use SELECT IMPROVEMENTS 1) Top-N feature A Top-N query allows us to retrieve the top or bottom … Continue reading Top Oracle 12c New Features for developers »

How to Install FMW 11g Web Tier Managed by Fusion Middleware Control (EM)

FMW 11g Web Tier can be managed using manual method (opmnctl method ) or we can manage using Fusion Middleware Control (EM).For FMW 11g Web Tier to be managed by Fusion Middleware Control (EM), you need to associate that with weblogic domain. Here are some cases we can consider for the management of FMW 11g … Continue reading How to Install FMW 11g Web Tier Managed by Fusion Middleware Control (EM) »

Enabling TLS in Oracle Apps R12.2

Here  we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: The data between web browser and web server travels unencrypted in R12 application So the password and other information can be tracked by sniffer. We are avoiding this by implementing SSL in R12. With SSL implementation, the data travels … Continue reading Enabling TLS in Oracle Apps R12.2 »

Enabling SSL or TLS in Oracle Apps R12

Security is of great concern today.Here are the steps Enabling SSL in Oracle Apps R12 Introduction: The data between web browser and web server travels unencrypted in R12 application So the password and other information can be tracked by sniffer. They can get your Username/Password or any sensitive data. This become critical when you have Internet access … Continue reading Enabling SSL or TLS in Oracle Apps R12 »

Step by Step Oracle 12c Database Installation on Linux

I will be posting the step by step Oracle 12c Database Installation on Linux. First we will performing the binaries installation and then creating the database using dbca Package and OS requirements We can install the Oracle Provided 12c preinstall package to meet the  Package and OS requirement running the below yum command (as root): … Continue reading Step by Step Oracle 12c Database Installation on Linux »