官术网_书友最值得收藏!

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:

  1. Create new groups and the oracle user as shown in the following code snippet, by logging in as the root user:
    groupadd oinstall
    groupadd dba
    useradd -g oinstall -G dba,oper,asmadmin oracle
    passwd oracle
    
  2. 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
    
  3. Copy the downloaded software to a temporary folder, say /u01/software, and run the following command as the root user to install Oracle Database XE, as shown in the following screenshot:
    Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
  4. Run /etc/init.d/oracle-xe configure as the root 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:
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)

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 
主站蜘蛛池模板: 宁城县| 驻马店市| 砀山县| 遵化市| 旬阳县| 开阳县| 和林格尔县| 临汾市| 乌鲁木齐县| 宜州市| 高阳县| 大冶市| 碌曲县| 龙岩市| 江孜县| 西昌市| 卓资县| 龙口市| 西乡县| 吉林市| 呼伦贝尔市| 双辽市| 司法| 准格尔旗| 杨浦区| 义乌市| 林口县| 调兵山市| 右玉县| 哈巴河县| 保德县| 遂溪县| 从化市| 宜城市| 乐陵市| 巢湖市| 隆林| 且末县| 云龙县| 绥宁县| 乌兰浩特市|