Forgot your password?    
+ Reply to Thread
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Interviews Question

  1. #1

    Interviews Question

    Question 1: What steps you follow when user complain about database slowness.
    Question 2: How you will unable trace for a particular session.
    Question 3: How you will generate AWR report and what you check in AWR report.
    Question 4: Steps for patching in application and database tier.
    Question 5: Steps for cloning from multinode environment to single and mulitnode environment..
    Question 6: What are necessary steps you will follow during shared APPL_TOP.
    Question 7: How you will keep concurrent request in hold.
    Question 8: During Patching you shutdown CM , What happen to running Concurrent Manager request.
    Question 9: Location for JVM and Apache config file in 11i.
    Question 10:What is the configuration of your apps and DB environment.
    Question 11: What error you faced recently and how you troubleshoot it.
    Question 12: How frequently you take support from Oracle Support Team & what types of errors.
    Question 13: Except from alert log mail, ora-errors,what types of issues you faced in your database.
    Question 14: What are the prerequisites during installation of oracle and apps 11i.
    Question 15: While patching you have not applied prerequisite patch and u get error how you will continue.
    Question 16: Size of your database , all and concurrent users.
    Question 17: Backup strategy in your environment.
    Question 18: How much you rate yourself in database and apps in mark of 5.
    Last edited by sandeep.negi27; 04-20-2012 at 11:51 AM.

  2. #2
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    can anyone explain how to clone multi node to multi node shared application tier file system clone.Like my architecture is forms and webserver on one node,concurrent and admin on one node and db on one node...can anyone explain how to clone this is shared application tier filesystem.

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    On R12 for the applications tier :
    on the source , run the preclone on all the nodes
    Multi to Multi with Shared Application File System , will require you to copy the Shared application Tier file system only once , to the shared location on the target.
    This means that the ORACLE_HOMEs ,APPL_TOP and the COMMON_TOP would be copied only once.
    on the target , run the adcfgclone on all the nodes , and while running , provide the services which would be running on the target.

    If its 11i , (apart from that stated in R12) in the target , you will have to use the following to create the configuration top:

    $ cd <COMMON_TOP>/admin/scripts/<CONTEXT NAME>
    $ adstpall.sh <APPS user name>/<APPS user password>
    $ cd <FND_TOP>/patch/115/bin
    $ perl -I <AU_TOP>/perl txkSOHM.pl

    This is to create the Configuration top (as an input parameter to the shared file system script txkSOHM.pl) which can not be shared among multiple application middle tier nodes.

  4. #4
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43
    In a shared apple top environment apart from running adcfgclone.pl we also need to run adclonectx.pl for sharing the appl_top from all nodes. We have to run adcfgclone.pl from the first node only as the APPL_TOP is shared and we can create the context file using adclonectx.pl in the other nodes by giving the reference of XML file of the first node. Then we need to run txkSOHM.pl from $FND_TOP/patch/115/bin which will create 8.0.6 and iAS config Home for Application system.

  5. #5
    Oracle Administrator
    Join Date
    Oct 2011
    Location
    Venice
    Posts
    40
    Questtion : I am running adpreclone.pl @ dbtier and mistakenly passed wrong apps password. What would happen ?
    Answre : adpreclone will not run and it will bounce the database. be careful while doing the same.

    Reference metalink note
    R12: adpreclone.pl bounces the Database when an incorrect APPS Password is used [ID 1378211.1]

    Plus Discussion @ https://forums.oracle.com/forums/thr...hreadID=890338
    Last edited by pkumar; 04-28-2012 at 06:26 PM.
    Cheers !
    pk.ora

  6. #6
    Thanks for Sharing .

  7. #7
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    I think we should run adpreclone.pl in the primary node.Not on all the nodes?after that perform adcfgclone.pl on one of the target node and share the appltop..

    waiting for your suggestions.

    tnx,
    sai.

  8. #8
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    FNDLOAD...after cloning can we transfer fnd_users from source to target node?how?

    tnx,
    sai.

  9. #9
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    What will you do if cloning failed while running adcfgclone ?

  10. #10
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    FNDLOAD...after cloning can we transfer fnd_users from source to target node................................

    In process of cloning we had actually cloned the database also. Fnd_users is a table in APPLSYS schema. It also get cloned there. Why you need to transfer this table again. Any how you can use fndload to download and upload any tables from source to target:

    Source:
    $FND_TOP/bin/FNDLOAD username/password@database 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XXUSERNAME.ldt FND_USER USER_NAME=’XXUSERNAME’

    Target:
    $FND_TOP/bin/FNDLOAD username/password@database 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXUSERNAME.ldt

+ Reply to Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. patching question
    By saioracleappsdba in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 3
    Last Post: 07-02-2012, 08:03 PM
  2. admerge question
    By saioracleappsdba in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 2
    Last Post: 06-24-2012, 07:33 AM
  3. GSM question
    By saioracleappsdba in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 06-16-2012, 07:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics