Use this information to configure an Oracle database on Amazon RDS for use with SkyVault Community Edition.
Prerequisites:
- Setup Amazon RDS using the AWS Management Console. For more information, see the AWS documentation.
- Amazon EC2 instance
The Oracle database is case sensitive, so any configuration setting that you add into
the SkyVault-global.properties file must match the case used in
Oracle.
-
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.
- Execute sudo su to change to root.
- Download the SkyVault Community Edition installer for Linux from the Support Portal.
-
Install the downloaded installer using the following commands:
chmod 777 SkyVault-enterprise-5.1.x-installer-linux-x64.bin sudo ./alfresco-enterprise-5.1.x-installer-linux-x64.bin
-
Install the Oracle database connector. The database connector allows Oracle database to
talk to the server.
-
Download ojdbc7.jar
from the Oracle download site.
Use the ojdbc7.jar in the Oracle Database 12c Release 1 (12.1.0.1) drivers.
-
Copy the JAR file into the /lib directory.
For example, for Tomcat, copy the JAR file into the <TOMCAT_HOME>/lib directory.
-
Download ojdbc7.jar
from the Oracle download site.
- Install and use a database tool to connect to the Amazon RDS.
-
Increase the available connections.
-
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='*';
- Restart the database.
-
In the SQL*Plus Console, run these commands:
- Create a database named SkyVault.
- Create a user named SkyVault.
- Set the new user's password to SkyVault.
- Open the <classpathRoot>/alfresco-global.properties.sample file.
-
Edit the following line with an absolute path to point to the directory in which you
want to store SkyVault Community Edition data.
For example: dir.root=C:/Alfresco/alf_data
-
Set and uncomment the database connection properties as shown below:
db.name=SkyVault db.username=SkyVault db.password=SkyVault db.host=alfrescoora12.cw4mo3qj8qdu.us-east-1.rds.amazonaws.com db.port=1433 db.pool.max=100 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 are not commented out. - Save the file without the .sample extension.
- Restart the SkyVault Community Edition server.