ADODFCMP Utility

Last updated on December 21st, 2015 at 05:40 amThe ODF Comparison utility is used to compare the data model of a customer’s data to a standard set of data model files from the current Oracle Application release. It can optionally modify the database to match the standard data model. Each application consists of certain building blocks. There is an object descriptor file (ODF) describing the … Continue reading ADODFCMP Utility »

Single Client Access Name (SCAN)

Last updated on August 27th, 2016 at 08:41 amWhat is Single Client Access Name (SCAN) It is a new Oracle Real Application Clusters (RAC) 11g Release 2 feature that provides a single name for clients to access Oracle Databases running in a cluster. The benefit is that the client’s connect information does not need to change if you add or remove nodes in the cluster. … Continue reading Single Client Access Name (SCAN) »

How to recover corrupt blocks using RMAN

Last updated on December 21st, 2015 at 05:34 am1. Recovering Data blocks By Using All Available Backups Run the BLOCKRECOVER command at the RMAN prompt, specifying the file and block numbers for the corrupted blocks RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15; Recover multiple blocks in single command RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15 DATAFILE 2 BLOCK 10; 2. Recovering Data blocks Using Selected Backups Run the BLOCKRECOVER … Continue reading How to recover corrupt blocks using RMAN »

How to identify corrupts blocks in the database

Last updated on December 21st, 2015 at 05:35 am1. Run below command to populate v$database_block_corruption view with information of all the corrupted blocks. RMAN> backup validate check logical database; “CHECK LOGICAL” option is used to identify both Physical and Logical Block Corruptions. Select the view to identify the corrupted blocks detected by RMAN. SQL> select * from v$database_block_corruption; Please note, After a corrupt block is … Continue reading How to identify corrupts blocks in the database »

JDBC connection scripts for Oracle Applications R12

Last updated on March 30th, 2019 at 12:57 pmThis article is part of EBS tutorials and provides different JDBC connection scripts for Oracle Applications R12 Oracle  OC4J connect to Oracle database using JDBC connection. Here is the list of some good scripts on JDBC connection The OC4J JVM process id can be found using the below opmnctl command opmnctl status -l A) To find total … Continue reading JDBC connection scripts for Oracle Applications R12 »

How to create RMAN recovery catalog and register database in catalog

Last updated on July 29th, 2018 at 10:33 amRMAN Recovery catalog is a very important registry. Control file registry get rotated after some time so you lost many backup information. By storing backup information in recovery catalog ,you get rid of this problem Also it provides a central repository where you can find all the backup information. Here are the steps on How to create recovery … Continue reading How to create RMAN recovery catalog and register database in catalog »

How to check if Port pool is free in Oracle applications R12

Last updated on March 30th, 2019 at 12:35 pmWhat is Port Pool? Oracle Applications 11i/R12.0/R12.1/R12.2 uses the concept of a port pool. A port pool is a preconfigured set of unique port assignments for every E-Business Suite technology stack component that requires network connectivity. So multiple Release 12 environments can coexists on the same machine,provided  you have  configured each of them to use a different … Continue reading How to check if Port pool is free in Oracle applications R12 »

FNDCPASS and AFPASSWD

Last updated on March 3rd, 2019 at 06:06 pmFNDCPASS is an important utility in EBS application and it is located in $FND_TOP/bin.  It is used to change password for apps schema, oracle EBS schema password and application user password change. $FNDCPASS FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS FNDCPASS apps/apps 0 Y system/manager ORACLE FNDCPASS apps/apps 0 Y system/manager USER When you execute FNDCPASS, it … Continue reading FNDCPASS and AFPASSWD »

How to set Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL

Last updated on July 28th, 2018 at 04:08 pmWhat is Table Monitoring in Oracle Table monitoring is checking for how many updates,deletes ,insert happened in the tables so that we can find out if the statistics are stale or good for the table .It is a very useful functionality in gathering stats for the tables in Oracle How to Set the  Table Monitoring in Oracle … Continue reading How to set Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL »

How to find how much space is actually used by the lobsegments

Last updated on November 28th, 2015 at 12:35 pmLet us take the example of FND_LOBS tables in Oracle Apps Database.FND_LOBS has LOB datatype column FILE_DATA How to  find how much space is actually used by the lobsegments Query to find the actual bytes used by the lob datatype select sum(dbms_lob.getlength (FILE_DATA)) from FND_LOBS; SUM(DBMS_LOB.GETLENGTH(FILE_DATA)) ———————————- 13313 The total space allocated in the extents could be … Continue reading How to find how much space is actually used by the lobsegments »

How to correct error RMAN-20004

Last updated on December 21st, 2015 at 04:14 amProblem:When Recovery catalog has been configured.and Production Database has been cloned and a connection has been made from the clone to Catalog database using rman with out changing the DBID of the clone,then we are in some trouble Then when you try to backup the production instance with the catalog,The backup fails with following error RMAN-06004: ORACLE … Continue reading How to correct error RMAN-20004 »

How to add debug codes in the application executable

Last updated on December 21st, 2015 at 03:53 amIt often happens the executable are either coredumping or not behaving exactly.We need to debug the executable. Here are the General steps on How to add debug codes in the application executable. Infact these are steps even followed  by adpatch to replace lib files in the product executables Let’s say that you need to link the object file … Continue reading How to add debug codes in the application executable »