Hurriyet

2 Ocak 2015 Cuma

Oracle E-Business Suite: How to apply patches in EBS R12.2 using Adop -- Abort or Rollback a Patch 12.2.4 Versiyonunda Adop Nasıl Kullanılır? Nasıl Patch Geçilir? - Nasıl Patch İptal Edilir?

In EBS Release 12.2 a new patching tool was introduced.  All the patching is now done with adop. The context of this patching system has also changed. It means that the patches are now applied to the online patching cycle. The patching cycle has a number of phases. These phases are:

  1. Prepare - creates the patch edition.
  2. Apply - apply ARU or manual patches to the patch edition.
  3. Finalize - perform any actions required to prepare for cutover.
  4. Cutover - Promote Patch Edition to be the new Run Edition.
  5. Cleanup - remove obsolete code and data from old editions.
We will now introduce the syntax and the usage of each phase:

Prepare:
The online patching cycle starts with prepare command.  That's why we connect to application node and  source the ebs RUN environment. Then we execute the following command which is
" adop phase=prepare"

 [applmgr@T1VSTEBSAPP01 APPS]$ cd /u01/install/APPS  
 [applmgr@T1VSTEBSAPP01 APPS]$ . EBSapps.env RUN  
 [applmgr@T1VSTEBSAPP01 APPS]$ adop phase=prepare  

When this command is executed a new patch edition is created.

File system synchronization can be done by applying the delta from the recent patching cycle, or by forming the entire patch edition file system as a copy of the run edition (called "fs_clone").

If prepare fails then we should abort the prepare phase.

 [applmgr@T1VSTEBSAPP01 APPS]$ adop phase=abort

Apply:

When the preparation phase is over, changes to the patch edition is isolated from the run edition. Therefore run edition can be used as usual.

We first change our directory to the patch's path.. Then we read the readme.txt of the patch. Unless there is not anything required to do before the patch, we execute apply patch command. 

 [applmgr@T1VSTEBSAPP01 Localization Patch]$ cd 20279504_TR/  
 [applmgr@T1VSTEBSAPP01 20279504_TR]$ adop phase=apply  
 [applmgr@T1VSTEBSAPP01 20279504_TR]$  


Finalize:


The finalize phase is the part where system is prepared to ready the system for a fast cutover.

[applmgr@T1VSTEBSAPP01 20279504_TR]$ adop phase=finalize  

Cutover: 

The cutover is made when the system is ready for downtime. It should be applied after the system can endure a downtime. Moreover the patch edition becomes the new run edition.

The Run/patch designation of the dual file systems are swapped during cutover. We re-source the run edition after the cutover phase.

[applmgr@T1VSTEBSAPP01 20279504_TR]$ adop phase=finalize 

Cleanup:

With cleanup unnecessary code created during the patch phase will be removed.


[applmgr@T1VSTEBSAPP01 20279504_TR]$ adop phase=cutover  
[applmgr@T1VSTEBSAPP01 20279504_TR]$ adop phase=c
There is another option which specifies cleanup mode with which full statistics is taken.

Note: Due to a known issue in Release 12.2.2, full cleanup is is currently available only in Release 12.2.3 and higher

Other Options:

FS Clone
$ adop phase=fs_clone
Abort
$ adop phase=abort
$ adop phase=cleanup 





General Structure:

$ . /EBSapps.env run
$ adop phase=prepare
$ adop phase=apply patches=123456
$ adop phase=finalize
$ adop phase=cutover
$ . /EBSapps.env run
$ adop phase=cleanup


How to abort a Patch Process - Rollback: 

We would want to abort a patch if we are failing during a patching process.If we cant solve the problem, the need to abort the cycle arises. To abort a patch, first we need to be at a status before cleanup phase.

The abort command is only available until successful completion of the cutover phase. After cutover completes, the system is running on the new edition and abort is no longer available for that
patching cycle. Warning: Aborting a patching cycle will drop the patch edition, but you must then run the cleanup and fs_clone phases before starting a new patching cycle. The cleanup must be a full cleanup ($ adop phase=cleanup cleanup_mode=full).

$ adop phase=prepare
$ adop phase=apply patches=123456
[Patch application encounters problems and you want to abort]
$ adop phase=abort
$ adop phase=cleanup cleanup_mode=full
$ adop phase=fs_clone

Patch - Patching Parameters:

In there reference-4, we have added a link which shows us the available patching parameters that can be used with adop.

 adop phase=prepare workers=1  

The command above is an example for that. We could use workers parameter with adop.


Where are the Adop Logs?

Adop logs are placed into the $ADOP_LOG_HOME which is in the non editione application file system." For example: /u01/install/APPS/fs_ne/EBSapps/log/adop"

In that folder, in the session id that we are in, we would see all the phases that we have done like "Prepare,Finalize,Apply,Cutover,Cleanup,Abort". Other than that within everyone of these folders, everything regarding that phase is inserted like subroutines depending on their execution time.

That is how we could find the related log file.

Inside the $ADOP_LOG_HOME:



Inside the directory of the patch session id:




References:
1-Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)
2-Patching Utilities - Adop: http://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm
3-Validations done by adop-

4-Patching Parameters - http://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

29 Aralık 2014 Pazartesi

Oracle E-Business Suite:Applying NLS Patch - Adding Languages To EBS in R12 & R11 - EBS'e Türkçe Dil Desteği Eklemek


After a fresh install of Oracle Production EBS R12.2.4 VM Template on our servers we wanted to add language support on our application system. Therefore we followed this document :"R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)"


In that document, it pretty much says everything about languages in an EBS system. You can either add a new language, or update the current language with respect to the other english file versions, just change the language files with the refreshed translations.

The whole process goes like:

1-We should check out the prerequisites under this topic "Before Requesting Translation Synchronization Patch" .  There some patches that you need to apply. according the patch level. You can check out  the patch level with the following SQL

 select * from fnd_product_installations where patch_level like '%AD%';

If you want to see that a patch is installed or not you can use the following patch: 

select * from AD_APPLIED_PATCHES where patch_name='%';  


2- Then  we activate the new language by using Oracle Applications Manager (OAM) Licence Manager.

We first click on Licence Manager.

Then we activate the language that we want.


3- After the activating the language, we go on with the adadmin utiliy the application node.

You run "adadmin" then go on with the "Maintain multi-lingual tables" which is under the the "Maintain Applications Database Entities Menu"

4- Then we request for a new syncronization patch by running the following command and uploading the output to the  following address.

Command:
 perl $AD_TOP/bin/adgennls.pl 

Output:
 $APPL_TOP/admin/$TWO_TASK/out/adgennls.txt 

Upload Address:

5- Then you receive  a translation syncrhonization patch to apply. To apply the for R12.2.4 
5.1- Change directory to the patch directory
5.2- Then execute the following command 
"adop phase=prepare,apply,finalize,cutover,cleanup"

6- Last step would be to generate message files from the adadmin utility.







Referances:


1-R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=176620445661286&id=252422.1&_afrWindowMode=0&_adf.ctrl-state=303mg8osv_25


2-Oracle E-Business Suite NLS Release Notes, Release 12.2 (Doc ID 1314621.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=176932629461056&parent=DOCUMENT&sourceId=252422.1&id=1314621.1&_afrWindowMode=0&_adf.ctrl-state=303mg8osv_70


3-How To Troubleshoot NLS Forms Generation Errors When Applying An NLS Patch In R12 Or 11i (Doc ID 1537973.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=273461662123937&id=1537973.1&_afrWindowMode=0&_adf.ctrl-state=1803s998f3_4


4- Oracle E-Business Suite Installation Guide: Using Rapid Install - Part Number E22950-18 - Finishing Tasks - Installing NLS Language Support

https://docs.oracle.com/cd/E26401_01/doc.122/e22950/T422699i4783.htm

5-  Using Lightweight MLS With Oracle E-Business Suite Release 12.1.3 and higher (Doc ID 1077709.1)

26 Aralık 2014 Cuma

Oracle E-Business Suite: Forms Compilation Error - Form Derleme Hatası

In R12.1.3

Recently we have encountered errors such as these:


Compiling KEY-NXTBLK trigger on QUERY_FIND data block...
Compilation error on KEY-NXTBLK trigger on QUERY_FIND data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 1
bad bind variable 'parameter.G_query_find'

It turned out that FORMS60_PATH was not set correctly. Whenever forms are compiled FORMS60_PATH is set to:

FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource

In context file it was set as:

$AU_TOP/resource:$AU_TOP/resource/stub

After correcting this and compiling manually it worked. To make this permanent change the s_f60path to include $AU_TOP/forms/US:$AU_TOP/resource

In R12.2.4 or in R12.2 we should be adding the following to the $FORMS_PATH variable in the context file which is in the $APPL_TOP/$SID_$HOSTNAME.env path  

$AU_TOP/forms/US:$AU_TOP/forms/TR 

After that forms can be compiled with the following command.

E.g.:
frmcmp_batch AKDFLOWB.fmb   apps/apps output_file=$AK_TOP/forms/TR/AKDFLOWB.fmx compile_all=special;


Referanslar:

Forms Compilation hatası
http://oracleappstechnology.blogspot.com.tr/2009/03/forms-compilation-errors.html

1 Aralık 2014 Pazartesi

Oracle Fusion Middleware: Running RDA For Hyperion - Remote Diagnostic Agent(RDA) - Hyperion için RDA Çalıştırmak

We have written about the RDA before for OBIEE and EBS.

1- http://berkeoz1.blogspot.com.tr/2014/01/oracle-e-business-suite-rda-nedir.html
2- http://berkeoz1.blogspot.com.tr/2014/07/oracle-fusion-middleware-running-rda.html

Now we would like to specify the usage of rda for Hyperion. The need to that has arisen to detect problems in the Hyperion system. What we had used before was the diagnostic tool of Hyperion.
(http://berkeoz1.blogspot.com.tr/2014/08/oracle-hyperion-starting-and-stopping.html)
However we will be using rda as a complementary tool to our diagnostic efforts.

Where is RDA?

RDA is found in the Middleware Home. (For example:E:\Oracle\Middleware\oracle_common\rda)

We could do the setup which is giving the appropriate details for running rda by "rda.cmd -S".


To list all the profiles that we can run we could use:

rda.exe -L

With that command all the modules and previously defined profiles to analyze the system can be found.



An example of the command to run RDA with using just the HFM module is below:

rda.cmd -vSCRP HFM

An example of the command to run RDA with using profile for HFM is below:

rda.cmd -vSCRP -p Hyperion1112_HFM

In the end, we would have something like the directory structure below in which we run first the "RDA_index.htm" file



References:

1-How to Use Remote Diagnostic Agent (RDA) to Gather Diagnostic Information On Oracle Hyperion Financial Management (HFM) Servers to Help Resolve Service Requests Faster [Video] (Doc ID 1100612.1)

19 Ağustos 2014 Salı

Oracle Fusion Middleware: Error Assigning Users To Application Role in OBIEE 11g - Kullanıcuların Uygulama Rolüne Atanırken Hata Alması

After installing OBIEE 11.1.1.7 on our system, we encountered with an error. This error was occuring although we had succesfully set our Active Directory. Our AD setup was working fine and we were logging in to system with the AD accounts.

Regarding the setup, you could check on how we have done it.
1-rovider - Active Directory Authentication to OBIEE 11g - Active Directory Configuration'ını OBIEE 11g İçin Yapmak

2-hentication to OBIEE 11g - 2 - Deleting Default Provider - Active Directory Configuration'ını OBIEE 11g İçin Yapm

The error that we have seen is

Java.lang.NullPointerException
#{viewScope.emas_pagemodel_security_EditAppRole.searchPrincipal}: java.lang.NullPointerException
     Hide Additional Trace Information

The error screen was like the picture below:




After that we have searched for the error, we have seen that there was a bug concerning this problem.

"Bug 16808088 : 11G JAVA.LANG.NULLPOINTEREXCEPTION ADDING USER TO ROLE AFTER UPGRADE TO 11.1.1.7"


The proposed solution is to set the virtualize parameter to false if it ise set. Virtualize parameter doesn't work with the username.attr which we have previously set in the security provider configuration settings.

In the end, we changed its value to false and we were able overcome this problem.

Reference:
1- https://community.oracle.com/thread/2530201?start=0&tstart=0

Oracle Fusion Middleware: EVALUATE_SUPPORT_LEVEL Error in Oracle OBIEE 11g

EVALUATE_SUPPORT_LEVEL errror appers when we open a report from a catalog or a dashboard. It has a quite simple solution.







In order to to solve this problem, we change evaluate support level parameter in the NQSConfig.ini file to the value given below:

EVALUATE_SUPPORT_LEVEL=2


After that, we could restart the BI server to activate the changes.

Oracle Fusion Middleware: Using Active Directory as a User Provider - Active Directory Authentication to OBIEE 11g - 2 - Deleting Default Provider - Active Directory Configuration'ını OBIEE 11g İçin Yapmak ve Default Provider'ı Kaldırmak

In our previous article, we explained how to add Active Directory as an user provider. Now we will delete the default authenticator in order to make the newly added Active Directory our only provider to have a tighter security configuration.

2.Deleting Default Provider

The reason why we put 2 at the beginning is that we are assuming that we have added the Active Directory just like we did on the arcticle before this.

2.1 Update the Credential Store Password

These configuration changes can be made from entreprise manager. The link should be like this: http://localhost:7001/em

Open Weblogic Domain / bifoundation_domain screen. Select Security / Credentials item under WebLogic Domain menu.



Find “system.user” under oracle.bi.system and click Edit.
Input the new user name and password. We have created OBIA_BISystemUser just for this purpose. We will use it later to add more privileges to our system user.

2.3. Security Provider Configuration

Click “WebLogic Domain” menu. Click “Security Provider Configuration” menu item under Security sub-menu.



We then add the following properties.

Property Name
Value
virtualize
false
user.login.attr
samaccountname
username.attr
samaccountname

2.4. Assign application roles to system users and groups

Select Business Intelligence / coreapplication from left panel. Click on Security / Application Roles item on Business Intelligence Instance menu.



Make the following assignments :

Role Name
Members
BISystem
OBIA_BISystemUser (User)
BIAdministrator
OBIA_Administrators (Group)
BIAuthor
OBIA_Administrators (Group)
BIConsumer
OBIA_Administrators (Group)
Note: The users and the groups are newly created. The creation process is explained on the first part of this arcticle.


2.5. Assign global roles to system users and groups:

Open Weblogic Admin Console. Go to “myrealm” in WebLogic Admin Console. Go to Roles and Policies tab. In “Realm Roles” sub tab, expand Global Roles / Roles.


Assign the roles to LDAP groups as seen in the following table.

Global Roles :
Assignment :
Admin
Group : OBIA_Administrators
User : OBIA_BISystemUser
AdminChannelUsers
Group : OBIA_Administrators
AppTester
Group : OBIA_Administrators
CrossDomainConnector
Group : OBIA_Administrators
Deployer
Group : OBIA_Administrators
Monitor
Group : OBIA_Administrators
Operator
Group : OBIA_Administrators

2.6. Delete default provider:

Go to Providers tab under security realm “myrealm”. Click on Active Directory provider we created. Select REQUIRED in Control Flag dropdown field. Click Save.

2.7. Stop and start BI services:

Click “Stop BI Services” under “Oracle Business Intelligence” group in Start Menu. To proceed, we have to provide weblogic user and its password in the console.
Delete the two boot.properties files in the following locations :
%OBI_HOME%\user_projects\domains\bifoundation_domain\servers\AdminServer\security
%OBI_HOME%\user_projects\domains\bifoundation_domain\servers\bi_server1\security

Click “Start BI Services” under “Oracle Business Intelligence” group in Start Menu.
Enter the user and password of OBIA_Weblogic when prompted.