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

Most people do not understand the knowledge points of this article "how to install Oracle11g database management system under CentOS", so the editor summarizes the following contents, detailed contents, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "how to install Oracle11g database management system under CentOS" article.

Oracle11g is a powerful relational database management system successfully built by Oracle with 30 years of design experience. At present, it has issued linux version and windows version. The high efficiency, security, stability and extensibility of software database is the key factor for its success. Almost all large-scale information systems in the world are applying Oracle technology.

Environmental preparation

\ 1. A server with CentOS 6.8x64 (virtual machine is also available)

\ 2. Linux.x64_11gR2_database_1of2.zip

3. Linux.x64_11gR2_database_2of2.zip "

The system requirements are as follows

\ 1. SWAP partition is larger than 3G

\ 1. The remaining space in the Oracle installation directory is more than 20g.

\ 2. Centos6.x system

Install the centos system

First we need to install a version with X window.

Configure system parameters

\ 1. Add oracle users use the following command to create groups and users

Root@localhost:~# groupadd oinstallroot@localhost:~# groupadd dbaroot@localhost:~# groupadd operroot@localhost:~# useradd-g oinstall-G dba,oper oracleroot@localhost:~# passwd oracle

\ 2. Configure kernel parameters to write the following to / etc/sysctl.conf

Fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmni = 4096kernel.sem = 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586

\ 3. The configuration system handle restricts adding the following parameters to the / etc/security/limits.conf file to optimize the kernel without modification, or overflow may occur if not modified

Oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240 install oracle

Using the oracle user, run this command to start installing oracle

Oracle@localhost:~$ / u01/app/database/runInstaller

\ 1. Configure Security Updates We remove oracle support password, email can not be filled in. In the next step, there is no email direct point. Yes can ignore it.

\ 2. Select Installation Option installation and configuration database `install instance upgrade database only we choose to install and configure the database

\ 3. System Class desktop version server version I choose the server version here

\ 4. Node selection single instance cluster environment. I choose single instance mode here.

\ 5. Select Install Type General installation Advanced installation I choose Advanced installation here

Select Product Language choose the language you need. I only use English here. Only English can be used for Chinese storage. Look back.

\ 7. Select Database Edition Enterprise Edition Standard Edition 1 I choose Enterprise Edition here

PS: if you need to know what you don't understand, please refer to [differences between versions of Oracle EE SE SE1].

\ 8. Specify Installation Location sets the oracle installation directory and the home directory. This location is to get the values of $ORACLE_BASE and $ORACLE_HOME of oracle (try not to modify them. If you modify it, please modify the variable value of the oracle user together)

\ 9. Create Inventory sets the location of the oracle record file to be kept by default

\ 10. Select Configuration Type

\ 11. Specify Database Identifiers sets the instance name

\ 12. Specify Configuration Options configures instance parameters, and memory usage can be configured according to the actual situation. Try not to exceed 50%.

If you need to store Chinese in the database, set the GBK character set in Character sets.

\ 13. Specify Management Options sets database management options directly to the next step, which is not needed for the time being.

\ 14. Specify Database Storage Options knows the database storage options. Choose the file system here and do not use asm to manage files.

\ 15. Specify Recovery Options database recovery options do not enable automatic backup of the database, you can adjust it if necessary

\ 16. Specify Schema Passwords set database password. Set database password as needed.

\ 17. Privileged Operating System Groups sets database permission groups, which are used to bind to local users.

\ 18. Perform Prerequisite Checks validation database installation environment

PS: the following packages are not installed.

Need to install the package

Gcc.x86_64libaio.i686glibc.i686compat-libstdc++-33.i686compat-libstdc++-33.x86_64elfutils-libelf-develgcc-c++libaio-devel.x86_64libaio-devel.i686libstdc++.i686unixODBC.i686unixODBC.x86_64unixODBC-devel.x86_64unixODBC-devel.i686

Install the epel source first

Root@localhost:~# yum install epel-release-y

Then download pdksh-5.2.14

Root@localhost:~# wget ftp://rpmfind.net/linux/centos/5.11/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm

Finally, install other packages

Click Check Again to re-verify after the installation is complete

The rest of these packages are caused by Oracle 11G requiring i386 version and centos6 starting to use i686 standard. Check Ignore All in the upper right corner. PS: [difference between i386 and i686]

\ 19. Configuration text for Summary data installation. You can keep the configuration text if necessary.

\ 20. Install Product installation starts, wait.

A dialog box pops up at the end of the installation block.

Here we click the Password Management in the lower right corner to change the password. If necessary, you can open socct users.

This pop-up box indicates that we need to run these two scripts with root privileges.

Switch to the root user and run the following command

Root@localhost:~# / u01/app/oraInventory/orainstRoot.shroot@localhost:~# / u01/app/oracle/product/11.2.0/dbhome_1/root.sh

Click ok to complete the installation

\ 21. Finish completes the installation diagram with the address of the em console

Create a service for oracle

\ 1. Set the dbstart command to modify the last line of the / etc/oratab file from N to Y

Orcl:/u01/app/oracle/product/11.2.0/dbhome_1:Y

\ 2. Create a new / etc/init.d/oracle file to write the following to the file

# chkconfig:2345 98 05#description:Oracle Server#add for oracleORACLE_BASE=/u01/app/oracle/export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_HOMEORACLE_SID=orclexport ORACLE_SIDLD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libexport LD_LIBRARY_PATHcase "$1" instart) echo "Starting Oracle..." su-oracle-c "lsnrctl start" su-oracle-c "dbstart 1 > $ORACLE_HOME/bin/dbstart.log 2 > $ORACLE_HOME/bin/dbstart.err" echo "Started." exit 0 Stop) echo "Stoping Oracle..." su-oracle-c "lsnrctl stop" su-oracle-c "dbshut" echo "Stoped." exit 0politics *) echo "Usage: $0 {start | stop}" exit 1esac

\ 3. Then give the oracle file execution permission

Root@localhost:~# chmod + x / etc/init.d/oracle

\ 4. Add boot boot

Root@localhost:~# chkconfig-add oracleroot@localhost:~# chkconfig oracle on

\ 5. Add boot boot em console

Add to the / etc/rc.loder file

Su-oracle-c "emctl start dbconsole"

Complete the installation

The blogger sorted out the common commands of oracle.

Dbca Database Configurator netca listener Configurator netmgr listener Controller dbstart Open Database dbshut close Database lsnrctl start turn on listening lsnrctl stop close listen emctl start dbconsole turn on em console emctl stop dbconsole close em console sqlplus / as sysdba use sysdba permissions to log in to the current database the above is about "how to install Oracle11g database management system under CentOS" this article, I believe everyone has a certain understanding I hope the content shared by the editor will be helpful to all of you. If you want to know more about the relevant knowledge, please follow the industry information channel.

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.