Oracle Apps R12 adcfgclone.pl prompts(rapid clone r12)
June 30, 2009 at 11:28 am | In Oracle Apps Tips and Tricks | Leave a CommentTags: adcfgclone, adcfgclone.pl, adcfgclone.pl r12, command prompts adcfgclone.pl, rapid clone
Dear Readers,
In this post I have given the actual prompts in the stage adcfgclone.pl(prompts).It is very useful for those who have not used R12 rapid clone.
[applvis@r12apps bin]$ perl adcfgclone.pl appsTier
Using Java from /u02/oracle/apps/apps_st/comn/clone/bin/../jre
Enter the APPS user password:
JDBCCLASSES = /u02/oracle/apps/apps_st/comn/clone/jlib/ojdbc14.jar
XMLPCLASSES = /u02/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar
LOCAL_CPATH =
/u02/oracle/apps/apps_st/comn/clone/jlib/java:/u02/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u02/oracle/apps/apps_st/comn/clone/
jlib/ojdbc14.jar
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:
applvis
= applvis
dba
= dba
Running:
/u02/oracle/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp
/u02/oracle/apps/apps_st/comn/clone/jlib/java:/u02/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u02/oracle/apps/apps_st/comn/clone/
jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u02/oracle/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate
-pairsfile /tmp/adpairsfile.lst -stage /u02/oracle/apps/apps_st/comn/clone 2> /tmp/adcfgclone.err; echo $? > /tmp/adcfgclone.res
Enter the APPS password : apps
Log file located at /u02/oracle/apps/apps_st/comn/clone/bin/CloneContext_06291504.log
Provide the values required for creation of the new APPL_TOP Context file.
Target hostname (virtual or normal) [r12apps]:
Target system database SID:vis
Target system database server node [r12apps]:
Target system base directory for source homes:/u02/oracle
Target system base directory for instance homes [/u02/oracle/inst]:
Do you want to preserve the Display set to sourcehost:0.0 (y/n) [y] ?:n
Target system Display [r12apps:0.0]:
Do you want the the target system to have the same port values as the source system (y/n) [y] ?:n
Clone Context uses the same port pool mechanism as the Rapid Install.
Once you choose a port pool, Clone Context will validate the port availability.
Enter the port pool to be used for the target system node [0-99]:
55
Checking the port pool 55
done: Port Pool 55 is free
Report file located at /u02/oracle/inst/apps/vis_r12apps/admin/out/portpool.lst
Complete port information available at /u02/oracle/inst/apps/vis_r12apps/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /u02/oracle/db/tech_st/10.2.0/admin/vis_r12apps/udump
3. /u02/oracle/db/tech_st/10.2.0/appsutil/outbound/vis_r12apps
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:3
Creating the new APPL_TOP Context file from :
/u02/oracle/apps/apps_st/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u02/oracle/inst/apps/vis_r12apps/appl/admin/vis_r12apps.xml
Log file located at /u02/oracle/apps/apps_st/comn/clone/bin/CloneContext_06291504.log
Check logfile /u02/oracle/apps/apps_st/comn/clone/bin/CloneContext_06291504.log for details.
Running Rapid Clone with command:
perl /u02/oracle/apps/apps_st/comn/clone/bin/adclone.pl java=/u02/oracle/apps/apps_st/comn/clone/bin/../jre mode=apply
stage=/u02/oracle/apps/apps_st/comn/clone component=appsTier method=CUSTOM
appctxtg=/u02/oracle/inst/apps/vis_r12apps/appl/admin/vis_r12apps.xml showProgress contextValidated=true
Running:
perl /u02/oracle/apps/apps_st/comn/clone/bin/adclone.pl java=/u02/oracle/apps/apps_st/comn/clone/bin/../jre mode=apply
stage=/u02/oracle/apps/apps_st/comn/clone component=appsTier method=CUSTOM
appctxtg=/u02/oracle/inst/apps/vis_r12apps/appl/admin/vis_r12apps.xml showProgress contextValidated=true
XMLPARSER: /u02/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar
JDBC: /u02/oracle/apps/apps_st/comn/clone/jlib/ojdbc14.jar
CLASSPATH:
/u02/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/u02/oracle/apps/apps_st/comn
/clone/jlib/java:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u02/o
racle/apps/apps_st/comn/clone/jlib/oui/share.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/u02/oracle/apps/apps_st/comn/clone/
jlib/ojmisc.jar
OUI CLASSPATH:
/u02/oracle/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u02/oracle/apps/apps_s
t/comn/clone/jlib/oui/xmlparserv2.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/share.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/s
rvm.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/ojmisc.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u02/oracle/apps/apps_
st/comn/clone/jlib/ojdbc14.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/java
Setting LD_LIBRARY_PATH to /u02/oracle/apps/apps_st/comn/clone/oui/lib/linux
Beginning application tier Apply – Mon Jun 29 15:05:14 2009
/u02/oracle/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath
/u02/oracle/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/u02/oracle/apps/apps_st/comn
/clone/jlib/java:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u02/o
racle/apps/apps_st/comn/clone/jlib/oui/share.jar:/u02/oracle/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/u02/oracle/apps/apps_st/comn/clone/
jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /u02/oracle/inst/apps/vis_r12apps/appl/admin/vis_r12apps.xml -stage
/u02/oracle/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /u02/oracle/inst/apps/vis_r12apps/admin/log/ApplyAppsTier_06291505.log
– 3% completed
What is FNDLOAD in Detail
June 30, 2009 at 8:09 am | In Oracle Apps Tips and Tricks | Leave a CommentTags: afcpprog.lct, FNDLOAD, fndload download syntax, fndload syntax, fndload upload, lct
FNDLOAD is used generally to download and upload from/into the apps database –the definitions of responsibilites ,
concurrent Programs,Menus,etc.
As an Apps DBA if you are given an ldt file and told to apply that in production then do the following
grep lct the ldt file
you will get the lct name (which is used as config file to upload the ldt file)
then use FNDLOAD giving the parameters
here an example is given
downloading(mostly tech consultants does this)..
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct
XXSC_POS_ORDER_EXTRACT.ldt PROGRAM APPLICATION_SHORT_NAME=”PO”
CONCURRENT_PROGRAM_NAME=”XXSC_POS_ORDER_EXTRACT”
Uploading(Apps DBA job)
1.given ldt here is XXCF_WH_HAT02_OPR_HANDLING.ldt
2.$grep lct XXCF_WH_HAT02_OPR_HANDLING.ldt
3.you get the lct name “afcpprog.lct” as result(which is control file for concurrent programs).
4.now give the following syntax(11i)
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXCF_WH_HAT02_OPR_HANDLING.ldt
for R12 replace the corresponding patch for $FND_TOP/patch/import/ and execute..
FNDLOAD is a very useful tool provided by oracle which eases the hectic work in sysadmin and it is very usefull when
you port developed large concurrent programs from dev to prod.
Your comments are welcome.
– Vivek R
Concurrent Manager Internals
June 29, 2009 at 8:22 am | In Oracle Apps Tips and Tricks | Leave a CommentTags: cmclean.sql, concsub, concurrent manager internals, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, internals of concurrent manager
Dear Readers,
In this post I will be writing about Internals of Concurrent Manager as how It works Internally.
A basic understanding like what is a concurrent manager and its responsiblity is required before reading further.
When submitting a concurrent request either Standard Manager or other Type of Managers
will process the request.
Concurrent Manager is controlled by three tables in database called FND_CONCURRENT_REQUESTS,FND_CONCURRENT_QUEUES and
FND_CONCURRENT_PROGRAMS .
When we submit any request a plsql routine using CONCSUB binary is called which queries
the FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS for
request and program definiton and the concurrent manager queries and maintains the status codes in the table FND_CONCURRENT_QUEUES
,all the statuses of the requests like pending,submitted,running,on hold ,ready are maintained as short codes in this table.
Concurrent Manager uses the CONCSUB utility using pl/sql routines for quering this table and if it finds that the status of any submitted
program is READY (to run) then it executes the submitted request
For Submitting Concurrent Programs You can also use CONCSUB Utility from the command line or shell prompt instead of front end forms.
an example is shown below
Active Users(request)
CONCSUB apps/[apps_pwd] SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDSCURS
Here FNDSCURS is the Active Users executable in apps.
Note :- If for any reason the concurrent manager does not start its the fnd_concurrent_queues where the control codes are messed up . download cmclean.sql from metalink to clean the statuses and never truncate this table using sql plus straight away.
Your Comments/Questions are welcome.
– Vivek R
How to troubleshoot oracle RAC CRS startup errors (CRS logfiles )
June 24, 2009 at 10:30 am | In Oracle Apps Tips and Tricks | 1 CommentTags: 10g rac logfile location, crs logfile, css logfile, evm logfile, online 10g RAC dba training, online workshop 10g RAC, rac logfile location, rac logfiles
Dear Readers,
Often its a mystery to find when a RAC CRS goes down,but with the help of the CRS stack logfiles the job is made is easy.
Here I have given some important log,trace files for troubleshooting.
Log Directory Structure in RAC 10g Cluster Ready Services
Each component in the CRS stack has its respective directories created under the CRS home:
$ORA_CRS_HOME/crs/log Contains trace files for the CRS resources.
$ORA_CRS_HOME/crs/init Contains trace files of the CRS daemon during startup. for any CRS login problems.
$ORA_CRS_HOME/css/log The Cluster Synchronization (CSS) logs indicate all actions such as reconfigurations,
missed check-ins, connects, and disconnects from the client CSS listener. also, the logger logs messages with the
category of auth.crit for the reboots done by Oracle. This could be used for checking the exact time when
the reboot occurred.
$ORA_CRS_HOME/css/init Contains core dumps from the Oracle Cluster Synchronization Service daemon (OCSSd)
and the process ID (PID) for the CSS daemon whose death is treated as fatal. If abnormal restarts for CSS exist,
the core files will have the format of core..
$ORA_CRS_HOME/evm/log Log files for the Event Volume Manager (EVM) and evmlogger daemons.
$ORA_CRS_HOME/evm/init PID and lock files for EVM. Core files for EVM should also be written here.
$ORA_CRS_HOME/srvm/log Log files for Oracle Cluster Registry (OCR), which contains the details at the Oracle cluster level.
$ORA_CRS_HOME//log Log files for Oracle Clusterware (known as the cluster alert log), this contains diagnostic messages
at the Oracle cluster level. This is available from Oracle database 10g R2.
Your comments are welcome
– Vivek
How to overcome the error ( CRS-0223 resource has placement error) when starting rac database using srvctl
June 24, 2009 at 8:54 am | In Oracle Apps Tips and Tricks | 1 CommentTags: crs-0223, CRS-0223 resource has placement error, crsctl commands, crsctl status, export asm, srvctl, start asm rac, troubleshooting RAC 10g
Dear Readers,
When starting the RAC database using srvctl you may get the following error
CRS-0223 resource has placement error
the reason behind this the ASM instances are not started before
Lets consider we run a two node rac setup
where nodes are rac1,rac2
do the following to overcome the error
Step 1.
login to rac1 using putty as root
login as oracle user
$crsctl check crs
make sure all the status is UP
Step 4.
do the following in rac1 as oracle user
$export ORACLE_SID=+ASM1
$sqlplus ‘/ as sysdba’
SQL>select * from v$instance;
ensure that the ASM1 is up..
if not start it
you can start also using $srvctl start asm -n rac1
Step 5.
do the following in rac2 as oracle user
$export ORACLE_SID=+ASM2
$sqlplus ‘/ as sysdba’
SQL>select * from v$instance;
ensure that the ASM2 is up..
if not start it
you can start also using $srvctl start asm -n rac2
Step 6.
verify the listener is up in both nodes
lsnrctl status , if not start in rac1
using $lsnrctl start LISTENER_RAC1
in rac2
$lsnrctl status , if not started then start it
using $lsnrctl start LISTENER_RAC2
Step 7.
login to tmprac1 and start the database using
$srvctl start database -d
if it is giving any error then start it using sqlplus
$sqlplus ‘ / as sysdba’
SQL>startup
do this in rac2 also
after everything login to sqlplus ‘/ as sysdba’
SQL>select * from v$active_instances;
it will display two RAC database instances;;
so now the startup is complete..
also start the enterprise manager if its not started using emdctl start dbconsole…
Your comments,questions are welcome.
– Vivek
5 Golden rules for Oracle Apps 11i/R12 Performance Tuning
June 23, 2009 at 1:53 pm | In Oracle Apps Tips and Tricks | Leave a CommentTags: 11i performance tuning, oracle apps performance tuning, oracle apps R12 performance tuning, performance tuning, r12 perfromance tuning
Dear Readers,
Here are some of the rules for oracle apps performance tuning
1.We should make sure Gather Shema Stats is running on periodical basis. It can be checked with bde_last_analyzed.sql
It verifies stats by schema and index.
2.We should not gather statistics excessively for all the schemas such as nightly or weekly.
3. We must not gather statistics on permanent objects during peak intervals.
4. we must use FND_STATS or the Gather Schema and Gather Table Statistics Concurrent Programs.
and we should NOT USE the analyze or dbms_stats command directly which results in sub-optimal plans.
5.we must use the bde_chk_cbo.sql which is given in metalink to check the intialization parameters so that its set to standards.
Then further if you face issues in performance then run AWRreport or statspack to analyze further..
especially look for customized modules ‘SQL’. and programs.
for oracle seeded programs always contact oracle support.
Your comments always welcome
– Vivek R
How to Create a Report in Business Objects using Desktop Intelligence and View in InfoView
June 19, 2009 at 8:35 am | In Oracle Apps Tips and Tricks | 1 CommentTags: business objects report creation, creating report in business objects, creating reports using desktop intelligence and publishing, infoview business objects reports creation
Dear Readers ,
In this post I will explain how to create a report using Desktop intelligence in Business Objects and View the same in Info View. I have posted the screen shots below,Here I am creating a report called Sales History using the created Universe Sales Universe.
a.
Create Report Wizard
b.
Choose Universe Option
c.
Choosing the Correct Universe
d.
Query Panel
e.
Choosing the report attributes
f.
Finished Report
g.
File>export>to Repository
h.
Send in The Right Category Screen
Your comments are welcome.
– Vivek
How to Create Universe in Business Objects
June 17, 2009 at 3:37 pm | In Oracle Apps Tips and Tricks | 4 CommentsTags: create end user layer business objects, create universe in business objects, how to create universe in business objects, universe creation using Designer Business objects
Dear Readers,
In this post i will explain in detail about how to create Universe in business objects.
1.Invoke Desinger from Start>Programs>Business Objects>Designer
Invoke Business Objects Designer
2.The Login Screen is shown below…
Designer Login Screen
3.After Logging in The Desinger will automatically invoke quick design wizard through which i am going to create the universe.
Quick design wizard
4.Give a meaningful name for the universe and in the Create new connection click New (since we are creating first time the
connection),otherwise we can use the existing connection from the dropdown menu.
Create Connection wizard -step I
5.Choose the correct drivers for connection.since I am using Oracle database I have chosen oracle driver which is shown below
Choose Driver in Connection Wizard -Step II
6.You can see I have created the connection and that connection is chosen in the Quick Design Wizard below..
connection_completed_and_selected
7.In Our Next Step (i.e Step 2 in the wizard) we are going to choose the Objects and classes which is nothing but tables or views in the schema which we have created in the previous step. i have shown that in the following scrn shot.
Create_classes_and_objects
8.Choose from the left pane the required objects and move them to the right pane which i have shown below..
Choose Objects to the right pane
9.Then Create measures as shown below
create_measures
10.Click Finish , the Universe Created Dialog Box appears 
universe_created
11.The Created Universe appears as below..
view_sales_universe
12.After Creation of Universe we can Insert tables,views(objects) whenever we need,this can be achieved by clicking Insert tab which is shown below..
insert_tables_into_universe
13.Now we have created the Universe, but we need to export this into the Webi so that it is available for other users.This can be done using export from file after creating the Universe…Then It can be viewed in the Central Management Console..
export_universe_sales
b.choose into the right area(webi)
choose_webi
c. confirmation that universe is exported
universe_exported
14..Now login to central Management Console and choose Universe and choose webi and expand you can see the Created
Universe (Sales Universe) which is shown below
sales_universe_in_cmc
Later You can define in Central Management Console — the Security Level for Users.
Hope This Helps All,
Your Comments are welcome.
–Vivek R
Similarities in Oracle BI Discoverer and Business Objects
June 17, 2009 at 12:25 pm | In Oracle Apps Tips and Tricks | Leave a CommentTags: business objects, Oracle BI discoverer and business objects, oracle bi discoverer difference business objects
Dear Readers,
Business Intelligence is becoming very famous nowadays due to its nature.Organizations use Business Intelligence for
Forecasting their future Growth,For Adapting Cost Cutting Measures and it helps when the Companies can focus their area for more ROI.The famous Products for Business Intelligence are Oracle BI Enterprise Edition which was previously Siebel Analytics and Oracle BI Discoverer Suite and Business Objects.
Oracle BI Discoverer has EUL(End User Layer) which is equivalent to Universe in Business Objects.
Its a semantic layer through which the end reports can be easily buit upon without much programming knowledge
Both products has folders and the working mechanism of these are almost the same in business objects and oracle bi discoverer.
Oracle BI Discoverer has got portal for web reports and business objects has got web intelligence for web reports.
Oracle BI Discoverer has got Discoverer Desktop where as business objects has got Desktop Intelligence for creating reports.
In Oracle BI discoverer reports are called as workbooks ,where as in business objects its called as documents.
Oracle BI has got Discoverer Administrator and business objects has got Central Management Console and both does the same almost.
In my following posts I will discuss more about business objects as how to create an universe from scratch with scrn shots and how to publish the reports in InfoView.
Your Comments are welcome.
— Vivek
Unable to Set Homepage to “FrameWork only” after applying ATG.RUP4 in 11i
June 17, 2009 at 8:31 am | In Oracle Apps Tips and Tricks | Leave a CommentTags: ATG RUP4 homepage issues, homepage blank after ATG RUP4, unable to set Framework only after ATG.RUP4
Dear Readers,
We all know that every patch in oracle has its merits and bugs.After applying ATG RUP4 ,
you may find it hard to get the homepage.You may only get a blank page.But setting Self Serive Framework
to other values than “Framework” works.This is a bug of ATG RUP4.But the solution to fix this as below.
do the following after setting the APPSORA.env
FNDLOAD apps/apps 0 Y UPLOAD $JTF_TOP/patch/115/import/jtfprefabcache.lct $FND_TOP/patch/115/import/US/b3664848.ldt CUSTOM_MODE=FORCE
bounce the Apache.
and set the Self Service Profile to “Framework only”
and it works.
Your comments are welcome..
—Vivek
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.
