Why 0 "Zero" in FNDCPASS?Lets Use 60 or 50.

I heard many times from people 0 Y is the mandatory in FNDCPASS/FNDLOAD and WFLOAD and i thought of writing this post to clear doubts  " ".

Default Priority for Concurrent Manager is 50.
Lowest Priority for Concurrent Manager is 99.
Highest Priority for Concurrent Manager is 0.

Lets do it practically
================
[applvision@apps ~]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 8 02:25:17 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
[applvision@apps ~]$ sqlplus system/manager

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 8 02:25:35 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
[applvision@apps ~]$ FNDCPASS apps/apps 60 Y system/manager SYSTEM APPLSYS welcome123
Log filename : L407423.log


Report filename : O407423.out
[applvision@apps ~]$ cat L407423.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module:
+---------------------------------------------------------------------------+

Current system time is 08-NOV-2013 02:27:13

+---------------------------------------------------------------------------+

Working...


+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 08-NOV-2013 02:27:15

+---------------------------------------------------------------------------+
[applvision@apps ~]$ sqlplus apps/welcome123

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 8 02:27:32 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "APPS"
SQL>

Note * :-

 From above practically hence it has been proved that "0" is the priority which can be change.

But it always best practice to use  "Oracle defaults"

You are hotbackup is running and suddenly database crashed/Someone killed pmon process then what will happen to database?

Terminal 1
=======
SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             436208356 bytes
Database Buffers          620756992 bytes
Redo Buffers               13049856 bytes
Database mounted.
Database opened.

SQL> alter database begin backup;

Database altered.

SQL>  select count(*),status from v$backup group by status;

  COUNT(*) STATUS
---------- ------------------
        44 ACTIVE

CREATE TABLE Persons
(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
  8  );

Table created.

SQL> !date
Fri Nov  8 02:13:33 IST 2013

SQL>
SQL> exit
ERROR:
ORA-03135: connection lost contact
Process ID: 0
Session ID: 400 Serial number: 7

Terminal 2
=======
[dbvision@apps ~]$ ps -fu $LOGNAME|grep -i pmon
dbvision  5448     1  0 01:55 ?        00:00:00 ora_pmon_vision
dbvision  5968  5931  0 02:11 pts/3    00:00:00 grep -i pmon
[dbvision@apps ~]$ kill -9 5448
[dbvision@apps ~]$ ps -fu $LOGNAME|grep -i pmon
dbvision  6025  5931  0 02:13 pts/3    00:00:00 grep -i pmon
[dbvision@apps ~]$ date
Fri Nov  8 02:14:02 IST 2013
[dbvision@apps ~]$


Starting the database after crashed
========================
SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             436208356 bytes
Database Buffers          620756992 bytes
Redo Buffers               13049856 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '/db/vision/db/apps_st/data/system01.dbf'


SQL>  select count(*),status from v$backup group by status;

  COUNT(*) STATUS
---------- ------------------
        44 ACTIVE

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> alter database end backup;

Database altered.

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> 1date
SP2-0042: unknown command "1date" - rest of line ignored.
SQL> !date
Fri Nov  8 02:16:38 IST 2013

SQL>

How to apply a patch to a Shared APPL_TOP or Apps Tier File System environment?

How To Apply Patches On Shared Application Tier File System Environment (Doc ID 745580.1). There are 2 sets of of TIER values in the context file. One set is controlling services on the node and one set is controlling the AD utilities.  In a shared application tier environment the following context values should all be set to yes....  [applvision@apps log]$ egrep -i 's_isAdAdmin|s_isAdWeb|s_isAdForms|s_isAdConc|s_isAdFormsDev|s_isAdConcDev|s_isAdWebDev' $CONTEXT_FILE <TIER_ADADMIN oa_var="s_isAdAdmin">YES</TIER_ADADMIN> <TIER_ADWEB oa_var="s_isAdWeb">YES</TIER_ADWEB> <TIER_ADFORMS oa_var="s_isAdForms">YES</TIER_ADFORMS> <TIER_ADNODE oa_var="s_isAdConc">YES</TIER_ADNODE> <TIER_ADFORMSDEV oa_var="s_isAdFormsDev">YES</TIER_ADFORMSDEV> <TIER_ADNODEDEV oa_var="s_isAdConcDev">YES</TIER_ADNODEDEV> <TIER_ADWEBDEV oa_var="s_isAdWebDev">YES</TIER_ADWEBDEV> [applvision@apps log]$

With all the above variables set to YES, adpatch will apply all files to this Apps Tier.

The following variables in each nodes respective context file represent the services that are actually running on the a node:- e.g

<TIER_DB oa_var="s_isDB">NO</TIER_DB>
<TIER_ADMIN oa_var="s_isAdmin">NO</TIER_ADMIN>
<TIER_WEB oa_var="s_isWeb">YES</TIER_WEB>
<TIER_FORMS oa_var="s_isForms">YES</TIER_FORMS>
<TIER_NODE oa_var="s_isConc">NO</TIER_NODE>
<TIER_FORMSDEV oa_var="s_isFormsDev">YES</TIER_FORMSDEV>
<TIER_NODEDEV oa_var="s_isConcDev">NO</TIER_NODEDEV>
<TIER_WEBDEV oa_var="s_isWebDev">YES</TIER_WEBDEV>