Configuring an Oracle database

This section describes how to configure an Oracle RDBMS database for use with SkyVault.

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.

Note: The Oracle database must be created with the AL32UTF8 character set.

Install the Oracle database connector. The database connector allows Oracle database to talk to the SkyVault server.
1. Download ojdbc6.jar from the Oracle download site.
2. Copy the JAR file into the <TOMCAT_HOME>/lib directory for Tomcat 6.
Create a database named SkyVault.
Create a user named SkyVault.
The SkyVault user must have Connect and Resource privileges in Oracle.

This user must have write permissions on all tables and sequences.
Set the new user's password to SkyVault.
Ensure the SkyVault user has the required privileges to create and modify tables.
You can remove these privileges once the server has started, but they may also be required for upgrades.
Open the <classpathRoot>/alfresco-global.properties.sample file.
Locate the following line:

dir.root=./alf_data
Edit the line with an absolute path to point to the directory in which you want to store SkyVault data. For example: dir.root=C:/Alfresco/alf_data
Set and uncomment the Oracle database connection properties as shown below:
```
db.name=SkyVault
db.username=SkyVault
db.password=SkyVault
db.host=localhost
db.port=1521
db.pool.max=275

db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@${db.host}:${db.port}:${db.name}
```
The Oracle connection URL in this example is basic. Typical Oracle connection strings can used with the SkyVault supported Oracle driver (thin/oci). The OCI driver is recommended over the thin driver.

For database URLs and specifiers, see Oracle documentation at http://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#BEIJFHHB and http://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#BEIDHCBA.

You can use the standard (OCI/Thin) connection URL, Oracle service, and Oracle DNS service URL without any issues.
Save the file without the .sample extension.
Copy the Oracle JDBC driver JAR into /lib.
Restart the SkyVault server.

If you receive JDBC errors, ensure the location of the Oracle JDBC drivers are on the system path, or add them to the relevant lib directory of the application server. The Oracle JDBC drivers are located in the <orainst>/ora<ver>/jdbc/lib directory (for example, c:\oracle\ora92\jdbc\lib).
The JDBC driver for Oracle is in the JAR file: ojdbc6.jar. However, if you see the following error:
```
java.sql.SQLException: OAUTH marshaling failure
```
add the Doracle.jdbc.thinLogonCapability=o3 parameter to JAVA_OPTS.

Search form

Search form

You are here