Infra installation
========================
The infra will basically install the metadatarepository for the oracle application server Middle tier server.We will be using the metadatarepository as a dehydration store for bpel process manager.These scrrenshots will guide you with the steps to follow.
Start the installation wizard
Provide the name and path in such a way so that you can identify them properly.
Select the second option to install Oracle Application Server infrastructure 10g
Again check the installation type.
I am using the first one as per my requirement.However if you want to have bpel process manager you need to selct metadata repository only.It will be installing a oracle database 10.1.0.4.
YOu may get this window next which you have to ignore by saying yes
Confirm the preinstallation requirement by selecting administrator priviledges.
Select the configuration option which you want to have.
go ahead and select the default values coming
same
specify the global sid name
specify the password for schmea.In order to avoid the confusion use the same password for all the schema
specify the instance name and password
Go ahead and install the application server 10.1.2.0.2
It will install the database
Configuration assistant.
finally end of installion
============================================================
so you have installed oracle application server infrastructure 10.1.2.0.2
next is to install the mid tier that is your j2ee and webserver on top of that you will install your bpel which will be using infra database which we have installed
just now.
Installation of Mid-tier
==============================
Next is the installation of Mid tier which is nothing but it installs the oracle application server container for j2ee(oc4j) and othe components.
Again i am providing only the screen shots and i believe you will be able to understand.
Start the .exe file
it will come up with a screen
Provide the path for installation and name
Select Product Oracle Application Server 10g
Select installation type as j2ee and webserver
Confirm the preinstallation requirement
Select the configuration option
Specify port configuration option.Let it be automatic if you are using a desktop
SPecify the instance name and ias_admin password
Say next in the summary screen
product install
Configuration assistant
Finally end of installation.
So so far we have done installation of infra and mid tier
========================================================
Installtaion of bpel process manager 10.1.2.0.2
================================================
The steps involved in installation of bpel process manager are
Unlock the orabpel Account and Change the Password
This is required if you are installing Oracle BPEL Process Manager for an Oracle Application Server Metadata Repository without Oracle Identity Management.That is the repository is not registered with OID so you have to change the password.
IF repository is registered with OID no need to change the password.
Do the following
Start SQL*Plus:
sqlplus /nolog
Connect to the OracleAS Metadata Repository:
CONNECT / AS SYSDBA
Unlock the Oracle BPEL Process Manager account:
ALTER USER orabpel IDENTIFIED BY orabpel ACCOUNT UNLOCK;
Change the account password also by following command
ALTER USER orabpel IDENTIFIED BY password(your own password)
Please check i have pasted the scripts in this widow itself but it should run within orabpel schema.
and upgrade your bpel schema
Locate the SQL*Plus script to upgrade the BPEL Process Manager schema
The name of the schema is upgrade_202_203_oracle.sql.
Log in to SQL*Plus and connect as the orabpel user
and run the script
done it will come up with a sql completed screen
So the preinstallation step for installation of BPEL process manager is over.:)
NOw we will go ahead and isntall the bpel process manager on top of mid pointing dehydration to infra.
Start the .exe file of installation
It will redirect to the welcome page
Choose the oracle home as mid's home
choose option as oracle application server for mid tier.It will install the bpel process manager on top of mid tier.I would here like to mention that it is always recommendede to use same version of jdeveloper as application server so if we are using application server 10.1.2 then we will be using the jdev also of same version.Here there is one important point that the jdev for application server 10.1.2 series should not be downloaded from any link.
The jdeveloper comes up with the developer addition of bepl process manager.Please look in to the screen shot the bpel process manager for developer also include the jdeveloper.So you can later also install the bpel process manager for developer to have the jdev.
Say next for the next screen
Now choose the dehydration store which is your midtier database
Specify the details of database
It will start installing the bpel process manager
configuration assistant will list down the component beging istalled which is bpel process manager
finally end of installation
So this part in over you have now bpel process manager on top of mid tier which is using infra database as a dehydration store.
Now the next task is to upgrade your infra and mid tier to 10.1.2.3.This is again a very easy task.YOu just need to start the 10.1.2.3 wizard and first give infra home as oracle home and upgrade it then give mid home as oracle home and upgrade it.Once it is upgraded you can go ahead and apply MLR's on top of that.Before that we need to upgrade the db from 10.1.0.4 to 10.1.0.5.
Upgradation of database 10.1.0.4 to 10.1.0.5
=================================================
Download the patch set and start the installation wizard.
It will come up with a screen like this
Next screen will ask for the path and name.YOu have point it to the same infra database home where your database is installed.If you want to check your database.Go to infra home ->bin directory and and log into your database.(Please esnure you have sqlplus.exe) file there.
It is an easy patch to apply as it will not ask for any other details simply intalltion windown will come and once you say install it will install the wizard and come up with the exit screen.
then
So the patch is applied however the main task is the post installation task for this patch.
In order to apply the post installation task your database should be down and listener should be up.It is always good to follow a document and do all the steps mentioned otherwise you might face several issue as i have faced many a time.The screen shot will give a better idea.Once database is down you have to start upgrading it by providing command
SQL> STARTUP UPGRADE
It will come up with some result saying Database mounted at the end.
The next you have to use the folllowing command
SQL> SPOOL patch.log
Don't ask me what these things are doing as i have no idea from database side.
Now you have to run the catpatch.sql command
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catpatch.sql
It takes a very long time to complete and finally it will come up with a screen like this
next is you have to use following command
SQL> SPOOL OFF
Restart the database:
SQL> SHUTDOWN
SQL> STARTUP
Next is to run the utlrp.sql command
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql
It will also take some time to complete and finally will come up with a screens aying it is completed.
====================================================
Now for upgrading AS we will start the upgradation from mid tier because all the mid tier using metadatarepository should be already upgraded to 10.1.2.3
So we will go ahead with the upgradation of mid 10.1.2.3
Start the installation wizard for 10.1.2.3 and select mid as oracle home
Do a software update of mid tier
I believe now you will be able to go ahead with the steps so i will not be pasting the screenshots.the very next step it will ask for ias_admin password.Then choose dehydration store and provide the details of the dehydration store.Say next and it will upgrade your apllication server to 10.1.2.3 along with bpel process manager.
Then you need to upgrade you infra to 10.1.2.3.One important point to note down is that infra needs to be updated software upgrade and then meta data repository upgrade
Now choose infra as a oracle home
Select meta datarepository to be upgraded
It will come up with a warning ,Ensure that you fulfill all the conditions as mentioned in the warning
then say immediate install
Now go ahead it will ask for some paswword keep providing them and instal it will upgrade your infra to 10.1.2.3
Aah it has worked for me.So now i have bpel process manager 10.1.2.3 using infra database.Now if you want to apply any mlr you can go ahead and apply the MLR on top of 10.1.2.3
