This discussion is archived
2 Replies Latest reply: Nov 11, 2013 12:01 AM by Prateek G RSS

ATG ENVIRONMENT SETUP ISSUE

eb20c2e9-ade7-43c7-8a85-f40499c1a389 Newbie
Currently Being Moderated

hi everyone,

 

my system configuration is low as i have only 2gb ram. i have successfully installed ATG 10.0.3. my problem is when i m installing Oracle 11g its too slow.i really find very hard to work. can anyone help in installing and configuring MYSQL. especially configuration part of MYSQL.

  • 1. Re: ATG ENVIRONMENT SETUP ISSUE
    Nitin Dubey Pro
    Currently Being Moderated

    1) If u beginner:

         Importing DAS,DPS,DCS,DSS would let u start ATG application and do some minimal things.

     

    Mysql prompt:

         CREATE database shop_production;   

     

         CREATE USER 'user_production'@'localhost' IDENTIFIED BY 'default';

         grant all on *.* to 'user_production'@'localhost';

      

         use shop_prod;

         source {ATG_HOME}\DAS\sql\install\mysql\das_ddl.sql

         source {ATG_HOME}\DPS\sql\install\mysql\dps_ddl.sql

         source {ATG_HOME}\DSS\sql\install\mysql\dss_ddl.sql

         source {ATG_HOME}\DCS\sql\install\mysql\dcs_ddl.sql

         FYI-chnage {ATG_HOME} to ATG directory.

     

    2) If u are aware of CIM:(even if u r not, i would recommend to get familiarize with it and use it)

    Use CIM to configure initial db setups,It's step by step guide.

     

    My recommendation would be use CIM to do database configurations only and do assemble ear and deployment manually.

     

     

    =======CIM MAIN MENU============================================================

    enter [h]elp, [q]uit to exit

     

     

    Choose the task you want to perform:

     

     

      [R]  Set the Administrator Password - Done (pending database import)

    *[P]  Product Selection

      [A]  Select Application Server

      [C]  Custom CIM Plugin Launcher

     

    > A

     

    -------APPLICATION SERVER SELECTION---------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      Choose Application Server: (* = Currently selected )

     

    *[1]  JBoss Application Server

      [2]  Oracle Weblogic Online (Either Production or Developer Mode)

      [3]  IBM Websphere Application Server

      [4]  Apache Tomcat (Development Only)

      [5]  Raw Ear Output Mode

     

    Select one > 5

     

    -------TARGET PATH FOR EAR FILES------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Enter target path for runAssembler output

     

     

       Enter path  [[D:/Program_Files/ATG/ATG10.2/home/../home/cimEars/]] >

     

    =======CIM MAIN MENU============================================================

    enter [h]elp, [q]uit to exit

     

     

    Choose the task you want to perform:

     

     

      [R]  Set the Administrator Password - Done (pending database import)

    *[P]  Product Selection

      [A]  Select Application Server - Done (Raw)

      [C]  Custom CIM Plugin Launcher

     

    >

     

    -------ANALYZING PRODUCT DIRECTORIES--------------------------------------------

     

     

     

    Please wait as CIM analyzes your product folders. . . . . .

     

    Analysis complete: 9 seconds

     

     

     

     

    -------PRODUCT SELECTION--------------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Select product you wish to configure by entering the corresponding item number.

     

      (Searching for products... done.)

     

      Choose one of the following options: (* = Currently selected )

     

      [1]  ATG Platform :

            Includes, optionally, data warehouse components

     

      [2]  ATG Site Administration :

            Includes ATG Platform and Content Administration

     

      [3]  ATG-Endeca Integration :

            Includes ATG Platform. Select this option when Endeca is used. Do not

            select this if you are using ATG Search

     

      [4]  Oracle ATG Web Commerce :

            Includes the ATG Platform and ATG Content Administration. Optional:

            data warehouse components, Preview, and Oracle ATG Web Commerce

            Merchandising

     

      [5]  ATG Content Administration :

            Includes ATG Platform.  Optional: Preview

     

      [6]  ATG REST :

            RESTful Web Services

     

      [D]  Done

     

    Select one or more > 4 5

     

      Choose one of the following options: (* = Currently selected )

     

      [1]  ATG Platform :

            Includes, optionally, data warehouse components

     

      [2]  ATG Site Administration :

            Includes ATG Platform and Content Administration

     

      [3]  ATG-Endeca Integration :

            Includes ATG Platform. Select this option when Endeca is used. Do not

            select this if you are using ATG Search

     

      *[4]  Oracle ATG Web Commerce :

            Includes the ATG Platform and ATG Content Administration. Optional:

            data warehouse components, Preview, and Oracle ATG Web Commerce

            Merchandising

     

      *[5]  ATG Content Administration :

            Includes ATG Platform.  Optional: Preview

     

      [6]  ATG REST :

            RESTful Web Services

     

      [D]  Done

     

    Select one or more > d

     

    -------CHOOSE COMMERCE ADDONS :-------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      Choose Commerce AddOns :

     

      [1]  Reporting

      [2]  Staging Server

      [3]  Dedicated Lock Servers

      [4]  Preview Server

      [5]  Merchandising UI

      [6]  Abandoned Order Services

      [D]  Done

     

    Select zero or more > 5

     

      Choose Commerce AddOns :

     

      [1]  Reporting

      [2]  Staging Server

      [3]  Dedicated Lock Servers

      [4]  Preview Server

    *[5]  Merchandising UI

      [6]  Abandoned Order Services

      [D]  Done

     

    Select zero or more > d

     

    -------INCLUDE DEMO APPLICATION:------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      Include Demo Application:

     

      [1]  Quincy Funds Demo

      [2]  MotorPriseJSP

      [D]  Done

     

    Select zero or one > d

     

    -------CHOOSE SWITCHING OR NON-SWITCHING DATASOURCE :---------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      Choose switching or non-switching datasource :

     

      [1]  Non-Switching Datasource

      [2]  Switching Datasource

     

    Select one > 1

     

    -------PUBLISHING MANAGEMENT GROUP----------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    The selected product requires the Publishing Management add on, which has been

    automatically included.

     

     

    -------CHOOSE NON-SWITCHING PUBLISHING DATASOURCE :-----------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    The selected product requires the Publishing Non-Switching Datasource add on,

    which has been automatically included.

     

     

    -------SITEADMIN ADDONS :-------------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    The selected product requires the Add commerce data to SiteAdmin add on, which

    has been automatically included.

     

     

    -------PRODUCT MODULE CALCULATION-----------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

    Current Product Selection:

     

      Oracle ATG Web Commerce

     

     

      ATG Content Administration

     

     

      ATG Site Administration

     

     

    Selected AddOns:

     

      Merchandising UI

      Non-Switching Datasource

      Publishing Management

      Publishing Non-Switching Datasource

      Add commerce data to SiteAdmin

     

     

    Server Instance Types:

     

      ATG Commerce Production Server

     

         DafEar.Admin DPS DSS DCS.PublishingAgent PublishingAgent

     

      ATG Commerce Publishing Server

     

         DCS-UI.Versioned BIZUI PubPortlet DafEar.Admin DCS-UI.SiteAdmin.Versioned

    SiteAdmin.Versioned DCS.Versioned

     

     

    -------VALIDATING INSTALLATION--------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    CIM is validating your Product Selection against your current installation.

     

     

      >> All required modules exist - passed

     

    =======CIM MAIN MENU============================================================

    enter [h]elp, [q]uit to exit

     

     

    Choose the task you want to perform:

     

     

    *[1]  Database Configuration

      [2]  Server Instance Configuration

      [3]  Application Assembly & Deployment

      [R]  Set the Administrator Password - Done (pending database import)

      [P]  Product Selection - Done (Oracle ATG Web Commerce & ATG Content

    Administration & ATG Site Administration)

      [A]  Select Application Server - Done (Raw)

      [C]  Custom CIM Plugin Launcher

     

    >

     

    -------CALCULATE DATASOURCE DEPENDENCIES----------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      Calculating Datasource Dependencies. View log file at D:/Program_Files/ATG/

    ATG10.2/home/../CIM/ log/cim.log

      |. . |

      |. . |

     

    -------SELECT A DATASOURCE TO CONFIGURE-----------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

    *[P]  Publishing

      [C]  Production Core

      [D]  Done

     

    >

     

    -------CONFIGURE DATASOURCE PUBLISHING------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

    *[C]  Connection Details

      [O]  Configure Another Datasource

     

    >

    Publishing

     

     

    -------ENTER CONNECTION DETAILS-------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Publishing

     

     

      Select Database Type

     

      [1]  Oracle Thin

      [2]  MS SQL

      [3]  iNet MS SQL

      [4]  DB2

      [5]  My SQL (Development Only)

     

    Select one > 5

     

       Enter User Name > user_publishing

     

       Enter Password > *******

     

       Re-enter Password > *******

     

       Enter Host Name > shop_publishing

     

       Enter Port Number [[3306]] >

     

       Enter Database Name > m

     

    =======CIM MAIN MENU============================================================

    enter [h]elp, [q]uit to exit

     

     

    Choose the task you want to perform:

     

     

    *[1]  Database Configuration

      [2]  Server Instance Configuration

      [3]  Application Assembly & Deployment

      [R]  Set the Administrator Password - Done (pending database import)

      [P]  Product Selection - Done (Oracle ATG Web Commerce & ATG Content

    Administration & ATG Site Administration)

      [A]  Select Application Server - Done (Raw)

      [C]  Custom CIM Plugin Launcher

     

    >

     

    -------CALCULATE DATASOURCE DEPENDENCIES----------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      Calculating Datasource Dependencies. View log file at D:/Program_Files/ATG/

    ATG10.2/home/../CIM/ log/cim.log

      |. . |

      |. . |

     

    -------SELECT A DATASOURCE TO CONFIGURE-----------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

    *[P]  Publishing

      [C]  Production Core

      [D]  Done

     

    >

     

    -------CONFIGURE DATASOURCE PUBLISHING------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

    *[C]  Connection Details

      [O]  Configure Another Datasource

     

    >

    Publishing

     

     

    -------ENTER CONNECTION DETAILS-------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Publishing

     

     

      Select Database Type

     

      [1]  Oracle Thin

      [2]  MS SQL

      [3]  iNet MS SQL

      [4]  DB2

      [5]  My SQL (Development Only)

     

    Select one > 5

     

       Enter User Name > user_publishing

     

       Enter Password > *******

     

       Re-enter Password > *******

     

       Enter Host Name > localhost

     

       Enter Port Number [[3306]] >

     

       Enter Database Name > shop_publishing

     

       Enter Database URL [[jdbc:mysql://localhost:3306/shop_publishing]]

    >

     

       Enter Driver Path > D:\Program_Files\Jars\mysql-connector-java-5.1.22\mysql-connector-java-5.1.22-bin.jar

     

       Enter JNDI Name [[ATGPublishingDS]] >

     

    -------CONFIGURE DATASOURCE PUBLISHING------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

    *[T]  Test Connection

      [S]  Create Schema

      [I]  Import Initial Data

      [D]  Drop Schema

      [O]  Configure Another Datasource

     

    >

     

    -------TEST DATASOURCE CONNECTION-----------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Publishing

     

     

      >> Connection to database user_publishing @ jdbc:mysql://localhost:3306/

    shop_publishing  is successful

     

    -------CONFIGURE DATASOURCE PUBLISHING------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

      [T]  Test Connection - Done

    *[S]  Create Schema

      [I]  Import Initial Data

      [D]  Drop Schema

      [O]  Configure Another Datasource

     

    >

     

    -------CREATE SCHEMA------------------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Publishing

     

     

    *[C]  Create Schema

      [S]  Skip

     

    >

     

      Schema Creation Beginning. View log file at D:/Program_Files/ATG/ATG10.2/

    home/../CIM/ log/cim.log

      |. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . |

      |. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . |

     

      >> Schema creation completed successfully

     

    -------CONFIGURE DATASOURCE PUBLISHING------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

      [T]  Test Connection - Done

      [S]  Create Schema - Done

    *[I]  Import Initial Data

      [D]  Drop Schema

      [O]  Configure Another Datasource

     

    >

     

    -------IMPORT DATA--------------------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Publishing

     

     

    *[I]  Import Data

      [S]  Skip

     

    >

     

       Define the password for the Merchandising User (login: merchandising). Password must be at least 8 characters in length. Password must contain one of the following characters: 1234567890. Password must contain both upper-case and lower-case letters. > ********

     

       Re-enter Password > ********

     

       Define the password for the Publishing Admin User (login: admin). Password must be at least 8 characters in length. Password must contain one of the following characters: 1234567890. Password must contain both upper-case and lower-case letters. > ********

     

       Re-enter Password > ********

     

    -------DATA IMPORT PUBLISHING---------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Combining template tasks...Success

     

    Importing ( 1 of 5 ) /CIM/tmp/import/management-import1.xml:

    /DAS/install/data/dynAdminRepo.xml to /atg/dynamo/security/AdminSqlRepository

    /DPS/InternalUsers/install/data/das-security.xml to /atg/userprofiling/

    InternalProfileRepository

    /DPS/InternalUsers/install/data/dcs-security.xml to /atg/userprofiling/

    InternalProfileRepository

    /DPS/InternalUsers/install/data/security.xml to /atg/userprofiling/

    InternalProfileRepository

    /DPS/InternalUsers/install/data/searchadmin-security.xml to /atg/userprofiling/

    InternalProfileRepository

    ...Success

     

    Importing ( 2 of 5 ) /Publishing/base/install/epub-role-data.xml to /atg/userprofiling/InternalProfileRepository...Success

     

    Importing ( 3 of 5 ) /Publishing/base/install/epub-file-repository-data.xml to /atg/epub/file/PublishingFileRepository...Success

     

    Loading ( 4 of 5 ) DSS/atg/registry/data/scenarios/DSS/*.sdl & DSS/atg/

    registry/data/scenarios/recorders/*.sdl...Success

     

    Importing ( 5 of 5 ) /CIM/tmp/import/management-import2.xml:

    /DCS/install/data/initial-segment-lists.xml to /atg/userprofiling/

    PersonalizationRepository

    /DCS/Versioned/install/data/internal-users-security.xml to /atg/userprofiling/

    InternalProfileRepository

    /WebUI/install/data/profile.xml to /atg/userprofiling/InternalProfileRepository

    /WebUI/install/data/external_profile.xml to /atg/userprofiling/

    ProfileAdapterRepository

    /BIZUI/install/data/portal.xml to /atg/portal/framework/PortalRepository

    /BIZUI/install/data/profile.xml to /atg/userprofiling/InternalProfileRepository

    /BIZUI/install/data/viewmapping.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /BCC/install/data/viewmapping.xml to /atg/web/viewmapping/ViewMappingRepository

    /DPS-UI/AccessControl/install/data/viewmapping.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /DPS-UI/install/data/viewmapping.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /AssetUI/install/data/viewmapping.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /AssetUI/install/data/assetManagerViews.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /SiteAdmin/Versioned/install/data/siteadmin-role-data.xml to /atg/

    userprofiling/InternalProfileRepository

    /SiteAdmin/Versioned/install/data/viewmapping.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /SiteAdmin/Versioned/install/data/templates.xml to /atg/multisite/

    SiteRepository

    /DPS-UI/Versioned/install/data/viewmapping.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /DPS-UI/Versioned/install/data/examples.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /DCS-UI/install/data/viewmapping.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /DCS-UI/install/data/viewmapping_preview.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /DCS-UI/Versioned/install/data/users.xml to /atg/userprofiling/

    InternalProfileRepository

    /DCS-UI/Versioned/install/data/viewmapping.xml to /atg/web/viewmapping/

    ViewMappingRepository

    /DCS-UI/SiteAdmin/Versioned/install/data/viewmapping.xml to /atg/web/

    viewmapping/ViewMappingRepository

    ...Success

     

    Update administrator password (1 of 1). The administrator password was

    successfully updated in the database.

     

    All imports completed successfully.

     

    -------CONFIGURE DATASOURCE PUBLISHING------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

      [T]  Test Connection - Done

      [S]  Create Schema - Done

      [I]  Import Initial Data - Done

      [D]  Drop Schema

    *[O]  Configure Another Datasource

     

    >

     

    -------SELECT A DATASOURCE TO CONFIGURE-----------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [P]  Publishing - Done

    *[C]  Production Core

      [D]  Done

     

    >

     

    -------CONFIGURE DATASOURCE PRODUCTION CORE-------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

    *[C]  Connection Details

      [O]  Configure Another Datasource

     

    >

     

    -------RE-USE VALUES FROM PREVIOUS DATASOURCE-----------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Production Core

     

     

      Base on previous database details:

     

      [1]  user_publishing@jdbc:mysql://localhost:3306/shop_publishing

    *[2]  None/Use Existing

     

    Select one > 1

     

    -------ENTER CONNECTION DETAILS-------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Production Core

     

     

      Select Database Type

     

      [1]  Oracle Thin

      [2]  MS SQL

      [3]  iNet MS SQL

      [4]  DB2

    *[5]  My SQL (Development Only)

     

    Select one >

     

       Enter User Name [[user_publishing]] > user_production

     

       Enter Password [[*******]] >

     

       Enter Host Name [[localhost]] >

     

       Enter Port Number [[3306]] >

     

       Enter Database Name [[shop_publishing]] > shop_production

     

       Enter Database URL [[jdbc:mysql://localhost:3306/shop_production]]

    >

     

       Enter Driver Path [[D:/Program_Files/Jars/mysql-connector-java-5.1.22/mysql-connector-java-5.1.22-bin.jar]] >

     

       Enter JNDI Name [[ATGProductionDS]] >

     

    -------CONFIGURE DATASOURCE PRODUCTION CORE-------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

    *[T]  Test Connection

      [S]  Create Schema

      [I]  Import Initial Data

      [D]  Drop Schema

      [O]  Configure Another Datasource

     

    >

     

    -------TEST DATASOURCE CONNECTION-----------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Production Core

     

     

      >> Connection to database user_production @ jdbc:mysql://localhost:3306/

    shop_production  is successful

     

    -------CONFIGURE DATASOURCE PRODUCTION CORE-------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

      [T]  Test Connection - Done

    *[S]  Create Schema

      [I]  Import Initial Data

      [D]  Drop Schema

      [O]  Configure Another Datasource

     

    >

     

    -------CREATE SCHEMA------------------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Production Core

     

     

    *[C]  Create Schema

      [S]  Skip

     

    >

     

      Schema Creation Beginning. View log file at D:/Program_Files/ATG/ATG10.2/

    home/../CIM/ log/cim.log

      |. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . |

      |. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . |

     

      >> Schema creation completed successfully

     

    -------CONFIGURE DATASOURCE PRODUCTION CORE-------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

      [T]  Test Connection - Done

      [S]  Create Schema - Done

    *[I]  Import Initial Data

      [D]  Drop Schema

      [O]  Configure Another Datasource

     

    >

     

    -------IMPORT DATA--------------------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Production Core

     

     

    *[I]  Import Data

      [S]  Skip

     

    >

     

    -------DATA IMPORT PRODUCTION CORE----------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Combining template tasks...Success

     

    Importing ( 1 of 1 ) /CIM/tmp/import/nonswitchingCore-import1.xml:

    /DAS/install/data/dynAdminRepo.xml to /atg/dynamo/security/AdminSqlRepository

    /DCS/install/data/returnData.xml to /atg/commerce/custsvc/CsrRepository

    ...Success

     

    Update administrator password (1 of 1). The administrator password was

    successfully updated in the database.

     

    All imports completed successfully.

     

    -------CONFIGURE DATASOURCE PRODUCTION CORE-------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

      [T]  Test Connection - Done

      [S]  Create Schema - Done

      [I]  Import Initial Data - Done

      [D]  Drop Schema

    *[O]  Configure Another Datasource

     

    >

     

    -------SELECT A DATASOURCE TO CONFIGURE-----------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [P]  Publishing - Done

      [C]  Production Core - Done

    *[D]  Done

     

    > P

     

    -------CONFIGURE DATASOURCE PUBLISHING------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

     

      [C]  Connection Details - Done

      [T]  Test Connection - Done

      [S]  Create Schema - Done

      [I]  Import Initial Data - Done

      [D]  Drop Schema

    *[O]  Configure Another Datasource

     

    > C

     

    -------RE-USE VALUES FROM PREVIOUS DATASOURCE-----------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Publishing

     

     

      Base on previous database details:

     

      [1]  user_publishing@jdbc:mysql://localhost:3306/shop_publishing

      [2]  user_production@jdbc:mysql://localhost:3306/shop_production

    *[3]  None/Use Existing

     

    Select one >

     

    -------ENTER CONNECTION DETAILS-------------------------------------------------

    enter [h]elp, [m]ain menu, [q]uit to exit

     

     

    Publishing

     

     

      Select Database Type

     

      [1]  Oracle Thin

      [2]  MS SQL

      [3]  iNet MS SQL

      [4]  DB2

    *[5]  My SQL (Development Only)

     

    Select one > M

     

    =======CIM MAIN MENU============================================================

    enter [h]elp, [q]uit to exit

     

     

    Choose the task you want to perform:

     

     

      [1]  Database Configuration - Done

    *[2]  Server Instance Configuration

      [3]  Application Assembly & Deployment

      [R]  Set the Administrator Password - Done

      [P]  Product Selection - Done (Oracle ATG Web Commerce & ATG Content

    Administration & ATG Site Administration)

      [A]  Select Application Server - Done (Raw)

      [C]  Custom CIM Plugin Launcher

     

    > 1

     

     

    I hope this CIM log is helpful.

  • 2. Re: ATG ENVIRONMENT SETUP ISSUE
    Prateek G Newbie
    Currently Being Moderated

    Hi,

     

    In ATG 10.0.3 you don't need to install mysql explicitly;it is preconfigured with ATG 10.0.3.

     

    Just go to start-->ATG folder-->Tools-->start MYSql server first.

     

    Then for database setup go to the path in command path as <ATGdir>/mysql/win/bin>mysql -u root -p and press enter

    It asks for password, just press enter and create your databse,user as suggested above-

    Mysql prompt:

         CREATE database shop_production;   

     

         CREATE USER 'user_production'@'localhost' IDENTIFIED BY 'default';

         grant all on *.* to 'user_production'@'localhost';

      

         use shop_prod;

         source {ATG_HOME}\DAS\sql\install\mysql\das_ddl.sql

         source {ATG_HOME}\DPS\sql\install\mysql\dps_ddl.sql

         source {ATG_HOME}\DSS\sql\install\mysql\dss_ddl.sql

         source {ATG_HOME}\DCS\sql\install\mysql\dcs_ddl.sql

         FYI-chnage {ATG_HOME} to ATG directory.

     

    this will complete your mysql db part.

    Since you are using Weblogic, there you must setup datasource also according to mysql settings.

     

    Let me know if you stuck in any step.

     

    Thanks & Regards,

    Prateek Gupta