# translate-db

**Repository Path**: wizard-paradise/translate-db

## Basic Information

- **Project Name**: translate-db
- **Description**: Translate DB
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-03-28
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# HuaWeiDigitalMeetingDB

#### Requirements
* [docker](https://docs.docker.com/engine/installation/linux/centos/)
* [docker-compose](https://docs.docker.com/compose/install/)

### Instructions
* Startup Oracle service
`docker-compose up -d`

* Stop Oracle service
`docker-compose stop`

* Check service running status
`docker-compose ps`

* Login to Oracle container
`docker-compose exec db /bin/bash`

* Execute SQL
`docker-compose exec db /bin/bash`
`sqlplus <username>/<password>`


###
* Connection String
    * [x] jdbc.url: jdbc:oracle:thin:@<host-name>:1521/xe
    * [x] jdbc.username: digitalmeeting
    * [x] jdbc.password: digitalmeeting

###Huawei Cloud Desktop connection production DB (use PLSQL Developer)
* Connection info
    * [x] "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.82.246.123)(PORT=8006)))(CONNECT_DATA=(SERVICE_NAME=xe)))"
    * [x] digitalmeeting
    * [x] digitalmeeting
* Configuration Information
    * install Oracle to 118 (a machine that has access to production database)
        * create user digitalmeeting identified by digitalmeeting;
        * grant dba to digitalmeeting;
        * create database link WEMEETING connect to wemeeting identified by b#cAnMHkw7QrXy using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dggtge-scn.huawei.com)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=dggtge)))';
        * create or replace synonym meeting for wemeeting.meeting@WEMEETING;
        * create or replace synonym ccm_participants for wemeeting.ccm_participants@WEMEETING;
        * create or replace synonym comments for wemeeting.comments@WEMEETING;
        * create or replace synonym databasechangelog for wemeeting.databasechangelog@WEMEETING;
        * create or replace synonym databasechangeloglock for wemeeting.databasechangeloglock@WEMEETING;
        * create or replace synonym meeting_participant for wemeeting.meeting_participant@WEMEETING;
        * create or replace synonym message for wemeeting.message@WEMEETING;
        * create or replace synonym message_receiver for wemeeting.message_receiver@WEMEETING;
        * create or replace synonym users for wemeeting.users@WEMEETING;
    * Run the command in 123
        * iptables -t nat -A PREROUTING -p tcp --dport 8006 -j DNAT --to-destination 10.82.246.118:1521