ATG 11.3 Setup in Ubuntu

Create a VM for Linux with 4G RAM and 200GB HDD

Install Ubuntu by default

Setup your System for the Oracle Installation

Export the zip files, a database folder will be extracted

unzip linux.x64_11gR2_database_1of2.zip

unzip linux.x64_11gR2_database_2of2.zip

Create Oracle and DBA groups

sudo groupadd oinstall

sudo groupadd dba

Create Oracle user home and account. Use the password 'oracle'

sudo mkdir -p /opt/oracle
sudo useradd -g oinstall -G dba  -d /opt/oracle -s /bin/bash oracle
sudo passwd oracle
sudo chown -R oracle:oinstall /opt/oracle

Edit kernel parameters editing /etc/sysctl.conf and adding at the bottom of the file the following:

#######################################

# Kernel Parameters for Oracle DB

########################################

kernel.sem = 250 32000 100 128

kernel.shmall = 2097152
kernel.shmmni = 4096
# Replace kernel.shmmax with the half of your memory in bytes
# if lower than 4Go minus 1

# 1073741824 is 1 GigaBytes

kernel.shmmax=2073741824

# Try sysctl -a | grep ip_local_port_range to get real values

net.ipv4.ip_local_port_range = 32768  60999

net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

# Max value allowed, should be set to avoid IO errors
fs.aio-max-nr = 1048576
# 512 * PROCESSES / what really means processes ?
fs.file-max = 6815744

# To allow dba to allocate hugetlbfs pages
# 1001 is your oinstall group, id. grep oinstall /etc/group will give this value
vm.hugetlb_shm_group = 1001

Now set these mentioned parameters executing this:

sudo sysctl -p

Update /etc/security/limits.conf

sudo gedit /etc/security/limits.conf

And add these parameters

#######################################

# Oracle DB Parameters

########################################

oracle          soft    nproc  2047
oracle          hard    nproc  16384
oracle          soft    nofile  1024
oracle          hard    nofile  65536
oracle          soft    stack  10240

Review that /etc/pam.d/login contains 'session    required   pam_limits.so'

sudo gedit /etc/pam.d/login

Update /etc/profile

sudo gedit /etc/profile

And add the following content at the bottom of the file:

if [ $USER = "oracle" ]; then
        if [ $SHELL = "/bin/ksh" ]; then
              ulimit -p 16384
              ulimit -n 65536
        else
              ulimit -u 16384 -n 65536
        fi
fi

You need to have the latest package updates of your distribution, execute this:

sudo apt-get update

Add these packages to your distribution one by one

sudo apt-get install alien
sudo apt-get install autoconf
sudo apt-get install automake
sudo apt-get install autotools-dev
sudo apt-get install binutils
sudo apt-get install bzip2
sudo apt-get install doxygen
sudo apt-get install elfutils
sudo apt-get install expat
sudo apt-get install gawk
sudo apt-get install gcc
sudo apt-get install gcc-multilib
sudo apt-get install g++-multilib
sudo apt-get install ia32-libs
sudo apt-get install ksh
sudo apt-get install less
sudo apt-get install lesstif2
sudo apt-get install lesstif2-dev
sudo apt-get install lib32z1
sudo apt-get install libaio1
sudo apt-get install libaio-dev
sudo apt-get install libc6-dev
sudo apt-get install libc6-dev-i386
sudo apt-get install libc6-i386
sudo apt-get install libelf-dev
sudo apt-get install libltdl-dev
sudo apt-get install libmotif4
sudo apt-get install libodbcinstq4-1 libodbcinstq4-1:i386
sudo apt-get install libpth-dev
sudo apt-get install libpthread-stubs0
sudo apt-get install libpthread-stubs0-dev
sudo apt-get install libstdc++5
sudo apt-get install lsb-cxx
sudo apt-get install make
sudo apt-get install openssh-server
sudo apt-get install pdksh
sudo apt-get install rlwrap
sudo apt-get install rpm
sudo apt-get install sysstat
sudo apt-get install unixodbc
sudo apt-get install unixodbc-dev
sudo apt-get install unzip
sudo apt-get install x11-utils

sudo apt-get install zlibc

Create a the following symbolic link to prevent an error:

sudo ln -s /usr/lib/x86_64-linux-gnu /usr/lib64

Execute the following to prevent the error: 'lib//libagtsh.so: undefined reference to `nnfyboot' in make: rdbms/lib/dg4odbc] Error 1'

sudo ln -sf /bin/bash /bin/sh
sudo ln -s /usr/bin/awk /bin/awk
sudo ln -s /usr/bin/rpm /bin/rpm
sudo ln -s /usr/bin/basename /bin/basename

Execute the following to prevent error: '/lib64/libgcc_s.so.1: File or directory does not exists, while creating lib/liborasdkbase.so.11.1 in ins_rdbms.mk'

cd /lib64

sudo ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 .

Reboot your Operative System and login as oracle and create the .bashrc file

sudo su - oracle
cd

touch .bashrc

ln -s .bashrc .bash_profile

Add unmask 022 into the .bashrc file

vi .bashrc

Once into the file type "i" to enable the insert mode and paste "unmask 022" then save the file pressing "esc" key, then type ":wq"

Execute the .bashrc file or Open and Close the terminal

source .bashrc

Install Oracle 11g-R2

Allow other user to connect to your session

xhost +

Then login as oracle user

su - oracle

Go to your "database" folder where you extracted your Oracle Install zip files and execute:

export DISPLAY=:0

./runInstaller

Then a visual Installer will be displayed, unckeck "I wish to receive security..." and click Next and Yes in the confirm dialog

  

Select "Create and configure a database" and click Next

Select "Desktop Class" and click Next

Change the Database edition to 'Standard Edition' and set the password to 'Password1' and click Next

Use the default Inventory PAth and the oraInventory group name will be 'oinstall'

Select checkbox 'Ignore All' and click Next

Click Finish in the Summary page.

The Installation process will start and probably you will see this error: "Error in invoking target 'install' of makefile '/opt/oracle/app/oracle/product/11.2.0/dbhome_1/ctx/lib/ins_ctx.mk'."

If this is the case, open a new Terminal and login as oracle user then execute these commands:

su - oracle

export ORACLE_HOME=/opt/oracle/app/oracle/product/11.2.0/dbhome_1

cd $ORACLE_HOME/lib

ln -s libclient11.a libagtsh.a

export ORACLE_HOME=/opt/oracle/app/oracle/product/11.2.0/dbhome_1

sed -i 's/^\(\s*\$(MK_EMAGENT_NMECTL)\)\s*$/\1 -lnnz11/g' $ORACLE_HOME/sysman/lib/ins_emagent.mk

sed -i 's/^\(TNSLSNR_LINKLINE.*\$(TNSLSNR_OFILES)\) \(\$(LINKTTLIBS)\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/network/lib/env_network.mk

sed -i 's/^\(ORACLE_LINKLINE.*\$(ORACLE_LINKER)\) \(\$(PL_FLAGS)\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/rdbms/lib/env_rdbms.mk

sed -i 's/^\(\$LD \$LD_RUNTIME\) \(\$LD_OPT\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/bin/genorasdksh

sed -i 's/^\(\s*\)\(\$(OCRLIBS_DEFAULT)\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/srvm/lib/ins_srvm.mk

Then go back to your visual Oracle Installer and click Continue to skip the error. You should not see any other error if you do this correctly

After that, you will need to execute some scripts as root user

Open a new Terminal for that and execute them (the last command will ask you to specify the pathname of the local bin directory, use the defualt)

sudo -s

/opt/oracle/app/oraInventory/orainstRoot.sh

/opt/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh

Then go back to the visual Oracle Installer en click Ok

It will show you the URL to access to the Enterprise Manager Database Control (orcl)  https://localhost:1158/em

Finally open a new Terminal and execute this:

sudo su - oracle

cd

vi .bashrc

Add to the bottom of the file these lines:

export ORACLE_HOME=/opt/oracle/app/oracle/product/11.2.0/dbhome_1

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

export PATH=$PATH:$ORACLE_HOME/bin

Save the file and done!

Database Schemas and Users

Create 4 schemas for the CRS and 4 users with the same name into the database using Oracle SQL Developer

CREATE USER CRS_CORE IDENTIFIED BY CRS_CORE;

CREATE USER CRS_CATA IDENTIFIED BY CRS_CATA;

CREATE USER CRS_CATB IDENTIFIED BY CRS_CATB;

CREATE USER CRS_PUB IDENTIFIED BY CRS_PUB;

CREATE USER CRS_AGENT IDENTIFIED BY CRS_AGENT;

ALTER USER CRS_CATA IDENTIFIED BY CRS_CATA;

ALTER USER CRS_CATB IDENTIFIED BY CRS_CATB;

ALTER USER CRS_CORE IDENTIFIED BY CRS_CORE;

ALTER USER CRS_PUB IDENTIFIED BY CRS_PUB;

ALTER USER CRS_AGENT IDENTIFIED BY CRS_AGENT;

GRANT CREATE SESSION TO CRS_CATA, CRS_CATB, CRS_CORE, CRS_PUB, CRS_AGENT

Install Java JDK 1.8.0_121

Unzip the file tar.zg file and move the folder to /opt/java

tar -xvzf jdk-8u121-linux-x64.tar.gz

sudo -s

mkdir /opt/java

cp -R /home/emede/Downloads/jdk1.8.0_121 /opt/java

chown emede -R /opt/java/

Then edit the /etc/profile file 

sudo vi /etc/profile

And add this content at the bottom of the file

JAVA_HOME=/opt/java/jdk1.8.0_121

PATH=$PATH:$HOME/bin:$JAVA_HOME/bin

export JAVA_HOME

export PATH

Now Uninstall the OpenJDK in case you have it

sudo apt-get purge openjdk-\*

Then notify to your system about the new JDK that you have installed

sudo update-alternatives --install "/usr/bin/java" "java" "/opt/java/jdk1.8.0_121/bin/java" 1

sudo update-alternatives --install "/usr/bin/javac" "javac" "/opt/java/jdk1.8.0_121/bin/javac" 1

sudo update-alternatives --install "/usr/bin/javaws" "javaws" "/opt/java/jdk1.8.0_121/bin/javaws" 1

Make this JDK the default

sudo update-alternatives --set java /opt/java/jdk1.8.0_121/bin/java

sudo update-alternatives --set javac /opt/java/jdk1.8.0_121/bin/javac

sudo update-alternatives --set javaws /opt/java/jdk1.8.0_121/bin/javaws

Force to load the /etc/profile executing this

source /etc/profile

JBoss EAP 7.0 Installation

Unzip JBoss EAP 7.0.0 file

sudo -s

mkdir /opt/jboss

unzip /home/emede/Downloads/jboss-eap-7.0.0.zip -d /opt/jboss

chown emede -R /opt/jboss

Endeca 11.3.0 Installation

Endeca is a set of 4 softwares:

• Oracle Commerce MDEX Engine 11.3.0
• Oracle Commerce Guided Search Platform Services 11.3.0
• Oracle Commerce Content Acquisition System 11.3.0
• Oracle Commerce Experience Manager Tools and Frameworks 11.3.0

Please verify you have these utilities in /bin directory.

basename
cat
chgrp
chown
date
dd
df
mkdir
more
rm
sed
tar
true

Also verify you have these utilities in /usr/bin

awk
cksum
cut
dirname
expr
gzip
head
id
printf
tail
tr
wc
which

If you need to add a symbolic link in /usr/bin/ that points to /bin/  execute ln -s <path> <newLink>:

sudo -s

ln -s /bin/gzip* /usr/bin/gzip

Go to the folder where you unzipped the file and execute

./OCmdex11.3.0-Linux64_1186050.bin

In progress....