All posts by Atul Kumar
OAM Webgate installation issue: Troubleshooting
Hi, I would like to share my experience with issue in webgate installation which I faced during SSO integration in one of the target system. Environment Details: In the target system the webserver was installed as root and the user/group was specified as nobody/nobody. When I tried to install the webgate it was not letting […]
Read MoreSiebel CRM integration with Oracle Access Manager
Environment details: OAM: Version 10.1.4.3 on RHEL Siebel: Version 8.1 on Aix 5.3 Steps for Integration: 1) Create profile for webgate and install the webgate on target siebel webserver. – I have used SIEBEL_SSO_UID as the header variable name to pass the username. 2) Create the following user in OAM LDAP a)SADMIN b)GuestUser 3) Check […]
Read MorePDF loading issue after integration with Oracle Access manager
Hi, I would like to share my experience of a issue, which I faced during SSO integration with one of the custom application. The integration was done successfully, but during testing the testers discovered the PDF files were not getting loaded. When a user clicks on a PDF file he/she would see a blank page.Environment […]
Read MoreWhole Server Migration
WSM is the process of moving the entire server instance from one physical machine to another upon failure or scheduled maintenance. All the services being hosted by that particular instance will also be migrated along with it to another healthy server. Machine configuration for WSM 1. Identify two machines on the same sub net for […]
Read MoreReduce autoconfig downtime – Parallel run & Profiler
Oracle has introduced two new features in autoconfig. These two new features for sure gonna help to reduce the downtime of application for maintenance tasks.1. AutoConfig: Parallel Run Option The “Parallel Run” feature enables AutoConfig to be executed simultaneously across multiple nodes of an Oracle E-Business Suite instance. Certain AutoConfig configurations of one node depend […]
Read MoreMigrating Non ASM DB to ASM DB
This is a sample document showing how to migrate Non ASM DB to ASM DB 1 create the ASM instance 2.Create the required DISK groups according to the needs DB name DEVEL SQL> select file_name from dba_data_files; FILE_NAME ——————————————————————————– /oracle/DEVEL/system01.dbf /oracle/DEVEL/undotbs01.dbf /oracle/DEVEL/sysaux01.dbf /oracle/DEVEL/users01.dbf /oracle/DEVEL/example01.dbf SQL> select name from v$controlfile; NAME ——————————————————————————– /oracle/DEVEL/control01.ctl SQL> select MEMBER […]
Read MoreDuplicating the DB from PRODUCTION to DEVELOPMENT using RMAN
The topic is related to creating a duplicated copy of DB from production to Development using rman. The below steps are applicapable in 9i,10g and 11g.In 11g there are some new methods for creating duplicate DB which I will be covering in coming topics The database names used here database names: Primary Database SID: PROD server […]
Read MoreCustom Schemas are not analyzed when Gather Schema Statistics are submitted.
Concurrent –> Request –> Submit Request –> Gather Schema statistics (Paramerters “ALL”)The above request gathers statistics for all schemas , however it skips custom schemas registered in Oracle Applications.Explaination : Whenever Custom schemas are registerd in Oracle Applications , the entries are done in 2 tables ie FND_ORACLE_USERID and FND_APPLICATIONS_TL However , when Gather schema […]
Read MoreDiagnosing RAC Issues and RAC Best Practices
I just wanted to share few metalink notes on Diagnosing RAC Issues across various platforms. Oracle Support has recently few interesting metalink notes on how to troubleshoot the various layers in a RAC Install i.e Storage, Network, OS, Database, Listener, CRS and ASM Components. The document also lists various whitepapers/metalink articles on troubleshooting IPMP, RAC […]
Read MoreXML Reports going in Warning after taking a long time.
[Preliminary Note: Please do not try it on PRODUCTION Instance until you have applied it on TEST] During working on 12.0.6 running on Linux environment I received a complain from the user that: “Their XML reports (.rtf) are taking too much time in running and ending in Warning status”. Following is the message I saw […]
Read More