You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shenyu.apache.org by xi...@apache.org on 2022/06/13 10:53:44 UTC
[incubator-shenyu-website] branch main updated: [ISSUE #587] Add oracle environment deployment documentation and more detailed guidance. (#594)
This is an automated email from the ASF dual-hosted git repository.
xiaoyu pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-shenyu-website.git
The following commit(s) were added to refs/heads/main by this push:
new 5ae55e98f2 [ISSUE #587] Add oracle environment deployment documentation and more detailed guidance. (#594)
5ae55e98f2 is described below
commit 5ae55e98f26a36d82a436d5fcd24044e2a755118
Author: Shawn Jim <32...@users.noreply.github.com>
AuthorDate: Mon Jun 13 18:53:39 2022 +0800
[ISSUE #587] Add oracle environment deployment documentation and more detailed guidance. (#594)
* [DOC #587] Add the user initializing database guide.
* [DOC #587] pass markdownlint.
* [DOC #587] pass markdownlint.
* [DOC #587] Add oracle environment deployment documentation and more detailed guidance.
---
docs/deployment/deployment-docker-compose.md | 6 +++++-
docs/deployment/deployment-docker.md | 20 ++++++++++++++++----
docs/deployment/deployment-local.md | 10 ++++++----
docs/deployment/deployment-package.md | 20 ++++++++++++++------
.../deployment/deployment-docker-compose.md | 6 +++++-
.../current/deployment/deployment-docker.md | 20 ++++++++++++++++----
.../current/deployment/deployment-local.md | 8 +++++---
.../current/deployment/deployment-package.md | 20 ++++++++++++++------
.../deployment/deployment-docker-compose.md | 6 +++++-
.../version-2.4.3/deployment/deployment-docker.md | 20 ++++++++++++++++----
.../version-2.4.3/deployment/deployment-local.md | 8 +++++---
.../version-2.4.3/deployment/deployment-package.md | 22 +++++++++++++++-------
.../deployment/deployment-docker-compose.md | 6 +++++-
.../version-2.4.3/deployment/deployment-docker.md | 20 ++++++++++++++++----
.../version-2.4.3/deployment/deployment-local.md | 8 +++++---
.../version-2.4.3/deployment/deployment-package.md | 22 +++++++++++++++-------
16 files changed, 163 insertions(+), 59 deletions(-)
diff --git a/docs/deployment/deployment-docker-compose.md b/docs/deployment/deployment-docker-compose.md
index bb5e708c89..0b29d7407c 100644
--- a/docs/deployment/deployment-docker-compose.md
+++ b/docs/deployment/deployment-docker-compose.md
@@ -23,9 +23,13 @@ This script will download the required configuration files and mysql-connector,
sh ./install.sh #The latest configuration is pulled by default. If you need to deploy the released version, you can add a parameter to indicate the version number, such as: v2.4.2 or latest
```
+### Initialize the `shenyu-admin` database
+
+Refer to the [database initialization documentation](./deployment-before.md#database-initialize) to initialize the database.
+
### Modify the configuration file
-The configuration file downloaded by the script can be modified.
+Modify the configuration file downloaded by the script to set up configurations such as `JDBC`.
### Execute docker-compose
diff --git a/docs/deployment/deployment-docker.md b/docs/deployment/deployment-docker.md
index 791f4ee1a7..5733cca691 100644
--- a/docs/deployment/deployment-docker.md
+++ b/docs/deployment/deployment-docker.md
@@ -22,25 +22,37 @@ This article introduces the use of `docker` to deploy the `Apache ShenYu` gatewa
> docker run -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-* use `MySQL` to store data, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to `/$(your_work_dir)/ext-lib`：
+* use `MySQL` to store data, follow the [guide document](./deployment-before.md#mysql) to initialize the database, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to `/$(your_work_dir)/ext-lib`：
```
docker run -v /${your_work_dir}/ext-lib:/opt/shenyu-admin/ext-lib -e "SPRING_PROFILES_ACTIVE=mysql" -e "spring.datasource.url=jdbc:mysql://${your_ip_port}/shenyu?useUnicode=true&characterEncoding=utf-8&useSSL=false" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-another way is to put the `application.yml`、`application-mysql.yml`、`application-pg.yml` configuration in ${your_work_dir}/conf from [Configure address](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) , and then execute the following statement：
+another way is to put the `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` configuration in ${your_work_dir}/conf from [Configure address](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) , modify the configuration `spring.profiles.active = mysql` in `application.yml`, and then execute the following statement：
```
docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -v /${your_work_dir}/ext-lib:/opt/shenyu-admin/ext-lib -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-* use `PostgreSql` to store data, execute the following statement：
+* use `PostgreSql` to store data, follow the [guide document](./deployment-before.md#postgresql) to initialize the database, execute the following statement：
```
docker run -e "SPRING_PROFILES_ACTIVE=pg" -e "spring.datasource.url=jdbc:postgresql://${your_ip_port}/shenyu?useUnicode=true&characterEncoding=utf-8&useSSL=false" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-another way is to put the `application.yml` configuration in ${your_work_dir}/conf, and then execute the following statement：
+another way is to put the `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` configuration in ${your_work_dir}/conf, modify the configuration `spring.profiles.active = pg` in `application.yml`,and then execute the following statement：
+
+```
+docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
+```
+
+* use `Oracle` to store data, follow the [guide document](./deployment-before.md#oracle) to initialize the database, execute the following statement：
+
+```
+docker run -e "SPRING_PROFILES_ACTIVE=oracle" -e "spring.datasource.url=jdbc:oracle:thin:@localhost:1521/shenyu" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
+```
+
+another way is to put the `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` configuration in ${your_work_dir}/conf, modify the configuration `spring.profiles.active = oracle` in `application.yml`, and then execute the following statement：
```
docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
diff --git a/docs/deployment/deployment-local.md b/docs/deployment/deployment-local.md
index 01dce11874..17da4d3a0f 100644
--- a/docs/deployment/deployment-local.md
+++ b/docs/deployment/deployment-local.md
@@ -28,11 +28,13 @@ This article introduces how to start the `Apache ShenYu` gateway in the local en
* use the development tool to start `org.apache.shenyu.admin.ShenyuAdminBootstrap`，Visit http://localhost:9095, the default username and password are: `admin` and `123456` respectively.
- * If you use `h2` to store, set the variable `--spring.profiles.active = h2`.
+ * If you use `h2` for storage, set the variable `--spring.profiles.active = h2` and start the server.
- * If you use `MySQL` for storage, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to /$(your_work_dir)/ext-lib, and modify the `mysql` configuration in `application.yaml`.
-
- * If you use `PostgreSql` for storage, modify the `pg` of `spring.profiles.active` configuration in `application.yaml`.
+ * If you use `MySQL` for storage, follow the [guide document](./deployment-before.md#mysql) to initialize the database and modify the `JDBC` configuration in `application-mysql.yml`, set the variable `--spring.profiles.active = mysql` and start the server.
+
+ * If you use `PostgreSql` for storage, follow the [guide document](./deployment-before.md#postgresql) to initialize the database and modify the `JDBC` configuration in `application-pg.yml`, set the variable `--spring.profiles.active = pg` and start the server.
+
+ * If you use `Oracle` for storage, follow the [guide document](./deployment-before.md#oracle) to initialize the database and modify the `JDBC` configuration in `application-oracle.yml`, set the variable `--spring.profiles.active = oracle`.
* use the development tool to start `org.apache.shenyu.bootstrap.ShenyuBootstrapApplication`.
diff --git a/docs/deployment/deployment-package.md b/docs/deployment/deployment-package.md
index 8a6d2613e2..be94342004 100644
--- a/docs/deployment/deployment-package.md
+++ b/docs/deployment/deployment-package.md
@@ -23,20 +23,28 @@ This article introduces the deployment of the `Apache ShenYu` gateway using the
> linux: ./start.sh --spring.profiles.active = h2
```
-* use `MySQL` to store data, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to /$(your_work_dir)/ext-lib, go to the `/conf` directory, and modify the configuration of `mysql` in `application.yaml`.
+* use `MySQL` to store data, follow the [guide document](./deployment-before.md#mysql) to initialize the database, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to /$(your_work_dir)/ext-lib, go to the `/conf` directory, and modify the `JDBC` configuration in `application-mysql.yml`.
```
-> windows: start.bat
+> windows: start.bat --spring.profiles.active = mysql
-> linux: ./start.sh
+> linux: ./start.sh --spring.profiles.active = mysql
```
-* use `PostgreSql` to store data, go to the `/conf` directory, and modify `spring.profiles.active` of the configuration in `application.yaml` to `pg`.
+* use `PostgreSql` to store data, follow the [guide document](./deployment-before.md#postgresql) to initialize the database, go to the `/conf` directory, and modify the `JDBC` configuration in `application-pg.yml`.
```
-> windows: start.bat
+> windows: start.bat --spring.profiles.active = pg
-> linux: ./start.sh
+> linux: ./start.sh --spring.profiles.active = pg
+```
+
+* use `Oracle` to store data, follow the [guide document](./deployment-before.md#oracle) to initialize the database, go to the `/conf` directory, and modify the `JDBC` configuration in `application-oracle.yml`.
+
+```
+> windows: start.bat --spring.profiles.active = oracle
+
+> linux: ./start.sh --spring.profiles.active = oracle
```
### Start Apache ShenYu Bootstrap
diff --git a/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-docker-compose.md b/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-docker-compose.md
index 08cba0e0bb..57be598e78 100644
--- a/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-docker-compose.md
+++ b/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-docker-compose.md
@@ -23,9 +23,13 @@ curl -O https://raw.githubusercontent.com/apache/incubator-shenyu/master/shenyu-
sh ./install.sh #默认拉取最新配置，如果需要部署已发布版本，可增加一个参数表示版本号，比如：v2.4.2 或 latest
```
+### 初始化`shenyu-admin`存储数据源
+
+参考[数据库初始文档](./deployment-before.md#数据库环境准备) 初始化数据库环境 。
+
### 修改配置文件
-可以修改脚本下载的配置文件。
+修改脚本下载的配置文件来设置`JDBC`等配置。
### 执行 docker-compose
diff --git a/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-docker.md b/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-docker.md
index 79885dc681..1cd1f08c84 100644
--- a/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-docker.md
+++ b/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-docker.md
@@ -22,25 +22,37 @@ description: docker部署
> docker run -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-* 使用 `MySQL` 来存储后台数据,将 [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) 拷贝到 `/${your_work_dir}/ext-lib`：
+* 使用 `MySQL` 来存储后台数据, 按照 [指引文档](./deployment-before.md#mysql) 初始化数据库, 将 [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) 拷贝到 `/${your_work_dir}/ext-lib`：
```
docker run -v /${your_work_dir}/ext-lib:/opt/shenyu-admin/ext-lib -e "SPRING_PROFILES_ACTIVE=mysql" -e "spring.datasource.url=jdbc:mysql://${your_ip_port}/shenyu?useUnicode=true&characterEncoding=utf-8&useSSL=false" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml` 配置放到`${your_work_dir}/conf` ， 然后执行以下语句：
+另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` 配置放到`${your_work_dir}/conf` ， 调整`application.yml`中的配置`spring.profiles.active = mysql`，然后执行以下语句：
```
docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -v /${your_work_dir}/ext-lib:/opt/shenyu-admin/ext-lib -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-* 使用 `PostgreSql` 来存储后台数据, 执行以下语句：
+* 使用 `PostgreSql` 来存储后台数据, 按照 [指引文档](./deployment-before.md#postgresql) 初始化数据库, 执行以下语句：
```
docker run -e "SPRING_PROFILES_ACTIVE=pg" -e "spring.datasource.url=jdbc:postgresql://${your_ip_port}/shenyu?useUnicode=true&characterEncoding=utf-8&useSSL=false" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml` 配置放到`${your_work_dir}/conf` ， 然后执行以下语句：
+另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` 配置放到`${your_work_dir}/conf`， 调整`application.yml`中的配置`spring.profiles.active = pg`，然后执行以下语句：
+
+```
+docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
+```
+
+* 使用 `Oracle` 来存储后台数据, 按照 [指引文档](./deployment-before.md#oracle) 初始化数据库, 执行以下语句：
+
+```
+docker run -e "SPRING_PROFILES_ACTIVE=oracle" -e "spring.datasource.url=jdbc:oracle:thin:@localhost:1521/shenyu" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
+```
+
+另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` 配置放到`${your_work_dir}/conf`， 调整`application.yml`中的配置`spring.profiles.active = oracle`，然后执行以下语句：
```
docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
diff --git a/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-local.md b/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-local.md
index b06bb1996d..3f79186679 100644
--- a/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-local.md
+++ b/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-local.md
@@ -28,11 +28,13 @@ description: 本地部署
* 使用开发工具启动 `org.apache.shenyu.admin.ShenyuAdminBootstrap`，访问 http://localhost:9095 ， 默认用户名和密码分别为: `admin` 和 `123456`。
- * 如果使用`h2`来存储，设置变量 `--spring.profiles.active = h2`
+ * 如果使用`h2`来存储，设置变量 `--spring.profiles.active = h2` 启动服务。
- * 如果使用`MySQL`来存储，修改 `application.yaml` 中的 `mysql` 配置。
+ * 如果使用`MySQL`来存储，需按照 [指引文档](./deployment-before.md#mysql) 初始化数据库和修改 `application-mysql.yml` 中的 `jdbc` 相关配置，再设置变量 `--spring.profiles.active = mysql` 启动服务。
- * 如果使用`PostgreSql`来存储，修改 `application.yaml` 中的 `spring.profiles.active` 配置为 `pg`。
+ * 如果使用`PostgreSql`来存储，需按照 [指引文档](./deployment-before.md#postgresql) 初始化数据库和修改 `application-pg.yml` 中的 `jdbc` 相关配置，再设置变量 `--spring.profiles.active = pg` 启动服务。
+
+ * 如果使用`Oracle`来存储，需按照 [指引文档](./deployment-before.md#oracle) 初始化数据库和修改 `application-oracle.yml` 中的 `jdbc` 相关配置，再设置变量 `--spring.profiles.active = oracle` 启动服务。
* 使用开发工具启动 `org.apache.shenyu.bootstrap.ShenyuBootstrapApplication`。
diff --git a/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-package.md b/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-package.md
index 60f0ddc8c5..f71e44a35f 100644
--- a/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-package.md
+++ b/i18n/zh/docusaurus-plugin-content-docs/current/deployment/deployment-package.md
@@ -24,20 +24,28 @@ description: 二进制包部署
> linux: ./start.sh --spring.profiles.active = h2
```
-* 使用 `MySQL` 来存储后台数据，将 [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) 拷贝到 `/${your_work_dir}/ext-lib`， 进入 `/conf` 目录，修改 `application.yaml` 中 `mysql` 的配置。
+* 使用 `MySQL` 来存储后台数据，需按照 [指引文档](./deployment-before.md#mysql) 初始化数据库，将 [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) 拷贝到 `/${your_work_dir}/ext-lib`， 进入 `/conf` 目录修改 `application-mysql.yaml` 中 `jdbc` 的配置。
```
-> windows: start.bat
+> windows: start.bat --spring.profiles.active = mysql
-> linux: ./start.sh
+> linux: ./start.sh --spring.profiles.active = mysql
```
-* 使用 `PostgreSql` 来存储后台数据， 进入 `/conf` 目录，修改 `application.yaml` 中 `spring.profiles.active` 的配置为 `pg`。
+* 使用 `PostgreSql` 来存储后台数据，需按照 [指引文档](./deployment-before.md#postgresql) 初始化数据库， 进入 `/conf` 目录修改 `application-pg.yaml` 中 `jdbc` 的配置。
```
-> windows: start.bat
+> windows: start.bat --spring.profiles.active = pg
-> linux: ./start.sh
+> linux: ./start.sh --spring.profiles.active = pg
+```
+
+* 使用 `Oracle` 来存储后台数据，需按照 [指引文档](./deployment-before.md#oracle) 初始化数据库， 进入 `/conf` 目录修改 `application-oracle.yaml` 中 `jdbc` 的配置。
+
+```
+> windows: start.bat --spring.profiles.active = oracle
+
+> linux: ./start.sh --spring.profiles.active = oracle
```
### 启动 Apache ShenYu Bootstrap
diff --git a/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-docker-compose.md b/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-docker-compose.md
index 08cba0e0bb..57be598e78 100644
--- a/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-docker-compose.md
+++ b/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-docker-compose.md
@@ -23,9 +23,13 @@ curl -O https://raw.githubusercontent.com/apache/incubator-shenyu/master/shenyu-
sh ./install.sh #默认拉取最新配置，如果需要部署已发布版本，可增加一个参数表示版本号，比如：v2.4.2 或 latest
```
+### 初始化`shenyu-admin`存储数据源
+
+参考[数据库初始文档](./deployment-before.md#数据库环境准备) 初始化数据库环境 。
+
### 修改配置文件
-可以修改脚本下载的配置文件。
+修改脚本下载的配置文件来设置`JDBC`等配置。
### 执行 docker-compose
diff --git a/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-docker.md b/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-docker.md
index 79885dc681..1cd1f08c84 100644
--- a/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-docker.md
+++ b/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-docker.md
@@ -22,25 +22,37 @@ description: docker部署
> docker run -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-* 使用 `MySQL` 来存储后台数据,将 [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) 拷贝到 `/${your_work_dir}/ext-lib`：
+* 使用 `MySQL` 来存储后台数据, 按照 [指引文档](./deployment-before.md#mysql) 初始化数据库, 将 [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) 拷贝到 `/${your_work_dir}/ext-lib`：
```
docker run -v /${your_work_dir}/ext-lib:/opt/shenyu-admin/ext-lib -e "SPRING_PROFILES_ACTIVE=mysql" -e "spring.datasource.url=jdbc:mysql://${your_ip_port}/shenyu?useUnicode=true&characterEncoding=utf-8&useSSL=false" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml` 配置放到`${your_work_dir}/conf` ， 然后执行以下语句：
+另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` 配置放到`${your_work_dir}/conf` ， 调整`application.yml`中的配置`spring.profiles.active = mysql`，然后执行以下语句：
```
docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -v /${your_work_dir}/ext-lib:/opt/shenyu-admin/ext-lib -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-* 使用 `PostgreSql` 来存储后台数据, 执行以下语句：
+* 使用 `PostgreSql` 来存储后台数据, 按照 [指引文档](./deployment-before.md#postgresql) 初始化数据库, 执行以下语句：
```
docker run -e "SPRING_PROFILES_ACTIVE=pg" -e "spring.datasource.url=jdbc:postgresql://${your_ip_port}/shenyu?useUnicode=true&characterEncoding=utf-8&useSSL=false" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml` 配置放到`${your_work_dir}/conf` ， 然后执行以下语句：
+另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` 配置放到`${your_work_dir}/conf`， 调整`application.yml`中的配置`spring.profiles.active = pg`，然后执行以下语句：
+
+```
+docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
+```
+
+* 使用 `Oracle` 来存储后台数据, 按照 [指引文档](./deployment-before.md#oracle) 初始化数据库, 执行以下语句：
+
+```
+docker run -e "SPRING_PROFILES_ACTIVE=oracle" -e "spring.datasource.url=jdbc:oracle:thin:@localhost:1521/shenyu" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
+```
+
+另外一种方式, 从 [配置文件地址](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) 中把 `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` 配置放到`${your_work_dir}/conf`， 调整`application.yml`中的配置`spring.profiles.active = oracle`，然后执行以下语句：
```
docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
diff --git a/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-local.md b/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-local.md
index 180cf97754..f95975f419 100644
--- a/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-local.md
+++ b/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-local.md
@@ -28,11 +28,13 @@ description: 本地部署
* 使用开发工具启动 `org.apache.shenyu.admin.ShenyuAdminBootstrap`，访问 http://localhost:9095 ， 默认用户名和密码分别为: `admin` 和 `123456`。
- * 如果使用`h2`来存储，设置变量 `--spring.profiles.active = h2`
+ * 如果使用`h2`来存储，设置变量 `--spring.profiles.active = h2` 启动服务。
- * 如果使用`MySQL`来存储，修改 `application.yaml` 中的 `mysql` 配置。
+ * 如果使用`MySQL`来存储，需按照 [指引文档](./deployment-before.md#mysql) 初始化数据库和修改 `application-mysql.yml` 中的 `jdbc` 相关配置，再设置变量 `--spring.profiles.active = mysql` 启动服务。
- * 如果使用`PostgreSql`来存储，修改 `application.yaml` 中的 `spring.profiles.active` 配置为 `pg`。
+ * 如果使用`PostgreSql`来存储，需按照 [指引文档](./deployment-before.md#postgresql) 初始化数据库和修改 `application-pg.yml` 中的 `jdbc` 相关配置，再设置变量 `--spring.profiles.active = pg` 启动服务。
+
+ * 如果使用`Oracle`来存储，需按照 [指引文档](./deployment-before.md#oracle) 初始化数据库和修改 `application-oracle.yml` 中的 `jdbc` 相关配置，再设置变量 `--spring.profiles.active = oracle` 启动服务。
* 使用开发工具启动 `org.apache.shenyu.bootstrap.ShenyuBootstrapApplication`。
diff --git a/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-package.md b/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-package.md
index 56ac2f2bb2..10306215f8 100644
--- a/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-package.md
+++ b/i18n/zh/docusaurus-plugin-content-docs/version-2.4.3/deployment/deployment-package.md
@@ -23,25 +23,33 @@ description: 二进制包部署
> linux: ./start.sh --spring.profiles.active = h2
```
-* 使用 `MySQL` 来存储后台数据，将 [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) 拷贝到 `/${your_work_dir}/ext-lib`， 进入 `/conf` 目录，修改 `application.yaml` 中 `mysql` 的配置。
+* 使用 `MySQL` 来存储后台数据，需按照 [指引文档](./deployment-before.md#mysql) 初始化数据库，将 [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) 拷贝到 `/${your_work_dir}/ext-lib`， 进入 `/conf` 目录修改 `application-mysql.yaml` 中 `jdbc` 的配置。
```
-> windows: start.bat
+> windows: start.bat --spring.profiles.active = mysql
-> linux: ./start.sh
+> linux: ./start.sh --spring.profiles.active = mysql
```
-* 使用 `PostgreSql` 来存储后台数据， 进入 `/conf` 目录，修改 `application.yaml` 中 `spring.profiles.active` 的配置为 `pg`。
+* 使用 `PostgreSql` 来存储后台数据，需按照 [指引文档](./deployment-before.md#postgresql) 初始化数据库， 进入 `/conf` 目录修改 `application-pg.yaml` 中 `jdbc` 的配置。
```
-> windows: start.bat
+> windows: start.bat --spring.profiles.active = pg
-> linux: ./start.sh
+> linux: ./start.sh --spring.profiles.active = pg
+```
+
+* 使用 `Oracle` 来存储后台数据，需按照 [指引文档](./deployment-before.md#oracle) 初始化数据库， 进入 `/conf` 目录修改 `application-oracle.yaml` 中 `jdbc` 的配置。
+
+```
+> windows: start.bat --spring.profiles.active = oracle
+
+> linux: ./start.sh --spring.profiles.active = oracle
```
### 启动 Apache ShenYu Bootstrap
-* 下载 [apache-shenyu-incubating-${current.version}-bootstrap-bin.tar.gz](https://archive.apache.org/dist/incubator/shenyu/2.4.3/apache-shenyu-incubating-2.4.3-bootstrap-bin.tar.gz)
+* 下载 [`apache-shenyu-incubating-${current.version}-bootstrap-bin.tar.gz`](https://archive.apache.org/dist/incubator/shenyu/2.4.3/apache-shenyu-incubating-2.4.3-bootstrap-bin.tar.gz)
* 解压缩 `apache-shenyu-incubating-${current.version}-bootstrap-bin.tar.gz`。 进入 bin 目录。
diff --git a/versioned_docs/version-2.4.3/deployment/deployment-docker-compose.md b/versioned_docs/version-2.4.3/deployment/deployment-docker-compose.md
index bb5e708c89..0b29d7407c 100644
--- a/versioned_docs/version-2.4.3/deployment/deployment-docker-compose.md
+++ b/versioned_docs/version-2.4.3/deployment/deployment-docker-compose.md
@@ -23,9 +23,13 @@ This script will download the required configuration files and mysql-connector,
sh ./install.sh #The latest configuration is pulled by default. If you need to deploy the released version, you can add a parameter to indicate the version number, such as: v2.4.2 or latest
```
+### Initialize the `shenyu-admin` database
+
+Refer to the [database initialization documentation](./deployment-before.md#database-initialize) to initialize the database.
+
### Modify the configuration file
-The configuration file downloaded by the script can be modified.
+Modify the configuration file downloaded by the script to set up configurations such as `JDBC`.
### Execute docker-compose
diff --git a/versioned_docs/version-2.4.3/deployment/deployment-docker.md b/versioned_docs/version-2.4.3/deployment/deployment-docker.md
index 791f4ee1a7..5733cca691 100644
--- a/versioned_docs/version-2.4.3/deployment/deployment-docker.md
+++ b/versioned_docs/version-2.4.3/deployment/deployment-docker.md
@@ -22,25 +22,37 @@ This article introduces the use of `docker` to deploy the `Apache ShenYu` gatewa
> docker run -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-* use `MySQL` to store data, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to `/$(your_work_dir)/ext-lib`：
+* use `MySQL` to store data, follow the [guide document](./deployment-before.md#mysql) to initialize the database, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to `/$(your_work_dir)/ext-lib`：
```
docker run -v /${your_work_dir}/ext-lib:/opt/shenyu-admin/ext-lib -e "SPRING_PROFILES_ACTIVE=mysql" -e "spring.datasource.url=jdbc:mysql://${your_ip_port}/shenyu?useUnicode=true&characterEncoding=utf-8&useSSL=false" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-another way is to put the `application.yml`、`application-mysql.yml`、`application-pg.yml` configuration in ${your_work_dir}/conf from [Configure address](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) , and then execute the following statement：
+another way is to put the `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` configuration in ${your_work_dir}/conf from [Configure address](https://github.com/apache/incubator-shenyu/blob/master/shenyu-admin/src/main/resources/) , modify the configuration `spring.profiles.active = mysql` in `application.yml`, and then execute the following statement：
```
docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -v /${your_work_dir}/ext-lib:/opt/shenyu-admin/ext-lib -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-* use `PostgreSql` to store data, execute the following statement：
+* use `PostgreSql` to store data, follow the [guide document](./deployment-before.md#postgresql) to initialize the database, execute the following statement：
```
docker run -e "SPRING_PROFILES_ACTIVE=pg" -e "spring.datasource.url=jdbc:postgresql://${your_ip_port}/shenyu?useUnicode=true&characterEncoding=utf-8&useSSL=false" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
```
-another way is to put the `application.yml` configuration in ${your_work_dir}/conf, and then execute the following statement：
+another way is to put the `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` configuration in ${your_work_dir}/conf, modify the configuration `spring.profiles.active = pg` in `application.yml`,and then execute the following statement：
+
+```
+docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
+```
+
+* use `Oracle` to store data, follow the [guide document](./deployment-before.md#oracle) to initialize the database, execute the following statement：
+
+```
+docker run -e "SPRING_PROFILES_ACTIVE=oracle" -e "spring.datasource.url=jdbc:oracle:thin:@localhost:1521/shenyu" -e "spring.datasource.username=${your_username}" -e "spring.datasource.password=${your_password}" -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
+```
+
+another way is to put the `application.yml`、`application-mysql.yml`、`application-pg.yml`、`application-oracle.yml` configuration in ${your_work_dir}/conf, modify the configuration `spring.profiles.active = oracle` in `application.yml`, and then execute the following statement：
```
docker run -v ${your_work_dir}/conf:/opt/shenyu-admin/conf -d -p 9095:9095 --net shenyu apache/shenyu-admin:${current.version}
diff --git a/versioned_docs/version-2.4.3/deployment/deployment-local.md b/versioned_docs/version-2.4.3/deployment/deployment-local.md
index 01dce11874..5854a663a3 100644
--- a/versioned_docs/version-2.4.3/deployment/deployment-local.md
+++ b/versioned_docs/version-2.4.3/deployment/deployment-local.md
@@ -28,11 +28,13 @@ This article introduces how to start the `Apache ShenYu` gateway in the local en
* use the development tool to start `org.apache.shenyu.admin.ShenyuAdminBootstrap`，Visit http://localhost:9095, the default username and password are: `admin` and `123456` respectively.
- * If you use `h2` to store, set the variable `--spring.profiles.active = h2`.
+ * If you use `h2` for storage, set the variable `--spring.profiles.active = h2` and start the server.
- * If you use `MySQL` for storage, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to /$(your_work_dir)/ext-lib, and modify the `mysql` configuration in `application.yaml`.
+ * If you use `MySQL` for storage, need to follow the [guide document](./deployment-before.md#mysql) to initialize the database and modify the `JDBC` configuration in `application-mysql.yml`, set the variable `--spring.profiles.active = mysql` and start the server.
- * If you use `PostgreSql` for storage, modify the `pg` of `spring.profiles.active` configuration in `application.yaml`.
+ * If you use `PostgreSql` for storage, need to follow the [guide document](./deployment-before.md#postgresql) to initialize the database and modify the `JDBC` configuration in `application-pg.yml`, set the variable `--spring.profiles.active = pg` and start the server.
+
+ * If you use `Oracle` for storage, need to follow the [guide document](./deployment-before.md#oracle) to initialize the database and modify the `JDBC` configuration in `application-oracle.yml`, set the variable `--spring.profiles.active = oracle` and start the server.
* use the development tool to start `org.apache.shenyu.bootstrap.ShenyuBootstrapApplication`.
diff --git a/versioned_docs/version-2.4.3/deployment/deployment-package.md b/versioned_docs/version-2.4.3/deployment/deployment-package.md
index 24d313a4ff..a45a6d0a39 100644
--- a/versioned_docs/version-2.4.3/deployment/deployment-package.md
+++ b/versioned_docs/version-2.4.3/deployment/deployment-package.md
@@ -23,25 +23,33 @@ This article introduces the deployment of the `Apache ShenYu` gateway using the
> linux: ./start.sh --spring.profiles.active = h2
```
-* use `MySQL` to store data, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to /$(your_work_dir)/ext-lib, go to the `/conf` directory, and modify the configuration of `mysql` in `application.yaml`.
+* use `MySQL` to store data, follow the [guide document](./deployment-before.md#mysql) to initialize the database, copy [mysql-connector.jar](https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.18/mysql-connector-java-8.0.18.jar) to /$(your_work_dir)/ext-lib, go to the `/conf` directory, and modify the `JDBC` configuration in `application-mysql.yml`.
```
-> windows: start.bat
+> windows: start.bat --spring.profiles.active = mysql
-> linux: ./start.sh
+> linux: ./start.sh --spring.profiles.active = mysql
```
-* use `PostgreSql` to store data, go to the `/conf` directory, and modify `spring.profiles.active` of the configuration in `application.yaml` to `pg`.
+* use `PostgreSql` to store data, follow the [guide document](./deployment-before.md#postgresql) to initialize the database, go to the `/conf` directory, and modify the `JDBC` configuration in `application-pg.yml`.
```
-> windows: start.bat
+> windows: start.bat --spring.profiles.active = pg
-> linux: ./start.sh
+> linux: ./start.sh --spring.profiles.active = pg
+```
+
+* use `Oracle` to store data, follow the [guide document](./deployment-before.md#oracle) to initialize the database, go to the `/conf` directory, and modify the `JDBC` configuration in `application-oracle.yml`.
+
+```
+> windows: start.bat --spring.profiles.active = oracle
+
+> linux: ./start.sh --spring.profiles.active = oracle
```
### Start Apache ShenYu Bootstrap
-* download [apache-shenyu-incubating-2.4.3-bootstrap-bin.tar.gz](https://archive.apache.org/dist/incubator/shenyu/2.4.3/apache-shenyu-incubating-2.4.3-bootstrap-bin.tar.gz)
+* download [apache-shenyu-incubating-${current.version}-bootstrap-bin.tar.gz](https://archive.apache.org/dist/incubator/shenyu/2.4.3/apache-shenyu-incubating-2.4.3-bootstrap-bin.tar.gz)
* unzip `apache-shenyu-incubating-${current.version}-bootstrap-bin.tar.gz`。 go to the `bin` directory.