Friday, March 7, 2014

adpatch compares file versions before copying


What c-driver will do?

C-drive copies the files from patch unzipped directory to required location in u r application file system. Before copying it will check the file version of the existing file at the file system with the file version of the file in the patch. If the patch file version is higher than what it is at file system level then only c-driver will copy that files.

How adpatch will know the file versions of the patch delivered files?

With each patch a file with name f.ldt is delivered , which contain the file versions of the files delivered with the patch.
Adpatch will use this file to compare the file versions of files its delivering with the file on file system.


What is Single Sign-On Server (SSO) ?


What is Single Sign-On Server (SSO) ?
As name says Single-Sign On Server is set of services (Software) which enables login to Application once which will allow you to login to Ppartner Applications with no need to login again. Lets assume I have configured single SSO Server for Portal , E-Business Suite, Collaboration Suite plus some other other applications, Now if I login to any one of them & after that if I wish to login to other applications I should be able to login without supplying passwords again.

How will I log off then ?
This is called as Single Sign-Off which is part of SSO server , If you logout from any one application SSO server will log off from all applications.

What are Technology Stack components of SSO Server ?
SSO consist of OC4J_Security & HTTP Server which are part of Oracle Identity Management which inturn part of Oracle Infrastructure Server which in turn part of Oracle Application Server. SSO server uses Oracle Internet Directory to store User Credentials in encrypted format for Partner Applications . If some one ask you to bounce SSO server , you bounce either of them or both . Oracle components uses mod_osso which is part of Oracle HTTP Server to connect to SSO server.

Partner Application & External Applications ?
As mentioned above lot of time about Partner Applications ; Partner Applications are the one which delegates their authentication to SSO server (like Portal, Discoverer, E-Business Suite, Collaboration Suite) where as External Applications are applications which don't delegate their authentication to SSO Server (like yahoo, google, hotmail applications).

What does delegating Authentication means here ? Delegating authentication means partner application will ask sso to verify if a user is authenticated properly or not where as external application will check username/password at their end sso server will simply hold username/password in OID (If users select remember external application password)

Request Flow when SSO is used ...
Very important to understand request flow when a application is configured with SSO & user tries to access Application .
1) User first time tries to access application (like portal, collabsuite, apps 11i) configured with sso server
2) Application checks that there is no login cookie set into User(Clients) browser so Application redirects it to Single Sign-On Server via mod_osso
3) Single Sign-On Server returns login page to user & user enter his/her username/password
4) SSO validates these password against one stored in Oracle Internet Directory
5) If password matches then SSO return a token to client with list of all applications which user has access and return client back to original application
6) This token is stored as part of cookie in user's/client's browser & further connections from client to applications will be allowed (as authentication token is already in cookie)


How adpatch knows what are the pre-req’s for the patch which it is applying?


How adpatch knows what are the pre-req’s for the patch which it is applying?
Ans: With every patch a file called b.ldt file will be delivered which contain the pre-req information. adpatch load this into databse using FNDLOAD and check , whether those pre-req patches were applied or not.


Oracle EBS 11i versus R12


Outline of few major technical difference.
Database:
Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2)

Application Tier:
Tech Stack in Application Tier consist of iAS(1.0.2.2.2) & Developer 6i (Forms & Reports 8.0.6) but in Applications R12 it is build on Fusion Middleware (10g Web Server and 10g Forms & Reports)

Sub component in Application Tier
A) HTTP Server or Web Server in R12 is Version 10.1.3 which is built on Apache version 1.3.34. In apps 11i it is Version 1.0.2.2.2 built on Apache Version 1.3.19
B) Jserv in apps 11i is replaced by OC4J (mod_jserv is replaced by mod_oc4j)
C) Forms Version 6i in Apps 11i is replaced by Forms 10.1.2.0.2 in R12
D) Reports Version 6i in Apps 11i is replaced by Reports 10.1.2.0.2 in R12
E) JDBC version is changed from version 9 in apps 11i to version 10.2.0 in Apps R12
F) modplsql or mod_pls is removed from Apps R12 (What will happen to my mod plsql applications- coming soon* )
G) Java processes use JDK/JRE version 1.5.0 in R12 against JDK version 1.3.1 or 1.4.2 in Apps 11i
H) Control Scripts are in new top ADMIN_SCRIPTS_HOME (R12) as compared COMMON_TOP/admin/scripts (11i)
I) New top INSTANCE_TOP added in Release 12 for all configuration and log files

Adadmin is not working how to enable maintenance mode oracle apps (EBS)


@$AD_TOP/patch/115/sql/adsetmmd.sql
You can also put your application in Maintenance mode from backend:
Enable Maintenance mode:
SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
SQL> select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual; –> to check

Disable Maintenance mode :
SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
SQL> select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual;
3. Enabling and Disabling Maintenance Mode
Maintenance mode is Enabled or Disabled from adadmin.
When you Enable or Disable 'Maintenance Mode', adadmin will execute the script:

$AD_TOP/patch/115/sql/adsetmmd.sql sending the parameter 'ENABLE' or 'DISABLE' :

sqlplus /@adsetmmd.sql ENABLE | DISABLE

ENABLE - Enable Maintenance Mode .
DISABLE - Disable Maintenance Mode.

When adsetmmd.sql runs, it sets the Profile Option 'Applications Maintenance Mode'

(APPS_MAINTENANCE_MODE) to 'MAINT' to Enable 'Maintenance Mode' and to 'NORMAL' to Disable it.

4. Determining if Maintenance Mode is running
A quick way to verify if the Environment is on Maintenance Mode or not, is by checking the value of this
Profile Option as follows:
sqlplus apps/apps
SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
If the query returns 'MAINT', then Maintenance Mode has been Enabled and the Users will not be able to

Login. If the query returns 'NORMAL' then Maintenance Mode has been De-Activated and the Users will be able to use the application.

Note: Maintenance Mode is only needed for AutoPatch Sessions. Other AD utilities do not require

Maintenance Mode to be enabled. Maintenance Mode must be 'Enabled' before running AutoPatch and 'Disabled' after the patch application is completed.

When Maintenance Mode is disabled, you can still run Autopatch by using options=hotpatch on the command line, if necessary. However, doing so can cause a significant degradation of performance.


Bouncing Workflow mailer Oracle Apps (EBS)

The ‘WorkFlow Mailer Services in Oracle E-Business R12 , how we can start ,stop these services’

Goto system administrator -> Oracle application manager --> Workflow

Click on the SERVICES COMPONENTS UP logo

Click on the WORKFLOW MAILER SERVICE in the last of this list

Select the WORKFLOW AGENT LISTENER SERVICE and select the Start ALL in the combo or selection box (highlighted) and then click on GO button



SELECT component_name as Component, component_status as Status FROM fnd_svc_components WHERE component_type = 'WF_MAILER';

Sample output:

COMPONENT STATUS
---------------------------------------- -----------

Workflow Notification Mailer RUNNING

Step of register/deregister SSO


Go to $FND_TOP/bin

Remove Refrence OID
1. txkrun.pl -script=SetSSOReg -removereferencesoid=yes
enter goofy

Remove Reference SSO
2. txkrun.pl -script=SetSSOReg -removereferences=yes
enter sl1pp1ng
enter goofy

3.**BOUNCE APACHE**
cd $COMMON_TOP/admin/scripts/ (11i)
cd $ADMIN_SCRIPTS_HOME (R12)
adapcctl.sh stop
adapcctl.sh start
cd $FND_TOP/bin

DE-Register OID
4. txkrun.pl -script=SetSSOReg -deregisteroid=yes

De-Register SSO
5. txkrun.pl -script=SetSSOReg -deregistersso=yes

Register SSO
6. txkrun.pl -script=SetSSOReg -registersso=yes

Register OID
7. txkrun.pl -script=SetSSOReg -registeroid=yes -provtmp=$FND_TOP/admin/template/ProvOIDToApps.tmp



====Answer of the question asked while register or deregister SSO Services =====


Enter Oracle E-Business apps database user password ? xxxx

Enter Oracle E-Business SYSTEM database user password ? xxxx

Enter LDAP Host ? server01.company.local

Enter the application name used for registration of this application instance in OID ( 24 chars or less ) ? dfin

Enter the descriptive service name used for registration of this application instance in OID ( 80 chars or less ) ? dfin

Enter the LDAP Port on Oracle Internet Directory server ? 389

Enter the Oracle Internet Directory Administrator (orcladmin) Bind password ? xxxx

Enter the host name where Oracle iAS Infrastructure database is installed ? server01.company.local

Enter the Oracle iAS Infrastructure database port number ? 1521

Enter the Oracle iAS Infrastructure database SID ? SSODB

Enter Oracle iAS Infrastructure database ORASSO schema password ? BrAQp68z

Enter the instance password that you would like to register this application instance with ? winter123

Enter the Oracle iAS Infrastructure database SID ? SSODB

Enter Oracle iAS Infrastructure database ORASSO schema password ? BrAQp68z


Enter E-Business Suite existing SSOSDK schema password or choose a password to use with the new SSOSDK schema if the schema does not exist ?