How to resize archive logs

Modifying the redo logs:
------------------------
SQL> select group#, bytes, status from v$log;

GROUP# BYTES STATUS
---------- ---------- ----------------
1 52428800 INACTIVE
2 52428800 CURRENT
3 52428800 INACTIVE

SQL> select group#, member,status from v$logfile;

GROUP# MEMBER
--------------------------------------------------------------------------------
3 /TESTDATA/TEST/testdata/redo03.log
2 /TESTDATA/TEST/testdata/redo02.log
1 /TESTDATA/TEST/testdata/redo01.log


SQL> alter database add logfile group 4 '/TESTDATA/TEST/testdata/redo04.log' size 125M;

alter database add logfile group 5 '/TESTDATA/TEST/testdata/redo05.log' size 125M;

alter database add logfile group 6 '/TESTDATA/TEST/testdata/redo06.log' size 125M;


select group#, bytes, status from v$log;

Switch until we are into log group 4

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;

remove the files at OS level

How to relink AD utilities

You cannot relink ad utilities using adadmin.
Instead use the following

cd $AD_TOP/bin
$ adrelink.sh force=y “ad all”

Active Responsibilities Report SQL Query

select application_name,responsibility_name,
security_group_name, user_name,
greatest(u.start_date, ur.start_date, r.start_date) start_date,
least(nvl(u.end_date, nvl(ur.end_date, r.end_date)),
nvl(ur.end_date, nvl(u.end_date, r.end_date)),
nvl(r.end_date, nvl(u.end_date, ur.end_date))) end_date
from fnd_user u,fnd_user_resp_groups ur,
fnd_responsibility_vl r,fnd_application_vl a,
fnd_security_groups_vl s
where a.application_id = r.application_id
and u.user_id = ur.user_id
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and ur.start_date <= sysdate
and nvl(ur.end_date, sysdate + 1) > sysdate
and u.start_date <= sysdate
and nvl(u.end_date, sysdate + 1) > sysdate
and r.start_date <= sysdate
and nvl(r.end_date, sysdate + 1) > sysdate
and ur.security_group_id = s.security_group_id
order by application_name,responsibility_name,security_group_name, user_name

Active Users report SQL query

select user_name, application_name, responsibility_name,
security_group_name,
greatest(u.start_date, ur.start_date, r.start_date) start_date,
least(nvl(u.end_date, nvl(ur.end_date, r.end_date)),
nvl(ur.end_date, nvl(u.end_date, r.end_date)),
nvl(r.end_date, nvl(u.end_date, ur.end_date))) end_date
from fnd_user u, fnd_user_resp_groups ur,
fnd_responsibility_vl r, fnd_application_vl a,
fnd_security_groups_vl s
where a.application_id = r.application_id
and u.user_id = ur.user_id
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and ur.start_date <= sysdate
and nvl(ur.end_date, sysdate + 1) > sysdate
and u.start_date <= sysdate
and nvl(u.end_date, sysdate + 1) > sysdate
and r.start_date <= sysdate
and nvl(r.end_date, sysdate + 1) > sysdate
and ur.security_group_id = s.security_group_id
order by user_name, application_name, responsibility_name,
security_group_name

How to relink 8.0.6 Oracle Home

Change directory to the 8.0.6 ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

Useful Metalink Notes

Upgrade:
246105.1 - Upgrading to J2SE 1.4.2 with Oracle Applications 11i
125767.1 - Upgrading Developer 6i with Oracle Applications 11i
124606.1 - Upgrading Oracle JInitiator with Oracle E-Business Suite 11i
216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0 Upgrade)
362203.1 - Oracle E-Business Suite Release 11i
with Oracle Database 10g Release 2 (10.2.0 Upgrade)
782224.1 - Interoperability Notes Oracle E-Business Suite Release 12 with 11gR1 (11.1.0.6)
467778.1 - Oracle 10gR2 (10.2.0.2) Database Preparation Guidelines for an E-Business Suite Release 12.0 Upgrade
316889.1 - Complete Checklist for Manual Upgrades to 10gR2
1617458.1 - Oracle E-Business Suite Release 12.2.4 Readme
1926201.1 - Interoperability Notes Oracle EBS 12.2 with Oracle Database 12c Release 1


Installation:
169706.1 - Oracle Database on Operating Systems Installation and Configuration Requirements
287453.1 - Oracle Applications 11.5.10 - Installation Update Notes for all Operating Systems
402310.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (32-bit)
316365.1 - Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions (11.5.10.2 Upgrade)
402312.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Solaris Operating System (SPARC)


Clone:
135792.1 - Cloning Oracle Applications Release 11i
230672.1 - Cloning Oracle Applications Release 11i with Rapid Clone
218089.1 - Autoconfig FAQ
165195.1 - Using AutoConfig to Manage System Configurations with Oracle Applications 11i


Performance:
244040.1 - Oracle E-Business Suite Recommended Performance Patches


Troubleshooting:
249669.1 - How To Collect Apache and Jserv Debugging Details For Applications 11i
230688.1 - Basic ApacheJServ Troubleshooting with IsItWorking.class With Applications 11i
753845.1 - How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java Mailer Issues
317307.1 - How to Test IMAP, POP, SMTP
469822.1 - Oracle Workflow Release 12 Diagnostics


Configuration:
216205.1 - Database Initialization Parameters for Oracle Applications Release 11i
396009.1 - Database Initialization Parameter Settings for Oracle Applications Release 12
380482.1 - Oracle E-Business Suite Release 12 Technology Stack Documentation Roadmap
287176.1 - DMZ Configuration with Oracle E-Business Suite 11i
380490.1 - Oracle E-Business Suite R12 Configuration in a DMZ


Migration:
238276.1 - Migrating to Linux with Oracle Applications Release 11i
230627.1 - 9i Export/Import Process for Oracle Applications Release 11i
331221.1 - 10g Export/Import Process for Oracle Applications Release 11i
362205.1 - 10g Release 2 Export/Import Process for Oracle Applications Release 11i
1133355.1 - Migrating an Oracle E-Business Suite Database to Oracle Exadata Database Machine


Export/Import:
277650.1 - How to Use Export and Import when Transferring Data Across Platforms or Across 32-bit and 64-bit Servers
243304.1 - 10g: Transportable Tablespaces Across Different Platforms
341733.1 - Export/Import DataPump Parameters INCLUDE and EXCLUDE - How to Load and Unload Specific Objects


Real Application Cluster(RAC)
270512.1 - Adding a Node to a 10g RAC Cluster
269320.1 - Removing a Node from a 10gR1 RAC Cluster


Data Guard
180031.1 - Creating a Data Guard Configuration
214071.1 - Creating a configuration using Data Guard Manager
232240.1 - Performing Switchover in a Data Guard Configuration without the Data Guard Broker
215020.1 - Troubleshooting Logical Standby


Others:
139516.1 - Discoverer 4i with Oracle Applications 11i
362851.1 - Guidelines to setup the JVM in Apps 11i
304099.1 - Using J2SE Version 5.0 with Oracle E-Business Suite 11i
201340.1 - Using Forms Listener Servlet with Oracle Applications 11i
169768.1 - Configuring Wallet Manager to enable HTTPS connections via UTL_HTTP.REQUEST
209870.1 - How to Reload the JVM in 9.2.0.X
403537.1 - Best Practices for Securing Oracle E-Business Suite Release 12

How to find Apache Version in Oracle Apps 11i

Login to Web tier as applmgr user
cd $IAS_ORACLE_HOME/Apache/Apache/bin
Run the following command
./httpd -version
You will see the output like below

Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Dec 6 2005 14:59:13 (iAS 1.0.2.2.2 rollup 5)
Which means you are on iAS Version 1.0.2.2.2 with patchset rollup 5 with Apache Version 1.3.19