Cloning Issues

1. Cannot login to Applications through PHP. 'NO DAD CONFIGURATION FOUND' error in cloned instance.

Cause: Modplsql agent of Apache is unable to find the DAD from
configuration file wdbsvr.app

Sol: Ensure that DAD name in wdbsvr.app file in iAS_TOP\Apache\modplsql\cfg is
correct. Also check DAD in ICXINDEX.hml is also having a correct value

2. Problem running adpatch on a Cloned environment.
Error: "The Applications system names per the APPL_TOP and the Database are
different"

Cause: The APPLICATIONS_SYSTEM_NAME field in the FND_PRODUCT_GROUPS table was still filled with the value of the old environment


3. Unable to Invoke help on a cloned instance.
ERROR:APPS_WEB_AGENT=NULL. Please verify DBC file.

This error is encountered when clicking on the "?" in oraclemypage.home URL.

Cause: "Applications Help Web Agent" profile option is set incorrectly

sol:Set the Applications Help Web Agent as

Refer the Note ID 188562.1

4.ADPATCH, ADADMIN fail with following error on a cloned instance.
Your current applications top directory does not match that of the
configuration file. Please check that your environment is correct.

Cause: Cloning copied a configuration file that does not match the cloned
environment.

Sol: Check Note:131821.1 for solution

DBA Questions

1. How you will recover Online redolog files?
2. If you lost your Control file lost how will you recover?
3. Users are complaining Concurrent paragram take time to complete?
4. What DMT and LMT? What is the difference between those?
5. How will u rebuild index for what purpose u will do?
6. How will create a user and how will assign a table space, quota to that user?
7. How will u dynamically set SGA in 9i, 10g?
8. How will set the sizes for shared pool, log buffer, large pool so on in SGA?
9. What is ADDM, AWR in 10G?
10. How will dynamically set the SGA in 10G?
11. Why we need to set kernel parameters for what purpose?
12. When creating database if you get error where will you check?
13. What is ORA-01000?
14 What is ORA-0060 ?
15. How to define Data Block size ?
16. What is the function of Optimizer ?
17. What is SAVE POINT ?
18.what is the use od root.sh script ?
19.What is the impact if I lose my dual table ?
20.How you identify the password for DB link in 9i ?

Apps DBA Questions

1. What is a snapshot? In which table we get Information?
2. How will check Apache is working in Front-end and Back End
3. Write down the methods to identify whether the application is in maintenance mode or not
4. What is the result of unsetting APPLCSF
5. How are the AOL Developers Environment variables set
6. How do we get access to the initial sigon to application?
7. From where are the Report files picked up for execution
8. Where are the Reports plsql files located
9. Which ORACLE HOME is used by ad utilities
10. Which file contains the product dependencies information
11. When apps password is given wrong for adstpall.sh, what is the effect on the services
12. What are the Various Statuses of Workers
13. How do you restart a failed patch process
14. What are the table/tables created when workers are initiated and in which schema
15. Create defaults file for "Compile Apps Schema"
16. Execute "Compile Apps Schema" in noninteractive mode
17. Where are the custom files placed
18. Difference between ad_bugs and ad_applied patches
19. What happened Relink adslpice and adpatch?
20. What are Oracle Apps DBA Important Tables we use in daily activities?
21. What is .lct and .ldt files in Patch Directory?
22. What are the tables updated when you apply application patch?
23. Can you apply Opatch without inventory? If there is no inventory, how do you apply Opatch?
24. What are the tables get created during Apps Patching?
25. How do you hide apps password during adpatching? (adpatch flags=hidepw)
26. What is interoperability patch
27. How do you compile jsp files?
28. Types of profile options?
29. Opatch log file location?
30. How do you clone a context file or how do you change existing port pool?
31. How do you run autoconfig in test mode?
32. What are mandatory users in oracle apps?
33. What is the location of apache and plsql cache?
34. What is adlicmgr ?
35. When do you relinking?
36. What is DAD?
37. How do you compile a schema?
38. What is the utility to clean the concurrent manager tables?
39. How do you stage the 11.5.10 Apps software?
40. ADPATCH has failed and it indicated there was an error with a worker. What steps can be taken to investigate this problem?
41. How can I check to see if a concurrent manager is running?
42. Where do concurrent request or manager logfiles and output files go?
43. What is the function of the 'Conflict Resolution Manager'?
44. Unable to Bring Up Concurrent Manager after Running Autoconfig.
45. When should I run AutoConfig?
46. Which files / profile options get changed when I run AutoConfig?
47. What is cloning?
48. How do I determine if my system is Rapid Clone enabled?
49. Can I clone from one operating system version to another?
50. Can I change the database dbf files layout while cloning?
51. What is the difference between Concurrent Requests, Programs, and Processes
52. What is iAS Patch?
53. Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you?
54. When you apply C driver patch does it require database to be Up & Why?
55. What are the important options to reduce patch down time?
56. Can you apply patch without putting Applications 11i in Maintenance mode?
57. What is difference between adpatch & opatch? Can you use both adpatch & opatch in Apps?
58. Why do I have invalid objects? What causes them? How you identify them ?
59. Is there a file that lists all of the patches that have been applied to the application?
60. What is the difference between apps listener & web listener?
61. Why only for Concurrent Manager, we specify apps/apps password & not for other?
62. What’s the significance of batch size? What r the effects when we increase r decrease the batch size it defaults to 1000.
63. What is the purpose of using the option Phtofile in adpatch?
64. How do I configure AutoConfig for a multi-node system?
65. How do you identify the No. of nodes in Middle tier and db Tier
66. What is a Shared APPL_TOP? How do you identify whether it is a shared appl_TOP or not?
67. What is a Jinitiator? (Jinitiator is the Oracle JVM used to run the applet instead of using browsers own JVM)
68. Where would i find .rf9 file, and what exactly it dose?
69. What is .dbc file, where its stored , what’s use of .dbc file ?
70. What is the use of adident utility ?
71. What is adsplice utility ?
72. How can you licence a product after installation ?
73. What is access_log in apache , what entries are recored in access_log ? Where is default location of this file ?
74. How to determine Oracle Apps 11i Version ?
75. What is PCP is Oracle Applications 11i ?
76. How to convert pll to pld file or pld file to pll ?
77. Where are the Application usrs details stored?
78. How to find plsql version?
79. When do you use startmgr.sh script? Where its locate?
80. What is the yellow Bar Issues?

Use full scripts for Apps DBA's

Apache issues

mportant HTTP Status Codes
200 OK

Ex : [02/Mar/2010:03:15:13 -0800] "GET /OA_HTML/jtflogin.jsp HTTP/1.1" 200 8973 0
Above url successfully opened with 8973 bytes

201 Created
202 Accepted
400 Bad Request
401 Unauthorized
402 Payment Required
403 Forbidden
404 Not Found
405 Method Not Allowed
406 Not Acceptable
407 Proxy Authentication Required
408 Request Timeout
409 Conflict
*424 Locked
500 Internal Server Error
501 Not Implemented
502 Bad Gateway
503 Service Unavailable
504 Gateway Timeout
505 HTTP Version Not Supported
*507 Insufficient Storage

You will find this Error codes in access_log file which locates on
IAS_ORACLE_HOME/Apache/Apache/logs/



 Use the following programs to verify the installation and check that the servlets are functioning.


a. http//:/servlets/IsItWorking

(11.5.10) This may fail with:

403 Forbidden You don't have permission to access /servlets/IsItWorking on this server.

This is due to enhanced security delivered with the autoconfig templates..

b.http://:/servlets/Hello

If this one fails, this indicates an issue with your Jserv set-up. You then need to follow Note:230688.1 to drill down into this problem

Validate the jsp pages

http(s)://:/OA_HTML/jsp/fnd/aoljtest.jsp















If this one fails , this indicates an issue with your Jserv set-up. You then need to follow Note:230688.1 to drill down into this problem.Otherwise you enter the values requested,.

Check that the CGI environment and mod_plsql is functioning.


If you are unable to run the procedure below because of an 'internal

error' or a 'cannot find host' or a similar error, then it could indicate

that there is a problem with the PLSQL Configuration.

a. Run the following URL:

http://:/pls//FND_WEB.PING

For example:

http://myHost.myDomain.com:2002/pls/SID/FND_WEB.PING

This should output the results of running FND_WEB.PING package

Concurrent Manager issues

Pathcing Issues

1. Encountered the following erro while applying the patch :

AutoPatch error:

This patch has some prerequisites specified, but a "snapshot" of this

APPL-TOP's file-system has never been taken, thereby rendering it impossible

to check for the prerequisites.

Please take a "snapshot" of this APPL-TOP using "AD Administration" first

or continue without prerequisite checking.

Continue as if prerequisite patches have been applied? [Yes] ?


Solution :

************

When you get the above error, Check for the list of preequisite patches that the adpatch has queried from the patch log file , if they are already applied, Give Yes and continue with the patching process. Once all the patches are applied , Run adadmin and update

Current view snapshot.

2. Encountered the following erro while applying the patch :

ATTENTION: All workers either have failed or are waiting:

FAILED: file pa_proj_levels_tmp.xdf on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Table Name is PA_PROJ_LEVELS_TMP

Table does not exist in the target database

Executing create Statement

Create Statement is

CREATE GLOBAL TEMPORARY TABLE "APPS"."PA_PROJ_LEVELS_TMP"

( "FROM_ID" NUMBER(15,0),

"TO_ID" NUMBER(15,0),

"FROM_LEVEL" NUMBER(15,0),

"TO_LEVEL" NUMBER(15,0),

"DIRECTION" VARCHAR2(1),

"ATTRIBUTE1" VARCHAR2(30),

"ATTRIBUTE2" VARCHAR2(30),

"ATTRIBUTE3" VARCHAR2(30),

"ATTRIBUTE4" VARCHAR2(30),

"ATTRIBUTE5" VARCHAR2(30),

"ATTRIBUTE6" VARCHAR2(30)

) ON COMMIT DELETE ROWS

Start time for statement above is Mon Apr 23 09:18:03 CDT 2007

Exception occured ORA-00955: name is already used by an existing object

java.sql.SQLException: ORA-00955: name is already used by an existing object



Solution :

************

Bounced the database and restarted the patch application. Patch was applied successfully.



3. ****************The below error occurs almost often*****************

Encountered the following erro while applying the patch :

ATTENTION: All workers either have failed or are waiting:

FAILED: file fndcct.jar on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Loading contents of archive file into database with arguments


-ms128m -mx256m oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/XFuEVowV@auohsmrkm13:10010:PMRKMI1" /pmrkmi/applmgr/11510/admin/PMRKMI/out/p001ldjva.jar


Calling /usr/java/j2sdk1.4.2_10/bin/java ...

SQL Error while connecting with thin driver to auohsmrkm13:10010:PMRKMI: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869824)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

could not open connection

loadjava: 2 errors

AD Worker error:

The above program failed. See the error messages listed

above, if any, or see the log and output files for the program.

Time when worker failed: Sun Apr 29 2007 14:27:47



Solution :

********************

Manually executed the command as follows :



$java -ms128m -mx256m oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/xxxxx@auohsmrkm13:10010:PMRKMI1" /pmrkmi/applmgr/11510/admin/PMRKMI/out/p001ldjva.jar

$ 0010:PMRKMI1" /pmrkmi/applmgr/11510/admin/PMRKMI/out/p001ldjva.jar

$

4.************The Below Error Occurs Often in 10G instances***************
  
Encountered the following erro while applying the patch :
                       
AutoPatch error:

The following ORACLE error:

ORA-38301: can not perform DDL/DML over objects in Recycle Bin


occurred while executing the SQL statement
DROP TABLE AD_DEFERRED_JOBS

AutoPatch error:

adfrjp(): Error dropping FND_INSTALL_PROCESSES table


An error occurred while generating Oracle Forms files.

Continue as if it were successful [No] :

You should check the file
/pmrkmi/applmgr/11510/admin/PMRKMI/log/u4725549f.log

for errors.


********************************************************************

* PATCH HAS FAILED !!! *

********************************************************************

Patch failed, please rerun patch when problem has been fixed !

Please check logfiles for errors at:

/pmrkmi/applmgr/11510/admin/PMRKMI/log/4725549_F

Solution :

********************
SQL> sho user

USER is "APPLSYS"

SQL> exec execute immediate 'purge recyclebin';

PL/SQL procedure successfully completed.

SQL>

AutoPatch is complete.

AutoPatch may have written informational messages to the file

/pmrkmi/applmgr/11510/admin/PMRKMI/log/u4725549f.lgi

Errors and warnings are listed in the log file

/pmrkmi/applmgr/11510/admin/PMRKMI/log/u4725549f.log
and in other log files in the same directory.


5. Encountered the following erro while applying the patch :

Error while applying patch -2 :

=========================================

AutoPatch is complete.

-ms128m -mx256m oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/*****@AUOHSROIN12.oracleoutsourcing.com:10010:PROINI" /proini/applmgr/11510/admin/PROINI_BALANCE/out/p001ldjva.jar


Calling /proini/applmgr/common/util/java/1.4/j2sdk1.4.2_04/bin/java ...

SQL Error while connecting with thin driver to AUOHSROIN12.oracleoutsourcing.com:10010:PROINI: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093632)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

Solution :
Executed the command manually :

java -ms128m -mx256m oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/apppwd@AUOHSROIN12.oracleoutsourcing.com:10010:PROINI1 " /proini/applmgr/11510/admin/PROINI_BALANCE/out/p001ldjva.jar

Skipped the worker and continued with patching.

6. Encountered the following erro while applying the patch :

create tablespace IZUD datafile '/dczb3i/oradata/data01/izud01.dbf' size 500M autoextend on next 25M maxsize 1800M extent

management local;
create tablespace IZUX datafile '/dczb3i/oradata/data01/izux01.dbf' size 500M autoextend on next 25M maxsize 1800M extent

management local;

create user izu identified by izu default tablespace izud;

grant connect,resource to izu;

select tablespace_name from dba_tablespaces where tablespace_name='IZUD';


TABLESPACE_NAME

------------------------------

IZUD
create tablespace IZUX datafile '/dczb3i/oradata/data01/izux01.dbf' size 500M autoextend on next 25M maxsize 1800M extent

management local;

select tablespace_name from dba_tablespaces where tablespace_name='IZUX';

TABLESPACE_NAME

------------------------------

IZUX

Run adsplicer :

******************

Please enter the directory where your AD Splicer control file is located.


The default directory is [/dczb3i/applmgr/11510/admin] :

Please enter the name of your AD Splicer control file [newprods.txt] :


Processing file /dczb3i/applmgr/11510/admin/newprods.txt...

Loading information for product 'izu'...

Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file!

Successfully read file /dczb3i/applmgr/11510/admin/newprods.txt.

Verifying localizations...

Validating inter-product dependency information...

Re-organizing product information lists...

Adding new languages into FND_LANGUAGES...

Creating ORACLE usernames for products...

AD Splicer is creating or updating the ORACLE username IZU

with password ***** for Oracle Support Diagnostic Tools tables.

Granting privileges for tablespaces...
Granting required system privileges and creating APPS*DDL packages...

sqlplus -s IZU/***** @/dczb3i/applmgr/11510/ad/11.5.0/admin/sql/adaddls.pls ***** IZU *****

Spawned Process 16221

Done running adaddls.pls for IZU

sqlplus -s IZU/***** @/dczb3i/applmgr/11510/ad/11.5.0/admin/sql/adaaddls.pls ***** IZU *****

Spawned Process 16224

Done running adaaddls.pls for IZU

sqlplus -s IZU/***** @/dczb3i/applmgr/11510/ad/11.5.0/admin/sql/adaddlb.pls ***** IZU *****

Spawned Process 16239

Done running adaddlb.pls for IZU

sqlplus -s IZU/***** @/dczb3i/applmgr/11510/ad/11.5.0/admin/sql/adaaddlb.pls ***** IZU *****

Spawned Process 16240

Done running adaaddlb.pls for IZU

Registering ORACLE usernames/passwords.

**

**Inserting application information for new products...

**

Running fnd_application_pkg.add_language ...

**

**Updating product information for new products...

**

Populating INSTALL_GROUP_NUM column to FND_ORACLE_USERID table.

**

**Updating product dependency information...

**

Recording modules in the database...done.

**

**Updating Data Groups...

**

Reading existing data groups from database.

Registering any new data groups.

Registering any new data group units.

Updating Data Group "Standard" to point to

APPS #1 Account (ORACLE ID = 900)
Updating Patch Advisor tables to include new product information ..

sqlplus -s APPS/***** @/dczb3i/applmgr/11510/ad/11.5.0/sql/adpaseed.sql *****

Spawned Process 16255

Done.
Saving module actions...done.

Saving product actions...done.

Product top directory for product "izu" exists.

Directory is /dczb3i/applmgr/11510/izu/11.5.0

Directory "log" for product "izu" exists.

Directory "out" for product "izu" exists.

Directory "mesg" for product "izu" exists.

Directory "sql" for product "izu" exists.

File "sql/IZUNLINS.sql" for product "izu" exists.

Directory "admin/sql" for product "izu" exists.

File "admin/sql/IZUNLADD.sql" for product "izu" exists.

Directory "admin/driver" for product "izu" exists.

File "admin/driver/izucon.drv" for product "izu" exists.

File "admin/driver/izuseq.drv" for product "izu" exists.

File "admin/driver/izutab.drv" for product "izu" exists.

File "admin/driver/izutbm.drv" for product "izu" exists.

File "admin/driver/izuos.drv" for product "izu" exists.

File "admin/driver/izupls.drv" for product "izu" exists.

File "admin/driver/izuvw.drv" for product "izu" exists.

File "admin/driver/izuplb.drv" for product "izu" exists.

File "admin/driver/izupdt.drv" for product "izu" exists.

File "admin/driver/izudat.drv" for product "izu" exists.

File "admin/driver/izuupg.drv" for product "izu" exists.

File "admin/driver/izudfr.drv" for product "izu" exists.

File "admin/driver/izuen.drv" for product "izu" exists.

File "admin/driver/izudep.drv" for product "izu" exists.

Do you wish to regenerate your environment file [Yes] ? no

AD Splicer is complete.

***********Skip the process of regenerating the env file as it will force to run autoconfig

select APPLICATION_ID from fnd_application where ALICATION_SHORT_NAME = 'IZU';

APPLICATION_ID

--------------

278

Edit the existing env file with the entry of the product top and save the changes.



/dczb3i/applmgr/11510/izu/11.5.0



7. Encountered the following erro while applying the patch :

AD Worker error:

The above program failed with error code 1.

See the AD Worker log file and/or the program log file for details.

Time when worker failed: Tue Oct 17 2006 08:47:04

========================================================



Isssue while applying a patch :



========================================================

FNDLOAD apps/IFm9bC29 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @PO:patch/115/import/US/poprg.ldt

While applying the patch 5249967, FAILED: file poprg.ldt on worker 1.

After looking at the log file , the worker 01 failed with this error :

Error loading seed data for VSET_TABLE: FLEX_VALUE_SET_NAME = PO_SRS_CHART_OF_ACCOUNTS, ORA-20001:

Later found that, the table VSET_TABLE does not exists.

SQL> select name,user from v$database;

NAME USER

--------- ------------------------------

TATENI APPS

SQL> select * from dba_objects where object_name='VSET_TABLE';
no rows selecte
SQL> select * from dba_objects where object_name='VSET_TABLE' and object_type='TABL
no rows selected
SQL> desc VSET_TABLE
ERROR:
ORA-04043: object VSET_TABLE does not exist
SQL>
Hence Skipping the worker using adctrl.