Wonders in AWS RDS – Good Deployment techniques
Introduction Amazon Web Service offers a diverse range of products and services to clients across the globe and shapes. Amazon RDS is one of the most popular and notable services…
Read MoreHUGE PAGES CONCEPTS
HUGE PAGES What are Huge Pages? Linux Manages memory in pages while loading data from disk to memory or writing back to disk from memory. Huge pages is a…
Read MoreOracle Blob and Clob Datatypes
CLOB and BLOB are two types of data types used in databases to store large amounts of data. BLOB: BLOB, or Binary Large Object, is used to store binary data such as images, audio, video, and other multimedia objects. It is an extension of the VARBINARY data type and can store up to 2GB of data.Using CLOB and BLOB data types can be beneficial in many situations. CLOB:CLOB, or Character Large Object, is used to store textual data and is used for large strings of text. It is an extension of the VARCHAR data type and can store up to 4GB of data if you have a large document or image you need to store, you can use a CLOB or BLOB data type to store it.storage space is occupied more in the database, so you should be careful about when and how you use them. To query for CLOB or BLOB datatypes,…
Read Morewhat are the oracle index status
Oracle index is a database object that is used to improve the performance of certain queries by providing direct access to the data in a table. Indexes are created on columns and contain entries that point to the data in the table. An index can be unique or non–unique and can be created on one or more columns. some of status are below. 1.Unusable 2.N/A 3.Valid 4.Invalid 1.UNUSABLEAn Oracle index can become unusable if the underlying table has been modified or dropped, or if the index has been corrupted. To fix this, you need to re–create the index.The data is not in the order specified by the SORTED INDEXES clause ALTER INDEX [schema.]indexname REBUILD ONLINE;…
Read MoreOracle Cloud – GL Journal Import by using FBDI process
Oracle Cloud – GL Journal Import by using FBDI Process Overview FBDI Journal Import Oracle Cloud made life easy for the data entry in creating/preparing journal entries in general…
Read MoreOracle Cloud – How to Install ADFDI Plug In
Oracle Cloud – How to Install ADFDI Plug In Introduction: ADFDI is an excel plug-in needed to use any spreadsheet functionality within Oracle Cloud (i.e. upload journal via spreadsheet,…
Read MoreOracle Cloud – How to do Form Personalize to stop showing ICONS on spring board
Oracle Cloud – How to do Form Personalize to stop showing ICONS on spring board Introduction: If we need to hide/display spring board icons or extend the application in…
Read MoreSteps for modifying the scan name configuration in oracle RAC.
INTRODUCTION What is scan name for Oracle database? Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name for clients to…
Read MoreOacore & Forms Servers Are Stuck at ADMIN State in EBS R12.2.5
Not able to bring up oacore and forms managed servers after clone. These managed servers are stuck at ADMIN state while trying to start the services. CAUSE: Credentials Missing in…
Read Moreadcfgclone.pl error :RC-50014: Fatal: Execution of AutoConfig was failed in R12
While R12.2.5 cloning autoconfig failed with the below error AutoConfig is exiting with status 1 ERROR: RC-50014: Fatal: Execution of AutoConfig was failed Raised by oracle.apps.ad.clone.ApplyApplTop END: Executed runAutoConfig… ERROR:…
Read More