Jun 21, 2012
How to Expire All Oracle Applications Users Passwords
550

How to Expire All Oracle Applications Users Passwords

How to Expire All Oracle Applications Users Passwords There may be a need to expire all Oracle Application users passwords in Oracle Applications 11i. Oracle provides a script to expire all users passwords from 11i.ATG_PF.H RUP4. The script is located under $FND_TOP/patch/115/sql/AFCPEXPIRE.sql. AFCPEXPIRE.sql is a very simple script and is...
Jun 21, 2012
Oracle Fusion Applications Patching Concepts
438

Oracle Fusion Applications Patching Concepts

Oracle Fusion Applications Patching Concepts Oracle Fusion Applications Patch Manager is the utility to apply the patches in Oracle Fusion Applications. The primary function of Oracle Fusion Applications Patch Manager is to manage patches that update both the database and middleware artifacts under the Oracle Fusion Applications Oracle home. Oracle...
Jun 21, 2012
Oracle Fusion Applications Oracle_Home Directory Structure
896

Oracle Fusion Applications Oracle_Home Directory Structure

Oracle Fusion Applications Oracle_Home Directory Structure The Oracle Fusion Applications Oracle home directory (FA_ORACLE_HOME) is located under the APPLICATIONS_BASE/fusionapps directory (net/mount1/appbase/fusionapps). The /fusionapps directory is an Oracle Fusion Applications Middleware home (FA_MW_HOME).    The Oracle home contains the following sub-directories: 1. /fusionapps/applications/lcm: The life cycle management directory. Contains the patching...
Jun 15, 2012
Oracle Tablespace Reorg to reclaim space
5.1K

Oracle Tablespace Reorg to reclaim space

Oracle Tablespace Reorg to reclaim space I have a tablespace, which is having 50 datafiles with the size of 38G, but the actual data in the tablespace is 2G, so I want to reclaim the space from tablespace by reducing the count of datafiles to 3 x8G=24G, so that mount...
Jun 06, 2012
How to get Apps password in R12
704

How to get Apps password in R12

How to get Apps password in R12??? Connect to sysdba and follow the below procedure alter session set current_schema=apps ; CREATE OR REPLACE PACKAGE get_pwd AS FUNCTION decrypt ( KEY IN VARCHAR2 ,VALUE IN VARCHAR2 ) RETURN VARCHAR2; END get_pwd; / CREATE OR REPLACE PACKAGE BODY get_pwd AS FUNCTION decrypt...
Jun 05, 2012
Oracle – How to purge old RMAN backups
915

Oracle – How to purge old RMAN backups

Oracle – How to purge old RMAN backups Do not use rm to remove files.  You must do it via RMAN. $ export NLS_DATE_FORMAT=’DD-MM-YY HH24:MI’ $ rman target / NOCATALOG RMAN > crosscheck backupset; This command will verify whether backup file is still on media. If it is unavailable, RMAN...