Oracle Database on Amazon RDS - Alfresco Content Services - 23.4 - 23.4 - Ready - Alfresco - external

Alfresco Content Services
Platform
Alfresco
Product
Alfresco Content Services
Release
23.4
License

You can configure an Oracle database on Amazon RDS for use with Content Services, with the following prerequisites:

The Oracle database is case sensitive, so any configuration setting that you add into the alfresco.global.properties file must match the case used in Oracle.

  1. Use the ssh command to connect to the Amazon EC2 instance using a provided .ppk key.
    • For Amazon Linux, the user name is ec2-user.
    • For RHEL5, the user name is either root or ec2-user.
    • For Ubuntu, the user name is ubuntu. For SUSE Linux, the user name is root.
  2. Execute sudo su to change to root.
  3. Install Content Services.
  4. Install the Oracle database connector to allow the database to talk to the server.
    1. Download ojdbc7.jar from the Oracle download site.
    2. Copy the JAR file into the /lib directory.

      For example, for Tomcat, copy the JAR file into the <TOMCAT_HOME>/lib directory.

  5. Install and use a database tool to connect to the Amazon RDS.
  6. Increase the available connections.
    1. In the SQL*Plus Console, run these commands: 
       alter system set processes=275 scope=spfile sid='*';
 alter system set sessions=305 scope=spfile sid='*';
 alter system set transactions=330 scope=spfile sid='*';
    2. Restart the database.
  7. Create a database named alfresco.
  8. Create a user named alfresco.
  9. Set the new user’s password to alfresco.
  10. Open the <classpathRoot>/alfresco-global.properties.sample file.
  11. Edit the following line with an absolute path to point to the directory in which you want to store Content Services data. For example: 
    dir.root=C:/Alfresco/alf_data
  12. Set and uncomment the database connection properties as shown below: 
    db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=alfrescoora12.cw4mo3qj8qdu.us-east-1.rds.amazonaws.com
db.port=1433
db.pool.max=275
db.txn.isolation=4096

# Oracle database connection

db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@${db.host}:${db.port}:${db.name}
    Note: Ensure that these database connection properties aren’t commented out.
  13. Save the file without the .sample extension.
  14. Restart the Content Services server.