Sunday, December 20, 2009

RUP 12.1.2 Released

Oracle E-Business Suite 12.1.2 RUP is released.
 This  Release Update Pack or maintenance pack can be installed only on 12.1 installation.

And is available as patchset 7303033 which is of size 3.2 GB in six parts.

CPU October 2009 (patch 8317877) is included in this release.

Important Notes:

RCDs for 12.1.2  561580.1
ReadMe    949406.1
Applications Technology ReadMe 845809.1

Friday, December 18, 2009

ICM startup errors

ICM log file shows these errors while startup.

This too has the same issue as in my previous post.

Services startup ...after a while..but the ICM log file shows  errors.

So i tried with cmclean.sql which resolved the problem.

But the web Application services retain the problem,

I have a doubt that this is happening typically because of insufficient Hardware resources.

Because this doesn't happen in any other node, except this particular system.
 Some extract from the ICM log file is as follows:

Starting SID_0204@SID Internal Concurrent Manager -- shell process ID 7901

          Reviver is ENABLED

Routine &ROUTINE has attempted to start the internal concurrent manager.  The ICM is already running.  Contact you system administrator for further assistance.afpdlrq received an unsuccessful result from PL/SQL procedure or function FND_DCP.Request_Session_Lock.

Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.

Possible DBMS_LOCK.Request resultCall to establish_icm failed

The Internal Concurrent Manager has encountered an error.

Review concurrent manager log file for more detailed information. : Dated:46:15 -

Shutting down Internal Concurrent Manager : Dated 09:46:15

List of errors encountered:


_ 1 _

Routine AFPCSQ encountered an ORACLE error. .

Review your error messages for the cause of the error. (=)

List of errors encountered:

_ 1 _

Routine AFPCAL received failure code while parsing or running your

concurrent program CPMGR

Review your concurrent request log file for more detailed information.

Make sure you are passing arguments in the correct format.

The SID_0204@SID internal concurrent manager has terminated with status 1 - giving up.

                   Process monitor session started : Dated 09:46:22

Call to PingProcess failed for FNDOPP
Call to StopProcess failed for FNDOPP
Call to PingProcess failed for FNDOPP
Call to StopProcess failed for FNDOPP

Errors while starting up services in R12

 adstrtal.txt is showing these errors.

The services shown dont startup initially,
but on waiting for some time and checking again,
the three OC4J instances and so forms get started up..

This error crops up typically after a clone on the target instance.

To resolve the error, I tried editing the parameters in opmn.xml under INST_TOP,

oc4j_status, which was disabled earlier , now enabled it.
start_timeout , previously having value 600....changed to 1800.

Even then,errors show up in the startup log file.....though the services startup slowly.

Monday, December 14, 2009

Pinning Objects into Shared Pool

Why Pinning?
                    Apps needs more space in SGA for packages and functions.
If SGA is fragmented some of them may not get enough free space.

     IF a package doesn't get contiguous free memory , Database will try to free the memory by deleting some objects using LRU algorithm……..
 Even then, if it unable to get enough memory , then ORA-04031 error is thrown….

Set SGA_TARGET parameter to use Automatic shared Memory Management-----this resolves the error to some extent...

 So……. Pinning objects into shared pool increases database performance to a great extent.
This is because , these pinned objects need not be loaded and parsed from database…….as they reside in the SQL and PL/SQL area of SGA.
NOTE : Care has to be taken while choosing which objects have to be pinned.
Generally, large and frequently used packages are pinned……….whereas pinning
Unnecessary or rarely used objects may degrade the DB performance.

To identify the objects to be pinned, we need to know which objects are executed more frequently.

This is done by running the script below……… which creates a ADXCKPIN.lst file---------- which is the list of objects in the shared pool.

$sqlplus system/password@AD_TOP/sql/ADXCKPIN.sql

Or Simply----

select owner,name,type,sharable_mem from v$db_object_cache where kept='YES';

 And then do

select * from x$ksmlru;

Gives current shared pool objects and the corresponding number of objects flushed out of the shared pool to allocate space.

Once you query the table, the database will reset the table.

How to pin?

Run the scripts ADXGNPIN.sql for packages and functions
and ADXGNPNS.sql for sequences…

$sqlplus sys/password@AD_TOP/sql/ADXGNPIN.sql APPS

his, by default, pins all objects under Apps Schema….so it is good to edit the script and pin the objects chosen….
Manually-----This can be done by executing a script…………..

SQL> exec dbms_shared_pool.keep('schema.object');

Some of the packages in SYS schema which are most used in Apps environment…….








Saturday, December 12, 2009

Using a defaults file

Why  is it required?

While running adadmin / adctrl ,  instead of responding to prompts  every time manually,

We can provide a file, called defaults file, with the answers for the prompts -----

Then Ad-utilities proceed  without prompting for answers...

How to create a defaults file ??

Run adadmin as follows for the first time, which creates the defaults file

$ adadmin defaultsfile=$APPL_TOP/admin/SID/kkdefaults.txt

Select a Menu and perform a task.

Now the defaults file got created….

Using the defaults file------

Run adadmin non-interactively as follows------

$ adadmin  interactive=n defaultsfile= $APPL_TOP/admin/SID/kkdefaults.txt   logfile=xxxxx.log   workers=8    menu_option=CHECK_DUAL

Restart a Failed Session in non-interactive mode------

Add ------->>>>>       restart=y   --------- to above commnad

  This option restarts the previous session without asking you again…...

Friday, December 11, 2009

Configuration Info

Run  adutconf.sql       under     AD_TOP/sql
Which creates     adutconf.lst     file--
This files contains information about our system configuration------


Status of Installation
       Registered products and Schemas
           Undo segments
                NLS Parameters in DB
                          MR Currenc y  Settings

Distributed AD

----->>>  Used To Run processes concurrently
                                   on a mutli-node system

----->>>   Shared Application Tier file system is a must
            Run adadmin or adpatch on primary   node          using options -----
$ adpatch workers=10 localworkers=3
                               NOW ---On the other nodes, Start   adctrl

                      $ adctrl distributed=y
Which asks for the worker range you want to use on that node
Enter worker range:4-10

File System Interview Questions (FAQs)

1)      Which script is used to start/stop Concurrent Managers? What is the syntax? And where is the script located in R12?
2)      Where are the startup scripts log files located?
3)      What is the meaning of status 0, status 1, status 150 when starting services?
4)      Which is the default Oracle Home set in the apps R12 Environment?
5)      How do we set Default Oracle home to the home used by Apache, if required?
6)      Which Home is used for forms and reports in R12?
7)      Which Home is used for Apache in R12?
8)      What is the default Database version that comes with 12.0.4 Apps installation and 12.1.1 installation?
9)      How many products are brought in by default installation of Apps?
10)   Can a multi-user installation be done with a single mount point in linux?(yes or no)
11)   Why do we need to edit limits.conf under /etc/security for installation of Apps?
12)   What is an Instance Top used for? What are the practical advantages of instance top?
13)   A Shared file system has all directories mounted onto various nodes. Then do we need to have a separate instance top for all nodes? If so why ?
14)   What are the various directories under each Product_Top?
15)   What is difference of Common top in R12 and 11i?
16)   What is AF_JLIB parameter in R12 and what is it set to?
17)   Is FND_TOP/secure and FND_SECURE same in R12?
18)   What is the difference between and httpd.lock files?
19)   What are the runtime executables for forms and reports in R12?
20)   What is the plugin required to run forms in R12?
21)   What is OPMN and what are the processes it manages?
22)   What is the script used for managing OC4J processes?
23)   Where are the opmn log files located?
24)   What is the advantage of Jserv getting replaced by OC4J in R12?
25)   How many instances of OC4J exist in R12 and what are they? And how are they managed?
26)   What is the configuration file for OC4J and its location?
27)   What are the various configuration files and their location for Apache?
28)   What is the formservlet.ini file replaced by in R12?
29)   What are the configuration files for Forms in R12?
30)   What is the difference between APPL_CONFIG_HOME, ORA_CONFIG_HOME and ORACLE_CONFIG_HOME in R12?
31)   Where are the Diagnostic Log files located for Apache and OC4J?
32)   What is the difference between fndenv.env and devenv.env?
33)   What is the use of webapps directory under COMMON_TOP?
34)   What is the use of META-INF and WEB-INF directories under OA_HTML?
35)   What is an odf file and what is it used for?
36)   What are the following executables used for?
a)      FNDSM
b)      FNDFS
37)   What are the following parameters used for in an Environment?
a)      FNDNAM
b)      GWYUID
c)       TWO_TASK
d)      APPLCSF
e)      APPLDCP
f)       APPLTMP
g)      NLS_LANG
h)      PATH
i)        APPL_TOP
j)        FND_TOP
k)      AU_TOP
l)        APPLFENV
m)    OA_JAVA
38)   What are the extensions for the following files
a) Source forms
b) Runtime forms
c) Message files
d) pl/sql libraries
e) Concurrent Manager Log files
f) Concurrent Request Log files
g) SSL certificates
h) Network Configuration files
i) Report files
j) Driver files
k) Environment files
l) Perl scripts, Shell Scripts, SQL scripts
m) Java Archives, Java Class files
39)   Where are the log files located for
  a) Apache
  b) Adpatch
  c) OC4J
  d) Autoconfig
  e)  Concurrent Manager
40)   What is the use and location of files in R12?
a)      Context file
b)      Consolidated env file
c)       DBC file
d)      server.xml
e)      opmn.xml
f)       Apache pids
g)      appsweb.cfg
h)      default.env
i)        orion-web.xml
j)        orion-application.xml
k)      SSL certificates
l)        Adconfig.txt
m)    Topfile.txt
n)      Adovars.env
o)      Adjborg.txt and adjborg2.txt

AD-UTILITIES Interview Questions or FAQs

         1)      What is an AD Utility? Why do we require ad-utilities?
2)      Which ad-utility do you use regularly and why?
3)      What is the pre-requisite to run any ad-utility?
4)      Do you need database to be up in order to run ad-utilities? Why?
5)      On a multi-node architecture, on which node do you invoke ad-utilities?(adadmin,apatch and adconfig)
6)      What are the prompts you get when you invoke adadmin?
7)      Why do you need system password for adadmin?
8)      Where is adadmin log file located?
9)      Where are the executables located for ad-utilities?
10)   What do you do when an adadmin session fails or errors out?
11)   What is the difference between .log and .lgi files?
12)   What is the script that runs when Compile Apps Schema in adadmin is started?
13)   Can we invoke more than one adadmin session simultaneously? If so when? If not Why?
14)   Which options do you choose to
        Generate Jar files
Generate Reports
Compile Jsps
Relink Programs
15)   What does Relink option do?
16)   What will you do if relinking has failed for a particular product?
17)   How do you proceed if a single Jsp or multiple jsp’s compilation fails?
18)   When do you need to run maintain snapshot information?
19)   What is the difference between compile apps schema and validate apps schema?
20)   What is the difference between generate jar files and reload jar files to database?
21)   What is the script that runs when you change maintenance mode from adadmin?
22)   How do you check in database whether maintenance mode is enabled or not?
23)   When do you need to enable maintenance mode?
24)   Why do you need to maintain MRC schema?
25)   What  does adadmin do when it runs Re-create grants and synonyms for apps schema option?
26)   What is the default character set in your Environment?
27)   When do you need to convert character set?
28)   What does copy files to destinations copy and to what location?
29)   Generation of forms failed through adadmin…how do you generate manually?
30)   What is the difference between fmb and fmx files?
31)   Adadmin is not accepting apps password even if it is correct password..why and what is your course of action?
32)   What is the extension of report files? How do you generate them manually?
33)   What is the location of forms and reports?
34)   What is the location of compiled jsps?
35)   How do you invoke adadmin session in non-interactive mode?
36)   Where is the defaults file located ?
37)   What is a patch?
38)    How do you apply a patch for Application file system?
39)   What are the different types of patches ?
40)   What are steps you follow before applying a patch?
41)   What is a mini-pack, maintenance pack, CU patches and CPU patches?
42)   What are various modes of applying a patch?
43)   What are the various options while applying a patch?
44)   How do you a patch a multi node environment
a)      if it is non-shared and c,d,g drivers are there
b)      if it is shared system and c,d,g drivers are there
c)       if it is non-shared and u driver
d)      shared and u-driver is there
45)   Can we invoke more than one patch session at a time? Why? Or why not?
46)   What does an adpatch do while
A c-driver action is going on?
A d-driver action is going on?
A g-driver action is going on?
47)   Can we rollback an applied patch ? How?
48)   What are b.ldt and f.ldt files?
49)   How do you check a patch is applied successfully or not?
50)   What is the difference between ad_bugs and ad_applied_patches?
51)   Where is patch log file located?
52)   A patch session errored out and which has already run for more than 3 hours time. On metalink search, it is found that a pre-req patch is there to be applied. How do you proceed?
53)   A patch readme suggests to apply it for R12. How do you decide if you can apply this patch for your system which is on 12.0.5?
54)   How many patches do you apply for a week?
55)   A patch failed while c-driver is going on. What will you do? Also for d and g drivers?
56)   A patch hangs for a long time while d-driver. If It is running a sql script, If it is generating forms, , How do you proceed in each scenario?
57)   If a patch fails while compiling jsps and relinking, how do you proceed in both issues?
58)   What is ad-controller?
59)   A worker hangs , What is your course of action?
60)   How do you restart a job? How do you assign a job to a different worker?
61)   How do you restart a worker?
62)   What is skipping a worker and how to do it?
63)   How do you check which drivers of a patch are applied ?
64)   When do you need to merge patches?
65)   Which patches can be merged and which not?
66)   Can a Payables patch be merged with HRMS patch? Why or why not?
67)   How do you merge patches?
68)   How do you check a file version?
69)   Adident shows number of line entries for a file version? Which one to consider?
70)   What is auto-config?
71)   How do you run auto-config in your organization?
72)   How can we run auto-config in test mode?
73)   What does do ?
74)   Where are the output files created when we run
75)   What is a difference file and how do you analyze it?
76)   What are the phases while running autoconfig?
77)   What happens in INSTE8_PRF phase and INSTE8_APPLY phase?
78)   What are the essential files needed for running autoconfig?
79)   What is a template file and a driver file? What do they consist of?
80)   How do you run autoconfig in multi-node environment (shared and non-shared file system)?
81)   What does autoconfig process do? Explain.
82)   Do you need to bring down your database while running auto config? Why or why not?
83)   Can you run auto config in DB tier while the database is up? Why?
84)   When do we need to run autoconfig?
85)   Where is autoconfig log file located?
86)   What is a customization? How do you know there are customizations in your system?
87)   How to preserve customizations?
88)   Autoconfig failed while PROFILE phase, what will you do?
89)   Autoconfig failed during APPLY phase, what next?
90)   Can autoconfig be run in parallel in all nodes of application? If so how?
91)   What are the errors you faced while running autoconfig? How did you resolve?
92)   Your XML file is corrupted and you don’t have access to backup xml. What will you do?
93)   Where is autoconfig script in database tier?
94)   You need to run autoconfig on Apps and DB tiers.Which tier will you run first?
95)   What is DBC file? Where is it located?
96)   How do you check status of a dbc file?
97)   Autoconfig fails when creating dbc file? What will you do?
98)   What are the options to recreate a dbc file?
99)   What is Admin App Server?  How to run it?
100)                       Do we require java to run autoconfig? Why?
101)                       What is cloning?
102)                       What are the pre-reqs for cloning complete Application file system?
103)                       What does pre clone script do on source system?
104)                       Can we run pre clone script on Apps tier when services are up? Why?
105)                       Where is the script located in DB and APPS? How do you start it in both ?
106)                       What is the precaution you need to take before copying the file system to Target ?
107)                       Where is located ? Where is its log file created?
108)                       What are the prompts asks for on target system?
109)                       What are the errors you faced while cloning? How did you resolve?
110)                       Can we clone a cloned system? How?
111)                       How do we clone a single-node to multi-node system?
112)                        Can we clone a multi-node to single-node ? How?
113)                       Do profile options get updated as in source when cloning ?
114)                       Which post clone steps you need to do manually?