Shulou(Shulou.com)06/01 Report--

Oracle XE

Oracle introduces XE like this: 11g XE (Express Edition) simplified version is an entry-level small volume database based on Oracle11gR2, free for development / deployment and release, easy to download and easy to use.

Characteristics

Oracle XE is mainly applicable to:

Developers suitable for Node.js, Python, PHP, Java, .NET, XML and open source projects need an independent software provider ISV (Independent Software Vendors) and hardware provider that is free to use DBA for initial database training or deployment. Educational institutions or students required by the course

Simple summary: free entry-level relational database

Limit

This is how Oracle explains XE, a powerful, industry-leading software with proven performance, and easy to upgrade without additional cost and complex migration.

Why do you need to upgrade, because this is a stripped-down version, the essence of streamlining lies in the following limitations, it is precisely because of this limitation that XE is a truly concise version without being brilliant.

Due to these limitations, even if the machine performance is excellent, it is especially suitable for eliminating abandoned machines for installation and use. It is a very environmentally friendly software.

Image acquisition

Docker pull liumiaocn/oracle:11.2.0

Startup setting

Port information

# # Environment variables

# # data Volume

Start the instance

Docker run-d\-p 38080 transactions=611 8080-p 31521 processes=500 1521\-e DEFAULT_SYS_PASS=liumiaocn\-e sessions=555\-e transactions=611\-- name oracle-11g\ liumiaocn/oracle:11.2.0

Start the Oracle container

[root@liumiaocn] # docker run-d\ >-p 38080 DEFAULT_SYS_PASS=liumiaocn 8080-p 31521 DEFAULT_SYS_PASS=liumiaocn 1521\ >-e processes=500\ >-e sessions=555\ >-e transactions=611\ >-- name oracle-11g\ > liumiaocn/oracle:11.2.0f66b569769e6ba7eacf57b141afccc76cef973f3da3c6a79557c98e5d4727c2b [root@liumiaocn] #

Result confirmed

Switch to the oracle user and use sqlplus to log in as sysdba to confirm

[root@liumiaocn] # docker exec-it oracle-11g sh# su-oracleoracle@32d01719b30a:~$ sqlplus / nologSQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 11 15:01:15 2018Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL > connect / as sysdbaConnected.SQL > select * from v$instance INSTANCE_NUMBER INSTANCE_NAME--HOST_NAME----VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT- -LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO EDITION- -1 XE32d01719b30a11.2.0.2.0 11-SEP-18 OPEN NO 1 STOPPEDALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO XESQL >

Set confirmation

Sessions has changed a little bit.

SQL > conn / as sysdbaConnected.SQL > show parameter processesNAME TYPE VALUE---aq_tm_processes integer 0db_writer_processes integer 1gcs_server_processes integer 0global_txn_processes Integer 1job_queue_processes integer 500log_archive_max_processes integer 4processes integer 500SQL > show parameter sessionsNAME TYPE VALUE-- java_max_sessionspace_size integer 0java softsoft0 Sessionspace_limit integer 0license_max_sessions integer 0license_sessions_warning integer 0sessions integer 772shared_server_sessions integerSQL > show parameter transactionsNAME TYPE VALUE-- transactions integer 611transactions_per_rollback_segment integer 5SQL >

Summary

The above is the whole content of this article. I hope the content of this article has a certain reference and learning value for everyone's study or work. Thank you for your support. If you want to know more about it, please see the relevant links below.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.