We generally receive few errors related to asmsnmp user while using ASM. Few of them are : Could not validate ASMSNMP password due to following error- “ORA-01031:…
Expert Oracle Posts
What is ‘Gather Statistics’?
When the data is updated continuously by updating, inserting or deleting of by users (Functional/Technical/End users), it becomes necessary to gather statistics as the performance of database goes down.
Oracle has provided a nice solution for it. This can be done by simply submitting a request from EBS. Oracle E-Business Suite provides concurrent programs that use the package FND_STATS to gather statistics for your applications database objects.
[Post Views: 16745]
Parallel Concurrent Processing (PCP):
PCP is the method by which we configure the Concurrent Manager in a multi tier environment with 2 or more concurrent nodes. This allows concurrent processing load to be distributed across the nodes and provides high availability in case of node failure. Managers migrate to surviving node (failover)when one of the concurrent nodes goes down and migrate back (failback) when the failed node comes back.
[Post Views: 14704]
After creating 11g R2 RAC database for the EBS R12, we wanted to enable multiplexing for the control files. Oracle recommends multiplexing the control files . We are using ASM for the storage of control files.
At the time of creating the database by dbca we can do multiplexing or we can also do later manually as described below.
Goal:- We have control file in the +DATA disk group and we want to also keep it in another disk group +OCR_VOTE for multiplexing.
[Post Views: 7399]
Some useful RAC 11G commands are documented below. STOP SEQUENCE COMMAND DESCRIPTION —————————————————————————————— srvctl stop database -d ORCL STOP DATABASE srvctl stop instance -d ORCL…
Few frequently used SQL queries related to ASM : 1) Create Disk Group: Create Disk groups using the CREATE DISKGROUP statement and specify the level…
Few good questions on Automatic Storage Management (ASM) 11gR2: (Oracle ASM Interview questions) Q 1 Can an ASM file be contained in more than one disk groups…
When we were trying to connect to our upgraded 184.108.40.206 database, below error was thrown and we were not able to connect. $ sqlplus as…
Posted by Arindam Mukherjee Recently I encountered an interesting performance issue while working with Oracle EBS seeded components and these issues are tied to wrong use…
220.127.116.11 is the latest release (at the time of writing this post) for the Oracle database. The intent of this guide is to upgrade the current database version from 18.104.22.168 to 22.214.171.124.
The installation procedure for the new Oracle Database 11g Release 2 (11.2) installs the Oracle software into a new Oracle home. This is referred to as an out-of-place upgrade and is different from patch set releases for earlier releases of Oracle Database, where the patch set was always installed in place. Oracle strongly recommends that you follow the steps in this procedure to ensure minimal downtime for the upgrade process and integrity of the new binaries and software libraries.
[Post Views: 9912]