Configuring an Oracle database as a content storage and session data storage medium
To make an Oracle database available as a storage medium for content and session data, add two Storage elements to the Storage Layer configuration file.
Procedure
- In the configuration directory of the Role, open
cd_storage_conf.xmlfor editing. - In the
Storageselement, ensure the presence of two<Storage>elements, uncommented, one for the Content Data Store and one for session data storage:<Storage Type="persistence" Id="UNIQUE_ID" dialect="ORACLESQL" Class="com.tridion.storage.persistence.JPADAOFactory"> <Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" /> <DataSource class="oracle.jdbc.pool.OracleDataSource"> <Property Name="driverType" Value="thin" /> <Property Name="networkProtocol" Value="tcp" /> <Property Name="serverName" Value="SERVER_NAME" /> <Property Name="portNumber" Value="1521" /> <Property Name="databaseName" Value="DATABASE_NAME" /> <Property Name="user" Value="USER_NAME" /> <Property Name="password" Value="PASSWORD" /> </DataSource> </Storage>where:UNIQUE_IDis a string of your choosing that uniquely identifies this storage mediumSERVER_NAMEis the name of the database server hostDATABASE_NAMEis the name of the database to accessUSER_NAMEis the name of a user who can access the databasePASSWORDis a valid password for that user
If you are connecting to Oracle RAC, use the property name
serviceNameinstead ofdatabaseName. - Ensure the presence of an
ItemTypeselement with itsdefaultStorageIdattribute set to the ID of the database. - SDL strongly recommends entering any sensitive strings, such as passwords, in encrypted form. You can obtain the encrypted form of a sensitive string by doing the following:
- In a command shell, navigate to a location that contains the files udp-core-BUILD.jar and udp-common-util-BUILD.jar, where
BUILDis the JAR file's build number. For example, you can find these files on the installation media in the folder Content Delivery\roles\api\rest\java\lib\ - Depending on your operating system, enter one of the following commands:
- Windows operating systems
-
java -cp udp-core-BUILD.jar;udp-common-util-BUILD.jar com.tridion.crypto.Encrypt INPUT - Unix operating systems
-
java -cp udp-core-BUILD.jar:udp-common-util-BUILD.jar com.tridion.crypto.Encrypt INPUT
where INPUT is the unencrypted string. (You may wish to redirect output to a file for easy copy-pasting of the tool's response.)
The tool returns the following kind of response:Configuration value = encrypted:9FUJ9CP81Oj63VhnJxcqx//pW3fP4bekeupIexctzcs=where the encrypted string is
encrypted:9FUJ9CP81Oj63VhnJxcqx//pW3fP4bekeupIexctzcs=
- In a command shell, navigate to a location that contains the files udp-core-BUILD.jar and udp-common-util-BUILD.jar, where
- Save and close
cd_storage_conf.xml.