Useful script for 'oracle-xe' service
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.eslintignore
.eslintrc.yml
.gitignore
.npmignore
.travis.yml
README.md
package-lock.json
package.json
usdocker_oracle-xe.js

README.md

Useful script for 'oracle-xe' service

This Useful Script creates a oracle-xe server based on a Docker Image. You don't have know docker to use this solution.

Installing

npm install -g @usdocker/usdocker # Install it first
npm install -g @usdocker/oracle-xe
usdocker -r    # Update USDocker database

Start the oracle-xe service

usdocker oracle-xe up

Stop the oracle-xe service

usdocker oracle-xe down

Check the oracle-xe status

usdocker oracle-xe status

Connecting to SQLPlus

usdocker oracle-xe client -- [args]

Example:

usdocker oracle-xe client -- system/oracle@xe

Connect to Bash

usdocker oracle-xe connect -- [args]

Connect to your Oracle

hostname: localhost
port: 1521
sid: xe
username: system
password: oracle

Connect to APEX

Connect to Oracle Application Express web management console with following settings:

http://localhost:8080/apex
workspace: INTERNAL
user: ADMIN
password: oracle

Customize your service

You can setup the variables by using:

usdocker oracle-xe --set variable=value

Default values

  • image": "sath89/oracle-xe-11g",
  • folder": "$HOME/.usdocker/data/oracle-xe",
  • port": 1521,
  • apex": 8080,
  • processes": 500,
  • sessions": 555,
  • transactions": 610,
  • password": "oracle",
  • allowImport": "true",
  • setPassword": "true" // only will work if allowImport: true also.