B2B Installation fundamentals

Installation of B2B on Windows machine

Download B2B: Get this from oracle metalink

Step1: Install Oracle Infrastructure

1. Go to Shiphome location and click on setup.exe
2. Provide necessary oracle home for this Infrastructure installation
3. Complete the installation.

Step 2: j2ee/midtire/OC4J installation

1. Go to Shiphome location and click on setup.exe
2. Provide a separate middleware home. This is different from step1
3. Complete the installation.

Step 3: post installation activity

1. Open a cmd prompt and set the oracle home, An example is shown below
C:\101202\infra_0306> set path=C:\101201\infra_0306\bin;%path%
C:\101202\infra_0306> set ORACLE_HOME= C:\101201\infra_0306
C:\101202\infra_0306> set path=%ORACLE_HOME/bin;%path%
C:\101202\infra_0306> set ORACLE_SID=orcl0306

2. Unlock the b2b user if Meta Data repository is used and shutdown the database
C:\ sqlplus /as sysdba
SQL> alter user b2b identified by b2b account unlock; ; // donot execute for IM –OID installation

SQL> alter system set aq_tm_processes=5 scope=spfile;
SQL> alter system set job_queue_processes=5 scope=spfile;
SQL> alter system set open_cursors=500 scope=spfile;
SQL> commit;
SQL> shutdown immediate;

3. Take the backup of database from oradata directory and name it as orcl_b2b_before

4. Login to database and startup again
C:\ sqlplus /as sysdba
SQL> startup;

5. On j2ee/ midtire terminal start the j2ee server before the installation of b2b
c: /101201/j2ee_0306/opmn/bin/> opmnctl startall

Step 4: B2B installation

1. Go to Shiphome location and click on setup.exe
2. Select the middleware home for b2b installation( Note: Middleware home same as step2)
3. Complete the installation.
4. Once the installation is completed then go to j2ee_0306/ip/config dir and open the tip properties file and change debug levels from ERROR to DEBUG and
change Logtype = text

5. Stop the j2ee server
6. Go back to infra terminal, shutdown the database and take a backup of database and start the database again
c:/ sqlplus /as sysdba
SQL> shutdown immediate;
SQL> quit;
7. Take a backup of database and start the database as orcl_b2b_after.
8. Go to midtire terminal and start the server.