ORA-01403: no data found / ORA-06512: at "APPS.FND_NET_SERVICES"

We are getting below error when attempting to run autoconfig on DB tier.

Issue:

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_NET_SERVICES", line 877
ORA-06512: at line 1

SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level

Cause:

Table DUAL existed not owned by SYS.

Table DUAL not owned by SYS should not exist as this can cause issues with EBS.

Fix:

Remove table DUAL not owned by SYS

The existence of this can be checked using:

SQL> column OWNER format a15;
SQL> column OBJECT_NAME format a20;
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED from dba_objects where object_name='DUAL';

Ref: (Doc ID 2054876.1)

Interview questions related to cloning in oracle apps

1. What is cloning and why is it required?
Cloning is the process of creating an identical copy of the Oracle application system.
It is required due to following reasons:

• Creating a test copy of your production system before upgrading.
• Moving an existing system to a different machine.
• To test some patches.
• Creating a development copy of your environment to be used by the developers.

2. What is the location of adpreclone.pl in oracle database?
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

3. What is the location of adcfgclone.pl in oracle database?
$ORACLE_HOME/appsutil/clone/bin

4. What is the location of adpreclone.pl in oracle application?
$INST_TOP/admin/scripts

5. What is the location of adcfgclone.pl for applmgr user?
$COMMON_TOP/clone/bin

6. How often do you clone?
Cloning happens weekly or monthly depending on the organization requirement.

7. When do you run adpreclone on Production?
If any changes made to either TechStack,database or any patches applied.

8. When we run perl adpreclone.pl dbTier why it requires apps password?
It requires a database connection to validate apps schema.

9. When we run perl adpreclone.pl appTier why it will not prompt for apps password?
It doesn’t require db a connection.

10. What happens after running adcfgclone.pl?

• It will take inputs and creates xml file.
• After creating xml file,it runs autoconfig.
• It registers the ORALCE_HOME with GLOBAL INVENTORY.

11. What adpreclone.pl does on appsTier?
It will collects all the information about the source system, creates a cloning stage area, and generates templates and drivers. All of these are to reconfigure the instance on a Target machine.

12. What Perl adcfgclone.pl dbTechStack do?

• Create context file
• Register ORACLE_HOME
• Relink ORACLE_HOME
• Configure ORACLE_HOME
• Start SQL*NET listener

13. What Perl adcfgclone.pl dbTier do?

• Create context file.
• Register ORACLE_HOME
• Relink ORACLE_HOME
• Configure ORACLE_HOME
• Recreate controlfile
• Configure database
• Start SQL*NET listener

14. What Perl adcfgclone.pl appsTier do?

• Create context file
• Register ORACLE_HOME
• Relink ORACLE_HOME
• Configure ORACLE_HOME
• Create INST_TOP
• Configure APPL_TOP
• Start Apps Processes.

15. When we run adcfgclone.pl which script it will call?
It will call adclone.pl which is located at $AD_TOP/bin .

16. What are the parameters are mandatory in RMAN DUPLICATE 11g?

• db_file_name_convert
• log_file_name_convert
• diagnostic_dest
• event='12345 trace name context forever, level 33'

17. Does clone preserve the patch history?
Yes, Rapid clone preserves the patch history in following locations:
RDBMS ORACLE_HOME: preserves the OUI oraInventory.
10.1.3 (IAS ORACLE_HOME): preserves the OUI oraInventory
10.1.2 ORACLE_HOME: preserves the patch level and Oracle inventory
APPL_TOP and Database: preserves the patch level and history tables.

How to Rollback an AutoConfig session in oracle apps

Each Autoconfig run of creates a rollback script you can use to revert the previous configuration setting if necessary. The script and all backup configuration files from each Autoconfig session are stored under the below location in database and application.

Application Tier:

$INST_TOP/admin/out/<MMDDhhmm>

Database Tire:

$ORACLE_HOME/appsutil/out/<CONTEXT_NAME>/<MMDDhhmm>

To roll back an AutoConfig sessions, execute the following command:

sh restore.sh

Ref: (Doc ID 387859.1)

How to Make User Run Any Requests Using Standard Manager Except Specific Program Run by Custom Manager?

1) From System Administrator Responsibility navigate to:

 a. Concurrent > Manager > Rule
 b. Create Combined Rule has the following two include lines:
      1. First line: Type: Program
          Application: same application assigned to that specific program
          Name: The name of the program.
      2. Second line: Type: User
           Name: User name

2) From System Administrator Responsibility navigate to:

  a. Concurrent > Manager > Define
  b. Query the custom manager
  c. Include the Combined Rule created to the custom manager Specialization Rule
  d. Exclude the Combined Rule created from the Standard manager Specialization Rule.

3) From System Administrator Responsibility navigate to:

  a. Concurrent >Manager > Administer
  b. Select Internal Manager and click Verify button.
  c. Wait till the verify request completes successfully.
  d. Make sure that the Standard manager and your custom manager are both up.

Ref: (Doc ID 1297419.1)

How to Create a Custom Concurrent Manager in oracle application

Below is the steps to create custom concurrent manager in oracle apps 11i/R12.

1. Navigate to Concurrent----> Manager----> Define.
2. Manager Field: Custom Manager.
3. Short Name: CUSTOM.
4. Type: Concurrent Manager.
5. Program Library: FNDLIBR.
6. Enter desired cache.
7. Work Shifts: Standard.
8. Enter number of Processes.
9. Provide Specialization Rules (you can include or exclude program, id, user, types or combination).
10. Save.
11. Navigate to Concurrent / Manager / Administer.
12. Activate the Custom Manager.

Ref: (Doc ID 170524.1)

Forms are not opening after refresh oracle apps R12.1.3

After instance refresh forms are not opening in Mozilla Firefox 45.0.2. Before instance refresh we are able to open the forms.

Fix:

1. Close the browser and clear the cache.
2. Goto control panel and follow the below steps.

Control Panel > Java > General > Settings (under Temporary Files Settings) and click on "Delete Files".

FRM-92050 failed to connect to Server /forms/servlet -1 Applet

We got the error "FRM-92050 failed to connect to Server /forms/servlet -1" while opening the form in oracle apps R12.

Fix:

Please use the below steps if you face this issue.

MSIE 8 --->Tools > Internet Options >
Security Settings -->Custom Level >
Scroll down to entry "Enable XSS Filter" > Select Disable XSS Filter button.

Difference between Local Inventory and Global Inventory in oracle

oraInventory:
The Orainventory is the location for the OUI's Book keeping the inventory stores information about.

*) All the Oracle software products installed on all ORACLE_HOMES on a machine
*) Other non-oracle products such as Java Runtime env's (JRE)


Global Inventory:
Global Inventory holds the information about Oracle Products on a Instance, The inventory contains the high level list of all oracle products installed on a machine such as ORACLE_HOMES or JRE.

There should be only one per machine. Its locations is defined in the oraInst.loc in /etc (on Linux) or /var/opt/oracle (solaris).

Local Inventory:
Inventory inside each Oracle Home is called as local Inventory or ORACLE_HOME Inventory. This Inventory holds information to that ORACLE_HOME only.

What to do if my Global Inventory is corrupted?
If your global Inventory is corrupted, you can recreate global Inventory on machine using Universal Installer and attach already Installed oracle home by option

-attachHome

./runInstaller -silent -attachHome -invPtrLoc $location_to_oraInst.loc ORACLE_HOME=Oracle_Home_Location ORACLE_HOME_NAME=Oracle_Home_Name CLUSTER_NODES={}

What is the difference between adcfgclone.pl and autoconfig?

Running "adcfgclone.pl" script will do the following steps:

*) This script performs the target clone configuration.
*) Run OS utility check (check if "make, cc, ld and ar" executable's are available in the PATH)
*) Create the target context file from the value entered (or reads the value from the context file if     passed to the script)
*) Instantiate all the templates created during the preclone.
*) Re-link ORACLE_HOMEs.
*) Create the database control files (for the database tier only).
*) Run AutoConfig.

adconfig.pl
This script runs AutoConfig tool to reconfigure the APPL_TOP and the Database ORACLE_HOME.

FNDCPASS interview questions in oracle apps

1. What is FNDCPASS?
FNDCPASS is a utility for changing the password of user,system and oracle.

USER (sysadmin and  all apps related users passwords):
FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN oracle

SYSTEM (apps,applsys & applsyspub users):
FNDCPASS apps/apps 0 Y system/manager SYSTEM applsys oracle

ORACLE (All 256 modules passwords will be change):
FNDCPASS apps/apps 0 Y system/manager ORACLE INV INV

2. What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ? 
0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
'0' is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form).
'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

3. Difference between apps, applsys and applsyspub?
Apps: is a schema which does not contain any tables of itself. We can say APPS is the shared runtime schema for all E-Business Suite products. It contains all the synonyms of all the table in Oracle apps. But it also contains packages, functions, procedures. The default password is apps.

Applsys schema contains all the tables required for administarative purpose. The default password is apps. All the technical products, database objects are consolidated into a single schema called Applsys.

Applsyspub schema is responsible for password checking. The default password is pub. Applsyspub is used for authentication by having read only views.

4. Where apps password location in oracle apps 11i?
In 11i you might have seen couple of files had apps password without encrypted form.
*) IAS_TOP/Apache/modplsql/cfg/wdbsvr.app
(Mod plsql Configuration File)
*)  ORACLE_HOME/reports60/server/CGIcmd.dat
(Reports Configuration File)

5.File Which is having applsyspub & Guest user password. 
$FND_TOP/secure/SID.dbc

autoconfig interview questions in oracle apps

1.What is autoconfig?
Autoconfig is a configuration tool that simplifies & Standadize configuration management tasks on oracle application environment.
*) adautocfg.sh internally call two scripts (adconfig.sh & adconfig.pl) ($AD_TOP/bin)

2. What are the parameter autoconfig will ask for?
Context file name and apps password

3. What is context file?
Context file is a central repository, which stores all application configuration information. The name is like _ .xml

4. How you will find autoconfig is enabled/not for u r applications?
a) Open any env / configuration files, the first few lines will tell u that these files are maintained by autoconfig.
b) If contextname.xml file is there in APPL_TOP/admin

5. How autoconfig will create env and configuration files?
Autoconfig will go to each and every top template directory take the templates from there and fill the values from xml file and create the required files.

6. In how many phases autoconfig will run?
*) NSTE8 - Instantiates AutoConfig template files to the AutoConfig configuration files specified in the relevant template driver files.
*) INSTE8_SETUP - Executes setup scripts that carry out activities not involving connection to the database.
*) INSTE8_PROFILE - Executes setup scripts that update profile options.
*) INSTE8_APPLY - Executes setup scripts that carry out activities involving updates to the database.

7. What is the location of adconfig log file?
$APPL_TOP/admin/log/

8. Is it possible to restore a autoconfig run?
Partially. Adconfig will create a restore script at $APPL_TOP/admin//out/. This restore.sh will copy the backed up files before autoconfig run to its original locations. But the profile values updated in the database can’t be restored back.

9. How to run autoconfig in test mode?
adchkcfg.sh script at AD_TOP/bin. This script will run autoconfig in test
mode and create the difference file which tells us what is going to change, when u actually run autoconfig.

10. How to find autoconfig is enabled or not for database?
If we have appsutil directory under RDBMS_ORACLE_HOME.

How to change the apps password in oracle apps R12.2.4

Below steps to change the apps password in oracle apps R12.2.4

1. Shut down the application tier services
$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password.
FNDCPASS apps/<existing apps passwd>  0 Y system/<system password> SYSTEM APPLSYS <new apps passwd>

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS newpasswd

3. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh
Note:Don't start any other application tier services.

4. Change the "apps" password in WLS Datasource as follows:

Log in to WLS Administration Console. (http:/krishna.appsdba.com:7002/console)
Click Lock & Edit in Change Center.
In the Domain Structure tree, expand Services, then select Data Sources.
On the "Summary of JDBC Data Sources" page, select EBSDataSource.
On the "Settings for EBSDataSource" page, select the Connection Pool tab.
Enter the new password in the "Password" field.
Enter the new password in the "Confirm Password" field.
Click Save.

5. Check whether you are able to connect to db using apps
sqlplus apps/<newpassword>

6. Before Starting all the services. Run Autoconfig.
cd $ADMIN_SCRIPTS_HOME
sh adautocfg.sh

7. Now start all the services on application tier.
$INST_TOP/admin/scripts/
sh adstrtal.sh

Note: These steps must be carried out on the run file system.

Project Costing Request Set is failing APP-FND-00806

Issue:

We are getting below error while submitting Request set in oracle apps.

APP-FND-00806: The default value SELECT APPLICATION_NAM
FROM FND_APPLICATION_VL WHERE APPLICATION_ID = $FLEX$ in
invalid for the Source Application segment. Your default
value will be ignored. Please inform your system
administrator that.

Fix:

To implement the solution, please execute the following steps:

1. Logon to the Application using your "System Administrator    Responsibility"
2. Navigate to "Concurrent Set"
3. Query and find your request set
4. Select the Link Stages button
5. Set the Start Stage field.
   Select LOV ==> select the correct process
6. Select Save.
7. Retest the issue.

Ref: (Doc ID 2030023.1)

APP-FND-00706: Routine FDFAVS3: : Detected a data error

Issue:

We are getting below error while submitting the concurrent request in oracle apps 11i.

Fix:

The Developer Test Mode diagnostics is not intended to be enabled except for specific cases or if instructed by Oracle Support. The solution is to set the profile option value to 'No' or to remove the value so that the default of 'No' will be picked at runtime.

1. Change the "FND: Developer Mode" profile value to 'No'.
2. Log out and back into the application.

Ref: (Doc ID 415165.1) & (Doc ID 400735.1)

Log files location in oracle apps 11i, R12.1 and R12.2

Log files location in oracle apps 11i:

Start/Stop script log files location:
$COMMON_TOP/admin/log/CONTEXT_NAME/

OPMN log file location:
$ORACLE_HOME/opmn/logs/ipm.log

Apache, Jserv, JVM log files locations:
$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log
$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_request_log
$IAS_ORACLE_HOME/Apache/Apache/logs/access_log
$IAS_ORACLE_HOME/Apache/Apache/logs/error_log
$IAS_ORACLE_HOME/Apache/JServ/logs

Concurrent log file location:
$APPL_TOP/admin/PROD/log or $APPLLOG/$APPLCSF

Patch log file location:
$APPL_TOP/admin/PROD/log

Worker Log file location:
$APPL_TOP/admin/PROD/log

AutoConfig log files location:
Application Tier:
$APPL_TOP/admin/SID_Hostname/log//DDMMTime/adconfig.log

Database Tier:
$ORACLE_HOME/appsutil/log/SID_Hostname/DDMMTime/adconfig.log

Error log file location:
Application Tier:
$APPL_TOP/admin/PROD/log

Database Tier :
$ORACLE_HOME/appsutil/log/SID_Hostname


In R12, the log files are located in $LOG_HOME (which translates to $INST_TOP/logs):

Concurrent logs location:
$LOG_HOME/appl/conc - > location for concurrent requests log and out files
$LOG_HOME/appl/admin - > location for mid tier startup scripts log files

Apache Logs (10.1.3 Oracle Home which is equivalent to iAS Oracle Home - Apache, OC4J and OPMN):
$LOG_HOME/ora/10.1.3/Apache - > Location for Apache Error and Access log files
$LOG_HOME/ora/10.1.3/j2ee - > location for j2ee related log files
$LOG_HOME/ora/10.1.3/opmn - > location for opmn related log files

Forms & Reports related logs (10.1.2 Oracle home which is equivalent to 806 Oracle Home)
$LOG_HOME/ora/10.1.2/forms
$LOG_HOME/ora/10.1.2/reports

Startup/Shutdown Log files location:
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

Patch log files location:
$APPL_TOP/admin/$SID/log/

Clone and AutoConfig log files location:
Database tier: 
RDBMS $ORACLE_HOME/appsutil/log/< context >/StageDBTier_< timestamp >.log

Application tier:
$INST_TOP/admin/log/StageAppsTier_< timestamp >.log

Where the logs for the admkappsutil.pl are located? 
$INST_TOP/admin/log/MakeAppsUtil_< timestamp >.log


Log files location in R12.2:

Log files of Online patching (adop) in EBS R12.2:

The adop log files are located on the non-editioned file system (fs_ne), under:
$NE_BASE/EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log

This log directory will contain patch logs, patch lgi and patch worker logs.
adop(phase=fs_clone) Online pathcing filesystem cloning process related log files are found under:
$INST_TOP/admin/log

Autoconfig log files location:
Applicaion Tier:
$INST_TOP/admin/log/<MMDDhhmm>

Database Tier: 
$ORACLE_HOME/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm>

Log files for start/stop of services from $ADMIN_SCRIPTS_HOME:
In below directory we will find log files related to start/stop process of oacore, forms, apache, opmn,
weblogic admin server/node manager:

$LOG_HOME/appl/admin/log

Log/Out files for Concurrent programs/managers location:
Log files: $APPLCSF/$APPLLOG (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/log)
Out files: $APPLCSF/$APPLOUT (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/out)

OPMN and OHS processes log file location:
Below directory contains log files related OPMN process(opmn.log),
OPMN Debug logs(debug.log), HTTP Transaction logs (access.log),security settings related logs.

$IAS_ORACLE_HOME/instances/<ohs_instance>/diagnostics/logs


Node Manager log file location in R12.2:
Log file is generated by Node Manager and contains data for all domains that
are controlled by Node Manager on a given physical machine.

$FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log

Weblogic log files location:
Initial settings for AdminServer and Domain level information is written in this log file.

$EBS_DOMAIN_HOME/sysman/log

Log files for server processes initiated through Weblogic in Oracle R12.2.4 are in below location:
Stdout and stderr messages generated by the forms, oafm and oacore services are located
at NOTICE severity level or higher are written by Weblogic Node Manager to below directory.

$EBS_DOMAIN_HOME/servers/<server_name>/logs/<server_name>.out

R12 - Logon is not working, no error message is shown

After the clone of an E-Business Suite Instance, the logon was not working as expected on the target Instance.

Fix:

To implement the solution, please execute the following steps :

1. Open a new Shell and source the APPS User Environment.

2. Change into the $FND_TOP Patch directory.
cd $FND_TOP/patch/115/bin

3. Compile the JSP files using following command :
perl ojspCompile.pl --compile --flush -p2

4. Initiate the execution of Autoconfig on the DB- and the APPS_Tier(s)

5. Start the APPS-Tier(s) Services again and re-test the logon.

Ref: (Doc ID 435550.1)

Adop Phase=prepare Failed After Creating the Custom Application

Issue:

The adop phase=prepare failed with error.  The unexpected error occurred while executing txkADOPPreparePhaseSynchronize.pl.

In txkADOPPreparePhaseSynchronize log file
=============================
Inside evalADPATCHStatus()...
=============================
message_status: ERROR
Adsplice action did not go through successfully.
*******FATAL ERROR*******
PROGRAM : (//EBSDEV/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
FUNCTION: main::execADSPLICE [ Level 1 ]
ERRORMSG: Adsplice action did not go through successfully.

Fix:

Please run the following steps.
1. adop phase=abort,cleanup cleanup_mode=full (as env is currently in prepare failed state after     adsplice was run on Run FS).
2. adop phase=fs_clone
3. adop phase=prepare

Ref: (Doc ID 1966527.1)

Creating a Custom Application in Oracle E-Business Suite Release 12.2

Section 1: Create A Custom Application Using adsplice:

1. Download Patch 3636980 "Support Diagnostics (IZU) patch for AD Splice" from My Oracle Support.

2. Manually copy the three .txt files from the 3636980\izu\admin directory to your own temporary directory.

3. Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will be using "xxmzprod.txt".

4. Rename izterr.txt to <CUSTOM MODULE>terr.txt. In this example, we will be using "xxmzterr.txt".

5. Open newprods.txt in a text editor.
a) Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (i.e. keep the case sensitivity).

6. Open xxmzprod.txt in a text editor.
a) Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (keeping the case sensitivity).
b) Change all references to prodid 278 to your own application ID.

7.Open xxmzterr.txt in a text editor.
a) Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (keeping the case sensitivity).
b) Change the text "Oracle_Support_Diagnostic_Tools" to be "xxmz_custom_app".

8. Copy the following text files to the $APPL_TOP/admin directory:
a) xxmzprod.txt
b) xxmzterr.txt
c) newprods.txt

9. Change directory to the admin directory under $APPL_TOP

10. Run AD Splice

AD Splice must be run from the admin directory under APPL_TOP, and is invoked by running the command:
$ adsplice

When prompted for the following, you can press Enter to accept the default location:
Enter the directory where your AD Splicer control file is located.
The default directory is [/oracle/VIS/apps/apps_st/appl/admin] :
When prompted for the following, you can press Enter to accept the default filename:
Please enter the name of your AD Splicer control file [newprods.txt] :
When prompted for the following, you can press Enter to accept the default value and regenerate the environment file:
Do you wish to regenerate your environment file [Yes] ?
AutoConfig will be run automatically as part of this procedure.

11. Review the AD Splice log file to ensure the procedure completed successfully.

12. Review the AutoConfig log file to ensure the procedure completed successfully.

Section 2: Verify Creation of Custom Product in the Database:

1. SQL>select * from fnd_application where application_short_name = 'XXMZ';
2. SQL>select * from fnd_product_installations where APPLICATION_ID = 50201;
3. SQL>select * from dba_users where username = 'XXMZ';
4. $ env | grep XXMZ
5. $ ls $XXMZ_TOP (admin log mesg out sql)

Section 3: Perform Required Steps on Application Tier Nodes:

1. For shared APPL_TOP installations, simply run AutoConfig for the remaining nodes (there is no     need to rerun AD Splice). Or, if the APPL_TOP is not shared, repeat       Steps 8 to 12 in Section 1 on all the other nodes.
2. Restart the application tier services.
3. Test operation thoroughly to confirm the effect of your changes.

Section 4: Create Custom Objects:

1. SQL>grant all privileges on myTable to apps;
2. SQL>create synonym myTable for XXMZ.myTable;>

Section 5: Propagate Changes to Other File System:

When you start the next online patching cycle, the prepare phase will run AD Splice sync-up actions to synchronize the two file systems.
If the AD Splice sync-up fails when the prepare phase is run, check the $APPL_TOP/admin/$TWO_TASK/log/adsplicelog log file for the following:

SQL: UPDATE FND_ORACLE_USERID SET READ_ONLY_FLAG = 'A' WHERE ORACLE_ID;

Section 6: Known Issues:

The following are currently known issues:

If you are an upgrade customer with a custom product top in the context file, but have not run AD Splice, you must:

1. Remove the relevant entry from the FND_OAM_CONTEXT_CUSTOM table.
   a) Run AutoConfig on all nodes.
   b) Apply the latest AD-TXK release update pack as needed.
   c) Run AD Splice to add/register the custom product.

2. A custom schema abbreviation cannot exceed eight characters. If you have any custom context variables with more than eight characters, you must take the same    actions for the above known issue (custom product top in context file).

3. If you have custom product tops from an older release, the FND_OAM_CONTEXT_CUSTOM table will have entries for them. If you do not want those custom product tops,    remove the entries from the FND_OAM_CONTEXT_CUSTOM table and then run AutoConfig.

Section 7: References:

For more information about AD Splice and patching operations in Oracle E-Business Suite Release 12.2, see:
1. Oracle E-Business Suite Setup Guide, Part No. E22953
2. Oracle E-Business Suite Maintenance Guide, Part No. E22954

Ref: (Doc ID 1577707.1)

Upgrade interview questions oracle database

1. Oracle database upgrade from version to version.
* Direct upgrade to Oracle 10g is only supported if your database is running one of the following releases: 8.0.6, 8.1.7, 9.0.1, or 9.2.0. If not, you will have to upgrade the database to one of these releases or use a different upgrade option (like export/ import).
* Direct upgrades to 11g are possible from existing databases with versions 9.2.0.4+, 10.1.0.2+ or 10.2.0.1+. Upgrades from other versions are supported only via intermediate upgrades to a supported upgrade version.

2. What is rolling upgrade?
It is a new ASM feature from Database 11g.ASM instances in Oracle database 11g release(from 11.1) can be upgraded or patched using rolling upgrade feature. This enables us to patch or upgrade ASM nodes in a clustered environment without affecting database availability.During a rolling upgrade we can maintain a functional cluster while one or more of the nodes in the cluster are running in different software versions.Rolling upgrade can be used only for Oracle database 11g releases(from 11.1).

3.Steps to Upgrade in Oracle ?
Manual upgrade which involves the following steps:
* Backup the database.
* In UNIX/Linux environments, set the $ORACLE_HOME and $PATH variables to point to the new    11g Oracle home.
* Analyze the existing instance using the "$ORACLE_HOME/rdbms/admin/utlu111i.sql" script.
* Start the original database using the STARTUP UPGRADE command and proceed with the     upgrade by running the "$ORACLE_HOME/rdbms/admin/catupgrd.sql" script.
* Recompile invalid objects.
* Restart the database.
* Run the "$ORACLE_HOME/rdbms/admin/utlu111s.sql" script and check the result of the upgrade.
* Troubleshoot any issues or abort the upgrade.

4. What happens when you give "STARTUP UPGRADE"?
$sqlplus "/as sysdba"
SQL> STARTUP UPGRADE

Note: The UPGRADE keyword enables you to open a database based on an earlier Oracle Database release. It also restricts logons to AS SYSDBAsessions, disables system triggers, and performs additional operations that prepare the environment for the upgrade.
You might be required to use the PFILE option to specify the location of your initialization parameter file.
Once the database is started in upgrade mode, only queries on fixed views execute without errors until after the catupgrd.sql script is run. Before running catupgrd.sql, queries on any other view or the use of PL/SQL returns an error.

5.What is the difference between startup Upgrade and Migrate ?
STARTUP MIGRATE:
Used to upgrade a database till 9i.

STARTUP UPGRADE:
From 10G  we are using startup upgrade to upgrade database.

6. What happens internally when you use startup upgrade/migrate?
It will adjust few database (init) parameters (irrespective of what you have defined) automatically to certain values in order to run upgrade scripts smoothly.
In other way,it will issue few alter statements to set certain parameters which are required to complete the upgrade scripts without any issues.

Opatch interview questions in oracle database

1. What is Opactch in Oracle?
The Opatch utility is a tool that allows the application and rollback of interim patches to Oracle products. This chapter provides information on using Opatch to apply patches.

2. Opatch options and description?
* apply: Installs an interim patch. Refer to "apply Command" for more information.
* napply:  Installs n number of patches (hence napply). Refer to "napply Command" for more     information.
* auto: Applies Oracle Clusterware patches. Refer to "auto Command" for more information.
* lsinventory: Lists what is currently installed on the system. Refer to "lsinventory Command" for more information.
* query: Queries a given patch for specific details. Refer to "query Command" for more information.
* rollback: Removes an interim patch. Refer to "rollback Command" for more information.
* version: Prints the current version of the patch tool. Refer to "version Command" for more information.

3. What are the features of opatch?
* Scalability: Opatch is scalable to support a large number of patches.
* Reliability: Opatch is reliable and protects the Oracle home and inventory. It can bring back the Oracle home to a stable state from patch application failures. It can also easily detect patch conflicts.
* Availability: Opatch's online patching improves system availability by allowing database patches   to be applied without needing to shut down databases.
* Portability: Opatch is compatible with all operating systems for which Oracle releases software.
* Robust: Opatch is very robust. It is very easy to apply a patch as well as remove it.
* Easy to maintain: Opatch is easy to maintain and is also extensible.
* Support for Silent Operation: Opatch supports silent operation. This mode allows you to run the software without any user interaction.
* Support for Real Application Clusters: Opatch supports RAC and works well in that setup. It is easy to extend it to Enterprise Manager Grid   Control.
* Easy to debug: Opatch has various levels of logging and tracing mechanisms. It also has a debug option that helps to easily diagnose software problems.

Opatch supports the following tasks:
Applying an interim patch.
Rolling back the application of an interim patch.
Detecting a conflict when applying an interim patch after previous interim patches have been applied. It also suggests the best options to resolve a conflict.
Reporting on installed products and interim patches.

4. What is CPU patch?
Critical Patch Update (CPU) - Release of security fixes each quarter instead the cumulative database security patch for the quarter.

5. What is PSU patch?
Patch Set Updates (PSU) - Cumulative patches that include both the security fixes and priority fixes. They are "version upgrades" modifying the las number of version (11.2.0.1.1, 11.2.0.1.2,...).

6. What is SPU patch?
Security Patch Update (SPU) - It is the new terminology of CPU (From October 2012) . SPU's can't be applied if any PSU's have been applied, unless your database is upgraded with a new base version.

7. In which months oracle release CPU patches?
JAN, APR, JUL, OCT

8. When we applying single Patch, can you use opatch utility?
Yes, we can use Opatch incase of single patch. The only type of patch that can't be used with OPatch is a patchset.

9. Is it possible to apply OPATCH without downtime?
As you know for apply patch your database and listener must be down. When you apply OPTACH it will update your current ORACLE_HOME. Thus coming to your question to the point in fact it is not possible without or zero downtime in case of single instance but in RAC you can Apply Opatch without downtime as there will be more separate ORACLE_HOME and more separate instances (running once instance on each ORACLE_HOME).

10. You have collection of patch (nearly 100 patches) or patchset. How can you apply only one patch from it?
With Napply itself (by providing patch location and specific patch id) you can apply only one patch from a collection of extracted patch. For more information check the opatch util NApply –help. It will give you clear picture.
For Example:
opatch util napply <patch_location> -id 9 -skip_subset -skip_duplicate
This will apply only the patch id 9 from the patch location and will skip duplicate and subset of patch installed in your ORACLE_HOME.

11. How to Apply Opatch in Oracle?
* You MUST read the Readme.txt file included in opatch file, look for any prereq. steps/ post installation steps or and DB related changes. Also, make sure that you have the correct opatch version required by this patch.
* Make sure you have a good backup of database.
* Make a note of all Invalid objects in the database prior to the patch.
* Shutdown All the Oracle Processes running from that Oracle Home , including the Listener and Database instance, Management agent etc.
* You MUST Backup your oracle Home and Inventory
  tar -cvf $ORACLE_HOME $ORACLE_HOME/oraInventory | gzip > Backup_Software_Version.tar.gz
* Unzip the patch in $ORACLE_HOME/patches
* cd to the patch direcory and do opatch -apply to apply the patch.
* Read the output/log file to make sure there were no errors.
* Log file location : /d02/oracle/ebs12/db/tech_st/11.2.0.3.0/cfgtoollogs/opatch/opatch2016-03-30_21-41-45PM_1.log

12. Oracle version 11.2.0.1.0 what does each number refers to?
  Oracle version number refers:
  11 - Major database release number
   2 - Database Maintenance release number
   0 - Application server release number
   1 - Component Specific release number
   0 - Platform specific release number