November Happy Hour will be moved to Thursday December 5th.
November Happy Hour will be moved to Thursday December 5th.
Product version: |
EPiServer CMS 6 R2 |
---|---|
Document last saved: |
This document explains how to configure an EPiServer CMS 6 R2 site with Oracle database and some preliminary steps that should be performed.
This document DOES NOT explain how to:
All prerequisites are valid for an EPiServer CMS 6 installation (see system requirements); there are some further prerequisites for configuration with an Oracle database - which are:
<package version="1.0" id="UpgradeSite">
<!--Uncomment below action to able to run Oracle Install-->
<action id="InstallOracle" displayName="Install Oracle Configuration" scriptPath="Install Oracle Configuration.ps1" actionType="Install">
<description>Installs an EPiServer CMS web site with Oracle database</description>
</action>
</package>
The changes required for configuring EPiServer CMS 6 R2 on an Oracle database will be performed on the site selected.
<EPiServer HOME> in these instructions is the path EPiServer CMS 6 is typically installed on: “C:\Program Files\EPiServer\” or “C:\Program Files (x86)\EPiServer\” on 64-bit machines.
<ORACLE HOME> is a directory where you installed your oracle client components, for example “C:\OracleClient\”.
CREATE TABLESPACE EPISERVER_DATA
LOGGING DATAFILE 'C:/oraclexe/oradata/epdev/EP_DATA.dbf'
SIZE 500M
EXTENT MANAGEMENT LOCAL;
CREATE USER EPISERVER IDENTIFIED BY EPISERVER
DEFAULT TABLESPACE EPISERVER_DATA
TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE TO EPISERVER;
GRANT CONNECT, RESOURCE TO EPISERVER;
GRANT CHANGE NOTIFICATION TO EPISERVER;
GRANT CREATE JOB TO EPISERVER;
GRANT CREATE PUBLIC SYNONYM TO EPISERVER;
GRANT CREATE PROCEDURE TO EPISERVER;
GRANT CREATE ROLE TO EPISERVER;
GRANT CREATE SESSION TO EPISERVER;
GRANT CREATE TABLE TO EPISERVER;
GRANT CREATE VIEW TO EPISERVER;
GRANT CREATE VIEW TO EPISERVER;
GRANT DROP PUBLIC SYNONYM TO EPISERVER;
GRANT UNLIMITED TABLESPACE TO EPISERVER;
EPISERVERORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname or IP>)(PORT = <port>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <database service name>)
)
)
<add name="EPiServerDB_oracle" connectionString="Data Source=EPISERVERORACLE;User Id=EPISERVER;Password=EPISERVER;" providerName="Oracle.DataAccess.Client"/>
NOTE: the connectionString attribute contains Data Source section that is identical to the data source alias for Oracle which is inserted in tnsnames.ora fileIf you wish, now you can Install Alloy Templates from Deployment Center.
The configuration of EPiServer CMS 6 R2 Web site with the Oracle database installation should now be complete.
In SQLPLUS connected to <EPISERVER> user run the Oracle upgrade scripts, provided in the EPiServer CMS 6 R2 installation, in the following order:
@"C:\<frameworkHome>\<FrameworkVersion>\Upgrade\Database\Oracle\0006_0000_0318_0113to0006_0002_0127_0000.sql"
@"C:\<frameworkHome>\<FrameworkVersion>\Upgrade\Database\Oracle\0006_0002_0128_0000to0006_0002_0130_0000.sql"
@"C:\<frameworkHome>\<FrameworkVersion>\Upgrade\Database\Oracle\0006_0002_0131_0000to0006_0002_0138_0000.sql"
@"C:\<frameworkHome>\<FrameworkVersion>\Upgrade\Database\Oracle\0006_0002_0139_0000to0006_0002_0228_0000.sql"
@"C:\<frameworkHome>\<FrameworkVersion>\Upgrade\Database\Oracle\0006_0002_0229_0000to0006_0002_0256_0000.sql"
@"C:\<EPiserverCmsHome>\<EPiserverCmsVersion>\Upgrade\Database\oracle\0006_0000_0530_0000to0006_0001_0233_0000.sql"
@"C:\<EPiserverCmsHome>\<EPiserverCmsVersion>\Upgrade\Database\oracle\0006_0000_0612_0000to0006_0000_0829_0000.sql"
@"C:\<EPiserverCmsHome>\<EPiserverCmsVersion>\Upgrade\Database\oracle\0006_0001_0234_0000to0006_0001_0236_0001.sql"
@"C:\<EPiserverCmsHome>\<EPiserverCmsVersion>\Upgrade\Database\oracle\0006_0001_0237_0000to0006_0001_0287_0000.sql"
@"C:\<EPiserverCmsHome>\<EPiserverCmsVersion>\Upgrade\Database\oracle\0006_0001_0288_0000to0006_0001_0316_0000.sql"
<package version="1.0" id="UpgradeSite">
<!--Uncomment below action to able to run Oracle Upgrade-->
<action id="UpgradeFrom52WithoutDatabase" displayName="Upgrade site with Oracle database" scriptPath="Upgrade Site (Oracle).ps1" actionType="Upgrade">
<description>Upgrades an EPiServer CMS web site from any 5.2 SP2 version to 6.0 without upgrading the database</description>
</action>
</package>
If you wish, now you can upgrade an EPiServer CMS 6 site from the deployment center.