Skip to main content
Version: 1.0

Oracle Getting Started

Oracle Database offers market-leading performance, scalability, reliability, and security.

If you have installed Websoft9 Oracle, the following steps is for your quick start


  1. Get the Internet IP of your Server on Cloud

  2. Check your Inbound of Security Group Rule of Cloud Console to ensure the TCP:80 is allowed

  3. Connect your Server and get default username and password of Oracle

  4. Complete Five steps for Domain if you want to use Domain for Oracle

  5. If you want to enable Oracle Database Enterprise or Standard, you should complete the below steps:

Oracle Initialization

Steps for you

  1. Using local browser to visit the URL <https://Server's Internet IP:5500/em>, you will enter Oracle EM login page

    URL must use https

  2. Input your Oracle Database credential(Don't have password?) and login it successfully

    Oracle EM

  3. When you can see Oracle EM, it means you Oracle instance is running.

  4. Then you can use sqlplus by below commands

    sudo docker exec -it oracle bash
    sqlplus SYS AS SYSDBA

Having trouble?

Below is for you to solve problem, and you can contact Websoft9 Support or refer to Troubleshoot + FAQ to get more.

Oracle QuickStart

This task Create new table is for your Oracle QuickStart

  1. 使用 CloudBeaver 连接 Oracle 数据库

  2. 创建一个数据表

  3. 向数据表中增加内容

  4. 查看新增的数据

Oracle Setup

Oracle Remote access

应用自身已经开启远程访问,只需在云控制台安全组启用 TCP:1521 端口即可。

Reset Oracle password


docker exec -it oracle ./ <your_password>

Get SID Or Servce Name

  1. 进入 sqlplus

    docker exec -it oracle sqlplus / as sysdba 
  2. 运行查询实例信息的 SQL 命令,instance_name 即所需的信息

    SQL> show parameter instance

    ------------------------------------ ----------- ------------------------------
    active_instance_count integer
    instance_abort_delay_time integer 0
    instance_groups string
    instance_mode string READ-WRITE
    instance_name string XE
    instance_number integer 0
    instance_type string RDBMS
    open_links_per_instance integer 4
    parallel_instance_group string

Oracle Clients

Oracle Database 支持多种客户端,有第三方工具,也有官方工具。


Web Based client: CloudBeaver

  1. 本地浏览器访问:http://服务器公网IP:9090,访问 CloudBeaver

  2. 新建一个 Oracle 数据库连接

  3. 连接成功的界面

Local GUI client: Navicat

  1. 下载并安装 Navicat for Oracle

  2. 新建一个 Oracle 数据库连接,主要参数说明:

  3. 连接成功后的界面

Command line client: SQL*Plus

SQL*Plus 是官方提供的命令行客户端,运行下面的命令即可进入 SQLPlus 的操作模式:

docker exec -it oracle sqlplus / as sysdba

Local develop client: SQL Developer

SQL Developer是 SQL*Plus 的图形版本,用 Java 编写,支持 SQL 和 PL/SQL 开发。您可以使用标准数据库身份验证连接到任何 Oracle 数据库模式。

Web develop client: APEX

APEX 是用于 Oracle 数据库的 Web 应用程序开发工具。

Reference sheet

The below items and General parameter sheet is maybe useful for you manage Oracle

Run docker ps, view all containers when Oracle is running:

CONTAINER ID   IMAGE                                                   COMMAND                  CREATED        STATUS                 PORTS                                                                                                                                                      NAMES
0bd5dabde1ff "/bin/sh -c 'exec $O…" 19 hours ago Up 3 hours (healthy)>1521/tcp, :::1521->15 21/tcp,>5500/tcp, :::5500->5500/tcp oracle
e8214ddd441c dbeaver/cloudbeaver:latest "./" 2 hours ago Up 2 hours>8978/tcp, :::9093->89 78/tcp cloudbeaver


Oracle configuration file: /data/apps/oracle/dbconfig


In addition to common ports such as 80, 443, etc., the following ports may be used:

1521Oracle Database ServerOptional
5500HTTPS access Oracle EMOptional


docker exec -it oracle sqlplus / as sysdba


sudo docker start | stop | restart | stats oracle


Oracle Database 提供了大量的命令工具:

  • sqlplus 客户端工具
  • expdp 导出
  • impdp 导出
  • rman 备份与恢复


Oracle 通过 Oracle REST Data Services 实现安全访问 Oracle 数据库。