Oracle Apps DBA's Pool

11.5.10.2 Installation Errors

2011-11-03T04:21:00.000-07:00

Some More Errors:

Error 1: RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Error 2: DBC File Check

RW-00023: Error: - DBC file was not created:

File = /u01/oracle/apps/trainappl/fnd/11.5.0/secure/TRAIN_dba1/train.dbc

------------------------

Executing script in InstantiateFile:

/u01/oracle/apps/traincomn/admin/install/TRAIN_dba1/adgendbc.sh

script returned:

****************************************************

adgendbc.sh started at Wed Nov 2 22:43:07 IST 2011

Params=

Unique constraint error (00001) is OK if key already exists

ADD call failed with exit code 127

Trying to update information ...

UPDATE call failed with exit code 127

Generating /u01/oracle/apps/trainappl/fnd/11.5.0/secure/dba1_train.dbc

DBC generation failed with exit code 127

Updating Server Security Authentication

Updating Server Security Authentication failed with exit code 127

adgendbc.sh exiting with status 127

ERRORCODE = 127 ERRORCODE_END

error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory

error while loading shared libraries: libdl.so.2: cannot open shared object file: No such file or directory

------------------------------

Error 3: HTTP Check

checking URL = http://dba1.appsahyd.com:8004

RW-50015: Error: - Portal is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Error 4: PHP Check

checking URL = http://dba1.appsahyd.com:8004/OA_HTML/US/ICXINDEX.htm

RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

------------------------------------------------------------------------------------------------------------------------------------

Error 5: And also observed the below error after sourcing the environmental file:

----------------

ls: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory

----------------

Sol:

As per the Metalink note 747424.1, i replaced all occurances of LD_ASSUME_KERNEL with XD_ASSUME_KERNEL only in DB-tier, but not in the Apps tier. So this was causing the

above issue in the instalation of oracle 11i on OEL5

DB Tier:

O_H/appsutil/bin/adgetlnxver.sh

Apps Tier:

/ad/11.5.0/bin/adgetlnxver.sh

-- Restart rapidwiz as " ./rapidwiz -restart "

--run the autoconfig in apps tier with completed successfully result (and also generated the DBC files)

--run the adstrtal.sh

--This time everything checked OK in the instalation wizard.

After Resolution:

11.5.10.2 Installation Errors on RHEL 4

2011-11-02T08:54:00.000-07:00

Error :1

RW-50010: Error: - script has returned an error: 1

RW-50004: Error code received when running external process. Check log file for details.

Running Database Install Driver for Train instance

afmkinit.sh exiting with status 127

.end std out.

cp: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory

touch: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory

.end err out.

****************************************************

Check log files @ O_H/appsutil/log/dbInstancecfg.log and installation log(11020548.log)

Sol:

1. Edit the <9i RDBMS_ORACLE_HOME>/appsutil/bin/adgetlnxver.sh file as below

2. Alter by replacing all occurrences of LD_ASSUME_KERNEL with XD_ASSUME_KERNEL

3. Press the retry button in rapidwiz screen

Below MOS Note Explains cleary about this issue:

Installation Of Oracle EBS 11.5.10.2 On OEL Fails [ID 747424.1]

---------------------------

Error 2:

There was an error while running the command - su orauser1 -c /u01/oracle/db/traindb/9.2.0/temp/Train_dba1/adrun9i.sh APPS APPS

/u01/oracle/db/traindb/9.2.0/appsutil/install/adlnkoh.sh: line 198: /u01/oracle/db/traindb/9.2.0/bin/sqlplus: No such file or directory

RW-50010: Error: - script has returned an error: 1

RW-50004: Error code received when running external process. Check log file for details.

Running Database Install Driver for Train instance

Observed below error in make.log @ RDBMS_O_H/install/make.log

/usr/bin/gcc: line 22: /usr/bin/gcc32: No such file or directory

/usr/bin/gcc: line 22: exec: /usr/bin/gcc32: cannot execute: No such file or directory

make: [

Sol:

Check below cmd:

$ gcc -v

/usr/bin/gcc: line 22: /usr/bin/gcc32: No such file or directory

/usr/bin/gcc: line 22: exec: /usr/bin/gcc32: cannot execute: No such file or directory

Actual o/p should be :

$ gcc -v

Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/specs

Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --enable-languages=c,c++ --disable-libgcj --host=i386-redhat-linux

Thread model: posix

gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-47.3)

Installed compat-gcc-32-c++-3.2.3-47.3 & compat-oracle-rhel4-1.0-3 rpms

Session Related Queries

2011-05-31T03:52:00.000-07:00

1. Show all connected users
set lines 100 pages 999
col ID format a15
select username
, sid ',' serial# "ID"
, status
, last_call_et "Last Activity"
from v$session
where username is not null
order by status desc
, last_call_et desc

2. Time since last user activity
set lines 100 pages 999
select username, floor(last_call_et / 60) "Minutes", statusfrom v$sessionwhere username is not nullorder by last_call_et

3. Sessions sorted by logon time
set lines 100 pages 999
col ID format a15col osuser format a15
col login_time format a14
select username, osuser, sid ',' serial# "ID", status, to_char(logon_time, 'hh24:mi dd/mm/yy') login_time, last_call_etfrom v$sessionwhere username is not nullorder by login_time

4. Show user info including os pid
col "SID/SERIAL" format a10
col username format a15col
osuser format a15col
program format a40
select s.sid ',' s.serial# "SID/SERIAL", s.username, s.osuser, p.spid "OS PID", s.programfrom v$session s, v$process pWhere s.paddr = p.addrorder by to_number(p.spid)

5. Show a users current sql
Select sql_textfrom v$sqlareawhere (address, hash_value) in(select sql_address, sql_hash_value from v$session where username like '&username')

6. Session status associated with the specified os process id
select s.username, s.sid, s.serial#, p.spid, last_call_et, statusfrom V$SESSION s, V$PROCESS pwhere s.PADDR = p.ADDRand p.spid='&pid'

7. All active sql
set feedback offset
serveroutput on size 9999
column username format a20
column sql_text format a55 word_wrapped
begin
for x in
(select username'('sid','serial#') ospid = ' process ' program = ' program username,
to_char(LOGON_TIME,' Day HH24:MI') logon_time,
to_char(sysdate,' Day HH24:MI') current_time,
sql_address,
sql_hash_value from v$session
where status = 'ACTIVE' and rawtohex(sql_address) <> '00'
and username is not null ) loop
for y in
(select sql_text from v$sqlarea where address = x.sql_address ) loop
if ( y.sql_text not like '%listener.get_cmd%' and
y.sql_text not like '%RAWTOHEX(SQL_ADDRESS)%' )
then dbms_output.put_line( '--------------------' );
dbms_output.put_line( x.username );
dbms_output.put_line( x.logon_time ' ' x.current_time ' SQL#=' x.sql_hash_value); dbms_output.put_line( substr( y.sql_text, 1, 250 ) );
end if;
end loop;
end loop;
end;
/
8. Display any long operations
set lines 100 pages 999
col username format a15
col message format a40
col remaining format 9999
select username, to_char(start_time, 'hh24:mi:ss dd/mm/yy') started, time_remaining remaining, messagefrom v$session_longops
where time_remaining = 0
order by time_remaining desc

9. List open cursors per user
set pages 999
select sess.username, sess.sid, sess.serial#, stat.value cursors
from v$sesstat stat, v$statname sn, v$session sess
where sess.username is not null
and sess.sid = stat.sid
and stat.statistic# = sn.statistic#
and sn.name = 'opened cursors current'
order by value

Copied from http://www.shutdownabort.com/

Steps to create Readonly/View Only User in OEM

2011-02-16T23:44:00.000-08:00

To create a new account with View Only privileges:

1. Logon to Grid Control as a super admin user (SYSMAN or equivalent)

2. Click on the links: Setup -> Administrators -> Click on Create

3. Remove the 'PUBLIC ROLE' that is listed by default

4. Under Create Administrator: System Privileges select 'VIEW ANY TARGET'.

5. Under Create Administrator: Targets, choose all the targets this new admin should be able to view

6. Under Create Administrator: Target Privileges , BATCH ASSIGN Choose 'View'

7. Click Apply

Reference - How To Create Administrator Accounts (Super Admin, Admin, View Only, etc) In Grid Control [ID 377310.1]

Steps to Remove/De-register Agent from OEM:

2011-02-16T22:06:00.000-08:00

1. Stop the Agent on the target machine:

cd /bin
emctl stop agent

2. Login to the Repository Ddatabase (via sqlplus) as user SYSMAN and execute the following command:
SQL> exec mgmt_admin.cleanup_agent(':');

For example:

SQL> exec mgmt_admin.cleanup_agent('ebsqa-mt.oracle_mt.com:3872');

PL/SQL procedure successfully completed.

3. De-install the Agent on the target machine.

Reference: Metalink Note - 438158.1 -- How to Cleanly De-Install the EM 10g Agent on Windows and Unix

Default Application users in 11i EBS

2010-09-30T02:33:00.000-07:00

We can find out the list of default users in 11i EBS with sql available 3904641 patch:

Below are list of Default Application users in EBS:

ANONYMOUS
AUTOINSTALL
CONCURRENT_MANAGER
FEEDER SYSTEM
INITIAL SETUP
STANDALONE_BATCH_PROCESS
MOBILEADM
ASGADM
WIZARD
ASGUEST
IEXADMIN
IBE_GUEST
IBE_ADMIN
IBEGUEST
OP_SYSADMIN
OP_CUST_CARE_ADMIN
IRC_EMP_GUEST
IRC_EXT_GUEST

How to Check Incompatibilities for Current Program From Applications

2009-10-11T19:55:00.000-07:00

How to Check Incompatibilities for Current Program From Applications:

Navigation:

Application Developer --> Program --> Incompatibilities.

Imp Queries on Troubleshooting concurrent request / manager issues

2009-10-06T01:10:00.000-07:00

Query to check the scheduled concurrent Requests/Programs:

SELECT cr.request_id,
DECODE (cp.user_concurrent_program_name,
'Report Set', 'Report Set:' || cr.description,
cp.user_concurrent_program_name
) NAME,
argument_text, cr.resubmit_interval,
NVL2 (cr.resubmit_interval,
'PERIODICALLY',
NVL2 (cr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')
) schedule_type,
DECODE (NVL2 (cr.resubmit_interval,
'PERIODICALLY',
NVL2 (cr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')
),
'PERIODICALLY', 'EVERY '
|| cr.resubmit_interval
|| ' '
|| cr.resubmit_interval_unit_code
|| ' FROM '
|| cr.resubmit_interval_type_code
|| ' OF PREV RUN',
'ONCE', 'AT :'
|| TO_CHAR (cr.requested_start_date, 'DD-MON-RR HH24:MI'),
'EVERY: ' || fcr.class_info
) schedule,
fu.user_name, requested_start_date
FROM apps.fnd_concurrent_programs_tl cp,
apps.fnd_concurrent_requests cr,
apps.fnd_user fu,
apps.fnd_conc_release_classes fcr
WHERE cp.application_id = cr.program_application_id
AND cp.concurrent_program_id = cr.concurrent_program_id
AND cr.requested_by = fu.user_id
AND cr.phase_code = 'P'
AND cr.requested_start_date > SYSDATE
AND cp.LANGUAGE = 'US'
AND fcr.release_class_id(+) = cr.release_class_id
AND fcr.application_id(+) = cr.release_class_app_id;

Query to check the duplicated schedules of the same program with the same arguments

SELECT request_id, NAME, argument_text, user_name
FROM (SELECT cr.request_id,
DECODE (cp.user_concurrent_program_name,
'Report Set', 'Report Set:' || cr.description,
cp.user_concurrent_program_name
) NAME,
argument_text, fu.user_name
FROM apps.fnd_concurrent_programs_tl cp,
apps.fnd_concurrent_requests cr,
apps.fnd_user fu
WHERE cp.application_id = cr.program_application_id
AND cp.concurrent_program_id = cr.concurrent_program_id
AND cr.requested_by = fu.user_id
AND cr.phase_code = 'P'
AND cr.requested_start_date > SYSDATE
AND cp.LANGUAGE = 'US'
AND fu.user_name NOT LIKE 'PPG%') t1
WHERE EXISTS (
SELECT 1
FROM (SELECT cr.request_id,
DECODE (cp.user_concurrent_program_name,
'Report Set', 'Report Set:'
|| cr.description,
cp.user_concurrent_program_name
) NAME,
argument_text, fu.user_name
FROM apps.fnd_concurrent_programs_tl cp,
apps.fnd_concurrent_requests cr,
apps.fnd_user fu
WHERE cp.application_id = cr.program_application_id
AND cp.concurrent_program_id =
cr.concurrent_program_id
AND cr.requested_by = fu.user_id
AND cr.phase_code = 'P'
AND cr.requested_start_date > SYSDATE
AND cp.LANGUAGE = 'US'
AND fu.user_name NOT LIKE 'PPG%') t2
WHERE t1.NAME = t2.NAME
AND t1.argument_text = t2.argument_text
AND t1.user_name = t2.user_name
GROUP BY NAME, argument_text, user_name
HAVING COUNT (*) > 1)
ORDER BY user_name, NAME

Query to check average pending time per request:

Note: Average pending time for a request is calculated like below:
("Highest of Requested_start_date or Date_submitted" - Actual_start_date ) / Total requests

A Request can be in Pending state for variety of reasons like conflict with other requests, improperly tuned managers (sleep seconds / cache size / number of managers etc)

We can schedule this script to gather data regularly for historical analysis as we normally purge the concurrent requests regularly.
SELECT TO_CHAR (actual_start_date, 'DD-MON-YYYY') DAY,
concurrent_queue_name,
(SUM ( ( actual_start_date
- (CASE
WHEN requested_start_date > request_date
THEN requested_start_date
ELSE request_date
END
)
)
* 24
* 60
* 60
)
)
/ COUNT (*) "Wait_Time_per_Req_in_Secs"
FROM apps.fnd_concurrent_requests cr,
apps.fnd_concurrent_processes fcp,
apps.fnd_concurrent_queues fcq
WHERE cr.phase_code = 'C'
AND cr.actual_start_date IS NOT NULL
AND cr.requested_start_date IS NOT NULL
AND cr.controlling_manager = fcp.concurrent_process_id
AND fcp.queue_application_id = fcq.application_id
AND fcp.concurrent_queue_id = fcq.concurrent_queue_id
GROUP BY TO_CHAR (actual_start_date, 'DD-MON-YYYY'), concurrent_queue_name
ORDER BY 2

Query to checking which manager is going to execute a program:

SELECT user_concurrent_program_name, user_concurrent_queue_name
FROM apps.fnd_concurrent_programs_tl cp,
apps.fnd_concurrent_queue_content cqc,
apps.fnd_concurrent_queues_tl cq
WHERE cqc.type_application_id(+) = cp.application_id
AND cqc.type_id(+) = cp.concurrent_program_id
AND cqc.type_code(+) = 'P'
AND cqc.include_flag(+) = 'I'
AND cp.LANGUAGE = 'US'
AND cp.user_concurrent_program_name = '&USER_CONCURRENT_PROGRAM_NAME' AND NVL (cqc.concurrent_queue_id, 0) = cq.concurrent_queue_id
AND NVL (cqc.queue_application_id, 0) = cq.application_id
AND cq.LANGUAGE = 'US'

Query to see all the pending / Running requests per each manager wise :

SELECT request_id, phase_code, status_code, user_name,
user_concurrent_queue_name
FROM apps.fnd_concurrent_worker_requests cwr,
apps.fnd_concurrent_queues_tl cq,
apps.fnd_user fu
WHERE (cwr.phase_code = 'P' OR cwr.phase_code = 'R')
AND cwr.hold_flag != 'Y'
AND cwr.requested_start_date <= SYSDATE
AND cwr.concurrent_queue_id = cq.concurrent_queue_id
AND cwr.queue_application_id = cq.application_id
AND cq.LANGUAGE = 'US'
AND cwr.requested_by = fu.user_id
ORDER BY 5

Query to checking the incompatibilities between the programs:

SELECT a2.application_name, a1.user_concurrent_program_name,
DECODE (running_type,
'P', 'Program',
'S', 'Request set',
'UNKNOWN'
) "Type",
b2.application_name "Incompatible App",
b1.user_concurrent_program_name "Incompatible_Prog",
DECODE (to_run_type,
'P', 'Program',
'S', 'Request set',
'UNKNOWN'
) incompatible_type
FROM apps.fnd_concurrent_program_serial cps,
apps.fnd_concurrent_programs_tl a1,
apps.fnd_concurrent_programs_tl b1,
apps.fnd_application_tl a2,
apps.fnd_application_tl b2
WHERE a1.application_id = cps.running_application_id
AND a1.concurrent_program_id = cps.running_concurrent_program_id
AND a2.application_id = cps.running_application_id
AND b1.application_id = cps.to_run_application_id
AND b1.concurrent_program_id = cps.to_run_concurrent_program_id
AND b2.application_id = cps.to_run_application_id
AND a1.language = 'US'
AND a2.language = 'US'
AND b1.language = 'US'
AND b2.language = 'US'

Forms URL in R12

2009-10-06T01:09:00.001-07:00

Forms URL in R12

When using Forms Servlet Mode:

http://.:/forms/frmservlet
Note: Modify the context variable parameter (s_appserverid_authentication) from SECURE to OFF and run autoconfig, then forms will startup without that authorization error.
When using Forms Socket Mode:
http://.:/OA_HTML/frmservlet
Query to get URL in Applications:

1. select profile_option_value from fnd_profile_option_values where profile_option_value like '%http%';

2. select home_url from icx_parameters;

Query to find Patch Level for a product searching with application Name

2009-10-06T01:07:00.000-07:00

Query to find Patch Level for a product searching with application Name(Product)/application (Product) short name

select fav.application_name,fav.application_id,fav.application_short_name,fpi.status,fpi.patch_level from fnd_application_vl fav,
fnd_product_installations fpi
where fpi.application_id=fav.application_id and fav.application_short_name ='&x'

Steps to find password for an application user in oracle applications

2009-09-07T12:10:00.000-07:00

Steps to find password for an application user in oracle applications:

1. Create get_pwd package

CREATE OR REPLACE PACKAGE get_pwd AS FUNCTION decrypt ( KEY IN VARCHAR2 ,VALUE IN VARCHAR2 ) RETURN VARCHAR2; END get_pwd;
/

2. Create get_pwd package body

CREATE OR REPLACE PACKAGE BODY get_pwd AS FUNCTION decrypt ( KEY IN VARCHAR2 ,VALUE IN VARCHAR2 ) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; END get_pwd;
/

3. Query to get password for apps user.

SELECT (SELECT get_pwd.decrypt (UPPER ((SELECT UPPER (fnd_profile.VALUE ('GUEST_USER_PWD')) FROM DUAL)), usertable.encrypted_foundation_password) FROM DUAL) AS apps_password FROM fnd_user usertable WHERE usertable.user_name LIKE UPPER ((SELECT SUBSTR (fnd_profile.VALUE ('GUEST_USER_PWD') ,1 , INSTR (fnd_profile.VALUE ('GUEST_USER_PWD'), '/') - 1 ) FROM DUAL))

4. Query to get password for any application user.

SELECT usertable.user_name , (SELECT get_pwd.decrypt (UPPER ((SELECT (SELECT get_pwd.decrypt (UPPER ((SELECT UPPER (fnd_profile.VALUE ('GUEST_USER_PWD')) FROM DUAL)), usertable.encrypted_foundation_password) FROM DUAL) AS apps_password FROM fnd_user usertable WHERE usertable.user_name LIKE UPPER ((SELECT SUBSTR (fnd_profile.VALUE ('GUEST_USER_PWD') ,1 , INSTR (fnd_profile.VALUE ('GUEST_USER_PWD'), '/') - 1 ) FROM DUAL)))) ,usertable.encrypted_user_password) FROM DUAL) AS encrypted_user_password FROM fnd_user usertable WHERE usertable.user_name LIKE UPPER ('&username')

How to change an Oracle password temporarily

2009-05-21T05:10:00.000-07:00

In Oracle it is possible to change a password temporarily. This can be useful for DBA which act as a different user.

SQL> select username,password from dba_users where username='GEORGE';

USERNAME PASSWORD
-------- ----------------
GEORGE F894844C34402B67

SQL> alter user george identified by welcome123;

Now login with the following credentials: george/welcome(old passwd)
After doing your work you can change the password back by using an undocumented feature called "by values"

SQL> alter user george identified by values 'F894844C34402B67';

Server usage CMDS in Solaris

2009-05-05T02:18:00.000-07:00

Some Imp Cmd's in Solaris:

1. CPU Speed
/usr/sbin/psrinfo -v -- CPU SPEED -- 1800 MHZ

2. RAM Size
prtconf | grep Memory -- RAM Size -- 64 Gb

3. No. of CPU's,O.S.Version,Kernel Version etc.,
uname -X

VLOOKUP function in M.S. Excel with example

2009-04-09T03:35:00.000-07:00

http://www.timeatlas.com/mos/5_Minute_Tips/General/Learning_VLOOKUP_in_Excel/

Error while running adbldxml.pl after upgrading database to 11.1.0.7 from 9.2.0.8

2009-04-03T05:01:00.000-07:00

Error while running adbldxml.pl after upgrading database to 11.1.0.7 from 9.2.0.8
The following error was encountered while running adbldxml.pl on the database tier to create the context file.

====================================================================
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Connecting to the wish database instance...

Connection paramaters values:
Database server hostname ==> SPINNER.LINKPC.NET
Database listener port ==> 1523
Database SID ==> wish
Database schema name ==> apps

Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

AC-40000: Error: Exception - java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
====================================================================

The problem was that the database was not registered with the listener.

SQL> show parameter local_listener;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string

The value for LOCAL_LISTENER is missing, so automatic instance registration is not taking place
We can correct this by setting the LOCAL_LISTENER parameter:

SQL> alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=host.domain.com)(PORT=port_number)(SID=sid_name))';

System altered.

SQL> alter system register;

System altered.

SQL> exit

Check TNS_ADMIN value. This should point to new O-H Path i.e., 11.1.0.6

Now adbldxml runs successfully.

Queries to verify OATM Migration

2009-03-23T04:38:00.000-07:00

select migration_status,error_text from FND_TS_MIG_CMDS where migration_status ='ERROR'

select * from all_objects where object_name like 'FND_TS%' and object_type='TABLE'

select * from FND_TS_MIG_STATUS

select * from FND_TS_SIZING

select IS_NEW_TS_MODE from fnd_product_groups (o/p should be “Y”

Query to find type of objects available in a tablespace

2009-03-17T23:12:00.000-07:00

select ds.segment_name,do.object_type,do.status,ds.tablespace_name from dba_segments ds,dba_objects do where ds.tablespace_name='TOOLS'

Query to count no. of segments in each t.s.

2009-03-17T23:11:00.000-07:00

select tablespace_name,count(*) from dba_segments group by tablespace_name;

Query to get workflow using WFLOAD

2009-03-16T23:54:00.000-07:00

WFLOAD apps/W1tty 0 Y DOWNLOAD <<(d/w file)I2PATCARD_prd.wft>> <<(original file) PATCARD>>

tkprof Execution

2009-03-16T02:19:00.001-07:00

tkprof orcl_ora_4930.trc report.out SYS=NO EXPLAIN=SCOTT/TIGER

Queries to find Database Size

2009-03-09T02:45:00.000-07:00

The database mainly comprises of datafiles, temp files and redo log files.
The biggest portion of a database’s size comes from the datafiles.

To find out how many megabytes are allocated to all datafiles:

SELECT sum(bytes)/1024/1024 data_size FROM dba_data_files;

To get the size of all TEMP files:

SELECT nvl(sum(bytes),0)/1024/1024 temp_size FROM dba_temp_files;

To get the size of the on-line redo-logs:

SELECT sum(bytes)/1024/1024 redo_size FROM sys.v_$log;

Finally, summing up the three above, total database size can be found:

SELECT (dsize.data_size + tsize.temp_size + rsize.redo_size)/1024/1024 "total_size"
FROM (SELECT sum(bytes) data_size
FROM dba_data_files ) dsize,
(SELECT nvl(sum(bytes),0) temp_size
FROM dba_temp_files ) tsize,
(SELECT sum(bytes) redo_size
FROM sys.v_$log ) rsize;

Query to find space used by a database user

2009-03-09T02:44:00.001-07:00

Query to find space used by a database user. Following query can be used to know the space used by the logged in user in MBs:

SELECT sum(bytes)/1024/1024 user_size FROM user_segments;

Query to find the space occupied by all the users in a database. This requires access to dba_segments table:

SELECT owner, sum(bytes)/1024/1024 total_size FROM dba_segments
GROUP BY owner ORDER BY total_size DESC;

Total space occupied by all users:

SELECT sum(bytes)/1024/1024 total_size FROM dba_segments;

Login to Oracle Applications directly thru f60cgi

2009-03-04T02:35:00.000-08:00

Accessing f60cgi is disabled in 11.5.10
----------------------------------------

With increased security in Oracle EBusiness Suite 11.5.10, the ability to
connect directly to forms via f60cgi has been disabled. By default, a user will
see the following error after entering their username and password:

APP-FND-01542: This Applications Server is not authorized to access this database.

This is expected functionality.

Enabling f60cgi direct login
------------------------------

It is possible to login however this method should only be used when
debugging problems.

1. Backup and open $APPL_TOP/admin/_.xml context file

2. Update the context variable:
s_appserverid_authentication

By default in 11.5.10, this is set to SECURE.
In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF.

Modes:
- ON : Partial
- SECURE : activates full server security (SECURE mode)
- OFF : deactivates server security

3. Run Autoconfig to instantiate the change.

You should now be able to access forms directly again using the f60cgi call.

4. After you have finished your Forms debugging, please reset
s_appserverid_authentication to SECURE and re-run Autoconfig.

Alternative option
---------------------

Running Autoconfig is the preferred method of updating
s_appserverid_authentication.

If you are unable to run Autoconfig during troubleshooting, you can run the
the following commands instead from $FND_TOP/secure directory:

Disable:

java oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION OFF DBC=host_visdemo1.dbc

Enable:

To activate basic server security, from the command line, enter:

jre oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION ON DBC=

To activate full server security (SECURE mode), from the command
line, enter:

jre oracle.apps.fnd.security.AdminAppServer apps/apps \
AUTHENTICATION SECURE DBC=

Check the status:

java oracle.apps.fnd.security.AdminAppServer apps/apps \
STATUS DBC=host_visdemo1.dbc

Reference:
552301.1 How To Access Forms Directly In Oracle Applications R12

Query to find the responsibilty for which form was assigned

2009-03-03T21:55:00.000-08:00

SELECT fu.user_name,fu.description,furg.start_date,
frvl.responsibility_name,fff.function_name,ff.form_name
FROM fnd_user fu,fnd_user_resp_groups furg,fnd_responsibility_vl frvl,
fnd_compiled_menu_functions fcmf,fnd_form_functions_vl fff,fnd_form_vl ff
WHERE fu.user_id = furg.user_id
AND furg.responsibility_id = frvl.responsibility_id
AND frvl.menu_id = fcmf.menu_id
AND fff.function_id = fcmf.function_id
AND fff.form_id = ff.form_id
AND (fu.end_date IS NULL OR fu.end_date >= SYSDATE)
AND (furg.end_date IS NULL OR furg.end_date >= SYSDATE)
AND (frvl.end_date IS NULL OR frvl.end_date >= SYSDATE)
AND form_name IN ('FORMNAME')

How to find Components version in R12

2009-02-25T23:23:00.000-08:00

Apache Version

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

Perl Version

$IAS_ORACLE_HOME/perl/bin/perl -v|grep built

Java Version

sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"

Jre version
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

Forms Version

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

Plsql Version

$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

Forms Communication mode

cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"

OATM Conversion Steps

2009-02-25T02:01:00.001-08:00

http://www.scribd.com/doc/6813095/OATM-Conversion

Basic Unix Shell scritps for DBA

2009-02-24T04:17:00.000-08:00

http://www.bijoos.com/ora7/oracle_unix.htm

Following are the shell scripts available:

1. Alert Log
2. To ping other servers on the network
3. To tnsping all Oracle databases on the network
4. To compare and verify if all instances mentioned in /etc/oratab is up and running
5. Alert for potential space problems and invalid objects, triggers
6. Script to identify the top 20 longest running oracle sessions
7. Useful if you have multiple versions of oracle on the same box
8. This script may be used as a cronjob to coalesce the tablespaces periodically

and many more

Basic Unix commands 4 DBA

2009-02-24T04:12:00.000-08:00

http://www.bijoos.com/oracle/unix4dba1.htm

Queries on maintenance mode

2009-02-24T03:49:00.000-08:00

Query to know status of maintenance mode:
select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

Query to ENABLE of maintenance mode:
sqlplus -s &un_apps/***** @/tcme3i/applmgr/1159/ad/11.5.0/patch/115/sql/adsetmmd.sql ENABLE

Query to DISABLE of maintenance mode:
sqlplus -s &un_apps/***** @/tcme3i/applmgr/1159/ad/11.5.0/patch/115/sql/adsetmmd.sql DISABLE

Steps to resolve locks on database

2009-02-23T21:42:00.000-08:00

Error Message:Could Not Reserve Records Due to Database Record Lock

1. Identify the Oracle serial ID, SID ID and terminate without shutting the
database down.

1.1 Make sure that the user is logged off.

1.1.1 Type ps -ef |grep

1.1.2 Kill all processes related to that user.

1.2 Identify SID, serial#

select distinct
acc.object, ses.osuser, ses.process,
ses.sid, ses.serial#
from v$access acc,
v$session ses
where (acc.owner != 'SYS'
or acc.object = 'PLAN_TABLE')
and acc.sid = ses.sid
and ses.status != 'INACTIVE'
and ses.type != 'BACKGROUND'
and acc.object not in ('V$ACCESS','V$SESSION')
and ses.audsid != userenv('SESSIONID')
order by 1,2,3
/

1.3. Double-check the identified SID and serial ID:

SELECT osuser,
username,
process,
sid,
serial#,
status,
to_char(logon_time,'DD-MON HH24:MI:SS') logon_time,
machine,
program
FROM v$session
WHERE sid = &SID_NUM
/

1.4. ALTER SYSTEM KILL SESSION '&SID_NUM,&SERIAL_NUM';
Alternatively use the following scripts to identify the blocking session:

-- check for locked tables
select a.object_id, a.session_id, substr(b.object_name, 1, 40)
from v$locked_object a,
dba_objects b
where a.object_id = b.object_id
order by b.object_name ;

--find_blocked.sql
select sid,
decode(block ,0,'NO','YES') BLOCKER,
decode(request,0,'NO','YES') WAITER
from v$lock
where request > 0 or block > 0 order by block desc
/

SELECT 'alter system kill session '''||vs.sid||','||vs.serial#||'''' ,al.
object_name, al.object_type, vs.status,
fu.user_name,vs.process,vs.osuser,vs.username,
to_char(vs.logon_time,'DD-MON HH24:MI:SS') logon_time, vs.program
FROM fnd_logins fl, fnd_user fu, all_objects al, v$lock vl, v$session vs
WHERE fl.pid = vl.sid
AND vl.id1 = al.object_id (+)
AND fl.user_id = fu.user_id
AND to_char (start_time, 'DD-MON-RR') = to_char (sysdate, 'DD-MON-RR')
and vs.sid=vl.sid
and vl.sid = &sid

'ALTERSYSTEMKILLSESSION'''||VS.SID||','||VS.SERIAL#||''''

Reference :

Metalink Note ID: 140969.1

Query to find free space in temporary tablesapce:

2009-02-20T00:41:00.000-08:00

SELECT tablespace_name,SUM(bytes_used),SUM(bytes_free) FROM V$temp_space_header GROUP BY tablespace_name;

Script to find tablespace free space in a database

2009-02-17T04:35:00.001-08:00

SELECT a.tablespace_name, a.file_name, a.bytes allocated_bytes,
b.free_bytes
FROM dba_data_files a,
(SELECT file_id, SUM(bytes) free_bytes
FROM dba_free_space b GROUP BY file_id) b
WHERE a.file_id=b.file_id
and a.tablespace_name='SYSTEM'
ORDER BY a.tablespace_name;

Script to find Table size in a database

2009-02-11T05:31:00.001-08:00

Script to find Table size in a database.

select sum(BYTES/1024/1024) as TOTAL_GIG from user_segments where
SEGMENT_NAME = 'TABLE_NAME';

Note: Need to execute as owner of the table.

(OR)

select sum(BYTES/1024/1024) as TOTAL_GIG from dba_segments where SEGMENT_NAME='FND_TS_MIG_CMDS'

Default Permissions in Unix

2009-02-11T03:38:00.001-08:00

Default Permissions in Unix:

1. For a File -- 644

2. For a Directory -- 755

3. user home directory at the time user creation -- 700

eg: useradd -g dba -d /home/user1

Here directory "user1" have 700 permissions by default.

Best site for DBA Monitoring Scripts

2009-02-10T22:03:00.000-08:00

http://www.oracle-base.com/dba/DBACategories.php

Diff bet ad_bugs and ad_appiled_patches tables

2009-02-02T00:43:00.000-08:00

Diff bet ad_bugs & ad_appiled_patches tables

AD_BUGS - AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie.patched) in the Oracle Applications installation.

AD_APPLIED_PATCHES - gives information only abt the bugs/patches those we applied after installation
- holds information about the "distinct" Oracle Applications patches that have been applied. If 2 patches happen to have the same name but are different in content (eg. "merged" patches), then they are considered distinct and this table will therefore hold 2 records.

AutoPatch modes, arguements and options

2009-01-08T01:38:00.000-08:00

Filed under: Oracle Application R12, Oracle Applications 11i

Tags: adpatch, adpatch options, patching options

Here are the various options for applying the patch in Oracle apps 11i and R12. ADpatch comes with lots of option that can be used, especially when we are applying the patch in production.

Modes of ADPATCH

If we talk about the mode of applying patch, there are 3 modes

1) Pre-Install Mode

Pre-install mode is used to update AD utilities before an upgrade and to apply family consolidated upgrade packs.
AutoPatch Pre-AutoInstall mode allows you to apply patches when your installation is missing database information and/or filesystem information that AutoPatch requires to run in normal mode.

Examples of when you would run AutoPatch in Pre-AutoInstall mode (and cannot run it in normal mode) include:

Prior to installing Oracle Applications for the first time
Prior to upgrading Oracle Applications to the latest release.
During an upgrade (to apply a bug fix that stopped your upgrade)

Applying patch in pre-install mode performs following tasks:

1.Version checking
2.File copy actions
3.Relink FND and AD executables
4.Save patch history information to file system
5.AutoPatch in pre-install mode will NOT:
6.Run SQL of EXEC command
7.Generate files
8.Read product driver files
9.Apply maintenance pack

To apply patch in pre-install mode, run

$adpatch preinstall=y

2) Test Mode

AutoPatch provides a test mode in which it tells you everything it would have done in applying a patch, but doesn’t actually apply the patch.
To run AutoPatch in Test Mode, you must include ‘apply=no’ on the AutoPatch command line.

For example:
$ adpatch apply=no

Instead of performing an action, AutoPatch indicates that it is not performing the action because “Apply=No”. In general, AutoPatch lists each file it would have copied, generated, relinked, or executed. This shows you exactly what actions it would have performed.

AutoPatch test mode works the same as normal mode, with the following exceptions:

1.It does not copy any files from your patch directory into your installation area.
2.It does not copy any files from your APPL_TOP to JAVA_TOP or OAH_TOP.
3.It does not archive any object modules into your product libraries.
4.It does not generate any forms or reports.
5.It does not relink any executables.
6.It does not run any ’sql’ or ‘exec’ commands.
7.It does not update the release version in the database.
8.It does not update the patch history file.

AutoPatch asks you the same initial questions in test mode as in normal mode. It performs the following actions to determine what it would have done if run in normal mode:

1.Reads and validates the patch driver file.
2.Reads product file driver files.
3.Extracts object modules from your product libraries (so it can perform version checking on the object modules it extracts).
4.Performs version checking.
5.Looks in the database to determine what ’sql’ and ‘exec’ comands it would have run.

Its a good practice to run the patch in test mode and analyze the things before applying the patch in normal mode.

3) Non-Interactive Mode

Starting in Release 11.5, you can run AutoPatch non-interactively.

Creating a defaults file

Before you can run AutoPatch non-interactively, you must first create an AutoPatch defaults file for your current environment.

Here is a simple way to create an AutoPatch defaults file for your current environment:

1. Specify defaultsfile= on the AutoPatch command line. The defaults file must be located under $APPL_TOP/admin/.

For example:
adpatch defaultsfile=$APPL_TOP/admin/testdb1/my_def.txt

2. Run AutoPatch up to the point where it asks you for the directory where your Oracle Applications patch has been unloaded. Then type ‘abort’ at this prompt.

3. Verify that your defaults file exists.
Once you have an AutoPatch defaults file for your current environment, you can run AutoPatch non-interactively.

Applying a single patch driver file non-interactively

Before applying any Oracle Applications patch, either interactively or non-interactively, you should read the README file (usually called readme.txt) supplied with the patch. You should also read the documentation supplied with the patch (if any).

It is possible to apply just a single patch driver file non-interactively using AutoPatch. Here is an example:

Assume the following:

1. defaults file is $APPL_TOP/admin/spin/def.txt
2. Applying copy driver for patch 123456, which is located in directory $APPL_TOP/patch/123456.
3. Using three parallel workers
AutoPatch log file name is cpy123456.log

The AutoPatch command line would be:

adpatch defaultsfile=$APPL_TOP/admin/spin/def.txt \
logfile=cpy123456.log \
patchtop=$APPL_TOP/patch/123456 \
driver=c123456.drv \
workers=3 \
interactive=no

If we dont give any of the mode as mentioned above and apply the patch simply using adpatch command then its a normal mode of patch application.

Having seen the modes of patch application, now we will see various arguements for applying patch.

1) defaultsfile
Purpose: This option is used when we are running the patch in non interactive mode. In that case we create defaults file and provide that file as an option for running patch in non-interactive mode.
Default: none. No default file read or written.

2) logfile
Purpose: This is the name of adpatch log file which it will write during patch application.
Default: none. Adpatch prompts for this value.

3) workers
Purpose: Specifies the number of workers to run. This value depends on number of CPU and other factors.
Default: none. Adpatch prompts for this value.

4) patchtop
Purpose: Top-level directory for the current patch. This is the directory after unzipping the patch. This directory will a patch number.
Default: none. Adpatch prompts for this value.

5) driver
Purpose: Name of the patch driver file. This comes with the patch and is present in patch directory.
Default - none. Adpatch prompts for this value.

6) restart
Purpose: To restart an existing session. Only valid when interactive=no is also specified
Default: No

7) localworkers
Purpose: Used in Distributed AD to specify the number of workers to be run on the current machine. If you have multi node instance (example RAC and shared APPL_TOP), then you can utilize this paramter to run the patch parallely in multiple nodes. You can start few workers on node 1, few on node 2 and so on. The way this can be done is that, you can start adpatch on one node with localworker=. Then run adctrl on other node in distributed mode and start some mode workers. This will speed up the process and utilized the resources effectively.
Default: Value specified for workers.

8. printdebug
Purpose: To display extra debugging information.
Default: No.

Now lets consider some common options that can be used with adpatch options=

1) checkfile
Purpose: To skip running exec, SQL, and exectier commands if they are recorded as already run. Indicates that Autopatch should run the command *only* if a certain file is newer than the version of it that was last run. The idea behind it is to reduce the duration of an Autopatch session by skipping actions that don’t really need to be performed. When used in the right manner, it can dramatically improve Autopatch performance, especially for big patches and/or long running actions.
Default: checkfile (use ‘nocheckfile’ to skip)

2) compiledb
Purpose: To compile invalid objects in the database after running actions in the database driver.
Default: compiledb (use ‘nocompiledb’ to skip)

3) compilejsp
Purpose: To compile out-of-date JSP files, if the patch has copy actions for at least one JSP file.
Default: compilejsp (use’nocompilejsp’ to skip)

4) copyportion
Purpose: To run commands found in a copy driver. This will copy the higher version files from patch to product top.
Default: copyportion (Use ‘nocopyportion’ to skip. Use it only when mentioned in readme of patch)

5) databaseportion
Purpose: To run commands found in a database driver. This portion includes applying the files (like sql, pls etc) to database.
Default: databaseportion (use ‘nodatabaseportion’ to skip. Use it only when mentioned in readme of patch)

6) generateportion
Purpose: To run commands found in a generate driver. This portion will generate new executable files from the copied code of patch. For example if will generate new forms files (fmx) from new .fmb files.
Default: generateportion (use ‘nogenerateporation’ to skip)

7) integrity
Purpose: To perform patch integrity checking. Tells adpatch whether to perform patch integrity checking, which verifies that the version of each file referenced in a copy action matches the version present in the patch.
Default: nointegrity (By default the integrity is not checked)

8. maintainmrc
Purpose: To maintain the MRC schema after running actions found in the database driver.
Default: maintainmrc (use ‘nomaintainmrc’ to skip)

9) autoconfig
Purpose: Tells adpatch to run Autoconfig after patch installation.
Default: autoconfig (use ‘noautoconfig’ to skip)

10) parallel
Purpose: To run actions that update the database or actions (like SQL) that generate files in parallel (like genform).
Default: parallel (use ‘noparallel’ to skip)

11) prereq
Purpose: Tells adpatch whether to perform prerequisite patch checking prior to running patch driver files that contain actions normally found in the copy driver.
Default: prereq (use ‘noprereq’ to skip)

12) validate
Purpose: To connect to all registered Oracle Applications schemas at the start of the patch. Adpatch validates the passwords for each schema.
Default: novalidate (use ‘validate’ to validate schema passwords)

Following flags can be passed to adpatch:

1) hidepw
Purpose: This argument is used to hide the passwords in log files
Default: nohidepw

2) trace
Purpose: Tells the adpatch utility whether to log all database operations to a trace file
Default: notrace

3) logging
Purpose: Tells the adpatch utility whether to create indexes using the logging or nologging mode.
Default: logging

Hope this helps !!

Important tables for ADPATCH

2009-01-08T01:24:00.000-08:00

Filed under: Oracle Application R12, Oracle Applications 11i
Tags: ad tables, adpatch tables, etrm

Here are some of the important tables used by and updated by ADPATCH utility.

AD_APPL_TOPS

This table holds the various APPL-TOP’s in the Oracle Applications installation that have ever been patched.

AD_APPLIED_PATCHES

AD_APPLIED_PATCHES holds information about the “distinct” Oracle Applications patches that have been applied. If 2 patches happen to have the same name but are different in content (eg. “merged” patches), then they are considered distinct and this table will therefore hold 2 records.

AD_BUGS

AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.

AD_PATCH_DRIVERS

This table holds information about the patch drivers that comprise a patch.

AD_FILE_VERSIONS
This table holds the various versions of Oracle Applications files (real files, not “pseudo-files”), that have ever been patched or executed in the Oracle Applications installation.

AD_FILES

AD_FILES is the “files repository”. It contains information about the various files that have been patched in the Oracle Applications installation.
Some entries are “pseudo-files” and not real files, (eg. directories) in which case some of the columns are not applicable and would then hold the value “DUMMY”

AD_PATCH_DRIVER_LANGS

NLS patches (or more specifically, NLS patch drivers) pertain to a language or multiple languages. This table holds that language (or multiple languages).

AD_PATCH_DRIVER_MINIPKS

This table holds information about the various Mini Packs contained in a patch (driver)

AD_PATCH_RUN_BUG_ACTIONS

holds the various actions present in “applied” bug (fix). If Autopatch determined not to apply a bug (fix), then this table will not hold any records for that “unapplied” bug fix.

AD_PATCH_RUN_BUG_ACTIONS

Even though a patch may have been applied on an Oracle Applications installation, some actions in some of its included bugs (fixes) may not have got executed if the “Autopatch” utility determined that it was not necessary to execute those actions. In such cases, EXECUTED_FLAG is set to N.

AD_PATCH_RUN_BUGS

This table holds information about the bugs fixed in a specific run of Autopatch.
AD_PATCH_RUN_BUGS holds information about the various bugs fixed in a specific run of Autopatch.
Even though a patch may have been applied on an Oracle Applications installation, some bugs (fixes) contained in it may not get applied due to some reason. In such cases, the REASON_NOT_APPLIED column holds the reason.

AD_PATCH_RUNS

AD_PATCH_RUNS holds information about the various invocations of Autopatch for applying Oracle Applications patches to a specific release of an Oracle Applications installation.
If multiple drivers are run in one invocation of Autopatch, they result in multiple records in this table. These multiple records will all have the same SESSION_ID (because they arose from one Autopatch invocation), but different TASK_NUMBER’s. The TASK_NUMBER’s in this case will be numbered sequentially as 1, 2, 3, etc.
Note that when the database driver of a Maintenance Pack is applied, it bumps up the release version by creating a new record in AD_RELEASES, which is then pointed to by the UPDATED_TO_RELEASE_ID column of the old record.

AD_RELEASES

AD_RELEASES holds the various Oracle Applications releases that an installation of Oracle Applications has gone through in its entire life cycle.
It should be noted that START_DATE_ACTIVE, END_DATE_ACTIVE and BASE_RELEASE_FLAG are loosely-maintained informational columns and are not accurately maintained, and therefore should not be relied upon heavily.

AD_PATCH_COMMON_ACTIONS

This table holds distinct information about the various actions that are (often repeatedly) performed by Autopatch as part of applying patches.

References:

Metalink ETRM DIRECT ACCESS DOCUMENT 150230.1

Hope this helps!!

EBS Forms problem in Windows Vista / Server 2008

2009-01-05T22:26:00.000-08:00

This is the problem with JInitiator. The DLL (Dynamic Link Libraries) file present in the JInitiator is not supported by VISTA / Windows Server 2008. Need to replace them with the latest one.
1. Go to (JInitiator installed location)\bin\hotspot
(Default JInitiator installed location: C:\Program Files\Oracle\JInitiator 1.1.8.16)
2. Find ‘jvm.dll’ file
3. Replace this with the latest one

Latest version of this file can be found here.
1. If you have latest Java / JRE installed on your system, go to
(JRE installed location)\bin\client -> here you can find the jvm.dll file, copy this file and paste it in \bin\hotspot, click yes, when prompts for replace.
(Default JRE installed location: C:\Program Files\Java\jre1.6.0_07)

Note: Update the jre to the latest version before replacing jvm.dll file to ensure that you are replacing with the latest one.

Invalid range "a-Z" in transliteration operator

2009-01-05T02:14:00.000-08:00

Error while running Pre-Clone Script.

Environment : Linux A.S.4
Bit : 32
Version : 11.5.10

[applspin@spinner SPIN_spinner]$ ./adpreclone.pl appsTier
Invalid range "a-Z" in transliteration operator at /d02/applspin/spinora/iAS/Apache/perl/lib/5.00503/vars.pm line 17.
Compilation failed in require at /d02/applspin/spinora/iAS/Apache/perl/lib/5.00503/File/Copy.pm line 13.
BEGIN failed--compilation aborted at /d02/applspin/spinora/iAS/Apache/perl/lib/5.00503/File/Copy.pm line 13.
Compilation failed in require at ./adpreclone.pl line 36.
BEGIN failed--compilation aborted at ./adpreclone.pl line 36.

Solution:

Open $IAS_ORACLE_HOME/Apache/perl/lib/5.00503/vars.pm and change (line 17):

if ($sym =~ tr/A-Za-Z_0-9//c) {

change to
if ($sym =~ tr/A-Za-z_0-9//c) {

(The change is the single character Z->z)

[applspin@spinner SPIN_spinner]$ ./adpreclone.pl appsTier
Completed Successfully

Reference: From Forums.

https://metalink2.oracle.com/metalink/plsql/f?p=200:27:7385154415821451567::::p27_id,p27_show_header,p27_show_help:677071.993,1,1

Steps to Create and Register a Custom Concurrent Program

2008-12-29T01:56:00.000-08:00

Steps to Create & Register a Custom Concurrent Program

Eg: Apache Bouncing Script.

Procedure:
~~~~~~~~~~~~
$cd <$CUST_COMMON_TOP>/bin
$ln -s $FND_TOP/bin/fndcpesr .

Create a shell script under $CUST_COMMON_TOP/bin .

vi adapcctl
***************************
#!/bin/ksh
#i2 Apache bounce script

ORA_USER_PASS=$1
USERID=$2
USERNAME=$3
REQUESTID=$4
export ORA_USER_PASS USERID USERNAME REQUESTID
action=`echo $ORA_USER_PASS |sed -e 's/.* //'|sed -e 's/\"//g'`
echo
echo "User selected action: $action"
echo

$COMMON_TOP/admin/scripts/$CONTEXT_NAME/adapcctl.sh $action
exit $?
***********************************************
chmod 755 the shell script.

Next you have to make into system administrator responsibly follow 3 steps from these menu

I. * sysadmin -> concurrent-> program -> executable

Executable: I2Apache
Short Name: I2APACHE
Application: i2 Custom COMMON
Description: I2 APACHE BOUNCE
Execution Method: Host
Execution File Name: adapcctl

II. * sysadmin -> concurrent-> program -> define

Program Name: i2 Apache
Short Name: I2APACHE
Application: i2 Custom COMMON
Description: I2 APACHE BOUNCE

=> Also add a parameter

III. * sysadmin ->security -> responsibility -> request => add it the responsibility.

Group: i2 Sysadmin
Application: i2 Custom COMMON
Code: I2_SYSADMIN

IV. Bounce the Concurrent Manager.

V. Verify your custom concurrent program.

Reference:

Metalink note numbers :266268.1 & 156636.1

Error while installing 11.5.10 on Linux AS 4

2008-12-18T21:39:00.000-08:00

Error while installing 11.5.10 on Linux AS 4

$ export LD_ASSUME_KERNEL=2.4.19

$ ./rapidwiz

Rapid Install Wizard is validating your file system......
Rapid Install Wizard will now launch the Java Interface.....

Exception in thread "main" java.lang.NoClassDefFoundError: UniWordWrapper
at TechStackPanel.CreateControls(TechStackPanel.java:99)
at TechStackPanel.(TechStackPanel.java:73)
at RIWizard.(RIWizard.java:464)
at RIWizard.main(RIWizard.java:1349)

SOL:

1. Check rapidwiz version

$rapidwiz -version

11.5.10.29

The most current version of the Rapid Install wizard is 11.5.10.35

2. Download startCD (Patch 4159029) which contains RapidWiz version 11.5.10.34 and unzip & install patch where startCD is located becoz it overwrites the startCD.

3. Start Installation.
$ ./rapidwiz

Reference:
http://forums.oracle.com/forums/thread.jspa?threadID=550513

Oracle Metalink Notes for Oracle Apps DBAs.

2008-12-17T21:21:00.000-08:00

Oracle Metalink Notes for Oracle Apps DBAs.

Dear Friends,

The following are the list of Oracle Metalink Notes, which ORACLE Support suggests
for various issues on different versions

Note: You need to have an account in Oracle Metalink to access notes.

NOTE.166650.1 :Working Effectively With Oracle Support Services

Release 12:

471566.1 Migrating Oracle E-Business SuiteR12 from Linux 32-bit to Linux 64-bit.

406138.1 Downloading Rapid Install Software with Oracle Electronic Delivery Oracle Applications Release 12.0

549389.1 Oracle Applications Release Notes, Release 12.0.4 useful for R12 upgrade)

409206.1 Required Pre-Upgrade Tasks for Oracle Projects, Release 12(Oracle Payables)

376811.1 Integrating Oracle E-Business Suite Release 12 with 10g AS Oracle Internet Directory and Oracle Single Sign-On

380482.1 Oracle E-Business Suite Release 12 Technology Stack Documentation Roadmap (Has all note ids related to Release 12)

373634.1 Configuring doc-id for R12 discoverer

376700.1 Enabling SSL in Release 12

559518.1 Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone

416305.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (64-bit)

555876.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Linux (64-bit)

402311.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Microsoft Windows

384248.1 Sharing the Application Tier File System in Oracle E-Business Suite Release 12

394692.1 Oracle Applications Documentation Resources, Release 12

380489.1 Using Load-Balancers with Oracle E-Business Suite Release 12

380490.1 Oracle E-Business Suite R12 Configuration in a DMZ

388577.1 Configuring Oracle Applications Release 12 with 10g R2 RAC

406982.1 Cloning Oracle Applications Release 12 with Rapid Clone

Release 11:

165195.1 "Using Autoconfig to Manage System Configurations with Oracle Applications 11i".

218089.1 "Frequently Asked Questions about Using Autoconfig with Oracle Applications Release 11i".

217368.1 "Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i".

362135.1 "Configuring Oracle Applications Release 11i with 10g Release2 Real Application Clusters and Automatic Storage Management"

123718.1 "A Guide to Understanding and Implementing SSL with Oracle Applications 11i".

125767.1 "Upgrading Developer 6i with Oracle Applications 11i".

268085.1 Configuring the Oracle Workflow 2.6/11i.OWF.H Java-based Notification Mailer with Oracle Applications 11i

333785.1 Oracle Applications 11i Internationalization Guide (Can get all docs on 11.5.10)

189708.1 Oracle Reports 6i Setup Guide for Oracle Applications 11i

273888.1 Steps to Upgrade Oracle Apps 11.5.4 to Latest Version or 11.5.9

437794.1 Database Status Check Before, During And After Migrations and Upgrades

362202.1 Oracle Applications Release 11i with Oracle 10g(10.1.0.4)

452783.1 Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)

131821.1 Cloning copied a configuration file that does not match the cloned environment

225587.1 Missing Resource Exception while performing "Configure the target system RDBMS ORACLE_HOME"

165195.1 for more information on how to run autoconfig

207308.1 AutoConfig enabled all the Concurrent Managers including the manager that initiate 'jre' processes. There is a issue of GSM Concurrent Managers causing 'maximum number of processes’ by spawning multiple jre processes.

207694.1 The environment variable PERL5LIB is missing

182812.1 some post cloning steps if the profile option and database records are still pointing to source

207159.1 Oracle E-Business Suite Release 11i Technology Stack Documentation Roadmap (Has all note ids related to Release 11i)

233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i

313418.1 Using Discoverer 10.1.2 with Oracle E-Business Suite 11i.

352843.1 HOW TO RUN A PATCH IMPACT ANALYSIS IN OAM

457166.1 FNDCPASS Utility New Feature: Enhance Security With Non-Reversible Hash Password

316806.1 Oracle Applications Installation Update Notes, Release 11i (11.5.10.2)

287453.1 Oracle Applications 11.5.10 -Installation Update notes.

Autoconfig:

NOTE.218089.1 : Autoconfig FAQ
NOTE.165195.1 : Using AutoConfig to Manage System Configurations with
NOTE.270519.1 :Customizing an AutoConfig Environment

Patching

NOTE.181665.1 : Release 11i Adpatch Basics
NOTE.174436.1 : Oracle Applications Patching FAQ
NOTE.175485.1 : How to Apply an 11i Patch When adpatch is Already Running

Cloning

NOTE.230672.1 : Cloning Oracle Applications Release 11i with Rapid Clone
NOTE.216664.1 : FAQ: Cloning Oracle Applications Release 11i
NOTE.135792.1 : Cloning Oracle Applications Release 11i
NOTE.362473.1 : Cloning E-Business Suite Using Hot Backup for Minimal
NOTE.216212.1 : Business Continuity for Oracle Applications Release 11i
NOTE.452056.1 : Business Continuity for Oracle Applications Release 12 on Database
Release 10gR2
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
Note 243880.1 : Shared APPL_TOP FAQ

IOBJ

NOTE.74660.1 : Resolving Invalid Objects in Oracle Applications

NOTE.338879.1 : Landscape1309 - Linux Landscape Quick Reference
NOTE.341782.1 : Linux Quick Reference

NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.370274.1 : New Features in Oracle Application 11i

NOTE.275734.1 : India Localization
NOTE.47837.1 : Applications Utilities FAQ
NOTE.189487.1 : System Administration FAQ's
NOTE.289786.1 : Installing Oracle Applications: A Guide to Using Rapid
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.243693.1 : Rapid Clone Coredumps when Running Adcfgclone.pl
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.331746.1 : Oracle Accelerator FAQ for Global Product Support (Internal
NOTE.144751.1 : Applications Patching - Time Saving Techniques
NOTE.232833.1 : Oracle Applications Release Notes, Release 11i (11.5.9)
NOTE.110372.1 : 11i: How to Clean up the UNIX Environment After Install
NOTE.156219.1 : Net8i/9i Basic configuration of LISTENER.ORA and TNSNAMES.
NOTE.69725.1 : Configuring TNSNAMES.ORA, SQLNET.ORA,and LISTENER.ORA in
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.139949.1 : NEED TO CLEAR APACHE, BROWSER OR JINITIATOR CACHE FOR
NOTE.133972.1 : How to Reset the APPS and APPLSYS Passwords in Release 11.5
NOTE.216980.1 : FNDLOAD Fails with PLS-306 in call to LOAD_ROW

NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.222663.1 : Internationalization Update Notes for the Oracle E-Business Suite 11i
NOTE.372952.1 : Customer Translations

NOTE.168330.1 : Reload Applications Related Java Objects
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i

NOTE.233436.1 : Installing Oracle Application Server 10g with Oracle E-
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)

NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.1076329.6 : SQL*Plus Errors - SP1.MSB Not Found
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -

NOTE.269293.1 : Oracle Applications Tablespace Model FAQs
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.268837.1 : Gathering Debug Weboam Log

NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.112577.1 : How to customize reports at runtime using XML - simple
NOTE.144689.1 : How to Generate a Report (.rdf) File from the UNIX Command
NOTE.211424.1 : How to Enable a Large SGA(over 1.7GB) on RedHat Advanced
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.144599.1 : How to Generate a .pll Library File for Applications 11i
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.208375.1 : How To Convert A Single Instance Database To RAC In A
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :

NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC

NOTE.1067473.6 : Custom Forms do not Show up in FNDSCMON Form
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack

NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)

NOTE.233038.1 : AD Command Line Options

NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.342459.1 : Diagnostics Overview

NOTE.394615.1 : Adaddnode.Pl failed with : ORA-00001 : unique constraint

NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.341322.1 : How to change the hostname of an Applications Tier using AutoConfig

NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions
NOTE.72324.1 : Guidelines on Resolving NLS/MLS issues

NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.331221.1 : 10g Export/Import Process for Oracle Applications Release 11i
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications Release 11i
NOTE.259552.1 : 11.5.9 Category 3 Preupgrade Instructions for 9.2.0.4

NOTE.341281.1 : How to disable the language selection option available in AppsLocalLogin.jsp

NOTE.389472.1 : OATM Migration fails with ORA-22853 for LOB objects

NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization

NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions
NOTE.123670.1 : Use Scanner Utility before Altering the Database Character
NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-
NOTE.258895.1 : SYS.RULE$ marked as having convertible data (ORA-12716 when
NOTE.258902.1 : SYS.JOB$ marked as having convertible data

NOTE.43208.1 : Certified Compilers
NOTE.270806.1 : 11.5.9 : Invalid Objects - IES Java Classes
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications
NOTE.343253.1 : Tns-12555, Tns-12560, Tns-00525, Linux Error : 1 Starting

NOTE.150168.1 : Obtaining Forms Runtime Diagnostics (FRD) In Oracle
NOTE.210193.1 : Use of Multiple Organizations In Oracle Applications
NOTE.165035.1 : Current Issues - Multiple Organizations Architecture
NOTE.208267.1 : Improved Convert to Multi-Org Process In Oracle
NOTE.226456.1 : Multiple Organizations in Oracle Applications R11i, March
NOTE.259546.1 : Setting Up Multiple Organizations in Oracle HRMS
NOTE.131081.1 : How can I find which version of Portal I am running ?

NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications

NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-

NOTE.283225.1 : How to Recreate the Listener for Event and Listener for

NOTE.153960.1 : FAQ : X Server testing and troubleshooting

NOTE.146468.1 : Installing and Upgrading Oracle9i Application Server with
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.351283.1 : Interoperability Notes : Oracle Applications Release 11i
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.317226.1 : Concurrent Managers Do Not Start With GSM Profile Option
NOTE.311015.1 : Adgendbc.sh Errors Running AutoConfig

NOTE.337937.1 : Step By Step - 10gR2 RAC with ASM install on Linux(x86) -

NOTE.266043.1 : Support of Linux and Oracle Products on Linux
NOTE.224302.1 : Raw Devices on Linux

NOTE.134395.1 : Cannot Connect to Personal Home Page : Your Session is no
NOTE.351646.1 : Configuring Oracle E-Business Suite Release 11i with 10g

NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class

NOTE.70276.1 : HOW TO INTEGRATE APPLICATIONS RELEASE 11 WITH CUSTOM
NOTE.273449.1 : Diagnosing Login Problems with Apps 11.5.9 (FND.G)
NOTE.139863.1 : Configuring and Troubleshooting the Self Service Framework

NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i

NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.252422.1 : Requesting Translation Synchronization Patches
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i

NOTE.68713.1 : Troubleshooting Self-Service Web Applications Login
NOTE.304489.1 : Using Oracle Applications with a Split Configuration

NOTE.225074.1 : 11i AOL : Cannot login to PHP after DB upgrade to 9.2.0.2
NOTE.358140.1 : Troubleshooting Unix coredumps and obtaining stack traces

NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX

NOTE.1812.1 :
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64

NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.300172.1 : Obsolescence of KOREAN_LEXER Lexer Type
NOTE.225456.1 : Troubleshooting Guide for Cloning Issues
NOTE.161474.1 : Oracle Applications Remote Diagnostics Agent (APPS_RDA)
NOTE.111383.1 : The Basics About Report Review Agent (FNDFS) on 11i

NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.316447.1 : About Oracle XML Publisher Release 5.5
NOTE.295036.1 : About XML Publisher Release 5.0
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3

NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.124606.1 : Upgrading JInitiator with Oracle Applications 11i

NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables
NOTE.1010501.7 : FAQ : Licensing and de-licensing a product, country-specific

NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise

NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i

NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i
NOTE.403311.1 : United States Time Zone Changes 2007 : E-Business Suite

NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets
NOTE.240862.1 : Install Oracle Unicode Fonts for Dynamic Image Generation
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.400830.1 : How to Render Non ASCII Characters in Personalized
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.403311.1 : United States & Canada 2007 Daylight Saving Time (DST)
NOTE.289788.1 : Upgrading Oracle Applications
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.189867.1 : Troubleshooting FRM-92050, FRM-92100, FRM-92101, FRM-92102

NOTE.253763.1 : After Cloning on Target instance FRM-92050 Failed to

NOTE.274783.1 :

Amol's Bookmark
*********************************************************************
NOTE.167000.1 : eBusiness Suite Support - Oracle Diagnostics Support Pack
NOTE.235307.1 : OSS Application Diagnostics Tools : FAQ and Troubleshooting
NOTE.231142.1 : About Oracle Diagnostics version 2.1
NOTE.262006.1 : About Oracle Diagnostics 2.2
NOTE.300976.1 : Support Diagnostics Newsletter for Applications Core
NOTE.357223.1 : "This test can be executed only after logging into
NOTE.363759.1 : How To Add Diagnostic Tools To Responsibility Menu

Installation
*********

NOTE.215868.1 : 11i Release Notes
NOTE.77219.1 : Applications Release 11.0.3 One-Hour Install for Unix
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.110372.1 : 11i : How to Clean up the UNIX Environment After Install
NOTE.169402.1 : How To Cleanup After A Failed Applications Installation On
NOTE.48602.1 : How do I determine which products are fully installed, and
NOTE.124353.1 : WIN : Manually Removing all Oracle Components on Microsoft
NOTE.275493.1 : Removing 10g Database and Software from AIX, HP-UX, Linux,
NOTE.279519.1 : How to completely remove 8i / 9i Database and Software from
NOTE.232831.1. : Oracle Applications NLS Release Notes 11.5.9 - B10846-01
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.187240.1 : Applications AOL Scenarios : Is It Supported ?
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.316806.1 : Oracle Applications Installation Update Notes, Rel 11.5.10.2
NOTE.360079.1 : Global and Local Inventory explained
NOTE.295185.1 : How to Recreate the Global oraInventory
NOTE.197028.1 : Software Requirements and Tools for Oracle Applications
NOTE.201392.1 : Visual C++ Requirement for Release 11i on Windows
NOTE.268776.1 : GNU Make Requirement for Release 11i For Windows
NOTE.181244.1 : Configuring VNC Or XVFB As The X Server For Applications 11i
NOTE.153960.1 : FAQ : X Server testing and troubleshooting

Patching
*******

NOTE.174436.1 : Oracle Applications Patching FAQ
NOTE.175485.1 : How to Apply an 11i Patch When adpatch is Already Running
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.252422.1 : Requesting Translation Synchronization Patches in Release
NOTE.316366.1 : 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2)
NOTE.259484.1 : Release 11.5.10 Maintenance Pack Installation Instructions
NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.181665.1 : Release 11i Adpatch Basics
NOTE.358247.1 : ORA-00001 : unique constraint violated error while applying
NOTE.358417.1 : Unable to Start Concurrent Managers After Applying 11i.
NOTE.353414.1 : Application Technology Group (ATG) Patching Policy
NOTE.359198.1 : XDF files fail to load on HP-UX, Memory Fault(Coredump)
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack
NOTE.337274.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 3
NOTE.244040.1 : Oracle E-Business Suite Recommended Performance Patches
NOTE.367756.1 : Uploading Java Objects To Patch History Tables Fails While
NOTE.76708.1 : Using ADSPLICE To Add Products To The APPL_TOP In

Cloning
******

NOTE.230672.1 : Cloning Oracle Applications Release 11i with Rapid Clone
NOTE.216664.1 : FAQ : Cloning Oracle Applications Release 11i
NOTE.242123.1 : Create new middle tier node in existing Apps 11i
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.364565.1 : Troubleshoot RapidClone or OAM Clone issues

Upgrade
*******
NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.289765.1 : Oracle Applications Release 11i (11.5.10) Upgrade Assistant
NOTE.289788.1 : Upgrading Oracle Applications

Autoconfig
**********
NOTE.165195.1 : Using AutoConfig to Manage System Configurations with
NOTE.218089.1 : Autoconfig FAQ
NOTE.270519.1 : Customizing an AutoConfig Environment
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.341322.1 : How to change the hostname of an Applications Tier using
NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.108865.1 : How To Create a Database Connection(DBC) File and

AD Utilities
**********
NOTE.233038.1 : AD Command Line Options

Relinking
********

NOTE.69798.1 : Basics of Relinking an Executable or Binary in an Oracle
NOTE.1009722.6 : How to relink Oracle Concurrent Program Executables on Unix

OAM
****

NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.117264.1 : FAQ (Oracle Applications Manager)
NOTE.177089.1 : OAM11i Standalone Mode Setup and Configuration
NOTE.214962.1 : How To Determine The Version Of OAM (Oracle Application
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.166115.1 : Oracle Applications Manager 11i integrated with Oracle
NOTE.185431.1 : Troubleshooting Oracle Applications Manager OAM 2.0 for 11i
NOTE.73959.1 : Installation and Configuration of Oracle Application Manager
NOTE.225024.1 : Oracle Applications Manager 11i Documentation Roadmap
NOTE.338317.1 : Basic Information on Cloning An 11.5.10 System Using OAM

NLS/MLS
*******

NOTE.15389.1 : NLS DEBUGGING SUCCESS GUIDE ** INTERNAL ONLY **
NOTE.227332.1 : NLS considerations in Import/Export - Frequently Asked
NOTE.15095.1 : Export/Import and NLS Considerations
NOTE.175300.1 : A Guide to Debugging Globalization (NLS) Support Issues
NOTE.124721.1 : Migrating an Applications Installation to a New Character

Forms
*****

NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.177610.1 : Oracle Forms in Applications FAQ
NOTE.141012.1 : How to Manually Generate an 11.5 Form on Unix

Apps Database
*************

NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications
NOTE.285267.1 : Oracle E-Business Suite 11i and Database FAQ
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.183078.1 : Recreating Applications 11i JAVA objects in the database
NOTE.216212.1 : Business Continuity for Oracle Applications Release 11i,
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.340859.1 : Upgrading Oracle Applications 11i Database to 10g with
NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.216211.1. : Nologging in the E-Business Suite

NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g

RAC / Apps RAC
**************

NOTE.220970.1 : RAC : Frequently Asked Questions
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.270901.1 : How to Dynamically Add a New Node to an Existing 9.2.0 RAC
NOTE.294652.1 : E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.277825.1 : How to setup Tnsnames.ora (806) for 11i and RAC

Database
********

NOTE.1012933.6 : General Information : Alert Logs and Trace Files
NOTE.209870.1 : How to Reload the JVM in 9.2.0.X
NOTE.175472.1 : How to Reload the JVM in 8.1.7.X
NOTE.159143.1 : Separating Multiple 8i or 9i Oracle Versions to Avoid
NOTE.307349.1 : OUI tips for Oracle RDBMS 10.1.X on OpenVMS
NOTE.130814.1 : How to move LOB Data to Another Tablespace

System Administration
*******************

NOTE.189457.1 : Oracle Applications Systems Administration Setup and Usage
NOTE.290525.1 : Oracle User Management FAQ
NOTE.316277.1 : Unable To Change Guest User Password In Oracle Applications
NOTE.311552.1 : How to optimize the purge process in a high transaction
NOTE.154850.1 : How to Run the Purge Concurrent Request and/or Manager Data

Jserver
******

NOTE.295484.1 : Clear Server Cache and Bounce Apache (Web Server)
NOTE.220188.1 : Oracle Applications Release 11i apps.zip Re-architect
NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class

Invalid Objects
*************

NOTE.60558.1 : Troubleshooting the Source of Invalid Objects
NOTE.266910.1 : How To Resolve IES Invalid Java Classes After Loading JAR
NOTE.113947.1 : Step by Step Troubleshooting Guide to Solve APPS Invalid

UNIX / LINUX / WINDOWS
NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.28588.1 : TECH : Using Truss / Trace on Unix

Advanced Configuration:

NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise
NOTE.226880.1 : Configuration of Load Balancing and Transparent Application
NOTE.97926.1 : Failover Issues and Limitations [Connect-time failover and
NOTE.123718.1 : 11i : A Guide to Understanding and Implementing SSL for

Techstack:

NOTE.162488.1 : Complete Guide to JInitiator 1.1.8 Setup & Troubleshooting
NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.94091.1 : Example : Identifying Connection String Problems in JDBC

Workflow:

NOTE.298550.1 : Troubleshooting Workflow Data Growth Issues

General:

NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide
NOTE.224882.1 : Common Commands asked by Oracle Support for Troubleshooting
NOTE.110415.1 : Payables MRC Frequently Asked Questions
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.257650.1 : Resolving Problems with Connection Idle Timeout
NOTE.270523.1 : How To Find the Oracle Applications Framework and Rollup
NOTE.301504.1 : "Cannot Complete Applications Logon" Error After Selecting
NOTE.315094.1 : JTF Login Page - an operational assessment for CRM

NOTE.242490.1 : How To Configure The "/etc/hosts" File On Linux
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g Release 1
NOTE.342861.1 : Java Version Conflict When Migrating Platforms
NOTE.209999.1 : Oracle Applications Manager in Oracle Applications 11.5.8
NOTE.198160.1 : Summary note to LOB's/BLOB's/CLOB's/NCLOB's and BFILES
NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in Unix

NOTE.186981.1 : Oracle Application Server with Oracle E-Business Suite
NOTE.333436.1 : Oracle E-Business Suite 11i on Windows Server 2003 Service
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.158577.1 : NLS_LANG Explained (How does Client-Server Character
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.43208.1 : Certified Compilers

NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :

NOTE.260393.1 : Java Mailer and Other 11.5.9/OWF G Current Issues in

NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets

NOTE.125767.1 : Upgrading Developer 6i with Oracle Applications 11i

NOTE.371438.1 : adpreclone.pl dbTier fails with RC-50409 : Topology
NOTE.342332.1 :
NOTE.135949.1 : Troubleshooting the Personal Home Page Login Problems in 11.
NOTE.164317.1 : Upgrading JDBC drivers with Oracle Applications 11i
NOTE.302035.1 : How to Test a JDBC Thin Driver Connection From the SSO
NOTE.365735.1 : How to use Digital Certificates for 11i Applications
NOTE.357922.1 : Autoconfig Reverts to old Context File Values.

NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA

NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java

NOTE.165123.1 : JAVA CLASS - ORA-29534 : referenced object
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications

NOTE.271218.1 : Yellow bar's and Java security error , The daddy of all

NOTE.294932.1 : Recommendations to Install Oracle Applications 11i
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications

NOTE.233428.1 :
NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i

NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual

NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC

NOTE.159270.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,

NOTE.303237.1 : Migrating Red Hat Linux 2.1 or 3.0 to Red Hat Linux 4.0
NOTE.91985.1 :
NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.272789.1 : Post Clone Problem : Login/Portal Server Installation May
NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle

NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC

NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC

NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.131321.1 : How to Relink Oracle Database Software on UNIX
NOTE.231876.1 : Windows OS Upgrade for 11i E-Business Suite

NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide

NOTE.209810.1 : How to Relink Oracle Applications 11i Programs After

NOTE.361428.1 : Using Linux Desktop Clients with Oracle Applications 11i

NOTE.296559.1 :
NOTE.275734.1 : India Localization
NOTE.364439.1 : Tips and Queries for Troubleshooting Advanced Topologies

NOTE.372928.1 : Oracle Critical Patch Update July 2006 Documentation Map
NOTE.372931.1 : E-Business Suite Critical Patch Update Note
NOTE.268837.1 : Gathering Debug Weboam Log
NOTE.292996.1 : How to Re-Install Intermedia on an 11i Environment

NOTE.160121.1 : Introduction to Sun Cluster v3
NOTE.188135.1 : Documentation Index for Real Application Clusters

NOTE.251351.1 : How to Change the Characterset in a Standby Database in 9i
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications

NOTE.1009718.6 : HOW TO SOLVE UNDEFINED SYMBOL ERRORS ON UNIX AND VMS

NOTE.316889.1 : Complete checklist for manual upgrades to 10gR2

NOTE.223721.1 : How to Install XVFB on Linux for dynamic image generartion
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3
NOTE : 163400.1 : Release Content Documents and Features Summary Matrices

NOTE.253918.1 : Autopatch Fails with "Unable to call adppdepRunFndLoad

NOTE.166650.1 : Working Effectively With Oracle Support Services
NOTE.333785.1 : Oracle Applications Internationalization Guide

NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions

NOTE.17210.1 : Supported NLS Character Sets

NOTE.179133.1 : The correct NLS_LANG in a Windows Environment

NOTE.226565.1 : 9iRAC Useful Views and Statistics (INTERNAL ONLY)

NOTE.387046.1 : RCONFIG : Frequently Asked Questions

NOTE.200340.1 : RAC : Cache Fusion

NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.312594.1 : Get Warning Messages Trying To Generate Jar Files From
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent
NOTE.365228.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 4
NOTE.371016.1 : How To License A New Product.

NOTE.151654.1 : How To Start the License Manager After Installing Oracle

NOTE.279430.1 : How To Change Project Installation From Shared To Full

NOTE.123891.1 :
NOTE.123891.1 : How to deactivate a language in e-Business Suite
NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.341437.1 : Business Continuity for Oracle Applications Release 11i

NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.304748.1 : Internal : E-Business Suite 11i with Database FAQ
NOTE.308320.1 : How to install the 10.1.0 Enterprise Manager Grid Control

NOTE.291901.1 : Maintenance Mode - A New Feature in 11.5.10
NOTE.134527.1 : TNS-00516 Starting TNS Listener

NOTE.300482.1 : Overview of Using Java with Oracle E-Business Suite Release
NOTE.208256.1 : WIN : How to Remove a Single ORACLE_HOME and Its Traces on
NOTE.363827.1 : Rebaselined Oracle Applications Technology Components for
NOTE.373611.1 : How to move Concurrent Processing Server from one node to

NOTE.240818.1. : Concurrent Processing: Transaction Manager Setup and Configuration Requirement in an 11i RAC Environment

NOTE.69660.1 : Understanding Data Auditing in Oracle Application Tables

NOTE.60828.1 : Overview of Oracle Applications AuditTrails
NOTE.134949.1 : Release 11.0.3 and Oracle 8i Release 8.1.6 Interoperability
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i

NOTE.189256.1 : UNIX : Script to Verify Installation Requirements for Oracle
NOTE.296559.1 : FAQ : Common Tracing Techniques within the Oracle
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions

NOTE.399789.1 : NLS Frequently Asked Questions

NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions

NOTE.110849.1 : Installing and Relinking Oracle Developer on UNIX Platforms

NOTE.76535.1 : Troubleshooting Issues Which Arise During the Application of Release 11 Patches
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i

NOTE.310840.1 : AFPCAL Received Failure Code While Parsing or Running
NOTE.371434.1 : Using Openfiler iSCSI with an Oracle database

NOTE.233040.1 : When Oracle Applications Automatic Patch Prerequisite
NOTE.236469.1 : Using Distributed AD in Applications Release 11.5.
NOTE.233043.1 : 11.5.9 Oracle E-Business Suite Consolidated Update 2
NOTE.108185.1 : Oracle Applications Object Library SQL scripts
NOTE.201662.1 : How To Manually Relink on Windows NT or Windows 2000

NOTE.306906.1 : How to create missing DB objects from xdf files

NOTE.396708.1 : Guidelines to Determine whether a Bug or SR is a LinuxOS

NOTE.166762.1 : Oracle Applications Manager 11i Availability
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.216589.1 : Step By Step Guide to Creating a Custom Application in
NOTE.105127.1 : FAQ (Customization)
NOTE.243880.1 : Shared APPL_TOP FAQ
NOTE.409045.1 : How to clone from Rac to Non-rac in Oracle Applications 11i.

NOTE.373611.1 : How to move Concurrent Processing Server from one node to

NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications

NOTE.261428.1 : Setting up 11i E-Business suite using a hardware load

NOTE.224875.1 : Installation, Patching & Upgrade Frequently Asked Questions

NOTE.278816.1 : How to Setup Parallel Concurrent Processing using Shared

NOTE.286506.1 : Sharing Middle-tier Oracle Home in E-Business Suite 11i

NOTE.105133.1 : Concurrent Manager Questions and Answers Relating to
NOTE.69336.1 : Basic information about Concurrent Managers
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
*********************************************************************

NOTE.416338.1 : How To Upgrade JDK / J2SE 1.4 Sub-Versions
NOTE.225165.1 : Patching Best Practices and Reducing Downtime
NOTE.368628.1 : Is The 'Personal Home Page' Mode Supported In Oracle 11i Applications?

NOTE.387859.1 : Using AutoConfig to Manage System Configurations in Oracle
NOTE.402306.1 : Oracle Applications Installation and Upgrade Notes Release
NOTE.160214.1 : How to change the oracle users, APPS, APPLSYS and

NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,
NOTE.335515.1 : Relink fails for Oracle 9.2.0.7.0 on LINUX x86 server on

NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator

NOTE.402312.1 : Oracle Applications Installation and Upgrade Notes Release

NOTE.394692.1 : Oracle Applications Documentation Resources, Release 12

NOTE.603104.1 : Troubleshooting RapidClone issues with Oracle Applications R12
NOTE.384248.1 : Sharing The Application Tier File System in Oracle E-Business Suite Release 12

NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.559518.1 : Cloning Oracle Applications Release 12 with Rapid Clone on RAC Enabled Systems

NOTE.393861.1 : Globalization Guide for Oracle Applications Release 12
NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator
NOTE.184876.1 : Oracle Application Object Library Middle (Web) Tier Setup
NOTE.403385.1 : Duplicate Responsibilities Created On Sysadmin Login And

NOTE.380483.1 : Oracle E-Business Suite Release 12 Additional Configuration
NOTE.148903.1 : Interoperability Notes Oracle Applications Release 11i with
NOTE.364704.1 : A Guide to Configure, Maintain & Troubleshoot JDBC Buffers

NOTE.148902.1 : Interoperability Notes Oracle Applications Release 11.0
NOTE.337762.1 : How to Remove an Oracle Applications 11i node

NOTE.399362.1 : Oracle Applications Release 12 Upgrade Sizing and Best
NOTE.104457.1 : Invalid Objects In Oracle Applications FAQs
NOTE.132604.1 : Upgrading OJSP with Oracle Applications 11i
NOTE.215268.1 : Implementing and Using the JSP Precompiler

NOTE.316900.1 : ALERT : Oracle 10g Release 2 (10.2) Support Status and Alerts

NOTE.189908.1 : ALERT : Oracle9i Release 2 (9.2) Support Status and Alerts
NOTE.380490.1 : Oracle E-Business Suite R12 Configuration in a DMZ

NOTE.269291.1 : Oracle Applications Tablespace Migration Utility User
NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA
NOTE.406982.1 : Cloning Oracle Applications Release 12 with Rapid Clone
NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.419839.1 : How to enable Apache, OC4J and OPMN logging in Oracle
NOTE.422419.1 : How To Enable and Collect Debug for HTTP, OC4J and OPMN in

NOTE.15390.1 : How to Determine and Change DB_NAME or ORACLE_SID
NOTE.375682.1 : About Oracle Applications Technology ATG_PF.H Rollup 5

NOTE.135715.1. : Diagnostic Steps for Intermittent FRM-99999 & FRM-92100
NOTE.185489.1 : Setting Up Parallel Concurrent Processing On Unix Server
NOTE.431496.1 : Java In The Database For Oracle Applications : Introduction
NOTE.183408.1 : Raw Devices and Cluster Filesystems With Real Application
NOTE.277366.1 : Technology Validation Utility for Oracle Applications
NOTE.394448.1 : Getting Started with the Application Management Pack for
NOTE.412044.1 : Application Management Pack for Oracle E-Business Suite
NOTE.375113.1 : Oracle Diagnostics 2.4
NOTE.405425.1 : Oracle Diagnostics 2.5

NOTE.201340.1 : Using Forms Listener Servlet with Oracle Applications 11i
NOTE.160337.1 : How To Manually Change The APPS, APPLSYS and APPLSYSPUB
NOTE.372322.1 : HP Tru64 UNIX Migration Strategy for Oracle E-Business

NOTE.303709.1 : Reclaiming unused space in APPLSYSD tablespace

NOTE.130183.1 : How to Get Log Files from Various Programs for Oracle
NOTE.269129.1 : How to Implement Printing for Oracle Applications : Getting

NOTE.297522.1 : How to investigate printing issues and work towards its resolution ?
NOTE.215527.1 : Maintenance Wizard Overview
NOTE.452120.1 : How to locate the log files and troubleshoot RapidWiz for
NOTE.312640.1 : Oracle Text : Re-installation of Applications 11i (11.5.10)

**************
*** iSetup ***
**************
NOTE.402785.1 : iSetup dependency with Deinstall and Reinstall of XMLDB
NOTE.368670.1 : About Oracle iSetup Minipack 11i.AZ.H
NOTE.243554.1 : How to Deinstall and Reinstall XML Database (XDB)

NOTE.244523.1 : Security Alert #57 : Buffer Overflows in EXTPROC of Oracle
NOTE.433435.1 : Japanese characters are displayed like square boxes in
NOTE.455366.1 : Investigating NoClassDefFoundError in eBusiness 11i when
NOTE.197409.1 : Error Opening Oracle*Terminal File fmrweb.res
NOTE.312553.1 : How To Use the Original Forms for Reprint Instead of the
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12

NOTE.458452.1 : Complying with Daylight Saving Time (DST) and Time Zone
NOTE.189367.1 : Best Practices for Securing the E-Business Suite
NOTE.300969.1 : Troubleshooting SSL with Oracle Applications 11i
NOTE.444524.1 : About Oracle Applications Technology ATG_PF.H Rollup 6
NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.428262.1 : How to identify the form name attached to an f60webmx

NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java
NOTE.405521.1 : Oracle Enterprise Manager Grid Control Release Notes for
NOTE.187905.1 : bde_imt_index_status.sql - List all interMedia Text indexes
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC

NOTE.345106.1 : Login Links On New Rapid Install Homepage Do Not Function
NOTE.443521.1 : Enterprise Manager Grid Control Plug-in for Oracle Applications, Version 1.0/1.2

NOTE.398412.1 : Workflow Queues Creation Scripts
NOTE.77483.1 : External Support FTP site : Information Sheet

NOTE.122452.1 : Global Customer Services Policy Regarding Customizations
NOTE.257911.1 : How To Use Rotatelogs In 9iAS Release 1 (1.0.2.x)
NOTE.276845.1 : Apache Web Server Hangs Every Other Time Running Adapcctl.
NOTE.218893.1 : How to Create The Service Manager 'FNDSM' on Oracle
NOTE.437878.1 : Upgrading Forms and Reports 10g in Oracle Applications
NOTE.290807.1 : Upgrading Sun JRE with Oracle Applications 11i

NOTE.280167.1 : AS10g with Apps 11i - Summary of Login process

NOTE.357218.1 : Troubleshooting JDeveloper setup for Oracle Applications
NOTE.403339.1 : Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12 Upgrade

NOTE.463249.1 : After Clone Forms Is Trying To Connect To Target Instance
NOTE.386374.1 : How to enable/disable/change password of the listeners for Oracle Applications 11i

NOTE.454750.1 : Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes

NOTE.428503.1 : Integrating Oracle E-Business Suite Release 11i with Oracle Database Vault 10.2.0.3

NOTE.443761.1 : How to check if a certain Patch was applied to Oracle Applications instance using 'adpatch'?

NOTE.291783.1 : Getting Started with the Oracle Grid Control Plug-in for Oracle Applications in Release 11i (AMP v1)

NOTE.468980.1 : How to Remove the Language Icons in the AppsLocalLogin.jsp

NOTE.398619.1 : Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)

NOTE.295606.1 : Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting

NOTE.169706.1 : Oracle® Database on AIX®,HP-UX®,Linux®,Mac OS® X,
Solaris®,Tru64 Unix® Operating Systems Installation and
Configuration Requirements Quick Reference (8.0.5 to 11.1)

NOTE.109665.1 : Organization Setup Frequently Asked Questions - FAQ
NOTE.434395.1 : ATG Service Request Creation
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12
NOTE.469213.1 : How To Encrypt The Apps Password In Wdbsvr.App
NOTE.293369.1 : OPatch documentation list
NOTE.275379.1 : Script To Check What Workflow Related Patches Are Installed
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC

NOTE.264157.1 : The correct NLS_LANG setting in Unix Environments
NOTE.91985.1 : Step by Step on Cloning the ORACLE_HOME (Including DB) and
NOTE.74838.1 : Migrating Apps Release 11.0 from UNIX Host To A Second

NOTE.396009.1 : Database Initialization Parameters for Oracle Applications Release 12

NOTE.391406.1 : How to get a clean Autoconfig Environment
NOTE.560719.1 : How to troubleshoot iSetup issues
NOTE.406376.1 : Oracle E-Business Tax Release 12 Known Issues
NOTE.577713.1 : On Windows, After 10g Upgrade, Running Autoconfig on Apps
NOTE.343917.1 : Frequently Asked Questions : Oracle E-Business Suite Support
NOTE.553831.1 : java.lang.ArrayIndexOutOfBoundsException Error when

NOTE.119319.1 : How to Replace Oracle Logo with Company Logo on Applications 11i Sign-On Screen

NOTE.554336.1 : How Do You Manually Generate A Form In Release 12 (frmcmp)

NOTE.444286.1 : How to manually generate a R12 report on Unix
NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual Hostnames and Business Continuity

NOTE.555081.1 : Concurrent Manager Does Not Start if the Profile Option "Concurrent : GSM Enabled" is Set "Y" at Site Level

NOTE.149124.1 : Creating a StatsPack performance report
NOTE.471566.1 : Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit

NOTE.397757.1 : How to Speed Up Index Creation on FND_LOBS by indexing Only FND_HELP Data

NOTE.375127.1 : How to restart the adworker having status fixed,restart,wait
NOTE.353150.1 : OPatch Failing Validation Phase When Archiving Really Did Not Fail

NOTE.215527.1 : Maintenance Wizard Overview
NOTE.564465.1 : Sysadmin And User Responsibility Not Available
NOTE.219968.1 : SQL*Net, Net8, Oracle Net Services - Tracing and Logging at a Glance

NOTE.417122.1 : Resolving the Library Cache Locks
NOTE.419475.1 : Removing Credentials from a Cloned EBS Production Database

Oracle Applications 11i/12 Online Documentation

http://www.oracle.com/technology/documentation/applications.html

Note: There are many other notes on various issues available in Oracle Metalink
For any specific issue, you shall always contact ORACLE SUPPORT for complete assistance.

Best site for RPMS

2008-11-19T03:56:00.001-08:00

http://rpm.pbone.net/

How to change the group of the existing user

2008-11-19T02:58:00.000-08:00

1. How to change the group of a user if the user is already exists. [oinstall to dba]

Sol: /usr/sbin/usermod -g dba oracle

2. If the oracle user exists, but its primary group is not "oinstall" or it is not a member of the "dba" group, then enter the following command:

Sol: /usr/sbin/usermod -g oinstall -G dba oracle

Printers Config File and Status check in Sun Solaris

2008-10-21T02:23:00.001-07:00

How to Check the printers that are configured in the server (O.S. - Sun Solaris)

$ cat /etc/printers.conf|grep printer_name

To check the status of the printer

$lpstat -p printer_name

Oracle user account LOCKED(TIMED)

2008-10-08T00:30:00.000-07:00

If you are on Oracle 10g and frequently facing the issue "Oracle user account LOCKED(TIMED)" with any user account then.

You need to observe the profile assigned to the particular user

select username,profile from dba_profiles where username='MYLOGIN';

If you find that the profile is DEFAULT then you have to observe one thing

SELECT resource_name, resource_type, limit FROM dba_profiles WHERE profile='DEFAULT';

COMPOSITE_LIMIT KERNEL UNLIMITED
SESSIONS_PER_USER KERNEL UNLIMITED
CPU_PER_SESSION KERNEL UNLIMITED
CPU_PER_CALL KERNEL UNLIMITED
LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
LOGICAL_READS_PER_CALL KERNEL UNLIMITED
IDLE_TIME KERNEL UNLIMITED
CONNECT_TIME KERNEL UNLIMITED
PRIVATE_SGA KERNEL UNLIMITED
FAILED_LOGIN_ATTEMPTS PASSWORD 10
PASSWORD_LIFE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_MAX PASSWORD UNLIMITED
PASSWORD_VERIFY_FUNCTION PASSWORD NULL
PASSWORD_LOCK_TIME PASSWORD UNLIMITED
PASSWORD_GRACE_TIME PASSWORD UNLIMITED

The FAILED_LOGIN_ATTEMPTS PASSWORD is 10 in the previous versions it used to be UNLIMITED.

If you like to change the profile option edit the default profile, but its not suggested for security reasons.

You can create a new profile with options of that in the default profile and change the FAILED_LOGIN_ATTEMPTS PASSWORD to UNLIMITED.

CREATE PROFILE DEFAULT_NEW LIMIT
COMPOSITE_LIMIT KERNEL UNLIMITED
SESSIONS_PER_USER KERNEL UNLIMITED
CPU_PER_SESSION KERNEL UNLIMITED
CPU_PER_CALL KERNEL UNLIMITED
LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
LOGICAL_READS_PER_CALL KERNEL UNLIMITED
IDLE_TIME KERNEL UNLIMITED
CONNECT_TIME KERNEL UNLIMITED
PRIVATE_SGA KERNEL UNLIMITED
FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED PASSWORD_LIFE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_MAX PASSWORD UNLIMITED
PASSWORD_VERIFY_FUNCTION PASSWORD NULL
PASSWORD_LOCK_TIME PASSWORD UNLIMITED
PASSWORD_GRACE_TIME PASSWORD UNLIMITED;

Assign this profile to the user

ALTER USER mylogin PROFILE DEFAULT_NEW;

Now you would not face the issue of user account locking frequently.

R12 Architecture

2008-09-09T00:04:00.000-07:00

Site with very useful Scripts,FAQ's n many more for DBA's

2008-09-01T23:18:00.000-07:00

http://www.orafaq.com/wiki/Scripts

Error Msg: REP – 3000 internal error starting Oracle Tool Kit.

2008-09-01T01:56:00.000-07:00

Error: Concurrent Requests are errored out in DEV1.

Error Msg: REP – 3000 internal error starting Oracle Tool Kit.
O.S. - SunSolaris

Sol:

1. Open .xml file & set display as : dlsnbss1:5.0
2. cat .xml|grep display
3. Run Autoconfig
4. Bounce Apache Server & Concurrent Server Services.

Reference Metalink NoteId:200474.1

ERROR [CODE=2] Compiling out of date JSP

2008-09-01T01:51:00.000-07:00

Error occurred while applying Patch 5335967(Pre-req of CPU Patch Jul’08)

11i.AOL : Error When Compiling JSP Files During Application of Patch

Error code: ERROR [CODE=2] Compiling out of date JSP
O.S. - SunSolaris

cause: _oa__html subdirectory not present at $COMMON_TOP/html/_pages.

Solution:
1. Create the _oa__html subdirectory.
2. Rerun the perl command to compile JSP file using ojspCompile.pl
Syntax:
$ perl -x / --compile –quiet (or) rerun the patch

Reference: Metalink Note:251280.1

Discoverer Server Not Coming up after clone

2008-09-01T01:41:00.000-07:00

Step:1 Run checkdiscoverer.sh script.

Found OAD is not running.

Step:2 Run startoad.sh script and found following error message:
Run-time exception error; current exception: CORBA_NO_RESOURCES
O.S. - SunSolaris

Solution:
To implement the solution, please execute the following steps:

1. Stop/Kill all the Discoverer Process that are running.(osagent, oad, dis*)
./stopall.sh

2. Run following commands to list the Visibroker implementation files and then rename them:

$ cd /dba/u01/app/applmgr/product/8.0.6STG/vbroker/adm/impl_dir
$ ls
README README.txt impl_rep impl_rep~
$ mv impl_rep impl_rep_sav
$ mv impl_rep~ impl_rep~_sav

3.Run the Environment variable Setting Script discwb.sh found in $ORACLE_806_HOME/discwb4 directory.
./discwb4

4. Now Start the Discoverer Server using, the startup scripts in the $ORACLE_806_HOME/discwb4/util directory:

Note: DOT SPACE DOT SLASH

a. ./startosagent.sh
b. ./startoad.sh
c. ./unregistersession.sh
d. ./unregisterpreference.sh
e. ./applypreference.sh
f. ./registerpreference.sh
g. ./registersession.sh
h. ./registercollector.sh
i. ./startlocator.sh
j. ./startgatekeeper.sh(Optional)
(OR)

Note: Instead of Performing Step 3 & 4 Perform Step 5

5. ERPTST1 > cd /dba/u01/app/applmgr/common/ERPTST1/admin/scripts/ERPTST1_dlsnbss1/
dlsnbss1:/dba/u01/app/applmgr/common/ERPTST1/admin/scripts/ERPTST1_dlsnbss1

ERPTST1 > ./addisctl.sh start
ERPTST1 > ./addisctl.sh status

Reference: Metalink NoteId:394163.1

Online Help Error

2008-08-28T22:44:00.000-07:00

When logging into a manufactoring responsibility in Application 11i
and request help by clicking on "?" or Help>Oracle Applications Library,
receive the following message :

Oracle Applications Help Error
--------------------------------------------------------------------------------
An error occurred while retrieving Oracle Applications Help information.
Target MSC:CONTENTS could not be found in the help tree.
Other resonsibilites work fine.

Navigation:

HELP -> Window Help

O.S. - SunSolaris

Sol:

Set the profile Help system root in site level & Application Level for “ADVANCED SUPPLY CHAIN” from MSC:CONTENTS to FND:LIBRARY

Reference: Metalink Note:259298.1

11i Application File System

2008-08-27T00:20:00.000-07:00

11i Application File System

2008-08-27T00:14:00.000-07:00

Unable to login

2008-08-25T04:28:00.001-07:00

When users are trying to login into oracle applications they are unable to login.
It shows the following error
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int)(userId=6,sessionMode='null','4DE538960900125FE040A8C00A016CCC24684017652941783825214968716732'); REASON = java.sql.SQLException: ORA-20001: Oracle error -20160: ORA-20160: Encountered an error while getting the ORACLE user account for your concurrent request.
Contact your system administrator.ORA-06512: at "APPS.ALR_FND_USER_UAR", line 1ORA-04088: error during execution of trigger 'APPS.ALR_FND_USER_UAR' has been detected in FND_SIGNON.NEW_ICX_SESSION.ORA-06512: at "APPS.APP_EXCEPTION", line 70ORA-06512: at "APPS.FND_SIGNON", line 18ORA-06512: at "APPS.FND_SIGNON", line 490ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 318ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 455ORA-06512: at line 1; ERRNO = 20001; (Could not lookup message because there is no database connection) at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:974) at oracle.apps.fnd.framework.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:866) at oracle.apps.fnd.framework.webui.OAPageBean.validateUser(OAPageBean.java:4572) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:687) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418) at _oa__html._OA._jspService(_OA.java:88) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnection.java:294) at java.lang.Thread.run(Thread.java:534) ........
...........

O.S. - HP-UX

Solution:
To implement the solution, please execute the following steps:

Disable the trigger 'ALR_FND_USER_UAR' using sqlplus :

- SQL> alter trigger ALR_FND_USER_UAR disable;

- Retest Login.

Metalink suggest the following doc id's solution:
1) Note:388695.1
2) Note:357998.1
And Bouncing the Apache could resolve the error in some cases.

2008-08-24T23:43:00.000-07:00

Do not change the permissions for ".." directory which is available in every user home directory.. Changing the permission of that directory will change permission to the every user home directory as a result all users directories under "/home/" need to change