- Oracle Database XE 11gR2 Jump Start Guide
- Asif Momen
- 431字
- 2021-08-13 18:28:11
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
Before we begin installing Oracle Database XE in Linux, we need to prepare the environment by installing the required packages, setting kernel parameters, and so on.
To begin, make sure that the following Linux packages are installed. To verify that the following Linux packages are installed use the rpm —qa <package name>
command:
kernel-headers-2.6.18-194.el5.x86_64.rpm
glibc-2.5-49.x86_64.rpm
make-3.81-3.el5.x86_64.rpm
binutils-2.17.50.0.6-14.el5.x86_64.rpm
glibc-devel-2.5-49.x86_64.rpm
glibc-headers-2.5-49.x86_64.rpm
libgomp-4.4.0-6.el5.x86_64.rpm
gcc-4.1.2-48.el5.x86_64.rpm
libaio-0.3.106-5.x86_64.rpm
The parameters that need to be included in the sysctl.conf
file under /etc
are as follows. These changes are to be made by logging in as the root
user:
kernel.semmsl=250 kernel.semmns=32000 kernel.semopm=100 kernel.semmni=128 kernel.shmmax=4294967295 kernel.shmmni=4096 kernel.shmall=2097152 kernel.sem= 250 32000 100 128 fs.file-max= 6815744 net.ipv4.ip_local_port_range=9000 65500
We are now ready to start the Oracle Database XE installation. However, it is recommended to complete the following steps for creating a Linux user oracle:
- Create new groups and the
oracle
user as shown in the following code snippet, by logging in as theroot
user:groupadd oinstall groupadd dba useradd -g oinstall -G dba,oper,asmadmin oracle passwd oracle
- Log in as the
oracle
user and add the following lines at the end of the.bash_profile
file:# Oracle instance name ORACLE_SID=XE; export ORACLE_SID; # Oracle home directory ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe; export ORACLE_HOME; # Search path for executable PATH=$ORACLE_HOME/bin:$PATH; export PATH; # Search path for shared libraries LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
- Copy the downloaded software to a temporary folder, say
/u01/software
, and run the following command as theroot
user to install Oracle Database XE, as shown in the following screenshot: - Run
/etc/init.d/oracle-xe configure
as theroot
user to configure the database. You will be prompted to select the HTTP port for Oracle Application Express, database listener port, SYS and SYSTEM user password, and the boot option. It is recommended to accept the default values and continue with the configuration of the database as shown in the following screenshot:

To access the database's home page go to Applications menu | Oracle Database 11g Express Edition | Get Started.
Starting and stopping Oracle Database XE in Linux
After you have installed Oracle Database XE, the database is up and running and you can begin using it right away.
To stop the running database, go to Applications menu | Oracle Database 11g Express Edition | Stop Database.
Similarly to start the database, go to Applications menu | Oracle Database 11g Express Edition | Start Database.
Alternatively, we can start the database manually by running the following command as the root
user:
# /etc/init.d/oracle-xe start
To manually stop the database, run the following command as the root
user:
# /etc/init.d/oracle-xe stop
- Boost.Asio C++ Network Programming(Second Edition)
- Oracle WebLogic Server 12c:First Look
- VMware View Security Essentials
- DBA攻堅指南:左手Oracle,右手MySQL
- C++程序設計(第3版)
- Android和PHP開發最佳實踐(第2版)
- 實用防銹油配方與制備200例
- 編寫高質量代碼:改善C程序代碼的125個建議
- INSTANT Mercurial SCM Essentials How-to
- Visual C
- Quarkus實踐指南:構建新一代的Kubernetes原生Java微服務
- Java編程技術與項目實戰(第2版)
- 深入淺出Serverless:技術原理與應用實踐
- 零基礎學Python編程(少兒趣味版)
- Scala Functional Programming Patterns