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/ for Unix

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

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

Follwing are the details after is invoked through

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

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 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/
    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/
      Script updates application configuration.
       - Configuring OAMJAVASPACE settings
       - Configuring JDK settings
       - Configuring DISCO settings
       - Configuring XMLParser settings
       - Configuring MOVEJSPPAGEREPOS settings

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


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…

'Linux-x86_64 Error: 28: No space left on device' While trying to start the database -- Error

SQL> startup mount pfile='/tmp/initdlfasp12.ora'
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device

This as you can see is on Linux x86 with 64 bit processor. We got this error after we changed SGA on 10gR2 database. So was sure that this is something to do with the OS.

Parameters to check for this are shmall.

shmall is the total amount of shared memory, in pages, that the system can use at one time.

$cat /proc/sys/kernel/shmmax

$ getconf PAGE_SIZE

As per Oracle SHMALL should be set to the total amount of physical RAM divided by page size.

Our system has 64GB memory, so change kernel.shmall = 1024 * 1024 * 1024 * 64 / 4096 = 16777216

Once this value is calculated you can modify Linux system configuration file directly.

$ su - root
vi /etc/sysctl.conf file:


# sysctl -p

Once this is done the database was started without any problem.

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;


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…