Insight about Archive files for R12

How to create ,replace ,delete and list the archive files in R12

Windows

To list the archive files	e.g. lib /list adst.lib
To include the single object into archive file	e.g. lib adst.lib aimain.obj
To list the particular object	e.g. lib /list adst.lib |grep aimain.obj o/p – aimain.obj
To find the header of particular object	adident Header adst.lib | grep aimain.oc o/p – $Header aimain.oc 120.10 2006/11/28 20:32:39 vlim ship $

Unix

To list the archive files	ar t libad.a ar t libad.a | grep aiures.o
To take out all the files from archive	e.g. ar -xv libad.a
To take out individual file from the archive	e.g. ar -xv libad.a aiures.o
To delete the particular object file from archive	e.g. ar d libad.a aiures.o
To replace or create the particular object file from archive	e.g. ar r libad.a aiures.o

 

 

R12 – Shortcut to access the forms URL and sysadmin Responsibility page

It will be skip the login page and direct to the sysadmin responsibility page. To access the Sysadmin responsibility page http://<host>.<domain>:<PORT >/OA_HTML/fndvald.jsp?username=SYSADMIN&password=SYSADMIN

To Launch the forms directly http://<host>.<domain>:<port>/forms/frmservlet. Modify the context variable parameter (s_appserverid_authentication) from SECURE to OFF and run autoconfig, then forms will startup without that authorization error.

How to find blocking session and kill the session from database

During adpatch ,deadlock will happen when some jobs depends on resource where another job its holding the resource.Using adctrl ,you can find two jobs in running state there will be no log updates.

* To find blocking session jobs below query will useful. It will return two rows.
select process,sid, blocking_session from v$session where blocking_session is not null;
E.g.
SQL> select process,sid, blocking_session from v$session where blocking_session is not null;
PROCESS SID BLOCKING_SESSION
———— ———- —————-
1234 365 366
1234 366 365

* Second step to find the serial number for the Blocking Session to kill
select SERIAL# from v$session where SID=<SID number>
E.g.
SQL> select SERIAL# from v$session where SID=365;
SERIAL#
———-
130

* Final step to kill the blocking session
alter system kill session ‘SID,SERIAL#’;
E.g.
SQL> alter system kill session ‘365,130’;
System altered.

To find the StartCD version – R12

To find the StartCD version for R12

• cd startCD\Disk1\rapidwiz
• Run RapidWizVersion.cmd for Windows /RapidWizVersion for Unix

Example output:

Oracle Applications Rapid Install Wizard
Version 12.0.0.22

(c) Copyright 2000-2006 Oracle Corporation.  All rights reserved.
Press any key to continue . . .