Saturday, January 20, 2007

Interview Questions

Many friends and collegues preparing for an interview asks me lot of questions while preparing for interview so thought of adding quality questions to our site, I am writing them here with the best answer I could think of, may be you can come up with better reply.. Lets make an attempt for Apps DBA's looking for better option to shape their future for their Dreams.

What is the difference between different releases of Oracle Applications like 11i7,11i8,11i9,11i10.?
Every new release has their own new functionality and fix of bugs in earlier version. This is what I observed while working on different releases. If you find one do share to let this help our folks. Tech stack that comes with fresh installation is as follows

11i Release Versions

Product11.5.711.5.811.5.911.5.10
Database Server 8.1.7.38.1.7.49.2.0.39.2.0.5
Forms Patchset991215
Reports991215





Client Tier



Jinitiator1.1.8.161.1.8.161.1.8.161.3.1.18





Web ServerApache 1.3.19Apache 1.3.19Apache 1.3.19Apache 1.3.19
Jserv1.1.21.1.21.1.21.1.2
JRE1.1.81.1.81.1.81.4.2_04-b05
JDK1.3.1_021.3.1_021.3.1_021.4.2
Self Service Framework5.5.2.E5.6E5.7H5.1O
Discoverer4.1.41 4.1.414.1.464.1.48
Portal3.0.9.8.13.0.9.8.13.0.9.8.43.0.9.8.4

11.5.7

  • Autoconfig enabled. Prior to this release, manual changes to all the configuration files were required.

In 11.5.10

  • we do not have APPS_MRC schema as such, now its functionalities are maintained in the product based schemas.

  • It comes with AD.I, so maintenance mode feature comes with it. This feature is used for optimal performance and reduces downtime while applying patch as it shuts down Workflow business event system and sets function security thereby Apps functions are not available to users.

  • OATM(Oracle Applications Tablespace Migration )

  • AutoConfig Integration with AutoPatch- AutoPatch automatically calls AutoConfig to instantiate and run new templates contained in a patch. When AutoPatch is run in test mode, AutoConfig
    also runs in test mode

Friday, January 19, 2007

Log files location

Log files and their location

Installation Log file
Cloning Log file
Autoconfig log files
Rolling back autoconfig configuration files
Apache/Jserv configuration files
Apache/Jserv Logs
Forms Server
Adodfcmp
fdfcmp/fndfvgn/gndmdgen
User Exits
Concurrent Manager
Internal Manager
Concurrent Program logs
Sql*net, net8 listener
ssp5(iProcurement)

Installation Log file
Database log files $ORACLE_HOME/appsutil/log/CONTEXT_NAME/
Applications log files $APPL_TOP/admin/CONTEXT_NAME/log/

Cloning Log file
perl adcfgclone.pl dbTier $ORACLE_HOME(9i)/appsutil/log/CONTEXT_NAME/ApplyDBTier_TIMESTAMP.log
perl adcfgclone.pl appsTier $APPL_TOP/admin/CONTEXT_NAME/log/ApplyAppsTier_TIMESTAMP.log

Autoconfig log files
Application Tier $APPL_TOP>/admin/CONTEXT_NAME/log/MMDDhhmm
Database Tier $/appsutil/log/CONTEXT_NAME/mmddhhmm

Rolling back autoconfig configuration files
Application Tier $APPL_TOP/admin//out/
Database Tier $ORACLE_HOME/appsutil/out//

Apache/Jserv configuration files
jserv.properties $APACHE_TOP/Jserv/etc/
jserv.conf $APACHE_TOP/Jserv/etc/
zone.properties $APACHE_TOP/Jserv/etc/
httpd.conf $APACHE_TOP/Apache/conf/
httpds.conf $APACHE_TOP/Apache/conf/
oracle_apache.conf $APACHE_TOP/Apache/conf/
apps.conf $APACHE_TOP/Apache/conf/

Apache/Jserv Logs
error_log $APACHE_TOP/Apache/logs/
access_log $APACHE_TOP/Apache/logs/
mod_jserv.log $APACHE_TOP/Jserv/logs/
jserv.log $APACHE_TOP/Jserv/logs/

Forms Server
When starting forms server we can specify a log file name.
Examples:
WIN/NT
f60srv32 log=c:\temp\f60srv.log
Unix
f60ctl start log=/temp/f60srv.log
f45ctl start port=9000 log=/temp/forms.log

Adodfcmp
adodfcmp.log $/admin/odf/
or
$PROD_TOP/patch//odf/

fdfcmp/fndfvgn/gndmdgen
L.req $APPL_TOP/admin or $APPL_TOP/install/log,

User Exits
userexit.log User exits from forms generate log file under directory from where the forms server is
started if variable FDUDEBUG is set to ON

Concurrent Manager
Concurrent Manager w.mgr Two methods to see concurrent manager logs
Directly from Oracle Applications:
System Administrator responsability
Navigator: Concurrent =>
Requests,
choose a request ...
menu: Special => Manager Log
OR

Navigator: Concurrent =>
Manager => Administer,
button Processes (Concurrent Processes window)
=> button Manager Log

Retrieve Manager log files under:
$FND_TOP/$APPLLOG
or if you have defined common directory :
$APPLCSF/$APPLLOG

Internal Manager
Internal Manager .mgr
(mgrname which figures
in startmgr file is 'std' by
default) Two methods to see internal manager log:
Directly from Oracle Applications:
System Administrator responsability
Navigator:
Concurrent =>
Manager =>
Administer, button Processes (Concurrent Processes window) =>
button Internal Manager Log

Retrieve Internal Manager log file under:
$FND_TOP/$APPLLOG
or if you have defined common directory :
$APPLCSF/$APPLLOG

Concurrent Program logs
Concurrent Program logs l.req Two methods to see concurrent program logs:

Directly from Oracle Applications:
System Administrator responsability (for own and other users requests) :
Navigator: Concurrent =>
Requests, button View Log...

Other responsabilities (for own requests), menus could be different:
Navigator: Requests, button View Log...
Navigator: Other => Requests, button View Log...
Navigator: Other => Requests => View, button View Log...
Navigator: Control => Requests => View, button View Log...

Retrieve Concurrent Program log files under:
$PROD_TOP/$APPLLOG
or if you have defined common directory :
$APPLCSF/$APPLLOG


Sql*net, net8 listener
You can specify LOG_DIRECTORY_ and LOG_FILE_ specific values for theses parameters
in listener.ora. You can set LOG_FILE and TRACE_FILE variables from a lsnrctl session.
There are also LOG_DIRECTORY_SERVER and LOG_FILE_SERVER parameters in sqlnet.ora.

ssp5(iProcurement)
Apache and Jserv logs are useful to check for iProcurement (SSP5), you can also
add these lines in ssp_init.txt (should be under $ORACLE_HOME/Apache/Jserv/etc)
to generate specific SSP5 log file:

DebugOutput=Directory(preferably under $APACHE_TOP/logs)
DebugLevel=5
DebugSwitch=ON

Tuesday, January 16, 2007

OID - Oracle Internet Directory

In this writing, I will tell you about OID - acronym for Oracle Internet Directory. Guys, it is a bit tough and confusing in understanding OID in the start but once OID is understood its a childs play. Oracle does have complex products and OID is one of them but I bet it is the best among the LDAP implementations.

Let us share our views about OID first as FAQs. We will then look into the configuration of 10g and then 9i (I dont give preference in configuring the older versions but dont worry we will have writing on that too - ;) )

1. What is OID ?

OID is a LDAP implementation by Oracle Corporation. It is more than a just mere LDAP server. It can store all the user details, organization details and object details in some cases. It can be used via standard LDAP commands like ldapsearch, ldapadd to search the entities within it.

Oracle always goes with the Standards as it did with OID. Oracle Internet Directory helps in better organization of data and the resources. It can be implemented in an organization as a single source of truth.

Other major competitors to OID are Microsoft's Active Directory, Sun's SunOne Directory and others.

2. Whats the use of OID ?

When a company needs a database which holds all the user information and can act as a single source of truth, LDAP can be implemented. OID is the best choice as it is very easy to configure, manage and work.

3. Why only OID ?

i) OID is built as a hierarchical tree which is easy to understand and navigate.

ii) OID is created in Java from scratch. So, can run on any of the platforms with same look and feel.

iii) OID data is stored in Oracle database and due to the fact of Oracle Database capabilities, it can handle enormous amounts of data,

iv) OID can retrieve data within seconds due to enterprise search inbuilt in the database.

v) OID can be integrated with any other LDAP implementations and also can be implemented with any of the Oracle Applications seemlessly.

vi) OID can be managed locally as well as remotely i.e., via both Web and also via a client software.

4. How can I install OID (or) from where do I start from ?

There is a catch here.

For Oracle 9i:

OID (both server and client software) by default comes with Oracle Database 9i Enterprise Software disks. We need to choose Enterprise option while installing OID or choose Custom select OID.

Oracle 10g (9.0.4 and above):

From Oracle 10g (9.0.4 and above versions are called 10g versions), OID server is no longer shipped with Database instead it is shipped with 10g iAS.
When we install Oracle 10g database, we do get a directory called ldap but they are only supporting files for LDAP i.e., we get the JAR files to launch the Swing UI - the local client (Swing UI) thait s shipped with Oracle 10g database software disks. We dont get the OID server with 10g Database disks.

In order to install OID 10g, we need to install from 10g iAS CDs.

5. I have Oracle 10g IAS CDs and trying to install OID. Which option do I choose for installing OID ?

We need to choose OracleAS Infrastructure 10g option and choose Identity Management and Metadata repository inorder to install the OID server.

6. Which port does OID run at ?

OID runs at two ports by default : non-SSL : 389 and SSL : 636


Hang on, still some more of the questions .. coming on your way.

Apps Unlimited - Easy to Define .. Easy to Learn. What say ? :)