Before you going to work with Oracle ATG eCommerce platform there are several things need to be concerned.
1. What is the Operating System best suited for memory hungry development ?
That is LINUX.
Here i will install ATG on Windows just to compare LINUX vs Windows. If you really need to install ATG with lesser pain good to use ATG on LINUX approach.
This conclusion done after installing ATG on both Windows and Linux with same configuration with 4GB RAM, same Intel i3 processors with same HP motherboards.
That is LINUX.
Here i will install ATG on Windows just to compare LINUX vs Windows. If you really need to install ATG with lesser pain good to use ATG on LINUX approach.
This conclusion done after installing ATG on both Windows and Linux with same configuration with 4GB RAM, same Intel i3 processors with same HP motherboards.
| Linux | Windows | Conclusion | |
| Total Installation Time | 2 hours | 6 hours | Linux is very fast |
| Re-installation at failures | No issues. Just delete the installation folder and extract the installation packages and then run :D | You need to do step by step Un-installation, If it is failed at Un-installation time, windows registries will keep entries. | High chances to Re-installation entire Windows OS due to windows registries. |
| Transparency | You know what you are doing with Linux, ATG Framework, Endeca, App Servers and finally with your code | Very thing hide other than your code | I have confidence with Linux |
| Support for Developers | Flexible like a Elastic, Eclipse is very fast with Two Production and Publishing weblogc server instances | Very slow, System hangs with two Weblogic server instances and Eclipse IDE | Linux has no pain |
| Listening to music while development | Yes of course | Not smooth | Love TUX |
This is my honest experience in both platform. If you don't know TUX, Try following painful WINDOWS approach.
2. This document was prepared 17th June of 2013 with considering latest software modules up to date. Following information are correct as of 17th June of 2013.
3. 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.
4. 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 items of web page can be shown through Endeca Search Engine queries. It is a new feature of ATG 10.2.
5. It is not mandatory to show web contents through Endeca Search Engine queries. You can create your own application without interacting Endeca search engine.
5. It is not mandatory to show web contents through Endeca Search Engine queries. You can create your own application without interacting Endeca search engine.
6. Create your own account in Oracle. Go to https://edelivery.oracle.com/. Here you can download ATG frameworks and Endeca frameworks.
7. Total installation time will take at least 6 hours.
8. As a best practice, use separate location for installation.
Ex - Installation Folder Structure
Installation Root ( Driver D: )
--------------------------------------
|
| --- D:\Oracle
| ( For Weblogic )
| --- D:\ATG\ATG10.2
| ( For Oracle ATG Web Commerce 10.2 and Oracle ATG Web Commerce Reference Store 10.2 )
| --- D:\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 )
8. There are many instances of user authentications. For the easiness, use same password for all instances. ( Ex- ATGtraining123 ). In production level, 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.
Requried 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 (Ubuntu 12.04 or Fedora 18 ) or Windows 7 64 bit
Java Framework
1. JDK 1.7 ( Download it from http://www.oracle.com )
Application Server
1. Oracle WebLogic Server 11gR1 (10.3.6)
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.)
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
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
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
download Oracle Endeca Platform Services 6.1.3
download Oracle Endeca Tools and Frameworks 3.1.2
download Oracle Endeca Content Acquisition System 3.1.2
Database
1. Oracle Database Express Edition 11g Release 2 (Download it from http://www.oracle.com )
2. Oracle SQL Developer (Download it from http://www.oracle.com )
Editor
1.Install notepad++ from http://notepad-plus-plus.org/
Installation of ATG framework and Endeca search engine with sample application.
Step 2. view
Step 3. view
Go to java installation directory. My path is C:\Program Files\Java\jdk1.7.0_21\bin
Then append Java Path to system variable called Path
( Start -> Computer -> right click and select properties -> Advance System Settings -> Environment Variables -> go to section called "System Variables" -> select variable called "Path" -> select edit -> go to end of the variable value add semi colon (;) and past the bin path of JDK. )
Step 1. view
Then open a command prompt and type following two commands two check Java installation is succeeded.
1. java -version
2. javac -version
Step 1: view
Now you have finished java installation and then move to install Oracle Weblogic server.
Installing Weblogic Server.
Open a command prompt and navigate it to download location of Weblogic server
Then type following command. Then it will begin Weblogic installation
java -jar
Step 1: view
Then select Weblogic installation location as described above.
Installation Root ( Driver D: )
------------------------------
|
|
--- D:\Oracle ( For Weblogic )
Step 1: view
Then select next (Without adding emails for supports)
Step 1: view
Then click yes without sending support email addresses
Step 1: view
Then click yes to bypass initiation of configuration manager
Step 1: view
Then select 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.
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.
Then start web logic admin server using following steps
1. Open a command prompt
2. Then navigate to directory called "bin" of newly created domain.
Ex- D:\Oracle\Middleware\user_projects\domains\base_domain\bin>
3. Then type "startWebLogic.cmd" and press enter
Step 1: view
Then brows Weblogic admin server console by http://localhost:7001/console
Then enter username and password. (weblogic, weblogic123)
Step 1: view
1. Open a command prompt
2. Then navigate to directory called "bin" of newly created domain.
Ex- D:\Oracle\Middleware\user_projects\domains\base_domain\bin>
3. Then type "startWebLogic.cmd" and press enter
Step 1: view
Then brows Weblogic admin server console by http://localhost:7001/console
Then enter username and password. (weblogic, weblogic123)
Step 1: view
Once you able to logging to Weblogic admin console, then you have successfully installed Weblogic server.
Installing ATG framework
Move to install the ATG framework by double clicking the installation file.
Step 1: view
Select installation location.
Installation Root ( Driver D: )
------------------------------
|
|
|
--- D:\ATG\ATG10.2
Step 1: view
Select all modules
Step 1: view
Select Oracle Weblogic server
Step 1: view
Change Weblogic configuration locations to right locations.
Step 1: view
Click install.
Step 1: view
Now we have installed Oracle ATG eCommerce framework. Then move to install sample application.
Installing Oracle ATG Web Commerce Reference Store 10.2
Then move to install ATG sample project ( Reference Module ) called "Oracle ATG Web Commerce Reference Store 10.2" and double click the installation.
Step 1: view
Then select language preference
Step 1: view
Then select next
Step 1: view
Then accept license agreement
Step1: view
Then select the installation location as ATG root location ( D:\ATG\ATG10.2 )
Step 1: view
Then select next
Step 1: view
Then click install and it will successfully install.
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
Installing Endeca Framework ( MDEX )
Extract the Oracle Endeca MDEX Engine 6.4.1.
It gives two things.
1. MDEX installation
2. Presentation API
Install MDEX by double click the installation
Step 1: view
Read license and click next
Step 1: view
Click next and select installation location ( Ex - D:\Endeca\MDEX\6.4.1 )
Step 1: view
Click next to finish the installation
Step 1: view
Then extract MDEX presentation API.
Step 1: view
Then copy the folder called "PresentationAPI" to Endeca Installation location ( Ex- D:\Endeca )
Step 1: view
Installing Endeca Framework ( Platform Services )
Then move to install Platform services. Extract zip file of Oracle Endeca Platform services 6.1.3 and double click the installation
Step 1: view
Then read license agreement and click next
Step 1: view
Then click next
Step 1: view
Then select the Endeca location ( Ex - D:\Endeca\PlatformServices )
Step 1: view
Then select Endeca control system with full features
Step 1: view
Then add your username, password of your computer login and domain of current machine.
Step 1: view
Then select MDEX root directory
Step 1: view
Then click next
Step 1: view
Then click next to complete the installation process.
Step 1: view
Then click yes to restart the machine.
Step 1: view
Now Endeca installation location will contain following folders.
Step 1: view
Then move to install Oracle Endeca Tools and Frameworks 3.1.2. Extract the zip file to Endeca location. Simply extract it to Edeca location.( Ex-D:\Endeca )
Step 1: view
Then create following system variables. Use your installation locations instead of followings.
1. ENDECA_TOOLS_ROOT
2. ENDECA_TOOLS_CONF
Ex - ENDECA_TOOLS_ROOT=D:\Endeca\ToolsAndFrameworks\3.1.2
Ex - ENDECA_TOOLS_CONF=D:\Endeca\ToolsAndFrameworks\3.1.2\server\workspace
Step 1: view
Then start the service of Tools and Frameworks by following steps
1. Open command prompt as administrator mode.
( Start -> All Programs->Accessories-> Right click on Command Prompt and Run as administrator )
2. Navigate to D:\Endeca\ToolsAndFrameworks\3.1.2\server\bin
3. Type install_service.bat and hit enter.
Step 1: view
Then move to install Oracle Endeca Content Acquisition System 3.1.2. Extract the zip file and double click.
Step 1: view
Click next. Then read license agreement and click next
Step 1: view
Click next
Step 1: view
Select the installation location to Endeca location.
Step 1: view
Add your username, password and domain of current computer login.
Step 1: view
Click next with default values
Step 1: view
Click next to finish the installation
Now we have installed Java, Weblogic, Endeca Framework including MDEX, Platform Services, Tools and Framework and CAS.
Open a command prompt and type services.msc. Then check following 4 services up and running.
Step 1: view
Now restart the computer.
Now move to install Oracle Database server and SQLDeveloper client.
Installing Oracle Database Server
Extract the Oracle Database Server Installation and double click and let it install.
Step 1: view
Select next and accept license agreement
Step 1: view
Change installation location if you want and click next
Enter password for SYSTEM database. Lets use same password "ATGtraining123"
Step 1: view
Click install.
Now move to install Oracle SQLDeveloper.
Installing Oracle SQLDeveloper
Extract the installation and run the sqldeveloper.exe
Then provide the java.exe path. ( Ex- C:\Program Files\Java\jdk1.7.0_21\bin\java.exe )
Step 1: view
Select SQL source ( .sql )
Step 1: view
Then create new connection to newly install 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 500 MB. I wish to create my data file in the installation location of Oracle Database.
Ex - C:\oraclexe\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 'C:\oraclexe\app\oracle\oradata\XE\ATGAPP.DBF' size 500M;
3. COMMIT;
Step 1: view
Now we have already installed all required software. When you going to create new project you have to go through specific approach to create web logic server instances, data sources, database repositories.
Open a command prompt and navigate to D:\ATG\ATG10.2\home\bin.
Type cim.bat and hit enter.
Step 1: view
Hit enter to add admin password. Enter a password. Please use same password in this training. password :- ATGtraining123
Step 1: view
Hit enter to select products. Select 7 and hit enter.
Step 1: view
Type d and hit enter to finish selection
Step 1: view
Type 4 then hit enter to select Abandon Order services. Then type d and hit enter to finish selection.
Step 1: view
Type d and hit enter to move next screen. Then type 1 and hit enter to select Non switching database. Switching databases good for staging levels.
Step 1: view
Then type d and hit enter to move next screen.
Step 1: view
Then type 1 2 3 to select Sample application and other features.
Then type d to move next screen.
Step 1: view
Then type 2 and hit enter to inspect the application. Then type d and hit enter to move next screen
Then type 1 to populate data configurations.
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.
Then type a and hit enter to select application server.
Step 1: view
Then type 2 to select Weblogic server.
Then provide Weblogic server path. ( Ex - D:\Oracle\Middleware\wlserver_10.3 )
Then provide weblogic domain path
( Ex - D:\Oracle\Middleware\user_projects\domains\base_domain )
Then hit enter to validate Weblogic server.
Step 1: view
Then provide Weblogic username, password.
Then hit enter to validate Weblogic server.
Step 1: view
Then it should able to connect Weblogic application server successfully.
Then move to create database repositories.
Then hit enter to move next screen.
Step 1: view
There are two database configurations need. One is for Publishing and Other one is for Production.
Then hit enter to select Production database configurations.
Then hit enter to add database connection details.
Then type 1 and hit enter to select Oracle Database connectivity.
Step 1: view
Next step is to create Oracle database schema for both Publishing and Production levels.
Now start the Oracle XE database server.
Step 1: view
Now open SQLDeveloper and run following script.
Here we create User called "PUBLISHING".
The password is our common password "ATGtraining123".
Then create another Schema for PRODUCTION database.
Use same password "ATGtraining123" for this time as well.
Script 1 for Publishing schema.
-- 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 schema.
-- 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
Then hit enter to accept default Database URl.
Then provide driver JAR file path. ( Ex - D:\Oracle\Middleware\wlserver_10.3\server\lib\ojdbc6.jar )
The hit enter to test the connection. It should be success.
Step 1: view
Then hit enter to create the schema.
Then hit enter to move next screen.
Then hit enter to import reference data.
Then hit enter to move next screen.
Step 1: view
Then set administrator password. This will required to authenticate many user login.
So use same password "ATGtraining123"
Step 1: view
It will import reference data successfully.
Then hit enter to create similar schema for Production database..
Step 1: view
Then hit enter to accept production database configurations
Then hit enter to move forward with new database configuration
Then type 1 to select Oracle driver.
Enter following details.
Username : PRODUCTION
password : ATGtraining123 and re-enter same password
hostname : localhost
port : 1521
database : xe
Then hit enter to accept default Database URl.
Then provide driver JAR file path.
( Ex - D:\Oracle\Middleware\wlserver_10.3\server\lib\ojdbc6.jar )
Step 1: view
Then hit enter to test the connection. It should be success.
Then hit enter to create the schema.
Then hit enter to move next screen.
Then hit enter to import reference data.
Then hit enter to move next screen.
Step 1: view
Now we have created both database schemas.
Now we have to create Weblogic server instances for each Publishing and Production servers.
Now hit enter to move next screen.
Then hit enter to exit database configurations.
Then hit enter to create Weblogic server instances.
By default it selected option 2.
Then hit enter to create Publishing database server instance.
Step 1: view
Then hit enter to select Publishing server instance.
Then enter server instance name as "ATGPublishing"
Then hit enter to accept default values of following parameters
1. Production Lock Server Port [[9012]]
2. CAS Hostname [[localhost]]
3. CAS Port [[8500]]
4. EAC Hostname [[localhost]]
5. EAC Port [[8888]]
6. Endeca Base Application Name [[CRS]]
Then find the "Full computer name" by following way.
( Start-> Computer-> right click properties -> find Full computer name )
Then give this full computer name.
Then hit enter to accept default values of following parameters.
1. Workbench Port Number [[8006]]
2. Default MDEX Host Name [[localhost]]
3. Default MDEX Port Number [[15000]]
Step 1: view
Then type o and hit enter move next screen.
Then hit enter to select publishing server instance.
Then hit enter to create publishing server instance.
Then hit enter to add server instance.
Then hit enter to select default server type.
Then provide Server instance name as "ATGPublishing"
Step 1: view
Then type c and hit enter to proceed with Custom Port Binding.
Then type 2 and hit enter to specific port binding.
Then hit enter to accept default values for following parameters.
1. HTTP Port [[7103]] >
2. HTTPS Port [[7104]] >
3. HTTP Port [[7103]] >
4. RMI Port [[8861]] >
5. DRP Port [[8851]] >
6. File Deployment Port [[8811]] >
7. File Synchronization Deploy Server Port [[8816]] >
8. Lock Server Port [[9010]] >
Step 1: view
Then we have to create server instance for Production server.
Now hit enter to move next screen.
Again hit enter to move server instance configuration screen.
Then hit enter to proceed with Production server instance.
Then hit enter to Instance Management for Production server.
Then hit enter again to add server instance.
Step 1: view
Then hit enter to create production Server Instance
Then add server instance name as "ATGProduction"
Then hit enter to accept default port binding.
Then hit enter to accept default parameter values
1. HTTP Port [[7003]] >
2. HTTPS Port [[7004]] >
3. Site HTTP Port [[7003]] >
4. RMI Port [[8860]] >
5. DRP Port [[8850]] >
6. File Deployment Port [[8810]] >
7. Lock Server Port [[9012]] >
Step 1: view
Now we have configured required server instances.
Then we need to create CRS ( Sample commerce reference store ) inside Endeca.
Now hit enter to move next screen.
Again hit enter to move next screen.
Again hit enter to move next screen.
Then type 2 and hit enter to select server instances.
Then type p and hit enter. This is to deploy CRS (Sample commerce reference store) application.
Step 1: view
Then type d and hit enter to begin deployment process
Then type a and hit enter to proceed with Endeca App Configuration without Experience Manager Preview.
Step 1: view
Then create folder called APPS in Endeca location. (Ex - D:\Endeca\APPS ).
This folder will use as deployment locations for Endeca search engine.
Now hit enter to accept default application name "CRS"
Then provide newly created folder path. D:\Endeca\APPS
Then hit enter to accept default values for following parameters.
1. EAC Port Number [[8888]] >
2. Dgraph Port Number [[15000]] >
3. Authoring Dgraph Port Number [[15002]] >
4. Log Server Port Number [[15010]] >
5. CAS Hostname [[localhost]] >
6. CAS Port Number [[8500]] >
Then enter CAS path name ( Ex - D:\Endeca\CAS\3.1.2 )
Then hit enter to accept default values for following parameters.
1. CAS Version [[3.1.2]] >
2. Language Code [[en]] >
3. Workbench Hostname [[localhost]] >
4. Workbench Port Number [[8006]] >
Then provide path to the Endeca ToolsAndFrameworks directory
( Ex - D:\Endeca\ToolsAndFrameworks\3.1.2 )
Then provide path to the Endeca MDEX directory
( Ex - D:\Endeca\MDEX\6.4.1 )
Then provide path to the Endeca Platform Services directory
( Ex - D:\Endeca\PlatformServices\6.1.3 )
Then hit enter to deploy the CRS application. Then it will complete the deployment.
Step 1: view
Then go to folder called "control" in CRS application
( Ex- : D:\Endeca\APPS\CRS\control )
Then find the file called "initialize_services.bat" DONOT double click run this file. Just with notepad++.
Then search on following key word "set_media". Then comment that line by adding "REM" to beginning of the line.
Step 1: view
Then open a command prompt and navigate to file location.
( Ex- D:\Endeca\APPS\CRS\control )
Then type initialize_services.bat and hit enter.
Then it will initialize the CRS Endeca application.
Step 1: view
Then go to CIM console.
Then type s and hit enter to skip initializing through CIM. Because we already initialized it using
Step 1: view
Now we have to create EAR files to deploy CRS application in previously created server instances.
Hit enter to move next screen.
Hit enter again to move next screen.
Type 3 to select Application Assembly & Deployment process. Then hit enter.
Then hit enter to create ear file for production.
Then type ATGProduction.ear as name of the deployment EAR.
Step 1: view
Then hit enter to make the deployment.
Step 1: view
Then hit enter to register data source on Weblogic server
Step 1: view
Then hit enter to add database driver
Step 1: view
Then hit enter to update environment.
Step 1: view
Then hit enter for JVM optimization
Then hit enter to update start up script
Then hit enter to copy protocol.jar
Again hit enter to Copy protocol.jar to Production with a Server Lock Manager
Then hit enter to finish it.
Step 1: view
Then hit enter to move next screen.
Again hit enter to move next screen.
Add production EAR name "ATGProduction.ear"
Then hit enter to deploy the EAR file.
Step 1: view
Then hit enter to register the data-source for production database.
Step 1: view
Then hit enter to add database driver
Step 1: view
Then hit enter to update environment.
Step 1: view
Then hit enter for post deployments.
Then hit enter copy protocol.jar
Then again hit enter to Copy protocol.jar to Publishing with a Server Lock Manager
Then hit enter to move next screen.
Step 1: view
Then hit enter to move next screen.
Again hit enter to move next screen.
Then type q to quit the installation process.
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 D:\ATG\ATG10.2\home\servers\ATGPublishing\localconfig\atg\endeca\assembler
Then create property file called "AssemblerTools.properties"
Then add this entry loggingDebug=true
Step 1: view
Copy file called "AssemblerTools.properties" to production level at D:\ATG\ATG10.2\home\servers\ATGProduction\localconfig\atg\endeca\assembler
Step 1: view
Create new folder called "search" at D:\ATG\ATG10.2\home\servers\ATGPublishing\localconfig\atg
Step 1: view
Then create property file called "SynchronizationInvoker.properties" at newly created location.
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
Step2: 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.
Then click save
Step 1: view
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 servers.
Open command prompt.
Then go to D:\Oracle\Middleware\user_projects\domains\base_domain\bin.
Then type
startManagedWebLogic.cmd ATGPublishing
and hit enter.
Step 1: view
Again open command prompt.
Then go to D:\Oracle\Middleware\user_projects\domains\base_domain\bin.
Then type
startManagedWebLogic.cmd ATGProduction
and hit enter.
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 Content 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 add following information.
Agent Name : ProdAgent
Add both available sites to include sites.
RMI URL : rmi://localhost:8860/atg/epub/AgentTransport
Then click save changes.
Step 1: view
Step 2: view
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.
Keep your computer calm at least two hours.
In this time it will begin the indexing process for the sample application
( Commerce Reference Application 10.2 )
located at D:\Endeca\Apps\CRS.
Beep sound will generate in the middle of the indexing process.
Step 1: view
Following things need to do after above TWO hours of indexing process.
Then open command prompt and navigate to this location.
Ex - D:\Endeca\Apps\CRS\control
Then type promote_content.bat and hit enter.
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 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 succeeded one.
WHAT NOT TO DO - :
Do not click on Baseline Indexing or Partial Indexing Buttons.
This makes a disaster as it will retry to re-initiate another indexing process parallel to first one.
If you do it, Then you have to uninstall all items and re-install all items.
1. Situation 1 - Totally Pending.
Step 1: view
Step 1: view
3. Situation 3 - All five indexes completed successfully.
If it successfully completed all indexing process then open command prompt and navigate to this location.
Then brows final result at http://localhost:7003/crs/storeus
If you faced above failed situations then follow following approach.
1. Restart entire Computer.
2. Then start database server by open a command prompt and then navigate to following location.
Ex - C:\oraclexe\app\oracle\product\11.2.0\server\bin
Then type StartDB.bat
3. Now we have to start Production and Publishing servers.
Open command prompt.
Then go to D:\Oracle\Middleware\user_projects\domains\base_domain\bin.
Then type
startManagedWebLogic.cmd ATGPublishing
and hit enter.
4. Run ATGProduction server on separate console by following command.
Open command prompt.
Then go to D:\Oracle\Middleware\user_projects\domains\base_domain\bin.
Then type
startManagedWebLogic.cmd ATGPproduction
and hit enter.
Then login to Dynamo Admin Page. You have to enter password for Dynamo Admin Console and Weblogic Server.
First prompt : ( For Dynamo Admin Console )
Username - admin
Password - ATGtraining123
Step 1: view
Second prompt : ( For Weblogic Admin Console )
Username - weblogic
Password - ATGtraining123
1. Then brows ProductCatelogSimpleIndexingAdmin by following path.
2. Component Browser -> atg -> commerce -> endeca -> index -> ProductCatelogSimpleIndexingAdmin
Open command prompt.
Then go to D:\Oracle\Middleware\user_projects\domains\base_domain\bin.
Then type
startManagedWebLogic.cmd ATGPublishing
and hit enter.
4. Run ATGProduction server on separate console by following command.
Open command prompt.
Then go to D:\Oracle\Middleware\user_projects\domains\base_domain\bin.
Then type
startManagedWebLogic.cmd ATGPproduction
and hit enter.
First prompt : ( For Dynamo Admin Console )
Username - admin
Password - ATGtraining123
Step 1: view
Second prompt : ( For Weblogic Admin Console )
Username - weblogic
Password - ATGtraining123
1. Then brows ProductCatelogSimpleIndexingAdmin by following path.
2. Component Browser -> atg -> commerce -> endeca -> index -> ProductCatelogSimpleIndexingAdmin
3. Then you have to manually run the Baseline Index by Clicking the Button.
4. Wait untile it finish all FIVE indexing to be completed.
5. Once it successfully finished it's all indexes, then you can brows the our ultimate GOAL that is
All Menus, Categories will display through the search engine..
Check weather search engine is working fine. You can search based on a key word.
Ex : - belt
Cheers...
Saminda Konkaduwa.
