Skip to main content

Autoconfig -- Indetail

Autoconfig as the name says used for automatic configuration/regeneration/reconfiguration for most of/all  the configuration files in Oracle Applications. This is one of the AD tools that i will be starting to detail.

Autoconfig can either be started using a shell script in Unix or cmd executable in windows under $COMMON_TOP/admin/script/$CONTEXT_NAME/adautocfg.sh for Unix

This inturn calls a shell script adconfig.sh under $AD_TOP/bin. You can either use adautocfg.sh or adconfig.sh to run autoconfig. Only difference is that you will have to supply the context file(SID_host.xml) if you run adconfig.sh.

APPS password is mandatory for autoconfig, so make sure you have apps password handy before starting autoconfig.

Follwing are the details after adconfig.sh is invoked through adautocfg.sh.

1. Check Perl version
2. Locate Perl and its libraries(For application tier or for database tier  -- If application tier then locate perl in  APACHE_TOP, for database tier then ORACLE_HOME)
3. Check if context file is passed else prompt for one
4. Execute adperl.pl

Once the perl script is initiated it starts writing the log file under $APPL_TOP/admin//log//adconfig.log

Following are the details once its starts running the perl script.

1. Create the log file
2. Set class path
3. Check if there is a new version of the context file, if yes then process the template and request data for new variables
(New template available under $AD_TOP/admin/template/adxmlctx.tmp)

4. Create a backup copy of the old context file under $APPL_TOP/admin//out//.xml
5. Establish database connectivity using APPS_JDBC_URL
6. Check if there are possible updates available for the context file, if yes then sync the same
   Update the local context file, check for adgendbc.sh template, write the context file on the file system.
7. Synchronize product tops, this uses a top file under $APPL_TOP/admin/topfile.txt
    Any update on new tops or removal of old tops are written to this file.
8. Start context value management,
    This check for all the s_* parameters in the context_file, if there is no value specified and the variable is mandatory then it prompts to enter the value.
9. Run $AD_TOP/bin/adchgatname.pl
    This script performs the task of validating the APPL_TOP name in context file. If the APPL_TOP name in context file is found to be invalid, it will replace it with valid name. By valid value for APPL_TOP name
it means:
- APPL_TOP name must be between 1 and 30 characters long
- APPL_TOP name must start with a letter
- APPL_TOP name must contain only alphanumeric and underscore characters
Again, if the APPL_Top name is changed, then this utility will take care of storing the old APPL_TOP name in APPL_TOP/admin/ATName.txt

10. Run $FND_TOP/patch/115/bin/txkSetConfig.pl
      Script updates application configuration.
       - Configuring OAMJAVASPACE settings
       - Configuring JDK settings
       - Configuring DISCO settings
       - Configuring XMLParser settings
       - Configuring MOVEJSPPAGEREPOS settings

11. Run $AD_TOP/bin/adgentns.pl
      Generates the entries in to the data model and generatesthe tnsnames.ora
12. Start Configuring templates from all of the product tops
       -

Comments

Popular posts from this blog

SQL Interview Questions on Subqueries

SUB Queries:
1. List the employees working in research department 2. List employees who are located in New York and Chicago
3. Display the department name in which ANALYSTS are working
4. Display employees who are reporting to JONES
5. Display all the employees who are reporting to Jones Manager
6. Display all the managers in SALES and ACCOUNTING department
7. Display all the employee names in Research and Sales Department who are having at least 1 person reporting to them
8. Display all employees who do not have any reportees
9. List employees who are having at least 2 reporting
10. List the department names which are having more than 5 employees
11. List department name having at-least 3 salesman
12. List employees from research and accounting having at-least 2 reporting
13. Display second max salary
14. Display 4th max salary
15. Display 5th max salary  -- Answer for nth Max Salary
Co-Related Subqueries:
16. Write a query to get 4th max salary from EMP table
17. Write a query to get 2nd…

Basics of RDBMS

Data
Small set of information becomes data, this set of information helps make decision. Data is always some useful information.


Database
Place where you store the data. Database represents some aspect of the real world called "miniworld". A database is designed, built and populated with data for a specific purpose. It has intended group of users and some preconceived applications in which these users are interested.

In other words, a database has some source from which data is derived, some degree of interaction with events in the real world and an audience that is actively interested in the contents of the database.

Database can also be defined as collection of one or more tables.

Ex: Mobile, human brain etc



DBMS (Database Management System)
Is a program that stores retrieves and modifies data in the database on request.

Study of different techniques of design, development and maintenance of the database

Types of DBMS
These types are based upon their management of database s…

Answers for SQL Functions

1. SQL> SELECT empno, ename FROM emp WHERE Length(ename) = 4;

2. SQL> SELECT empno, ename, job FROM emp where Length(job)=7;

3. SQL> SELECT Length('qspiders') - Length(replace('qspiders','s','')) FROM dual;

4. SQL>  SELECT empno, ename, job FROM emp WHERE Instr(job,'MAN') >0;

5. SQL> SELECT empno, ename, job FROM emp WHERE Instr(job, 'MAN') =1;

6. SQL> SELECT empno, ename, job FROM emp WHERE (Length(ename) - Length(Replace(ename, 'L',''))) = 1;

7. SQL> SELECT * FROM dept WHERE Instr(dname,'O') > 0;

8. SQL> SELECT Concat(ename,' working as a ') || Concat(job, ' earns ') || Concat(sal, '  in ') || Conc
at('dept ',deptno) AS text from emp;

OR

SQL> SELECT Concat(Concat(Concat(Concat(Concat(Concat(Concat(ename,' working as a '), job),' earns '), sal),'  in '),'dept '), deptno) AS text FROM emp;

9. SQL> SELECT empno, ename…