Tar and Gunzip utilities for production system (General)

TAR and GUNZIP tools are extremely useful when comes to cloning and backup activities .

• tar cvf – * | gzip > appltop.tar.gz — This command will TAR and gunzip the whole appltop .You can use the command according to your requirements

Tar and gunzip

• tar -cvf file.tar directory – Simple Command for TAR
  

ScribeFire makes life easier for Bloggers

ScribeFire makes life easier for Bloggers . ScribeFire is Firefox addon through we can edit ,create and delete the blog contents . Its very handy and lighter to use . Thanks to Firefox .

Running AutoConfig(AC) on particular product

My friend asked me how to run the AC on particular product like AD,GL,..etc . Looks like an good option but I didn’t get any hits how to achieve this .

I think there is no explicit parameter in adconfig.pl where we can pass the value of product top.

After some analysis , I found out some option to run AC for particular product and it works too .

For eg. if you want to run for AD (Applications DBA ) alone.

You can pass the particular top driver file parameter to the adconfig.pl . The command looks like this

—-

perl adconfig.pl driver=/d1/V1210/apps/apps_st/appl/ad/12.0.0/admin/driver/adtmpl.drv

We need to change the <PROD>tmpl.drv and I hope it will works for all products.

This blog is one year old

I take this opportunity to thank everyone encouraged me to start this blog

Difference in registry key for Windows

This topic is common to all . I found its very interesting . It will be helpful to Windows oracle APPS customer.

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet

ControlSet001 = Set of boot information used to boot the system.

ControlSet002 = Set of boot information used for “Last Known
Good” configuration.

CurrentControlSet = Maps to either 001 or 002 above, depending
on how the system was booted. All edits should be done to this set,
as doing so will assure you’re modifying whichever control set is
currently in force.

How to find an AD patchset level ?

SQL> select PATCH_LEVEL from fnd_product_installations where APPLICATION_ID=50;

PATCH_LEVEL
——————————
11i.AD.I

This query works for both 11i and R12 instance

How to merge two apps patches.

Merging apps patches will be useful when you want to reduce the downtime for patch application

Simple steps to merge two patches.

1. Download two required apps patches (pR12_xxxxx_Solaris.zip) and (P12_yyyyy_Solaris.zip).
2. Create one source directory (for e.g. src )
3. Unzip two apps patches into src directory.
4. Create one destination directory (for e.g. dest)
5. Source the Apps env and issue the following command.
   1. Perl <ad_top>/bin/admerge.pl –s src –d dest
6. Patch is merged and created u_merged.drv . Use this driver file for adpatch application

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.