Power of Dream: 2013

This covers installations under CentOS-6.4 64 bit and Mint Linux-15 64 bit.

CentOS-6.4 64 bit is called "Community Enterprise Operating System" and it should be compatible with Latest Redhat 7 64 bit and Fedora 19 64 bit.

Mint Linux-15 64 bit should be compatible with Latest Ubuntu 13.04 LTS 64 bit.

Before you going to work with Oracle ATG eCommerce platform there are several things need to be concerned.

1. This document was prepared 7th September of 2013 with considering latest software modules up to date. Following information are correct as of 17th June of 2013.

2. ATG 10.2 development required at least 4 GB RAM with 64 bit OS architecture. 32 bit Operating Systems including Linux and Windows unable to cater more than 3 GB of memory. Even your computer system configured with more than 3 GB RAM ( Ex- 8 GB ) it will show maximum up to 4 GB RAM. This is commonly called as 3 GB barrier.

3. The successful installation will include ATG 10.2 framework, Endeca search engine and Sample reference application called "ATG Web Commerce Reference Store 10.2". This helps to understand the integration with Endeca Search Engine and ATG framework. In ATG 10.2, all content of e-commerce site can be shown through Endeca Search Engine queries. Not by direct database queries. It is a new feature of ATG 10.2.

4. It is not mandatory to show web contents through Endeca Search Engine queries. You can create your own application without interacting Endeca search engine. Endeca Search Engine has several components such as MDEX, CAS, Platform Services and Tools and Framework. Installing Endeca means you have to install those components.

5. Create your own account in Oracle. Go to https://edelivery.oracle.com/. Here you can download ATG frameworks and Endeca frameworks.

6. Total installation time will take at least 2 hours for Linux.

7. As a best practice, use separate location for installation.

Installation Folder Structure

create installation folder called "common" in root path "/" using following commands.

For Redhat Linux, Fedora, CentOs

1. Open terminal and type su -
2. Enter root password
3. Go to root path by following command
4. cd /
5. Create folder called "common" by following command
6. mkdir common
7. Give full permission to /common folder by following command
8. chmod -R 777 common

Step 1: view

For Ubuntu, Mint Linux

1. Open terminal and type sudo mkdir /common
2. Enter password of current user
3. Give full permission to /common folder by following command
4. sudo chmod -R 777 /common

Installation Root ( /common )

--------------------------------------

| --- /common/Oracle

| For Weblogic Application Server

| --- /common/ATG10.2

|      For Oracle ATG Web Commerce 10.2,
|               Oracle ATG Web Commerce Reference Store 10.2
| --- /common/Endeca
|         For Oracle Endeca MDEX Engine 6.4.1,

| Oracle Endeca Platform Services 6.1.3,

|      Oracle Endeca Tools and Frameworks 3.1.2,
|         Oracle Endeca Content Acquisition System 3.1.2
| --- /common/Downloads
          For all above downloaded software

8. There are many instances of user authentications. For the easiness, use same password for all instances. ( Ex- ATGtraining123 ). In production time, use very strong passwords.

9. Download required installation in to separate driver it self. Not in to deep folder structure. If you download installations in to deep folder structure, then extraction path will be too long and it will failed the installation.

10. If you are using Oracle database located at remote server, Then network should have enough speed. Otherwise repository creation will be failed. It is good to install local Oracle XE database server in-order to eliminate those issue. For the production environment please consult Network and System engineers for high speed network.

Required Hardware configurations

1. x86 processor with x86 motherboard

2. 8 GB RAM

Required software and their versions

Following software and their versions are mandatory.

Operating System

1. Linux 64 bit ( Download your preferred one from following list )

Download Instructions :-

Ubuntu 12.04 ( http://www.ubuntu.com/download/desktop )

Mint Linux 15 ( http://www.linuxmint.com/download.php )

CentOS 6.4 ( http://www.centos.org/ )

Fedora 19 ( http://fedoraproject.org/en/get-fedora-options )

Redhat 7 ( https://www.redhat.com/wapps/store/catalog.html )

Java Framework

1. JDK 1.6 64 bit

Download Instructions :-

1. Download it from ( http://www.oracle.com )

2. There are several type of JDK files.

3. Download JDK 6 not other versions.

4. Download the file type called ".bin"

5. Ex - jdk-6u45-linux-x64.bin

Application Server

1. Oracle WebLogic Server 11gR1 (10.3.6) Generic One

Download Instructions :-

1.Download generic installer from http://www.oracle.com. It will come as a single JAR file around 1 GB.

2.Given version 11gR1 (10.3.6) is mandatory and download it from http://www.oracle.com.)

3. Ex - wls1036_generic.jar

ATG Frameworks

1. Oracle ATG Web Commerce 10.2 (64 bit)

Download Instructions :-

1. Signed to https://edelivery.oracle.com/ .

2. Read and Accept license agreement.

3. Select product as ATG Web commerce

4. Select your platform as 64 bit

5. Select Oracle ATG Web Commerce (10.2)

6. Download Oracle ATG Web Commerce 10.2

7. Extract the ZIP file and find the BIN file.

8. Ex - ATG10.2_394REL.bin

ATG Sample Application

1. Oracle ATG Web Commerce Reference Store 10.2 (64 bit)

Download Instructions :-

1. Signed to https://edelivery.oracle.com/ .

2. Read and Accept license aggrement.

3. Select product as ATG Web commerce

4. Select your platform as 64 bit

5. Select Oracle ATG Web Commerce (10.2)

6. Download Oracle ATG Web Commerce Reference Store 10.2

7. Extract the ZIP file and find the BIN file.

8. Ex - CommerceReferenceStore10.2_354REL.bin

Endeca Search Engine Frameworks

1. Oracle Endeca MDEX Engine 6.4.1 (64 bit)

2. Oracle Endeca Platform Services 6.1.3 (64 bit)

3. Oracle Endeca Tools and Frameworks 3.1.2 (64 bit)

4. Oracle Endeca Content Acquisition System 3.1.2 (64 bit)

Download Instructions :-

1. Signed to https://edelivery.oracle.com/ .

2. Read and Accept license agreement.

3. Select product as Oracle Endeca

4. Select your platform as 64 bit

5. Select Oracle Endeca Commerce 3.1.2 Media Pack

6. Download Oracle Endeca MDEX Engine 6.4.1 64 bit

Extract the ZIP file and find the SH file.

Ex - mdex_6.4.1.715066_x86_64pc-linux.sh

7. Download Oracle Endeca Platform Services 6.1.3 64 bit

Extract the ZIP file and find the SH file.
Ex - platformservices_613654721_x86_64pc-linux.sh

8. Download Oracle Endeca Tools and Frameworks 3.1.2 64 bit

                 Extract the ZIP file and find extracted folder. It is not a .sh file.
   Ex - ToolsAndFrameworks

9. Download Oracle Endeca Content Acquisition System 3.1.2 64 bit

Extract the ZIP file and find the SH file.

Ex - cas-3.1.2-x86_64pc-linux.sh

Database

1. Oracle Database Express Edition 11g Release 2 64 bit

Download Instructions :-

1. Download it from ( http://www.oracle.com )

Ex - oracle-xe-11.2.0-1.0.x86_64.rpm.zip

SQL Developer

1. Oracle SQL Developer 64 bit

Download Instructions :-

1. Download it from ( http://www.oracle.com )

Ex - sqldeveloper-3.2.20.09.87-1.noarch.rpm

Once you downloaded all above software, then /common/Downloads folder will looks like similar to following figure

Step 1: view

Installation of ATG framework and Endeca search engine with sample application.

First give full permission to all downloaded software as following figure

For Redhat Linux, Fedora, CentOs

1. Open terminal and type su -
2. Enter root password
3. Go to root path by following command
4. cd /common/Downloads
5. chmod -R 777 *

For Ubuntu, Mint Users

1. cd /common/Downloads
2. sudo chmod -R 777 *
3. Type current user password

Step 1: view

Then we have to increase buffer size of Linux Terminal. This is to read lengthy server consoles.

1. Open terminal
2. Go to edit -> keyboard profile

Step 1: view

3. Then go to Scrolling
4. Then change Scrollback to 10000

Step 1: view

Now we are about to install all our ATG software. It will take at least 2 hours. :D

Install 32 bit supplementaries for 64 bit Operating System.
Reason : Endeca Platform Services required 32 bit perl libraries for correct
function.

For Redhat Linux, Fedora, CentOs

1. Switch user to root by command su -
2. Install GLIB i686 by command yum install glibc.i686

Step 1: view

For Ubuntu, Mint Users

1. Install ia32-libs by command sudo apt-get install ia32-libs

Installing dos2unix and unix2dos

For Redhat Linux, Fedora, CentOs

1. Switch user to root by command su -
2. yum install unix2dos
3. yum install dos2unix

For Ubuntu, Mint Users

1. sudo aptitude install tofrodos
2. cd /usr/bin
3. sudo ln -s fromdos dos2unix
4. sudo ln -s todos unix2dos

Next Install Java. ( For all Linux )

1. Go to /common/Downloads

2. Type ./jdk-6u45-linux-x64.bin

Step 1: view

Then it will extract all JDK content in to a folder in same location called jdk1.6.0_45

Step 1: view

3. Now we have to copy extracted JDK folder in to /common folder. Type

cd /common/Downloads
cp -r jdk1.6.0_45/ /common/

4. Then remove extracted

rm -fr jdk1.6.0_45/

Step 1: view

5. Then go to /common folder
Then switch to root user mode.
Then give full permission to JDK folder

Step 1: view

Now we have set-up Java Environmental variables to point well-known two java commands. They are java and javac

1. Now exit from root user mode by command called exit
2. Go to home directory by command called cd ~

3. Now open .bash_profile by following command gedit .bash_profile

Step 1: view

Now append java and javac paths to PATH environment variable.

You have to do this before export PATH command in .bash_profile file.

Then go to new line
Then create new Linux shell variable called JAVA_HOME with the value of JDK home path.
Then go to new line
Then export newly created JAVA_HOME

java is located at /common/jdk1.6.0_45/binjavac is located at /common/jdk1.6.0_45/jre/bin

Java home is located at /common/jdk1.6.0_45

Finally it should looks like this.

Step 1: view

Now save and exit from .bash_profile file.
load changes by command called . .bash_profile ( There are two dots :D )

Step 1: view

Now check whether java is correctly pointing to your console by following two commands

javac -version
java -version

Step 1: view

It will show java and javac version.
Now we have installed JAVA successfully.

Installing Weblogic Server.

Open a terminal and navigate it to download location of Weblogic server
Then type following command. Then it will begin Weblogic installation

java -jar wls1036_generic.jar

Step 1: view

Then select next to proceed.

Step 1: view

Then select Weblogic installation location as described above.

Installation Root
------------------------------
    |
    |
    --- /common/Oracle/Middleware

Step 1: view

Then de-select emails supports and proceed.

Step 1: view

Then click yes to bypass initiation of configuration manager.

Step 1: view

Then click yes to remain security issues.

Step 1: view

Then select "i wish to remain security issues ... " and continue.

Step 1: view

Then select typical installation

Step 1: view

Then select local JDK that you installed.

Step 1: view

Then select next without changing given locations

Step 1: view

Then select next to complete the installation

Step 1: view

Then select "Run Quickstart"

Step 1: view

Then select "Getting started with Weblogic server" to create web logic server instances

Step 1: view

Then select "Create a new Weblogic domain"

Step 1: view

Then select "Generate a domain configured automatically to support the following product".

Step 1: view

Then click next by without changing configured values by default.

Step 1: view

Then add password for Weblogic instance. keep default username "weblogic" as it is. Use common password "ATGtraining123" for everywhere. Use good strong passwords for production time.

Step 1: view

Then click next with default configurations

Step 1: view

Then click next without selecting any option.

Step 1: view

Then click create. This will create Weblogic server instance.

Step 1: view

Click done. Then installation will finish.

Step 1: view

Then start web logic admin server using following steps

1. Open a terminal prompt and execute following commands

2. cd /common/Oracle/Middleware/user_projects/domains/base_domain/bin

3. ./startWebLogic.sh

Step 1: view

4. Then see the weblogic console. If it successfully installed and started successfully then last console output will look like this.

Step 1: view

Then we have to login to Weblogic Admin Console. This admin console gives you full of features to console weblogic daemons.

1. Now open web browser and brows http://localhost:7001/console

2. Use username as "weblogic" and password as "ATGtraining123".

3. Then it will bring you to following admin console.

Step 1: view

Cheers we have installed Java and Weblogic successfully.

Installing ATG framework

1. Open Terminal
2. Navigate to Software directory by cd /common/Downloads/
3. Run Installation of ATG by ./ATG10.2_394REL.bin

Step 1: view

4. Type index number of language and press enter to continue.
5. Again press enter to continue.

Step 1: view

6. Press enter several times to go down and Accept license and provide installation path as /common/ATG10.2

7. Type Y for Yes to confirm the installation location.

8. Press enter to select all features to install.

Step 1: view

8. Select application server as Oracle WebLogic - option 4

9. Provide Weblogic Middleware directory path /common/Oracle/Middleware

10. Provide WebLogic home directory path /common/Oracle/Middleware/wlserver_10.3

11. Provide WebLogic domain directory path     /common/Oracle/Middleware/user_projects/domains/base_domain

12. Provide JDK Home directory      /common/jdk1.6.0_45

13. Provide WebLogic listen port as                     7001

14. Provide ATG RMI port as                          8860

Step 1: view

Now you are going finish the ATG installation with previewing configurations.

Press enter to install.

Step 1: view

Once installation done. press enter to exit the setup.

Step 1: view

Now go to installation folder and see the content of ATG framework. This is the ATG engine. There are lots of folders inside ATG installation.

Following folders has important features of ATG framework.

CIM - This can be use to setup a new project configuration with lesser time. It provides simple approach to create Application server instances, data sources, project deployments, creating endeca instances and many more things.

DCS , DPS , DSS - Provides out-of the box e-commerce functionalities. Source codes are available in src folder. we can use these source codes for more customization of out-of the box features. sql folder has database scripts for above out-of the box features

Creating a new project means you have to create a new project folder inside ATG framework. for an example, lets assume your e-commerce project name is ABCEcommerce. Then project structure will be like this.

/common
   |
   |
ATG10.2
   |
     |
    ABCEcommerce ( DCS, DPS, DSS will be included as libraries )
        |
       src
       |
       META-INF
       |
       lib
       |
       webapp.war
       |
       build.xml ( Ant build file )

Installing ATG Sample Ecommerce web site.

ATG sample e-commerce application is called "Reference Store".

Many of e-commerce projects can be done using customizing this sample application.

It has full e-commerce life cycle with test data.

Once you installed it, you can see a folder called CommerceReferenceStore inside ATG installation directory.

Go to download location

1. cd /common/Downloads/

Then run Commerce Reference Store Setup file.

2. ./CommerceReferenceStore10.2_354REL.bin

Select language preference

3. select 2

Read license agreement

4. Press enter and go down and read license agreement.

Step 1: view

Accept license agreement

5. Type Y for yes

6. Provide ATG installation location as /common/ATG10.2

7. Again confirm the installation location with Y

Step 1: view

8. Read Pre-Installation Summary and say Y to install.

Step 1: view

9. Once installation done, press enter to exit.

10. Now go to ATG home folder and see the folder called "CommerceReferenceStore". That is the sample store given by ATG framework.

Step 1: view

Now we have installed Java, Weblogic server, ATG 10.2 framework, ATG 10.2 Commerce Reference Application.

Now move to install Endeca Framework.
Endeca Framework provides search engine functionalities.
Endeca Framework has several components. They are

MDEX                            - This will use to index site contents.
CAS                                - This will use to acquire contents from sites.
Platform Services     - This provides core services to run Endeca Services

Tools and Framework - This provides utilities to create Endeca application for
                                         given site.

Installing Endeca Framework ( MDEX )

Go to download location

1. cd /common/Downloads/

Run the MDEX setup with targeted installation location as /common

2. ./mdex_6.4.1.715066_x86_64pc-linux.sh --target /common

Step 1: view

3. Once installation done, It will ask to configure environmental variables.
When you run the Endeca service you have to run these commands.

As a best practice, lets create Linux shell script to following things.

1. Configure all these environmental variables
2. Then start services one by one.

Ex - startEndeca.sh

Also we have to create separate Linux shell script to following things.

1. shut-down these services one by one.

Ex - stopEndeca.sh

Go to /common

1. cd /common

Create two files called startEndeca.sh and stopEndeca.sh using following command.

2. gedit startEndeca.sh and save it in /common

Step 1: view

3. gedit stopEndeca.sh and save it in /common

Step 1: view

4. Add following content to startEndeca.sh

#!/bin/bash

ENDECA_MDEX_ROOT=/common/endeca/MDEX/6.4.1
export ENDECA_MDEX_ROOT
PATH=$ENDECA_MDEX_ROOT/bin:$PATH
export PATH

Step 1: view

Installing Endeca Framework ( Platform Services )

Go to download location

1. cd /common/Downloads/

Run the MDEX setup with targeted installation location as /common

2. ./platformservices_613654721_x86_64pc-linux.sh --target /common/

Step 1: view

3. Read license agreement and Accept it by pressing enter key.

Step 1: view

4. Then provide following ports for Endeca services.

     Endeca HTTP service : 8888

     Shutdown port number of the Endeca HTTP service : 8090

     Endeca Control System : 8088

     Install Endeca Application Controller : Y

     MDEX Engine Path : /common/endeca/MDEX/6.4.1

     Install the reference implementations : Y

Step 1: view

5. Then it will ask to configure Endeca service environmental variables.

Step 1: view

6. Use cat command to read the content of installer_sh.ini

cat /common/endeca/PlatformServices/workspace/setup/installer_sh.ini

7. Copy the content

Step 1: view

8. Then edit startEndeca.sh

1. cd /common/
2. gedit startEndeca.sh

Step 1: view

9. Then add copied content to startEndeca.sh

Step 1: view

So far we have added start up scripts of MDEX and Platform Services.

Now we have to install Tools and Framework and then will add it's start-up parameters to startEndeca.sh

1. Navigate to /common/Downloads folder
2. Copy entire ToolsAndFrameworks folder to /common/endeca/ToolsAndFrameworks

Step 1: view

3. Then open startEndeca.sh to add following system variables.

1. export ENDECA_TOOLS_ROOT=/common/endeca/ToolsAndFrameworks/3.1.2
2. export ENDECA_TOOLS_CONF=/common/endeca/ToolsAndFrameworks/3.1.2/server/workspace

Step 1: view

Then move to install Oracle Endeca Content Acquisition System 3.1.2.

Navigate to /common/Download and run the installation file.

Create following folder structure inside the ToolsAndFrameworks

1. cd /common/endeca/ToolsAndFrameworks/3.1.2/reference/

2. mkdir media-mdex-cas

3. cd media-mdex-cas

4. mkdir lib

Step 1: view

Now we will install Endeca Content Acquisition System

1. cd /common/Downloads

2. ./cas-3.1.2-x86_64pc-linux.sh --target /common/

Step 1: view

Provide following information

1. Port for the CAS service : 8500.

2. Shutdown port for the CAS service : 8506.

3. ENDECA_TOOLS_ROOT path : /common/endeca/ToolsAndFrameworks/3.1.2

4. ENDECA_TOOLS_CONF path : /common/endeca/ToolsAndFrameworks/3.1.2/server/workspace

5. Fully qualified name, including domain information, of the CAS server : Localhost

Step 1: view

It will finish successfully.

Step 1: view

Now we have successfully installed Endeca Search Engine. It has MDEX, ToolsAndFrameworks, Platform Services and CAS.

Step 1: view

In startEndeca.sh file contains environmental variables that will use to start those Endeca services.

The next step is to add those start-up scripts given by above Endeca tools.

We will append those steps bellow environmental variables.

1. Open startEndeca.sh

cd /common

gedit startEndeca.sh

2. Add Platform Services's start-up command.

/common/endeca/PlatformServices/6.1.3/tools/server/bin/startup.sh

3. Add Tools And Framework's start-up command.

/common/endeca/ToolsAndFrameworks/3.1.2/server/bin/startup.sh

4. Add CAS start-up command. ( There is & symbol at the line end )

/common/endeca/CAS/3.1.2/bin/cas-service.sh &

Step 1: view

Now open stopEndeca.sh file that we have create already.

1. cd /common

2. gedit stopEndeca.sh

Add following content to stopEndeca.sh

#!/bin/bash

/common/endeca/PlatformServices/6.1.3/tools/server/bin/shutdown.sh
/common/endeca/ToolsAndFrameworks/3.1.2/server/bin/shutdown.sh
/common/endeca/CAS/3.1.2/bin/cas-service-shutdown.sh

Now we have done all configurations for Endeca start-up and shutdown.

Next change the permissions of startEndeca.sh and stopEndeca.sh

1. cd /common

2. chmod 777 startEndeca.sh

3. chmod 777 stopEndeca.sh

Then start Endeca

1. cd /common

2. ./startEndeca.sh

Step 1: view

Then stop Endeca

1. cd /common

2. ./stopEndeca.sh

Step 1: view

Cheers we have successfully installed Endeca.

Next, we are going to install Oracle Database System for CentOS or Redhat Linux or Fedora.

If you are using Ubuntu or Mint Linux please refer bellow after this guide.

1. Go to download location.

cd /common/Downloads/

2. Switch to root user mode

3. unzip oracle xe database installation file

unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

Step 1: view

4. Navigate to extracted location called /common/Downloads/Disk1

cd /common/Downloads/Disk1

5. Switch to root user mode

6. Run the installation file

rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm

7. Configure oracle installation

/etc/init.d/oracle-xe configure

8. Specify the HTTP port that will be used for Oracle Application Express : 8080

9. Specify a port that will be used for the database listener : 1521

10. Provide password for SYS and SYSTEM users.

ATGTraining123

11. Confirm the password

ATGTraining123

12. Enable Oracle XE database to start-up at boot time

Step 1 : view

12. Now exit from root user mode.

exit

Step 1: view

Cheers now we have installed Oracle XE Database for Linux successfully.

Please refer following approach for UBUNTU or Mint Linux users.

1. Go to download location.

cd /common/Downloads/

2. unzip oracle xe database installation file

unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

3. Install additional libraries and dependencies

sudo apt-get install alien libaio1 unixodbc

4. Navigate to extracted location called

cd /common/Downloads/Disk1

5. Convert RPM package into UBUNTU or Mint compatible deb package.

sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

Result will be a new package called oracle-xe_11.2.0-2_amd64.deb

Which will be located at /common/Downloads/Disk1

6. create empty file called chkconfig located at /sbin
     sudo touch /sbin/chkconfig

7. Give full user permission to /sbin/chkconfig
    sudo chmod 777 /sbin/chkconfig

8. Open /sbin/chkconfig
    gedit /sbin/chkconfig

9. Add following content to /sbin/chkconfig
   Do not add new lines from both begin and end of the file.
   Make sure you are using default gedit editor.
   Otherwise special character will be added with your sense.
   This makes failed installation.

#!/bin/bash
# Oracle 11gR2 XE installer chkconfig hack for Ubuntu
file=/etc/init.d/oracle-xe
if [[ ! `tail -n1 $file | grep INIT` ]]; then
echo >> $file
echo '### BEGIN INIT INFO' >> $file
echo '# Provides: OracleXE' >> $file
echo '# Required-Start: $remote_fs $syslog' >> $file
echo '# Required-Stop: $remote_fs $syslog' >> $file
echo '# Default-Start: 2 3 4 5' >> $file
echo '# Default-Stop: 0 1 6' >> $file
echo '# Short-Description: Oracle 11g Express Edition' >> $file
echo '### END INIT INFO' >> $file
fi
update-rc.d oracle-xe defaults 80 01

10. Save and close /sbin/chkconfig

11. create empty file called 60-oracle.conf located at /etc/sysctl.d/

sudo touch /etc/sysctl.d/60-oracle.conf

12. Give full user permission to /etc/sysctl.d/60-oracle.conf
sudo chmod 777 /etc/sysctl.d/60-oracle.conf

13. Open /etc/sysctl.d/60-oracle.conf

gedit /etc/sysctl.d/60-oracle.conf

14. Add following Oracle related kernel Parameters to /etc/sysctl.d/60-oracle.conf

kernel.shmmax parameter should be calculated.

I have 8GB RAM.

So calculated value is 1024 * 1024 * 1024 *

1024 * 1024 * 1024 * 8 = 8589934592

No need to calculate other parameters.

      Do not add new lines from both begin and end of the file.
      Make sure you are using default gedit editor.
      Otherwise special character will be added with your sense.
      This makes failed installation.

fs.file-max=6815744
net.ipv4.ip_local_port_range=9000 65000
kernel.sem=250 32000 100 128
kernel.shmmax=8589934592

15. Save and close /etc/sysctl.d/60-oracle.conf

16. start procps service.
      sudo service procps start

17. Create soft link from /usr/bin/awk to /bin/awk
      sudo ln -s /usr/bin/awk /bin/awk

18. create folder called subsys at /var/lock/
      sudo mkdir /var/lock/subsys

19. create empty listener file called listener located at /var/lock/subsys/
      sudo touch /var/lock/subsys/listener

20. Run deb package located at /common/Downloads/Disk1

sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb

21. Un-mount shared memory location located at /dev/shm
      sudo umount /dev/shm
22. If /dev/shm is not existed it will give error. Then ignore it.

23. Remove /dev/shm folder.
      sudo rm -rf /dev/shm
24. If /dev/shm is not existed it will give error. Then ignore it.

25. Now create fresh shared memory folder called shm located at /dev
      sudo mkdir /dev/shm

26. Now mount newly created shared memory location.
      You have to calculate your RAM size based on Megabytes.
      For 8GB RAM it will be 1024 * 8 = 8192

      sudo mount -t tmpfs shmfs -o size=8192m /dev/shm

27. Now configure oracle.
     sudo /etc/init.d/oracle-xe configure

   During this configuration it will ask several questions, Answer them in following manner.

Specify the HTTP port that will be used for Oracle Application Express : 8080

Specify a port that will be used for the database listener : 1521

Provide password for SYS and SYSTEM users.

ATGTraining123

Confirm the password

ATGTraining123

Enable Oracle XE database to start-up at boot time

28. Load changes to your current profile. The dot (.) at beginning is required.

. $HOME/.profile

29. Start oracle database.
sudo service oracle-xe start

Cheers we have installed Oracle successfully.

Next, we are going to install sqldeveloper editor for CentOS or Redhat Linux or Fedora.

If you are using Ubuntu or Mint Linux please refer bellow after this guide.

1. Move to software download location.

cd /common/Downloads/

2. Switch to root user mode

3. Install sqldeveloper rpm package

rpm -ivh sqldeveloper-3.2.20.09.87-1.noarch.rpm

Step 1: view

4. Exit from root user mode.

exit

5. Creating desktop shortcut for sqldeveloper.

1. Navigate to your Desktop

cd ~/Desktop/

2. Create empty Linux shell file in your desktop. Name it sqldeveloper.sh

touch sqldeveloper.sh

3. Give it full permission

chmod 777 sqldeveloper.sh

4. Open it using gedit

gedit sqldeveloper.sh

Step 1: view

5. Add following content to start sqldeveloper

     #!/bin/bash

     export JAVA_HOME=/common/jdk1.6.0_45
     /opt/sqldeveloper/sqldeveloper.sh

Step 1: view

5. Save and exit from editor

6. Give full permission to /opt/sqldeveloper/sqldeveloper.sh

1. Switch to super user mode

2. Move to /opt/sqldeveloper/

cd /opt/sqldeveloper/

3. Give full permission to /opt/sqldeveloper/sqldeveloper.sh

chmod 777 /opt/sqldeveloper/sqldeveloper.sh

Step 1: view

6. Run sqldeveloper now

1. Navigate to your Desktop

cd ~/Desktop/

2. Run

./sqldeveloper.sh

Step 1: view

It is running.. :D

So now we are going to create database connection with newly installed Oracle Database.

Open SQLDeveloper. Then go to ( File -> New - Database Connection )

Step 1: view

Connection Name : ATG

Username : SYS
Password : ATGtraining123
Connection Type : basic
Role : SYSDBA
Hostname : localhost
Port : 1521
SID : xe

Step 1: view

Click the button called "Test" to test the connection.

Save the connection and Connect.

Step 1: view

Extract newly saved connection.

Then it will open SQL pad to run SQL commands.

Step 1: view

Run the following script to expand data files of SYSTEM database.

ATG repository creation will failed without these expansions.

This will create additional data file with 5000 MB.

I wish to create my data file in the installation location of Oracle Database.

Ex - /u01/app/oracle/oradata/XE/ATGAPP.DBF

1. SELECT A.FILE_ID,B.FILE_NAME,B.AUTOEXTENSIBLE,B.BYTES/1024/1024,SUM(A.BYTES)/1024/1024

FROM DBA_EXTENTS A , DBA_DATA_FILES B WHERE A.FILE_ID=B.FILE_ID

GROUP BY A.FILE_ID,B.FILE_NAME,AUTOEXTENSIBLE,B.BYTES/1024/1024;

2. ALTER TABLESPACE SYSTEM ADD DATAFILE '/u01/app/oracle/oradata/XE/ATGAPP.DBF' size 5000M;

3. COMMIT;

Now you can see newly created data file.

1. Swtich to root user mode

2. Change to /u01/app/oracle/oradata/XE where you can see oracle default data files.

cd /u01/app/oracle/oradata/XE

3. You will be able to see newly created data file specially for ATG.

Step 1: view

Now we have already installed all required software.
Now we are going to set up sample e-commerce project called "Commerce Reference Store" given by ATG.

Installing Commerce Reference Store and customizing it in to considerable level will give you enough understand about ATG ecommerce project and how Endeca search engine work together.

Creating ATG project means creating new project folder in ATG home folder located at /common/ATG10.2

Since Commerce Reference Store given by default it is also located at    /common/ATG10.2/CommerceReferenceStore

When you going to create new ATG project you have to go through specific approach to create web logic server instances, data sources, database repositories. Same approach is applicable when we install Commerce Reference Store.

ATG has given us wonderful tool called CIM.
Which is located at /common/ATG10.2/home/bin/cim.sh

Now we are going to install Commerce Reference Store

On your mark, get set go......

1. Run Endeca search engine
    cd /common/
    ./startEndeca.sh

Step 1: view

Now open seperate tab terminal window ( File -> Open Tab )
As a best practice use on terminal per application. Use multiple tabs.

Step 1: view

2. cd /common/Oracle/Middleware/user_projects/domains/base_domain/bin

3. ./startWebLogic.sh

Step 1: view

4. Navigate to location of cim.sh
    cd /common/ATG10.2/home/bin/

5. Run cim.sh
    ./cim.sh

6. Enter R

7. Set administration password of cim.sh
    Use our common password "ATGtraining123"

8. Confirm same password

Step 1: view

Enter P to select products
( If you face issues in current step Enter m to jump main menu )

Step 1: view

Enter 7 to select Commerce Reference Store

Step 1: view

Enter D to complete selections.

Step 1: view

Enter 5 to select Abandon Order services.

Then Enter D to finish selection.

Then Enter D again to avoid demo applications.

Step 1: view

Enter 1 to select non-switching database. ( Switching database will be used at production level in order to switch from different stages like development, staging and production )

Step 1: view

Enter 1 to make indexes based on SKU ( Store Keeping Unit )

SKU - Inventory has Black Levis shirts with Long Sleeve 16 Lnch shoulder.

These coloured key words can be used to identification of particular item.

Enter 1 to configure Endeca preview to run on Production server

Endeca Preview - Endeca preview is a feature that gives site owners to check whether

the Endeca driven new changes are affected before

go live. In live environment this feature will be deployed on Staging server.

Enter D to finish Endeca Preview selection

Step 1: view

Enter 1 2 3 to select Demo application ( Commerce Reference Store ) Local supports and Fulfilment features.

Fulfilment - It begins just after customer ordered products. This included getting products from inventories or Just in time production line, Packing, Shipping and handover to customer.

Enter D to finish the selection

Step 1: view

Enter 2 to Inspect Application

Enter D to finish selections

Enter 1 to configure full data sets for products and categories.

Step 1: view

Then please make sure to start the application server if it is not running.

It is already described how to start the application server.

Brows http://localhost:7001/console to make sure the application server up and running.

Enter A and hit enter to select application server.

Enter 2 select Weblogic Server

Step 1: view

Enter Weblogic Server path : /common/Oracle/Middleware/wlserver_10.3

Enter Domain Path : /common/Oracle/Middleware/user_projects/domains/base_domain

Step 1: view

Just Enter to perform validation of Weblogic Server.

It will automatically use correct URL based on Weblogic T3 Protocol.

Enter Weblogic user name : weblogic

Enter Weblogic password : ATGtraining123

Enter Confirmation password : ATGtraining123

Enter P to perform validation

Step 1: view

There are two database configurations need.

One is for Publishing and Other one is for Production.

Enter 1 to select database configurations.
Then Enter P to add Publishing database connection details.

Step 1: view

Enter C add Database configurations

Enter 1 to select Oracle Database

Step 1: view

Now do not continue from this point until we finished the creation of two DB schemas for Publishing and Production.

Now open sqldeveloper

1. Navigate to Desktop

cd ~/Desktop/

2. Run sqldeveloper.sh

./sqldeveloper.sh

Step 1: view

3. Login as SYS

Connection Name : ATG

     Username : SYS
     Password : ATGtraining123
     Connection Type : basic
     Role : SYSDBA
     Hostname : localhost
     Port : 1521
     SID : xe

4. Once you successfully connected Database Administrator, Then we can

create our required database users called Publishing and Production.

Publishing in sense, before production level.

Site owners can add, delete, edit products, categories, prices, shipping

methods, internal users such as Merchants and many more customizations.

Production in sense, the live application.

Here we are going to create user called "PUBLISHING".

The password is our common password "ATGtraining123".

Then create another user for "PRODUCTION" database.

Use same password "ATGtraining123" for this time as well.

Script 1 for Publishing User.

-- USER SQL
CREATE USER PUBLISHING IDENTIFIED BY ATGtraining123;

-- ROLES
GRANT "RESOURCE" TO PUBLISHING ;
GRANT "CONNECT" TO PUBLISHING ;

-- SYSTEM PRIVILEGES
GRANT ALTER TABLESPACE TO PUBLISHING ;
GRANT CREATE USER TO PUBLISHING ;
GRANT CREATE ANY OUTLINE TO PUBLISHING ;
GRANT CREATE MINING MODEL TO PUBLISHING ;
GRANT UPDATE ANY TABLE TO PUBLISHING ;
GRANT CREATE TRIGGER TO PUBLISHING ;
GRANT CREATE TABLESPACE TO PUBLISHING ;
GRANT CREATE ASSEMBLY TO PUBLISHING ;
GRANT CREATE SEQUENCE TO PUBLISHING ;
GRANT SELECT ANY SEQUENCE TO PUBLISHING ;
GRANT CREATE ANY SQL PROFILE TO PUBLISHING ;
GRANT EXECUTE ANY OPERATOR TO PUBLISHING ;
GRANT EXECUTE ANY TYPE TO PUBLISHING ;
GRANT CREATE ANY DIRECTORY TO PUBLISHING ;
GRANT CREATE TABLE TO PUBLISHING ;
GRANT CREATE ANY INDEX TO PUBLISHING ;
GRANT EXECUTE ASSEMBLY TO PUBLISHING ;
GRANT SELECT ANY TABLE TO PUBLISHING ;
GRANT CREATE OPERATOR TO PUBLISHING ;
GRANT CREATE ANY PROCEDURE TO PUBLISHING ;
GRANT CREATE ANY CUBE TO PUBLISHING ;
GRANT EXECUTE ANY CLASS TO PUBLISHING ;
GRANT CREATE ANY MATERIALIZED VIEW TO PUBLISHING ;
GRANT SELECT ANY TRANSACTION TO PUBLISHING ;
GRANT CREATE EXTERNAL JOB TO PUBLISHING ;
GRANT INSERT ANY TABLE TO PUBLISHING ;
GRANT CREATE LIBRARY TO PUBLISHING ;
GRANT CREATE JOB TO PUBLISHING ;
GRANT CREATE ANY OPERATOR TO PUBLISHING ;
GRANT CREATE ANY LIBRARY TO PUBLISHING ;
GRANT CREATE ANY SEQUENCE TO PUBLISHING ;
GRANT CREATE CLUSTER TO PUBLISHING ;
GRANT FORCE ANY TRANSACTION TO PUBLISHING ;
GRANT CREATE EVALUATION CONTEXT TO PUBLISHING ;
GRANT CREATE ANY CUBE BUILD PROCESS TO PUBLISHING ;
GRANT EXECUTE ANY INDEXTYPE TO PUBLISHING ;
GRANT CREATE ANY DIMENSION TO PUBLISHING ;
GRANT CREATE ANY RULE TO PUBLISHING ;
GRANT CREATE RULE TO PUBLISHING ;
GRANT CREATE ANY VIEW TO PUBLISHING ;
GRANT CREATE PROCEDURE TO PUBLISHING ;
GRANT CREATE ANY TRIGGER TO PUBLISHING ;
GRANT CREATE DIMENSION TO PUBLISHING ;
GRANT CREATE ROLLBACK SEGMENT TO PUBLISHING ;
GRANT CREATE CUBE DIMENSION TO PUBLISHING ;
GRANT EXECUTE ANY RULE TO PUBLISHING ;
GRANT EXECUTE ANY PROCEDURE TO PUBLISHING ;
GRANT FORCE TRANSACTION TO PUBLISHING ;
GRANT CREATE ANY JOB TO PUBLISHING ;
GRANT CREATE ANY INDEXTYPE TO PUBLISHING ;
GRANT EXECUTE ANY PROGRAM TO PUBLISHING ;
GRANT GRANT ANY PRIVILEGE TO PUBLISHING ;
GRANT CREATE ANY EVALUATION CONTEXT TO PUBLISHING ;
GRANT EXECUTE ANY ASSEMBLY TO PUBLISHING ;
GRANT CREATE CUBE BUILD PROCESS TO PUBLISHING ;
GRANT EXECUTE ANY RULE SET TO PUBLISHING ;
GRANT CREATE SYNONYM TO PUBLISHING ;
GRANT ALTER ANY TABLE TO PUBLISHING ;
GRANT CREATE VIEW TO PUBLISHING ;
GRANT EXECUTE ANY LIBRARY TO PUBLISHING ;
GRANT CREATE RULE SET TO PUBLISHING ;
GRANT CREATE ANY CLUSTER TO PUBLISHING ;
GRANT CREATE TYPE TO PUBLISHING ;
GRANT EXECUTE ANY EVALUATION CONTEXT TO PUBLISHING ;
GRANT CREATE PUBLIC SYNONYM TO PUBLISHING ;
GRANT CREATE ANY MINING MODEL TO PUBLISHING ;
GRANT CREATE ANY RULE SET TO PUBLISHING ;
GRANT CREATE MEASURE FOLDER TO PUBLISHING ;
GRANT CREATE ROLE TO PUBLISHING ;
GRANT CREATE ANY CONTEXT TO PUBLISHING ;
GRANT CREATE ANY SYNONYM TO PUBLISHING ;
GRANT CREATE ANY CUBE DIMENSION TO PUBLISHING ;
GRANT CREATE ANY TABLE TO PUBLISHING ;
GRANT CREATE SESSION TO PUBLISHING ;
GRANT CREATE PUBLIC DATABASE LINK TO PUBLISHING ;
GRANT UNLIMITED TABLESPACE TO PUBLISHING ;
GRANT CREATE ANY EDITION TO PUBLISHING ;
GRANT CREATE ANY ASSEMBLY TO PUBLISHING ;
GRANT CREATE INDEXTYPE TO PUBLISHING ;
GRANT GRANT ANY ROLE TO PUBLISHING ;
GRANT CREATE MATERIALIZED VIEW TO PUBLISHING ;
GRANT DROP TABLESPACE TO PUBLISHING ;
GRANT DELETE ANY TABLE TO PUBLISHING ;
GRANT CREATE PROFILE TO PUBLISHING ;
GRANT CREATE ANY MEASURE FOLDER TO PUBLISHING ;
GRANT CREATE ANY TYPE TO PUBLISHING ;
GRANT CREATE CUBE TO PUBLISHING ;
GRANT CREATE DATABASE LINK TO PUBLISHING ;

COMMIT;

-- QUOTAS

Script 2 for Production User.

-- USER SQL
CREATE USER PRODUCTION IDENTIFIED BY ATGtraining123;

-- ROLES
GRANT "RESOURCE" TO PRODUCTION ;
GRANT "CONNECT" TO PRODUCTION ;

-- SYSTEM PRIVILEGES
GRANT ALTER TABLESPACE TO PRODUCTION ;
GRANT CREATE USER TO PRODUCTION ;
GRANT CREATE ANY OUTLINE TO PRODUCTION ;
GRANT CREATE MINING MODEL TO PRODUCTION ;
GRANT UPDATE ANY TABLE TO PRODUCTION ;
GRANT CREATE TRIGGER TO PRODUCTION ;
GRANT CREATE TABLESPACE TO PRODUCTION ;
GRANT CREATE ASSEMBLY TO PRODUCTION ;
GRANT CREATE SEQUENCE TO PRODUCTION ;
GRANT SELECT ANY SEQUENCE TO PRODUCTION ;
GRANT CREATE ANY SQL PROFILE TO PRODUCTION ;
GRANT EXECUTE ANY OPERATOR TO PRODUCTION ;
GRANT EXECUTE ANY TYPE TO PRODUCTION ;
GRANT CREATE ANY DIRECTORY TO PRODUCTION ;
GRANT CREATE TABLE TO PRODUCTION ;
GRANT CREATE ANY INDEX TO PRODUCTION ;
GRANT EXECUTE ASSEMBLY TO PRODUCTION ;
GRANT SELECT ANY TABLE TO PRODUCTION ;
GRANT CREATE OPERATOR TO PRODUCTION ;
GRANT CREATE ANY PROCEDURE TO PRODUCTION ;
GRANT CREATE ANY CUBE TO PRODUCTION ;
GRANT EXECUTE ANY CLASS TO PRODUCTION ;
GRANT CREATE ANY MATERIALIZED VIEW TO PRODUCTION ;
GRANT SELECT ANY TRANSACTION TO PRODUCTION ;
GRANT CREATE EXTERNAL JOB TO PRODUCTION ;
GRANT INSERT ANY TABLE TO PRODUCTION ;
GRANT CREATE LIBRARY TO PRODUCTION ;
GRANT CREATE JOB TO PRODUCTION ;
GRANT CREATE ANY OPERATOR TO PRODUCTION ;
GRANT CREATE ANY LIBRARY TO PRODUCTION ;
GRANT CREATE ANY SEQUENCE TO PRODUCTION ;
GRANT CREATE CLUSTER TO PRODUCTION ;
GRANT FORCE ANY TRANSACTION TO PRODUCTION ;
GRANT CREATE EVALUATION CONTEXT TO PRODUCTION ;
GRANT CREATE ANY CUBE BUILD PROCESS TO PRODUCTION ;
GRANT EXECUTE ANY INDEXTYPE TO PRODUCTION ;
GRANT CREATE ANY DIMENSION TO PRODUCTION ;
GRANT CREATE ANY RULE TO PRODUCTION ;
GRANT CREATE RULE TO PRODUCTION ;
GRANT CREATE ANY VIEW TO PRODUCTION ;
GRANT CREATE PROCEDURE TO PRODUCTION ;
GRANT CREATE ANY TRIGGER TO PRODUCTION ;
GRANT CREATE DIMENSION TO PRODUCTION ;
GRANT CREATE ROLLBACK SEGMENT TO PRODUCTION ;
GRANT CREATE CUBE DIMENSION TO PRODUCTION ;
GRANT EXECUTE ANY RULE TO PRODUCTION ;
GRANT EXECUTE ANY PROCEDURE TO PRODUCTION ;
GRANT FORCE TRANSACTION TO PRODUCTION ;
GRANT CREATE ANY JOB TO PRODUCTION ;
GRANT CREATE ANY INDEXTYPE TO PRODUCTION ;
GRANT EXECUTE ANY PROGRAM TO PRODUCTION ;
GRANT GRANT ANY PRIVILEGE TO PRODUCTION ;
GRANT CREATE ANY EVALUATION CONTEXT TO PRODUCTION ;
GRANT EXECUTE ANY ASSEMBLY TO PRODUCTION ;
GRANT CREATE CUBE BUILD PROCESS TO PRODUCTION ;
GRANT EXECUTE ANY RULE SET TO PRODUCTION ;
GRANT CREATE SYNONYM TO PRODUCTION ;
GRANT ALTER ANY TABLE TO PRODUCTION ;
GRANT CREATE VIEW TO PRODUCTION ;
GRANT EXECUTE ANY LIBRARY TO PRODUCTION ;
GRANT CREATE RULE SET TO PRODUCTION ;
GRANT CREATE ANY CLUSTER TO PRODUCTION ;
GRANT CREATE TYPE TO PRODUCTION ;
GRANT EXECUTE ANY EVALUATION CONTEXT TO PRODUCTION ;
GRANT CREATE PUBLIC SYNONYM TO PRODUCTION ;
GRANT CREATE ANY MINING MODEL TO PRODUCTION ;
GRANT CREATE ANY RULE SET TO PRODUCTION ;
GRANT CREATE MEASURE FOLDER TO PRODUCTION ;
GRANT CREATE ROLE TO PRODUCTION ;
GRANT CREATE ANY CONTEXT TO PRODUCTION ;
GRANT CREATE ANY SYNONYM TO PRODUCTION ;
GRANT CREATE ANY CUBE DIMENSION TO PRODUCTION ;
GRANT CREATE ANY TABLE TO PRODUCTION ;
GRANT CREATE SESSION TO PRODUCTION ;
GRANT CREATE PUBLIC DATABASE LINK TO PRODUCTION ;
GRANT UNLIMITED TABLESPACE TO PRODUCTION ;
GRANT CREATE ANY EDITION TO PRODUCTION ;
GRANT CREATE ANY ASSEMBLY TO PRODUCTION ;
GRANT CREATE INDEXTYPE TO PRODUCTION ;
GRANT GRANT ANY ROLE TO PRODUCTION ;
GRANT CREATE MATERIALIZED VIEW TO PRODUCTION ;
GRANT DROP TABLESPACE TO PRODUCTION ;
GRANT DELETE ANY TABLE TO PRODUCTION ;
GRANT CREATE PROFILE TO PRODUCTION ;
GRANT CREATE ANY MEASURE FOLDER TO PRODUCTION ;
GRANT CREATE ANY TYPE TO PRODUCTION ;
GRANT CREATE CUBE TO PRODUCTION ;
GRANT CREATE DATABASE LINK TO PRODUCTION ;

COMMIT;

-- QUOTAS

Now move in to CIM console. Here we can enter Database configuration details.

Enter following details.

Username : PUBLISHING
password   : ATGtraining123 and re-enter same password
hostname : localhost
port           : 1521
database   : xe

Just Enter to Accept JDBC Connectivity URL

Enter the path of Oracle JDBC driver path : /common/Oracle/Middleware/wlserver_10.3/server/lib/ojdbc6.jar

Just Enter to accept given JNDI. That is ATGPublishingDS.

Enter T to validate Publishing user account.

Step 1: view

Validation message should be successful one.

Step 1: view

Enter S to create Publishing Schema under Publishing User.

Enter C to confirm the operation.

Step 1: view

Enter i to import sample dataset.

Again Enter i to confirm the operation.

Step 1: view

Provide Admin password which is the common password we used.

That is ATGtraining123

Ideally it should be same password given by beginning of the CIM.

Step 1: view

Data for the Publishing schema will be imported under 14 stages.

NEXT we have to create Production schema and import data for the Production schema.

Enter O to configure another Database configuration

Enter C to select Production schema

Enter C to provide Production user account details.

Step 1: view

Enter 2 create fresh connection

Enter 1 to select Oracle database connectivity.

Step 1: view

Enter Production database user account details

Username : PRODUCTION

password : ATGtraining123 and re-enter same password
hostname : localhost
port : 1521
database : xe

Then hit enter to accept default Database connectivity URl.

Then provide driver JAR file path : /common/Oracle/Middleware/wlserver_10.3/server/lib

Enter T to check validation of Production database.

Step 1: view

Enter S to create Production schema

Enter C to confirm the process.

Step 1: view

Enter i to import reference data for the Production database.

Enter i to confirm the process.

Step 1: view

Once we complete Database imports, Then we have to create two server instances called Production and Publishing.

Enter O to navigate upper level of the CIM.

Enter D to end of successful completions of Database configurations

Enter 2 to select Server Instance configurations

Step 1: view

Enter P to select Publishing server.

Enter P to confirm the server instance creation

Step 1: view

Enter Production Lock Server Hostname [[localhost]] > Just Enter, it will take default

localhost

   Enter Production Lock Server Port [[9012]] > Just Enter, it will take default 9012

   Enter CAS Hostname [[localhost]] > Just Enter, it will take default localhost

   Enter CAS Port [[8500]] > Just Enter, it will take default 8500

   Enter EAC Hostname [[localhost]] > Just Enter, it will take default localhost

   Enter EAC Port [[8888]] > Just Enter, it will take default 8888

   Enter Endeca Base Application Name [[ATG]] > CRS

   Enter the Fully-qualified Workbench Hostname, Including Domain > localhost
   Enter Workbench Port Number [[8006]] > Just Enter, it will take default 8006

   Enter Default MDEX Host Name [[localhost]] > Just Enter, it will take default localhost

   Enter Default MDEX Port Number [[15000]] > Just Enter, it will take default 15000

Step 1: view

Enter i to begin Weblogic server instance manager.

Enter a to create Weblogic server instance for Publishing server

Enter 1 to finish the server instance creation with in built LOCK Manager.

Lock Managers will be useful when new deployment on publishing server and production server. The minimum downtime with proper synchronization of new changes will be applied using these LOCK managers.

Step 1: view

Enter C for custom port bindings

Enter 2 to select correct port binding schema

Enter HTTP Port [[7103]] > Just Enter, it will take default 7103

Enter HTTPS Port [[7104]] > Just Enter, it will take default 7104

Enter Site HTTP Port [[7103]] > Just Enter, it will take default 7103

Enter RMI Port [[8861]] > Just Enter, it will take default 8861

Enter DRP Port [[8851]] > Just Enter, it will take default 8851

Enter File Deployment Port [[8811]] > Just Enter, it will take default 8811

Enter File Synchronization Deploy Server Port [[8816]] > Just Enter, it will take default

8816

Enter Lock Server Port [[9010]] > Just Enter, it will take default 9010

Step 1: view

Enter o to create another server instance.

Enter s to create Production server instance.

Step 1: view

Enter i to begin with Instance Manager

Enter a to add Production Server Instance

Enter 1 to create Production server instance with LOCK manager.

Step 1: view

Enter server name as ATGProduction

Enter U to select default port bindings

Enter HTTP Port [[7003]] > Just Enter, it will take default 7003

Enter HTTPS Port [[7004]] > Just Enter, it will take default 7004

Enter Site HTTP Port [[7003]] > Just Enter, it will take default 7003

Enter RMI Port [[8860]] > Just Enter, it will take default 8860

Enter DRP Port [[8850]] > Just Enter, it will take default 8850

Enter File Deployment Port [[8810]] > Just Enter, it will take default 8810

Enter Lock Server Port [[9012]] > Just Enter, it will take default 9012

Step 1: view

Enter d to completion of server instance creation.

Step 1: view

Enter o to jump to previous stage

Enter d to completion of server instance creation

Enter 2 to select server instance configurations

Step 1: view

Enter p to select Publishing server

Enter d to deploy CRS ( Commerce Reference Store ) on Publishing server.

Enter a to avoid preview managers.

Step 1: view

Then create folder called APPS in Endeca location /common/endeca

This APPS folder will use as deployment locations for Endeca search engine integration.

cd ~

mkdir /common/endeca/APPS

Step 1: view

Enter to accept default application name "CRS"

Then provide newly created folder path. /common/endeca/APPS
Enter to accept default values for following parameters.

Enter the CRS Endeca App Name [[CRS]] > Just enter, It will take default value CRS

Enter the CRS Endeca App Deployment Path > /common/endeca/APPS

Enter the EAC Port Number [[8888]] > Just enter, It will take default value 8888

Enter the Dgraph Port Number [[15000]] > Just enter, It will take default value 15000

Enter the Authoring Dgraph Port Number [[15002]] > Just enter, It will take default value

15002

Enter the Log Server Port Number [[15010]] > Just enter, It will take default value 15010

Enter the CAS Hostname [[localhost]] > Just enter, It will take default value localhost

Enter the CAS Port Number [[8500]] > Just enter, It will take default value 8500

Enter the CAS Path > /common/endeca/CAS/3.1.2

Enter the CAS Version [[3.1.2]] > Just enter, It will take default value 3.1.2

Enter the Language Code [[en]] > Just enter, It will take default value en

Enter the Workbench Hostname [[localhost]] > Just enter, It will take default value localhost

Enter the Workbench Port Number [[8006]] > Just enter, It will take default value 8006

Enter the path to the Endeca ToolsAndFrameworks directory

(including version number) > /common/endeca/ToolsAndFrameworks/3.1.2

Enter the path to the Endeca MDEX directory

(including version number) > /common/endeca/MDEX/6.4.1

Enter the path to the Endeca Platform Services directory

(including version number) > /common/endeca/PlatformServices/6.1.3

Step 1: view

Enter D to deploy the application.

Step 1: view

Do not initialize until mandatory changes required in files of /common/endeca/APPS

Navigate to /common/endeca/APPS/CRS/control

Open initialize_services.sh

cd /common/endeca/APPS/CRS/control

gedit initialize_services.sh

Then search on following key word "set_media".

Then comment that line by adding "#" to beginning of the line.

Step 1: view

Then brows same folder /common/endeca/APPS/CRS/control

Open each and every file and change very first line from #!/bin/sh to #!/bin/bash

Re-do same thing to all files in /common/endeca/APPS/CRS/control

Step 1: view

Do same thing in to all files located in /common/endeca/APPS/CRS/control

Go to CIM console.

Enter i to initialize the application

Step 1: view

Next we have to build Production and Publishing EAR files and deploy them in to Production and Publishing server instances.

Enter m to navigate main menu.

Enter 3 to begin build and deployment process.

Enter a to select Production server instance

Enter ATGProduction.ear as name of the EAR file of Production deployment

Step 1: view

Enter D to create ATGProduction server instance and deployment of ATGProduction.ear file in to ATGProduction server instance.

Step 1: view

Enter R to make registrations of data source for ATGProduction server instance.

Step 1: view

Enter A to add Oracle Database connectivity driver.

Enter U to update server environments.

Step 1: view

Enter P to complete post deployment process.

Enter W to make JVM optimizations

Enter U to update startup scripts.

Step 1: view

Enter C to copy additional jar files.

Again Enter C to confirm previous operation.

Enter D to finish the deployment process of ATGProduction.ear

Step 1: view

Enter o to create ATGPublishing server instance and it's build file ATGPublishing.ear

Enter p to create ATGPublishing server instance

Enter EAR file name as ATGPublishing.ear

Step 1: view

Enter D to create ATGPublishing server instance and it's deployment file called ATGPublishing.ear

Step 1: view

Enter R to register data sources for ATGPublishing server.

Step 1: view

Enter A to add Oracle JDBC driver to ATGPublishing server instance.

Enter U to update environmental variables.

Step 1: view

Enter p to complete post deployment process.

Enter c to copy additional jar files

Enter c to confirm previous operation.

Step 1: view

Enter d to complete the process of creating ATGPublishing server instance and deployment of it's war file.

Enter m to jump main menu.

Step 1: view

Enter q to quit from entire CIM console.

Step 1: view

Now we have successfully deployed CRS application in Weblogic server.

Next we have to some addition configurations.

Open the folder located at

/common/ATG10.2/home/servers/ATGPublishing/localconfig/atg/endeca/assembler

Then create new property file called "AssemblerTools.properties"

Then add this entry loggingDebug=true

Step 1: view

Then copy it to production level at

/common/ATG10.2/home/servers/ATGProduction/localconfig/atg/endeca/assembler

Step 1: view

Create new folder called "search" at
/common/ATG10.2/home/servers/ATGPublishing/localconfig/atg

Step 1: view

Then create property file called "SynchronizationInvoker.properties" in newly created folder "search" at
/common/ATG10.2/home/servers/ATGPublishing/localconfig/atg/search.

Then add following entries.

host=localhost
port=8860

Step 1: view

Then brows the page of admin console. http://localhost:7001/console/

Then go to deployments -> Then tick both deployment EAR files ->
Then click drop-down called "start". -> Then select "Servicing all requests"

Step 1: view

Then go to Data Sources at admin page.

Then goto Data Sources -> Then click on data source called "ATGProductionDS" ->
Then click configuration tab -> Add maximum capacity as 40.

Then click save

Step 1: view

Then save configurations

Step 2: view

Then brows the page of admin console. http://localhost:7001/console/

Then go to Data Sources -> Then click on data source called "ATGPublishingDS" ->
Then click configuration tab -> Add maximum capasity as 40.

Step 1: view

Then click save

Step 2: view

Then brows the page of admin console. http://localhost:7001/console/

Select JTA -> change timeout to 30000.

Then save.

Step 1: view

Now we have to start Production and Publishing server instances.

As a best practice, it is really good if we have 3 seperate shell files to start

1. Weblogic Admin server start up script - weblogicAdmin.sh
2. Production server instance - crsProduction.sh
3. Publishing server instance - crsPublishing.sh

Create 3 empty files in /common using following commands and give them execution permissions.

cd /common/

touch weblogicAdmin.sh
chmod 777 weblogicAdmin.sh
touch crsProduction.sh
chmod 777 crsProduction.sh
touch crsPublishing.sh
chmod 777 crsPublishing.sh

Step 1: view

Open weblogicAdmin.sh

Add following two lines.

#!/bin/bash

/common/Oracle/Middleware/user_projects/domains/base_domain/bin/startWebLogic.sh

Save and exit.

Step 1: view

Open crsProduction.sh

Add following two lines.

#!/bin/bash

/common/Oracle/Middleware/user_projects/domains/base_domain/bin/startManagedWebLogic.sh ATGProduction

Save and Exit

Step 1: view

Open crsPublishing.sh

Add following two lines.

#!/bin/bash

/common/Oracle/Middleware/user_projects/domains/base_domain/bin/startManagedWebLogic.sh ATGPublishing

Save and Exit

Step 1: view

In this moment you may have two tabs to start Endeca and Manual start up of Weblogic Admin console.
No need to close those two tabs.

Now open a new tab in current terminal.
Run ATGProduction server instance

cd /common/
./crsProduction.sh

Provide Weblogic admin username and password

username - weblogic
password - ATGtraining123

Step 1: view

Production server instance should be startup like bellow.

Step 1: view

Now open a new tab in current terminal.
Run ATGPublishing server instance

cd /common/
./crsPublishing.sh

Provide Weblogic admin username and password

username - weblogic
password - ATGtraining123

Step 1: view

Publishing server instance should be startup like bellow.

Step 1: view

Next we need to complete the full content deployment.

Brows Business Control Center. http://localhost:7103/atg/bcc

username - admin
password - ATGtraining123

Step 1: view

Then brows Content Administration -> Then CA Console

Step 1: view

Then Click Configuration -> Then Add Site

Step 1: view

Then enter following information.

    1. Site Name: Production
    2. Site Initialization Options: Do a full deployment
    3. Site Type: Workflow target

Then map following repository mappings.

1./atg/commerce/catalog/SecureProductCatalog

   To

/atg/commerce/catalog/ProductCatalog_production

2./atg/commerce/claimable/SecureClaimableRepository

To

/atg/commerce/claimable/ClaimableRepository_production

3./atg/commerce/locations/SecureLocationRepository

To

/atg/commerce/locations/LocationRepository_production

4./atg/commerce/pricing/priceLists/SecurePriceLists

     To

     /atg/commerce/pricing/priceLists/PriceLists_production

5. /atg/multisite/SecureSiteRepository

      To

   /atg/multisite/SiteRepository_production

6. /atg/seo/SecureSEORepository

   To

   /atg/seo/SEORepository_production

7. /atg/store/stores/SecureStoreTextRepository

      To

   /atg/store/stores/StoreTextRepository_production

8. /atg/userprofiling/PersonalizationRepository


      To

/atg/userprofiling/PersonalizationRepository_production

Then click save changes.

Step 1: view

Then go to Agent Tab and then go to Add Agent to site.

Step 1: view

Agent Name : ProdAgent

Add both available sites to include sites.
RMI URL : rmi://localhost:8860/atg/epub/AgentTransport

Step 1: view

Then click save changes.

Then go to Configuration -> Then click Make Changes Live

Step 1: view

Then click Do a full deployment -> Then click Make Changes Live.

Step 1: view

Then click Overview -> Then Click on site name ( Production )

Step 1: view

Then it will brings you the Full content deployment process.
In this process it will make search engine indexing process.

In this moment please don't run unnecessary new programs as computer consumes higher memory.

In this time it will begin the indexing process for the sample application ( Commerce Reference Application 10.2 )

Beep sound will generate in the middle of the indexing process.

Step 1: view

This will take 15 minutes for following hardware configurations

Operating System : CentOS, Redhat Linux, Fedora, Ubuntu or Mint Linux

Processor : I5 Intel core, 2.4 GHz, x86_64

RAM : 4GB

This will take 6 minutes for following hardware configurations

Operating System : CentOS, Redhat Linux, Fedora, Ubuntu or Mint Linux

Processor : I3 Intel core, 2.4 GHz, x86_64

RAM : 8GB

So you better keep this process for 30 minutes.
Then it will end-up with EITHER success or failures.

Once this 30 minutes elapsed, above indexing process end-up with successfully or failures. Begin next task.

Navigate to /common/endeca/APPS/CRS/control
Run promote_content.bat

Step 1: view

Then Login to Dynamo Admin Console located at
http://localhost:7103/dyn/admin

For the Weblogic it will ask password for two times including Dynamo Admin Console and Weblogic Admin Console.

First prompt : ( For Dynamo Admin Console )

Username - admin
Password - ATGtraining123

Step 1: view

Second prompt : ( For Weblogic Admin Console )

Username - weblogic
Password - ATGtraining123

Step 1: view

Then it will show ATG Dynamo Admin Console.

Step 1: view

Then click on

Component Browser -> atg -> commerce -> endeca -> index -> ProductCatelogSimpleIndexingAdmin

Then it will show the progress of indexing process.

There may be THREE situations can be occurred. Two situations need to be treated as FAILED situations of indexing process. Other one is SUCCESSED one.

1. Situation 1 - Totally Pending.

Step 1: view

Solution :

1. Shut down Production server instance

2. Shut down Publication server instance

3. Shut down Weblogic Admin console

4. Shutdown Endeca services

5. Restart entire computer

6. Start Endeca service

7. Start Production server instance

8. Start Publication server instance

9. Do not start Weblogic Admin console

10. Login to ATG Dynamo Admin page ( http://localhost:7103/dyn/admin )

11. Manually click Baseline Index button located at

Component Browser -> atg -> commerce -> endeca -> index ->

ProductCatelogSimpleIndexingAdmin

2. Situation 2 - Partially Completed with Failures.

Step 1: view

Solution :

1. Shut down Production server instance

2. Shut down Publication server instance

3. Shut down Weblogic Admin console

4. Shutdown Endeca services

5. Restart entire computer

6. Start Endeca service

7. Start Production server instance

8. Start Publication server instance

9. Do not start Weblogic Admin console

10. Login to ATG Dynamo Admin page ( http://localhost:7103/dyn/admin )

11. Manually click Baseline Index button located at

Component Browser -> atg -> commerce -> endeca -> index ->

ProductCatelogSimpleIndexingAdmin

3. Situation 3 - All five indexes completed successfully.

Step 1: view

The Production server console

Step 1: view

Once it successfully finished it's all indexes, then you can brows the our ultimate GOAL.

That is http://localhost:7003/crs/storeus

This is the complete deployment process of ATG sample application.

The content of this web page comes through Endeca integration happened in /common/endeca/APPS/CRS. It makes integration between back-end repositories and the web site.

Check weather search engine is working fine. You can search based on a key word.

Ex : - belt

Cheers

Saminda Konkaduwa

Power of Dream

Saturday, September 7, 2013

Linux Installation of Oracle eCommerce ATG 10.2 with Commerce Reference Sample Application