CRS 11.1 installation on CentOS7

CRS 11.1 Installation Requirement

(Oracle Commerce 11.1.0.1)

Sharing is Caring...

Requirements:

	Vendor	Version
Application Server	Oracle WebLogic (WLS)(Generic with coherence)	12.1.2
Database	Oracle	11g (Release 2)
Operating System	Linux	centOS 7 (64 bit)
JDBC Driver(contain in oracle)	Oracle Thin	11.2.0.3, 12.1.0.1.0
JDK	Oracle Java	1.7.0_72 (64-bit)
Browsers	Adobe Flash Player Firefox	14.0 24 ESR
Sql Developer	-	3.0.X

Endeca	version
Platform Services	11.1.0
MDEX	6.5.1
Tools and Frameworks	11.1.0
CAS	11.1.10

TIP:.Before starting to install any packages make sure you have all packages with right version otherwise it will fail further installation.

CRS Installation guide…

Tips:

1. Install all softwares with non root user this user must have Admin Privilege.
2. create common dir under / ( i.e. /common) and use this dir to install all softwares.
3. use right method to remove installed software.
4. Before starting to installation of CRS 11.1 make sure that you have all required softwares(mentioned in CRS 11.1 requirements) with proper version with you.
5. keep all softwares in /common/downloads directory.

Prerequisite Installations:

1. Install glibc , dos2unix,unix2dos  packages it is required by endeca PlatformServices to work properly
1. sudo yum install glibc.i686
2. sudo yum install dos2unix
3. sudo yum install unix2dos
2. hit hostname on terminal copy that hostname
3. open /etc/hosts
4. copy the line as shown in that file

<ipaddress> <hostname> localhost

eg- 192.168.1.145 hostname localhost

Installation Overview-

1. Install jdk (mentioned version)
2. Install weblogic server (mentioned version)
3. Install ATG platform(mentioned version)
4. Install CRS (mentioned version)
5. Install Endeca engine(mentioned version)
6. Install Oracle Database(mentioned version)
7. Install SQL Developer
8. Starting CIM...

1.Install JDK

1. extract jdk package from /common/download
1. tar -zxvf <jdkpkg>
2. copy extracted dir to /common
3. open  ~/.bash_profile dir using vi ~/.bash_profile
4. copy PATH=$PATH:/common/jdk1.7.0_72/bin:/common/jdk1.7.0_72/jre/bin/  save it
5. on terminal hit . ~/.bash_profile
6. now to check if environment for java is set or not type
1. java -version and javac -version , correct version must be displayed

Tip: when you open new terminal always hit these two commands to check if java environment is set or not if not then hit . ~/.bash_profile and check it again

if correct version is not displaying it means your centos is having jdk installed already to uninstall go to Applications-->SystemTools-->Softwares-->search for openjdk and uninstall all jdk pkgs and follow from step no 5.

2.Install Weblogic

1. move to /common/downloads
2. type java -jar <wlspkg.jar>
1. this command will not run if java environment variable is not set
3. instead of /home/username or /home use /common path
4. select complete installation option
5. after installation it will ask to create domain so continue with creating domain.

3.Install ATG Platform

1. move to /common/downloads dir
2. unzip the OCPlatform zip using unzip <OCPlatform***.zip>
3. chmod 777 <unzipped OCPlatformbinfile.bin>
4. to run this type ./<unzipped OCPlatformbinfile.bin>
1. Type index number of language and press enter to continue.
2. press enter to continue
3. Press enter several times to go down and Accept license and provide installation path as /common/ATG11.1
4. Type Y for Yes to confirm the installation location.
5. Press enter to select all features to install.
6. Select application server as Oracle WebLogic - option 4
7. Provide Weblogic Middleware directory path  /common/Oracle/Middleware
8. Provide WebLogic home directory path        /common/Oracle/Middleware/wlserver/
9. Provide WebLogic domain directory path     /common/Oracle/Middleware/user_projects/domains/wl_server
10. Provide JDK Home directory                          /common/jdk1.6.0_45
11. Provide WebLogic listen port as                     7001
12. Provide ATG RMI port as                          8860
5. Once installation done. press enter to exit the setup.
6. Now go to installation dir  and see the content of ATG framework. This is the ATG engine. There are lots of folders inside ATG installation.

4.Install CRS

1. Move to /common/downloads dir
2. To Unzip OCReference**.zip type unzip <OCReference**.zip>
3. chmod 777 <OCReferencebinfile name>
4. to execute binary type ./<OCReferencebinfile name>
5. Select language preference - select 2
6. Read license agreement  - Press enter and go down and read license agreement.  
7. Accept license agreement - Type Y for yes
8. Provide ATG installation location as /common/ATG11.1
9. Again confirm the installation location with Y
10. Read Pre-Installation Summary and say Y to install
11. Once installation done, press enter to exit.

Note: To check if ur CRS is installed go to ATG home dir(/common/ATG11.1) in this directory you can see CommerceReferenceStore dir

    this CommerceReferenceStore is nothing but the module as like another module on ATG stack.

5.Install Endeca engine(mentioned version)

1. MDEX
2. Platform Services (check if u have installed glibc.i686 if not install it)
3. Tools and Framework
4. CAS

1. MDEX

    1.Go to /common/downloads directory unzip MDEX file

    2.run MDEX setup as ./mdex<**>.sh --target /common

once installation is done it will ask to set environment variable .These environment variables are important to set to start Endeca service so copy that source command

and cat it as

cat source /common/endeca/MDEX/<***>/installer_sh.ini

copy all the content and create a script as startEndeca under /common

and paste all content in it

example:

#!/bin/bash

ENDECA_MDEX_ROOT=/common/endeca/MDEX/6.5.1

export ENDECA_MDEX_ROOT

PATH=$ENDECA_MDEX_ROOT/bin:$PATH

export PATH

save and exit

ii.    Platform Services

    1.Go to /common/downloads directory unzip Platform<**>.zip

    2.run Platform Services setup as OCPlatform<**>.bin --target /common

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

    4.Endeca HTTP service : 8888

    5.Shutdown port number of the Endeca HTTP service : 8090

    6.Endeca Control System : 8088

    7.Install Endeca Application Controller : Y

    8.MDEX Engine Path : /common/endeca/MDEX/6.5.1

    9.Install the reference implementations : Y

once installation is done it will ask to set environment variable .These environment variables are important to set to start Endeca service so copy that source command

and cat it as

cat source /common/endeca/Platform/<***>/installer_sh.ini

copy all the content and paste all content  in a script  startEndeca under /common

example

VERSION=11.1.0

BUILD_VERSION=11.1.0.842407

ARCH_OS=x86_64pc-linux

PRODUCT=IAP

ENDECA_INSTALL_BASE=/common

#  Environment variables required to run the Endeca Platform Services software.

ENDECA_ROOT=/common/endeca/PlatformServices/11.1.0

export ENDECA_ROOT

PERLLIB=$ENDECA_ROOT/lib/perl:$ENDECA_ROOT/lib/perl/Control:$ENDECA_ROOT/perl/lib:$ENDECA_ROOT/perl/lib/site_perl:$PERLLIB

export PERLLIB

PERL5LIB=$ENDECA_ROOT/lib/perl:$ENDECA_ROOT/lib/perl/Control:$ENDECA_ROOT/perl/lib:$ENDECA_ROOT/perl/lib/site_perl:$PERL5LIB

export PERL5LIB

PATH=$ENDECA_ROOT/bin:$ENDECA_ROOT/perl/bin:$ENDECA_ROOT/utilities:$PATH

export PATH

ENDECA_CONF=/common/endeca/PlatformServices/workspace

export ENDECA_CONF

#  ENDECA_REFERENCE_DIR points to the directory the reference implementations

#  are installed in.  It is not required to run any Oracle Commerce software.

ENDECA_REFERENCE_DIR=/common/endeca/PlatformServices/reference

export ENDECA_REFERENCE_DIR

save and exit

iii.Tools and framework

1. go to /common/downloads dir
2. unzip Tools and frameworks setup file
3. navigate to cd/Disk1/Install
4. run runInstaller.sh

The Welcome screen displays.

1. Click Next to begin the installation process.
2. Read the License Agreement and click I accept the License Terms and Export Restrictions.
3. If this is the first product that you have installed on this machine using the Oracle Universal Installer, the Specify Inventory directory screen appears.
1. Specify the directory where the Oracle Universal Installer should place inventory files and directories This directory contains permanent and product specific files.
2. Specify the UNIX group name that should own the base directory.You must specify a UNIX group name that has permission to update, install, and deinstall Oracle software.Members of this group must have write permissions to the base directory chosen.
3. Click Next
4. Choose the installation type, and click Next.The Complete Installation includes the reference application; the Minimal Installation does not.
5. Specify a name and a path where you want to install Tools and Frameworks. change path to /common/endeca/ToolsAndFrameworks_1 as your path.
6. Click Next.
7. Enter an admin password and confirm the password.The admin user is the default administrator user for Tools and Frameworks.
8. Click Next
9. When the Summary screen appears, click Install.
10. When the End of Installation screen appears, click Exit.

Note: Here no need to set any envt variable

iv. Install CAS

1. Go to /common/downloads dir
2. unzip CAS file
3. run OCCas<**>.sh as
1. ./OCCas<**>.sh --target /common
4. provide proper  paths
5. and after installation it will ask to set environment variables copy that source command cat it and copy all content in startEndeca.sh

example:

ENDECA_TOOLS_ROOT=/common/endeca/ToolsAndFrameworks_1/11.1.0

export ENDECA_TOOLS_ROOT

ENDECA_TOOLS_CONF=/common/endeca/ToolsAndFrameworks_1/11.1.0/server/workspace

export ENDECA_TOOLS_CONF

after this copy all start scripts as shown below

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

/common/endeca/ToolsAndFrameworks_1/11.1.0/server/bin/startup.sh

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

save and exit file

dont forget to put “&” on last line

TIP:make sure all path exists..

6.Install oracle database

7.install SQLDeveloper

open SQLDeveloper

connect to database as

username SYS AS SYSDBA

provide password

and fire following queries

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;

now create schema for four users which is required for crs setup

CREATE USER CRSPUB IDENTIFIED BY CRSPUB;

GRANT "RESOURCE" TO CRSPUB ;

GRANT "CONNECT" TO CRSPUB ;

GRANT ALTER TABLESPACE TO CRSPUB ;

GRANT CREATE USER TO CRSPUB ;

GRANT CREATE ANY OUTLINE TO CRSPUB ;

GRANT CREATE MINING MODEL TO CRSPUB ;

GRANT UPDATE ANY TABLE TO CRSPUB ;

GRANT CREATE TRIGGER TO CRSPUB ;

GRANT CREATE TABLESPACE TO CRSPUB ;

GRANT CREATE ASSEMBLY TO CRSPUB ;

GRANT CREATE SEQUENCE TO CRSPUB ;

GRANT SELECT ANY SEQUENCE TO CRSPUB ;

GRANT CREATE ANY SQL PROFILE TO CRSPUB ;

GRANT EXECUTE ANY OPERATOR TO CRSPUB ;

GRANT EXECUTE ANY TYPE TO CRSPUB ;

GRANT CREATE ANY DIRECTORY TO CRSPUB ;

GRANT CREATE TABLE TO CRSPUB ;

GRANT CREATE ANY INDEX TO CRSPUB ;

GRANT EXECUTE ASSEMBLY TO CRSPUB ;

GRANT SELECT ANY TABLE TO CRSPUB ;

GRANT CREATE OPERATOR TO CRSPUB ;

GRANT CREATE ANY PROCEDURE TO CRSPUB ;

GRANT CREATE ANY CUBE TO CRSPUB ;

GRANT EXECUTE ANY CLASS TO CRSPUB ;

GRANT CREATE ANY MATERIALIZED VIEW TO CRSPUB ;

GRANT SELECT ANY TRANSACTION TO CRSPUB ;

GRANT CREATE EXTERNAL JOB TO CRSPUB ;

GRANT INSERT ANY TABLE TO CRSPUB ;

GRANT CREATE LIBRARY TO CRSPUB ;

GRANT CREATE JOB TO CRSPUB ;

GRANT CREATE ANY OPERATOR TO CRSPUB ;

GRANT CREATE ANY LIBRARY TO CRSPUB ;

GRANT CREATE ANY SEQUENCE TO CRSPUB ;

GRANT CREATE CLUSTER TO CRSPUB ;

GRANT FORCE ANY TRANSACTION TO CRSPUB ;

GRANT CREATE EVALUATION CONTEXT TO CRSPUB ;

GRANT CREATE ANY CUBE BUILD PROCESS TO CRSPUB ;

GRANT EXECUTE ANY INDEXTYPE TO CRSPUB ;

GRANT CREATE ANY DIMENSION TO CRSPUB ;

GRANT CREATE ANY RULE TO CRSPUB ;

GRANT CREATE RULE TO CRSPUB ;

GRANT CREATE ANY VIEW TO CRSPUB ;

GRANT CREATE PROCEDURE TO CRSPUB ;

GRANT CREATE ANY TRIGGER TO CRSPUB ;

GRANT CREATE DIMENSION TO CRSPUB ;

GRANT CREATE ROLLBACK SEGMENT TO CRSPUB ;

GRANT CREATE CUBE DIMENSION TO CRSPUB ;

GRANT EXECUTE ANY RULE TO CRSPUB ;

GRANT EXECUTE ANY PROCEDURE TO CRSPUB ;

GRANT FORCE TRANSACTION TO CRSPUB ;

GRANT CREATE ANY JOB TO CRSPUB ;

GRANT CREATE ANY INDEXTYPE TO CRSPUB ;

GRANT EXECUTE ANY PROGRAM TO CRSPUB ;

GRANT GRANT ANY PRIVILEGE TO CRSPUB ;

GRANT CREATE ANY EVALUATION CONTEXT TO CRSPUB ;

GRANT EXECUTE ANY ASSEMBLY TO CRSPUB ;

GRANT CREATE CUBE BUILD PROCESS TO CRSPUB ;

GRANT EXECUTE ANY RULE SET TO CRSPUB ;

GRANT CREATE SYNONYM TO CRSPUB ;

GRANT ALTER ANY TABLE TO CRSPUB ;

GRANT CREATE VIEW TO CRSPUB ;

GRANT EXECUTE ANY LIBRARY TO CRSPUB ;

GRANT CREATE RULE SET TO CRSPUB ;

GRANT CREATE ANY CLUSTER TO CRSPUB ;

GRANT CREATE TYPE TO CRSPUB ;

GRANT EXECUTE ANY EVALUATION CONTEXT TO CRSPUB ;

GRANT CREATE PUBLIC SYNONYM TO CRSPUB ;

GRANT CREATE ANY MINING MODEL TO CRSPUB ;

GRANT CREATE ANY RULE SET TO CRSPUB ;

GRANT CREATE MEASURE FOLDER TO CRSPUB ;

GRANT CREATE ROLE TO CRSPUB ;

GRANT CREATE ANY CONTEXT TO CRSPUB ;

GRANT CREATE ANY SYNONYM TO CRSPUB ;

GRANT CREATE ANY CUBE DIMENSION TO CRSPUB ;

GRANT CREATE ANY TABLE TO CRSPUB ;

GRANT CREATE SESSION TO CRSPUB ;

GRANT CREATE PUBLIC DATABASE LINK TO CRSPUB ;

GRANT UNLIMITED TABLESPACE TO CRSPUB ;

GRANT CREATE ANY EDITION TO CRSPUB ;

GRANT CREATE ANY ASSEMBLY TO CRSPUB ;

GRANT CREATE INDEXTYPE TO CRSPUB ;

GRANT GRANT ANY ROLE TO CRSPUB ;

GRANT CREATE MATERIALIZED VIEW TO CRSPUB ;

GRANT DROP TABLESPACE TO CRSPUB ;

GRANT DELETE ANY TABLE TO CRSPUB ;

GRANT CREATE PROFILE TO CRSPUB ;

GRANT CREATE ANY MEASURE FOLDER TO CRSPUB ;

GRANT CREATE ANY TYPE TO CRSPUB ;

GRANT CREATE CUBE TO CRSPUB ;

GRANT CREATE DATABASE LINK TO CRSPUB ;

COMMIT;

CREATE USER CRSCORE IDENTIFIED BY CRSCORE;

GRANT "RESOURCE" TO CRSCORE ;

GRANT "CONNECT" TO CRSCORE ;

GRANT ALTER TABLESPACE TO CRSCORE ;

GRANT CREATE USER TO CRSCORE ;

GRANT CREATE ANY OUTLINE TO CRSCORE ;

GRANT CREATE MINING MODEL TO CRSCORE ;

GRANT UPDATE ANY TABLE TO CRSCORE ;

GRANT CREATE TRIGGER TO CRSCORE ;

GRANT CREATE TABLESPACE TO CRSCORE ;

GRANT CREATE ASSEMBLY TO CRSCORE ;

GRANT CREATE SEQUENCE TO CRSCORE ;

GRANT SELECT ANY SEQUENCE TO CRSCORE ;

GRANT CREATE ANY SQL PROFILE TO CRSCORE ;

GRANT EXECUTE ANY OPERATOR TO CRSCORE ;

GRANT EXECUTE ANY TYPE TO CRSCORE ;

GRANT CREATE ANY DIRECTORY TO CRSCORE ;

GRANT CREATE TABLE TO CRSCORE ;

GRANT CREATE ANY INDEX TO CRSCORE ;

GRANT EXECUTE ASSEMBLY TO CRSCORE ;

GRANT SELECT ANY TABLE TO CRSCORE ;

GRANT CREATE OPERATOR TO CRSCORE ;

GRANT CREATE ANY PROCEDURE TO CRSCORE ;

GRANT CREATE ANY CUBE TO CRSCORE ;

GRANT EXECUTE ANY CLASS TO CRSCORE ;

GRANT CREATE ANY MATERIALIZED VIEW TO CRSCORE ;

GRANT SELECT ANY TRANSACTION TO CRSCORE ;

GRANT CREATE EXTERNAL JOB TO CRSCORE ;

GRANT INSERT ANY TABLE TO CRSCORE ;

GRANT CREATE LIBRARY TO CRSCORE ;

GRANT CREATE JOB TO CRSCORE ;

GRANT CREATE ANY OPERATOR TO CRSCORE ;

GRANT CREATE ANY LIBRARY TO CRSCORE ;

GRANT CREATE ANY SEQUENCE TO CRSCORE ;

GRANT CREATE CLUSTER TO CRSCORE ;

GRANT FORCE ANY TRANSACTION TO CRSCORE ;

GRANT CREATE EVALUATION CONTEXT TO CRSCORE ;

GRANT CREATE ANY CUBE BUILD PROCESS TO CRSCORE ;

GRANT EXECUTE ANY INDEXTYPE TO CRSCORE ;

GRANT CREATE ANY DIMENSION TO CRSCORE ;

GRANT CREATE ANY RULE TO CRSCORE ;

GRANT CREATE RULE TO CRSCORE ;

GRANT CREATE ANY VIEW TO CRSCORE ;

GRANT CREATE PROCEDURE TO CRSCORE ;

GRANT CREATE ANY TRIGGER TO CRSCORE ;

GRANT CREATE DIMENSION TO CRSCORE ;

GRANT CREATE ROLLBACK SEGMENT TO CRSCORE ;

GRANT CREATE CUBE DIMENSION TO CRSCORE ;

GRANT EXECUTE ANY RULE TO CRSCORE ;

GRANT EXECUTE ANY PROCEDURE TO CRSCORE ;

GRANT FORCE TRANSACTION TO CRSCORE ;

GRANT CREATE ANY JOB TO CRSCORE ;

GRANT CREATE ANY INDEXTYPE TO CRSCORE ;

GRANT EXECUTE ANY PROGRAM TO CRSCORE ;

GRANT GRANT ANY PRIVILEGE TO CRSCORE ;

GRANT CREATE ANY EVALUATION CONTEXT TO CRSCORE ;

GRANT EXECUTE ANY ASSEMBLY TO CRSCORE ;

GRANT CREATE CUBE BUILD PROCESS TO CRSCORE ;

GRANT EXECUTE ANY RULE SET TO CRSCORE ;

GRANT CREATE SYNONYM TO CRSCORE ;

GRANT ALTER ANY TABLE TO CRSCORE ;

GRANT CREATE VIEW TO CRSCORE ;

GRANT EXECUTE ANY LIBRARY TO CRSCORE ;

GRANT CREATE RULE SET TO CRSCORE ;

GRANT CREATE ANY CLUSTER TO CRSCORE ;

GRANT CREATE TYPE TO CRSCORE ;

GRANT EXECUTE ANY EVALUATION CONTEXT TO CRSCORE ;

GRANT CREATE PUBLIC SYNONYM TO CRSCORE ;

GRANT CREATE ANY MINING MODEL TO CRSCORE ;

GRANT CREATE ANY RULE SET TO CRSCORE ;

GRANT CREATE MEASURE FOLDER TO CRSCORE ;

GRANT CREATE ROLE TO CRSCORE ;

GRANT CREATE ANY CONTEXT TO CRSCORE ;

GRANT CREATE ANY SYNONYM TO CRSCORE ;

GRANT CREATE ANY CUBE DIMENSION TO CRSCORE ;

GRANT CREATE ANY TABLE TO CRSCORE ;

GRANT CREATE SESSION TO CRSCORE ;

GRANT CREATE PUBLIC DATABASE LINK TO CRSCORE ;

GRANT UNLIMITED TABLESPACE TO CRSCORE ;

GRANT CREATE ANY EDITION TO CRSCORE ;

GRANT CREATE ANY ASSEMBLY TO CRSCORE ;

GRANT CREATE INDEXTYPE TO CRSCORE ;

GRANT GRANT ANY ROLE TO CRSCORE ;

GRANT CREATE MATERIALIZED VIEW TO CRSCORE ;

GRANT DROP TABLESPACE TO CRSCORE ;

GRANT DELETE ANY TABLE TO CRSCORE ;

GRANT CREATE PROFILE TO CRSCORE ;

GRANT CREATE ANY MEASURE FOLDER TO CRSCORE ;

GRANT CREATE ANY TYPE TO CRSCORE ;

GRANT CREATE CUBE TO CRSCORE ;

GRANT CREATE DATABASE LINK TO CRSCORE ;

COMMIT;

CREATE USER CRSCATA IDENTIFIED BY CRSCATA;

GRANT "RESOURCE" TO CRSCATA ;

GRANT "CONNECT" TO CRSCATA ;

GRANT ALTER TABLESPACE TO CRSCATA ;

GRANT CREATE USER TO CRSCATA ;

GRANT CREATE ANY OUTLINE TO CRSCATA ;

GRANT CREATE MINING MODEL TO CRSCATA ;

GRANT UPDATE ANY TABLE TO CRSCATA ;

GRANT CREATE TRIGGER TO CRSCATA ;

GRANT CREATE TABLESPACE TO CRSCATA ;

GRANT CREATE ASSEMBLY TO CRSCATA ;

GRANT CREATE SEQUENCE TO CRSCATA ;

GRANT SELECT ANY SEQUENCE TO CRSCATA ;

GRANT CREATE ANY SQL PROFILE TO CRSCATA ;

GRANT EXECUTE ANY OPERATOR TO CRSCATA ;

GRANT EXECUTE ANY TYPE TO CRSCATA ;

GRANT CREATE ANY DIRECTORY TO CRSCATA ;

GRANT CREATE TABLE TO CRSCATA ;

GRANT CREATE ANY INDEX TO CRSCATA ;

GRANT EXECUTE ASSEMBLY TO CRSCATA ;

GRANT SELECT ANY TABLE TO CRSCATA ;

GRANT CREATE OPERATOR TO CRSCATA ;

GRANT CREATE ANY PROCEDURE TO CRSCATA ;

GRANT CREATE ANY CUBE TO CRSCATA ;

GRANT EXECUTE ANY CLASS TO CRSCATA ;

GRANT CREATE ANY MATERIALIZED VIEW TO CRSCATA ;

GRANT SELECT ANY TRANSACTION TO CRSCATA ;

GRANT CREATE EXTERNAL JOB TO CRSCATA ;

GRANT INSERT ANY TABLE TO CRSCATA ;

GRANT CREATE LIBRARY TO CRSCATA ;

GRANT CREATE JOB TO CRSCATA ;

GRANT CREATE ANY OPERATOR TO CRSCATA ;

GRANT CREATE ANY LIBRARY TO CRSCATA ;

GRANT CREATE ANY SEQUENCE TO CRSCATA ;

GRANT CREATE CLUSTER TO CRSCATA ;

GRANT FORCE ANY TRANSACTION TO CRSCATA ;

GRANT CREATE EVALUATION CONTEXT TO CRSCATA ;

GRANT CREATE ANY CUBE BUILD PROCESS TO CRSCATA ;

GRANT EXECUTE ANY INDEXTYPE TO CRSCATA ;

GRANT CREATE ANY DIMENSION TO CRSCATA ;

GRANT CREATE ANY RULE TO CRSCATA ;

GRANT CREATE RULE TO CRSCATA ;

GRANT CREATE ANY VIEW TO CRSCATA ;

GRANT CREATE PROCEDURE TO CRSCATA ;

GRANT CREATE ANY TRIGGER TO CRSCATA ;

GRANT CREATE DIMENSION TO CRSCATA ;

GRANT CREATE ROLLBACK SEGMENT TO CRSCATA ;

GRANT CREATE CUBE DIMENSION TO CRSCATA ;

GRANT EXECUTE ANY RULE TO CRSCATA ;

GRANT EXECUTE ANY PROCEDURE TO CRSCATA ;

GRANT FORCE TRANSACTION TO CRSCATA ;

GRANT CREATE ANY JOB TO CRSCATA ;

GRANT CREATE ANY INDEXTYPE TO CRSCATA ;

GRANT EXECUTE ANY PROGRAM TO CRSCATA ;

GRANT GRANT ANY PRIVILEGE TO CRSCATA ;

GRANT CREATE ANY EVALUATION CONTEXT TO CRSCATA ;

GRANT EXECUTE ANY ASSEMBLY TO CRSCATA ;

GRANT CREATE CUBE BUILD PROCESS TO CRSCATA ;

GRANT EXECUTE ANY RULE SET TO CRSCATA ;

GRANT CREATE SYNONYM TO CRSCATA ;

GRANT ALTER ANY TABLE TO CRSCATA ;

GRANT CREATE VIEW TO CRSCATA ;

GRANT EXECUTE ANY LIBRARY TO CRSCATA ;

GRANT CREATE RULE SET TO CRSCATA ;

GRANT CREATE ANY CLUSTER TO CRSCATA ;

GRANT CREATE TYPE TO CRSCATA ;

GRANT EXECUTE ANY EVALUATION CONTEXT TO CRSCATA ;

GRANT CREATE PUBLIC SYNONYM TO CRSCATA ;

GRANT CREATE ANY MINING MODEL TO CRSCATA ;

GRANT CREATE ANY RULE SET TO CRSCATA ;

GRANT CREATE MEASURE FOLDER TO CRSCATA ;

GRANT CREATE ROLE TO CRSCATA ;

GRANT CREATE ANY CONTEXT TO CRSCATA ;

GRANT CREATE ANY SYNONYM TO CRSCATA ;

GRANT CREATE ANY CUBE DIMENSION TO CRSCATA ;

GRANT CREATE ANY TABLE TO CRSCATA ;

GRANT CREATE SESSION TO CRSCATA ;

GRANT CREATE PUBLIC DATABASE LINK TO CRSCATA ;

GRANT UNLIMITED TABLESPACE TO CRSCATA ;

GRANT CREATE ANY EDITION TO CRSCATA ;

GRANT CREATE ANY ASSEMBLY TO CRSCATA ;

GRANT CREATE INDEXTYPE TO CRSCATA ;

GRANT GRANT ANY ROLE TO CRSCATA ;

GRANT CREATE MATERIALIZED VIEW TO CRSCATA ;

GRANT DROP TABLESPACE TO CRSCATA ;

GRANT DELETE ANY TABLE TO CRSCATA ;

GRANT CREATE PROFILE TO CRSCATA ;

GRANT CREATE ANY MEASURE FOLDER TO CRSCATA ;

GRANT CREATE ANY TYPE TO CRSCATA ;

GRANT CREATE CUBE TO CRSCATA ;

GRANT CREATE DATABASE LINK TO CRSCATA ;

COMMIT;

CREATE USER CRSCATB IDENTIFIED BY CRSCATB;

GRANT "RESOURCE" TO CRSCATB ;

GRANT "CONNECT" TO CRSCATB ;

GRANT ALTER TABLESPACE TO CRSCATB ;

GRANT CREATE USER TO CRSCATB ;

GRANT CREATE ANY OUTLINE TO CRSCATB ;

GRANT CREATE MINING MODEL TO CRSCATB ;

GRANT UPDATE ANY TABLE TO CRSCATB ;

GRANT CREATE TRIGGER TO CRSCATB ;

GRANT CREATE TABLESPACE TO CRSCATB ;

GRANT CREATE ASSEMBLY TO CRSCATB ;

GRANT CREATE SEQUENCE TO CRSCATB ;

GRANT SELECT ANY SEQUENCE TO CRSCATB ;

GRANT CREATE ANY SQL PROFILE TO CRSCATB ;

GRANT EXECUTE ANY OPERATOR TO CRSCATB ;

GRANT EXECUTE ANY TYPE TO CRSCATB ;

GRANT CREATE ANY DIRECTORY TO CRSCATB ;

GRANT CREATE TABLE TO CRSCATB ;

GRANT CREATE ANY INDEX TO CRSCATB ;

GRANT EXECUTE ASSEMBLY TO CRSCATB ;

GRANT SELECT ANY TABLE TO CRSCATB ;

GRANT CREATE OPERATOR TO CRSCATB ;

GRANT CREATE ANY PROCEDURE TO CRSCATB ;

GRANT CREATE ANY CUBE TO CRSCATB ;

GRANT EXECUTE ANY CLASS TO CRSCATB ;

GRANT CREATE ANY MATERIALIZED VIEW TO CRSCATB ;

GRANT SELECT ANY TRANSACTION TO CRSCATB ;

GRANT CREATE EXTERNAL JOB TO CRSCATB ;

GRANT INSERT ANY TABLE TO CRSCATB ;

GRANT CREATE LIBRARY TO CRSCATB ;

GRANT CREATE JOB TO CRSCATB ;

GRANT CREATE ANY OPERATOR TO CRSCATB ;

GRANT CREATE ANY LIBRARY TO CRSCATB ;

GRANT CREATE ANY SEQUENCE TO CRSCATB ;

GRANT CREATE CLUSTER TO CRSCATB ;

GRANT FORCE ANY TRANSACTION TO CRSCATB ;

GRANT CREATE EVALUATION CONTEXT TO CRSCATB ;

GRANT CREATE ANY CUBE BUILD PROCESS TO CRSCATB ;

GRANT EXECUTE ANY INDEXTYPE TO CRSCATB ;

GRANT CREATE ANY DIMENSION TO CRSCATB ;

GRANT CREATE ANY RULE TO CRSCATB ;

GRANT CREATE RULE TO CRSCATB ;

GRANT CREATE ANY VIEW TO CRSCATB ;

GRANT CREATE PROCEDURE TO CRSCATB ;

GRANT CREATE ANY TRIGGER TO CRSCATB ;

GRANT CREATE DIMENSION TO CRSCATB ;

GRANT CREATE ROLLBACK SEGMENT TO CRSCATB ;

GRANT CREATE CUBE DIMENSION TO CRSCATB ;

GRANT EXECUTE ANY RULE TO CRSCATB ;

GRANT EXECUTE ANY PROCEDURE TO CRSCATB ;

GRANT FORCE TRANSACTION TO CRSCATB ;

GRANT CREATE ANY JOB TO CRSCATB ;

GRANT CREATE ANY INDEXTYPE TO CRSCATB ;

GRANT EXECUTE ANY PROGRAM TO CRSCATB ;

GRANT GRANT ANY PRIVILEGE TO CRSCATB ;

GRANT CREATE ANY EVALUATION CONTEXT TO CRSCATB ;

GRANT EXECUTE ANY ASSEMBLY TO CRSCATB ;

GRANT CREATE CUBE BUILD PROCESS TO CRSCATB ;

GRANT EXECUTE ANY RULE SET TO CRSCATB ;

GRANT CREATE SYNONYM TO CRSCATB ;

GRANT ALTER ANY TABLE TO CRSCATB ;

GRANT CREATE VIEW TO CRSCATB ;

GRANT EXECUTE ANY LIBRARY TO CRSCATB ;

GRANT CREATE RULE SET TO CRSCATB ;

GRANT CREATE ANY CLUSTER TO CRSCATB ;

GRANT CREATE TYPE TO CRSCATB ;

GRANT EXECUTE ANY EVALUATION CONTEXT TO CRSCATB ;

GRANT CREATE PUBLIC SYNONYM TO CRSCATB ;

GRANT CREATE ANY MINING MODEL TO CRSCATB ;

GRANT CREATE ANY RULE SET TO CRSCATB ;

GRANT CREATE MEASURE FOLDER TO CRSCATB ;

GRANT CREATE ROLE TO CRSCATB ;

GRANT CREATE ANY CONTEXT TO CRSCATB ;

GRANT CREATE ANY SYNONYM TO CRSCATB ;

GRANT CREATE ANY CUBE DIMENSION TO CRSCATB ;

GRANT CREATE ANY TABLE TO CRSCATB ;

GRANT CREATE SESSION TO CRSCATB ;

GRANT CREATE PUBLIC DATABASE LINK TO CRSCATB ;

GRANT UNLIMITED TABLESPACE TO CRSCATB ;

GRANT CREATE ANY EDITION TO CRSCATB ;

GRANT CREATE ANY ASSEMBLY TO CRSCATB ;

GRANT CREATE INDEXTYPE TO CRSCATB ;

GRANT GRANT ANY ROLE TO CRSCATB ;

GRANT CREATE MATERIALIZED VIEW TO CRSCATB ;

GRANT DROP TABLESPACE TO CRSCATB ;

GRANT DELETE ANY TABLE TO CRSCATB ;

GRANT CREATE PROFILE TO CRSCATB ;

GRANT CREATE ANY MEASURE FOLDER TO CRSCATB ;

GRANT CREATE ANY TYPE TO CRSCATB ;

GRANT CREATE CUBE TO CRSCATB ;

GRANT CREATE DATABASE LINK TO CRSCATB ;

COMMIT;

so here are four users as (username/password)follows

CRSPUB/CRSPUB for Publishing datatsource

CRSCORE/CRSCORE for Productioncore datasource

CRSCATA/CRSCATA for cata datasource

CRSCATB/CRSCATB for catb datasource

Note:before starting cim make sure your all paths

start weblogic server

start Endeca -->  chmod 777 /common/startEndeca.sh

./startEndeca.sh

make sure your weblogic is up and running by hitting localhost:7001/console

make sure your endeca services are running by hitting ps -ef | grep endeca command on terminal

8.Starting CIM

1. follow the instructions as mentioned in http://docs.oracle.com/cd/E52191_02/CRS.11-1/ATGCRSInstall/html/s0208startingcim01.html

and now you can see BCC and CRS server