Wednesday, July 25, 2007

Troubleshooting Single Sign On.....

During the bootcamp and the SSO setup, I ran into some errors when trying to log in Oracle EBS.
One of the problems you can encounter is that the redirection to your SSO login page is not working. To find out what's the problem you can check the following :

1. Is OID running ? You can log on to OID using the orcladmin account,
2. Is the iAS10g for your SSO running ? Check $ORACLE_HOME/opmn/bin/opmnctl status
3. Can you login EBS using the AppsLocalLogin.jsp url....(to check if the EBS services are running)
4. If this is working fine, check your config document again. Maybe something went wrong when administrating your EBS node with SSO ( script)

Also check Metalink
- note 376811.1 :'Integrating Oracle E-Business Suite Release 12 with Oracle Internet Directory and Oracle Single Sign-On '
- note261914.1 : Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On
- note 444573.1 : Basic checks for user integration when using Oracle E-Business Suite 11i with Oracle AS 10g
- note 295606.1 : Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting

Wednesday, July 18, 2007

Back home

Last Friday I returned home from two weeks in Montpellier. Until the last day, we worked with EBS R12 and had some great discussions regarding Single Sign On. I had configured Single Sing On with EBS R12 and tested some features the last day.

I wanted to know what would happen if a user did exist in OID, but not in EBS . There is a profile option which takes care of this issue. If the profile 'APPS_SSO_OID_IDENTITY ' is set to 'enabled', OID will create the EBS user if it does not exist..
I also noticed that when the user password is changed in EBS, this password is also transferred to OID. But I don't think passwords should be changed in EBS anymore when using Single Sign ON.....

And after two weeks of working with R12, I returned home with more R12 experience and also with more friends !
I would like to thank the staff of the Oracle/IBM Joint Solution Center in Montpellier for making the bootcamp possible. Especially Paul Bramy, for his enthusiasm and help. I also want to thank my fellow bootcampers for sharing knowledge and experience, Pascal Labrevois and Andrea Cobis. I hope to speak them soon again...

Tuesday, July 10, 2007

Last week - RAC week

So, the last week of the bootcamp in Montpellier arrived. Yesterday I spend some time installing Oracle Portal, but from today I am concentrating Oracle RAC 10g. I am planning to install a RAC database using ASM. Because I have little experience with these Oracle products, it seems valueable to me.
At the same time a colleague is working on a DMZ implementation with EBS R12, so I will be looking over his shoulder also.
Last week I also installed Oracle Discoverer and maybe we can also look at the integration of Discoverer with EBS R12. I already performed the steps mentioned in note 373634.1. Since Oracle Discoverer is not part of the EBS R12 rapid install anymore, we are curious how it is working with EBS R12....

Friday, July 06, 2007

SSO and EBS R12

First week is almost over here in Montpellier. What have I done till now ?

1. - I have installed GRID control 10gR2 and upgraded it to R3. But the EBS plugin is not yet available for AIX, so I could not go on with GRID.
2. - I have installed Oracle AS10gR2 and implemented Single Sign On the EBS R12.
3. - I have installed Oracle Discoverer and configured it with SSO, so that you can also login to Discoverer using your SSO account
4. - I have managed to configure a cloned R12 environment in SSO.

Also EBS R12 was cloned from a multi node configuration to a single node configuration.
Next week I will be focusing on RAC.

Wednesday, July 04, 2007

EBS R12 on AIX

To start this post I would like to sum up our IBM hardware setup, on which we are working with EBS R12

2 4-node AIX cluster with on each 2 DB servers + 2 APPS servers
+ 1 Apps server for a Single Sign On installation and Grid Control.

- EBS release 12 for AIX
- EBS release for AIX
- 10gR2 DB + patchset
- 10gAS R3 ( )
- 10gGrid Control (R3)

We have started with two multinode installations of EBS R12 on AIX. One with a vision database and the other one with an empty database. The environment with an empty database is going to be used for cloning. But after installing EBS R12 we ran into a forms problem. When creating a forms session in EBS, a FRM-92101 error occurs. We are investigating what the problem could be. I also found out OPMNCTL does not work from the command line..

opmnctl status
Unable to connect to opmn.
Opmn may not be up.

Could be same problem.
From an IBM colleague in the US we received a solution we are about to test.
More to come....

Monday, July 02, 2007


I have arrived in Montpellier. I got stuck in Paris for more then a hour, but around 01:00 this morning I arrived at my hotel.
After a few hours of sleep, I hooked up with another EBS dba, and together we went to IBM France for the bootcamp.
We first designed our strategy for the coming 2 weeks as you can see on the picture.
Next we divided the tasks and made sure everybody was able to login the machines.
We are now starting with an EBSR12 install, both vision and an empty database.
Also we are installing a Grid control 10GR3 to manage the databases....unfortunately the EBS plugin is not yet available for the IBM platform...(only Linux and Solaris..)