- Home
- Docs
- Installation and configuration
- Enterprise
- Docker version
- Connecting Oracle database to ONLYOFFICE Docs
Connecting Oracle database to ONLYOFFICE Docs
Currently, there are no Docker variables that allow connecting with Oracle; the user must perform the steps manually. The steps to connect Oracle database to ONLYOFFICE Docs are as follows:
-
Install ONLYOFFICE Docs:
sudo docker run -i -t -d -p 80:80 --name onlyoffice \ onlyoffice/documentserver-ee
-
Install Oracle on the same or a separate server:
sudo docker run --name oracle -p 8080:1521 -p 8081:5500 \ -e ORACLE_PASSWORD=admin \ -e APP_USER=onlyoffice \ -e APP_USER_PASSWORD=onlyoffice \ -d gvenzl/oracle-xe:21-slim
-
Download a script for creating tables and copy it to the container; afterward, create a database and run the script:
wget https://github.com/ONLYOFFICE/server/raw/master/schema/oracle/createdb.sql sudo docker cp ./createdb.sql oracle:/ sudo docker exec oracle sqlplus -s onlyoffice/onlyoffice@//localhost/xepdb1 @/createdb.sql
-
Change the parameters responsible for establishing a connection in
local.json
and switch Document Server to mssql:sudo docker exec -it onlyoffice bash nano /etc/onlyoffice/documentserver/local.json "services": {"CoAuthoring": {"sql": {"type": "oracle","dbHost": "oracle_ip_or_hostname","dbPort": "8080","dbName": "xepdb1","dbUser": "onlyoffice","dbPass": "onlyoffice"... supervisorctl restart all
Host ONLYOFFICE Docs on your own server or use it in the cloud
Article with the tag:
Browse all tags