Oracle - Oracle - Alfresco - Alfresco Sync Service - Alfresco/Alfresco-Sync-Service/5.2/Alfresco-Sync-Service/Install/Database/Oracle - 5.2

Alfresco recommends that you use a separate Oracle instance for the Sync Service.

Note: Only the Sync Service communicates with the database. It persists events taken from the JMS queue into the database. The repository does not communicate with the database.

The Sync Service isn’t packaged with an Oracle driver, so it’ll need to be downloaded separately and cited in the start-up. For more information on downloading the Sync Service, see Install options.

Download the Oracle database connector from the download page available at https://www.oracle.com.
For the supported database connector version, see the compatible version for your installed version of Alfresco Content Services in the Alfresco Supported Platforms documentation.
Copy the JAR file into the same directory as the Sync Service JAR.
The JDBC driver for Oracle is in the JAR file, for example: OjdbcXX.jar (where XX is the version number).

However, if you see the following error, then add the Doracle.jdbc.thinLogonCapability=o3 parameter to JAVA_OPTS:
```
java.sql.SQLException: OAUTH marshaling failure
```
The Oracle database must be created with the AL32UTF8 character set. Check the current character set by executing:
```
SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;
```
Increase the maximum connections setting in the Oracle configuration file. The property processes specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. This effectively determines the maximum number of concurrent users in the system.
```
alter system set processes=450 scope=spfile
```
The value of the db.pool.max property in the config.yml file must be less than processes.

If there are multiple Sync Service instances forming a cluster hidden behind a load balancer, processes should be greater than or equal to the sum of all db.pool.max from all config.yml files.

For example, if processes=450, and there are 3 Sync Service instances, then the correct setting in config.yml is db.pool.max : 150.
Create a user with the username given by the sync property, sql.db.username, with password given by the sync property, sql.db.password:
```
CREATE USER alfresco IDENTIFIED BY admin;
```
Grant the alfresco user Connect and Resource privileges in Oracle.
1. Grant the user write permissions on all tables and sequences:
```
GRANT CONNECT, RESOURCE TO alfresco;
```
2. Configure the privileges by using one of the following commands:
```
ALTER USER alfresco QUOTA <QUOTE_M> ON Users;
```
  or
```
GRANT UNLIMITED TABLE SPACE TO alfresco
```
  Note: If the privileges on tablespace “USERS” aren’t set correctly, you may see the following error:
```
ORA-01950: no privileges on tablespace 'USERS'
```

Ensure sql.db.driver and sql.db.url are correctly updated in the config.yml file, for example:

 sql:
     db:
         driver: oracle.jdbc.OracleDriver
         url: jdbc:oracle:thin:@//localhost:1521/xe