Shulou(Shulou.com)05/31 Report--

This article mainly explains the "Oracle database installation detailed steps", the explanation content in the article is simple and clear, easy to learn and understand, please follow the small series of ideas slowly in-depth, together to study and learn the "Oracle database installation detailed steps" bar!

Oracle Database 11.2.0.4 Installation Detailed Steps

I. Preparations

1. Installation packages required for a new installation of Oracle 11g database:

There are 7 packages in total, and if you have a single instance environment without RAC, you only need the first 2 packages.

p13390677_112040_Linux-x86-64_1of7.zipp13390677_112040_Linux-x86-64_2of7.zip

Operating system version installed: Red Hat Enterprise Linux Server release 6.9 (Santiago)

3. You need to install Xmanager6, which can be found online.

4, hardware needs to be explained, minimum requirements.

I. Hardware:

1. minimum hardware requirements

a) At least 1GB of physical memory

b)Swap meets the following requirements:

RAMSwap SpaceBetween 1 GB and 2 GB1.5 times the size of RAMBetween 2 GB and 16 GBEqual to the size of RAMMore than 16 GB16 GB

Note: The recommendations above (from the 11.2 Database installation guide) are minimal recommendations.

c)/tmp At least 1 GB of space and less than 2TB.

d)Database software requires at least 4.4GB of space

e)Database requires at least 1.7G of space.

2. Oracle databases are supported on ext2, ext3, ext4, and xfs file systems (see Note:236826.1 and Note 1632127.1 for more information)

5, Attach software installation address sharing link: https://pan.baidu.com/s/1NFYZ5BDfsLv9gm0HtmaqYA: ep1e

II. Formal installation of Oracle software

1. Install the necessary dependency software

[root@OracleLinux6 ~]#yum install -y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

2. Create users and user groups

[root@OracleLinux6 ~]# groupadd -g 501 oinstall[root@OracleLinux6 ~]# groupadd -g 502 dba[root@OracleLinux6 ~]# useradd -g oinstall -G dba oracle

3. Create a new installation directory and set permissions

[root@OracleLinux6 ~]# mkdir -p /orasetup /home/app/oracle[root@OracleLinux6 ~]# chmod -R 775 /orasetup /home/app[root@OracleLinux6 ~]# chown -R oracle:oinstall /orasetup /home/app

4. Upload requires installation of Oracle 11G software and decompression of the software

[root@OracleLinux6 ~]# cd /orasetup/[root@OracleLinux6 orasetup]# rz[root@OracleLinux6 orasetup]# unzip p13390677_112040_Linux-x86-64_1of7.zip

After decompression, you need to execute the following permissions again. It has been ensured that Oracle users can execute

[root@OracleLinux6 ~]# chmod -R 775 /orasetup[root@OracleLinux6 ~]# chown -R oracle:oinstall /orasetup

5. Modify user environment variables

[root@OracleLinux6 ~]# su - oracle[oracle@OracleLinux6 ~]$ pwd/home/oracle Add the following information: [oracle@OracleLinux6 ~]$ vi .bash_profile export PATHalias rm='rm -i'alias cp='cp -i'alias mv='mv -i'alias vi='vim'alias sqlplus='rlwrap sqlplus'alias rman='rlwrap rman'export ORACLE_BASE=/home/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID= orclexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib/usr/libexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:$ORACLE_HOME/jdk/binexport NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"export NLS_LANG="Simplified Chinese_China".AL32UTF8umask 022

6. Modify system environment variables

[root@OracleLinux6 ~]# vi /etc/profile Add the following information: if [ $USER = "oracle" ]|| [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fifi [root@OracleLinux6 ~]# source /etc/profile

7. Modify user restrictions

[root@OracleLinux6 ~]# vi /etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240oracle hard stack 32768

8. Modify kernel parameters

[root@OracleLinux6 ~]# vim /etc/sysctl.conf fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.sem = 250 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 Finally refresh the following parameters [root@OracleLinux6 ~]# sysctl -p

9, modify the hosts file

[root@OracleLinux6 ~]# vim /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.254.33 OracleLinux6

10. Install the database

First install Xmanager software, switch user to Oracle user and install database. [root@OracleLinux6 ~]# su - oracle[oracle@OracleLinux6 ~]$ export DISPLAY=192.168.254.1:0.0[oracle@OracleLinux6 ~]$ xhost +

Go to the database folder and run./ runInstaller。

[oracle@OracleLinux6 ~]$ cd /orasetup/database/[oracle@OracleLinux6 database]$ lltotal 60drwxrwxr-x 4 oracle oinstall 4096 Aug 27 2013 install-rwxrwxr-x 1 oracle oinstall 30016 Aug 27 2013 readme.htmldrwxrwxr-x 2 oracle oinstall 4096 Aug 27 2013 responsedrwxrwxr-x 2 oracle oinstall 4096 Aug 27 2013 rpm-rwxrwxr-x 1 oracle oinstall 3267 Aug 27 2013 runInstallerdrwxrwxr-x 2 oracle oinstall 4096 Aug 27 2013 sshsetupdrwxrwxr-x 14 oracle oinstall 4096 Aug 27 2013 stage-rwxrwxr-x 1 oracle oinstall 500 Aug 27 2013 welcome.html[oracle@OracleLinux6 database]$ ./ runInstaller

11, Start installing Oracle, Go to the installation home page, Remove the checked option

12, skip upgrade installation

13. Jump out of the dialog box and click yes to continue

14, Select Install Database Software Only

15, Install Single Instance Database

16, select type, language type

17, Install Database Version

18, installation path selection (this is set in your user environment variable)

19,Create Inventory

20,Operating System Group

21，Prerequisite Ckeck

This step may have two yum packages not installed, need to install in the next ksh and libaio-devel, you can ignore but I am not sure what the impact, I am installed after continuing.

22，Summary

23，Install Product

24, Execute script near installation completion

25. Use the terminal to execute the script file prompting Path with root permission. Click OK to complete it.

26, the database installation ends here.

III. Setting up monitoring

1. Set listening under Oracle user

2，Listener Configure

3，Add Listener

4，Listener name

5，Listener TCP

6，Listener Port

7, Listener another option NO

8. Select Cancel as the last step to end monitoring settings.

IV. Creation of a database

1. Enter Oracle user and create database

2，CreateDatabase

3，Setup2

4, Setup3 Set database name

5, Setup4 --Remove √

6, Setup5 ---Create password

7, Setup6 --Select listener name:LISTENER1 Default is LISTENER without selection

8, Setup7 ---Setup template

9, Setup8 --Enable Flashback and Archiving

10, Setup9 --Select template schemas

11, Setup10 --Set Memory Capacity (can be set to 70%)

12, Setup11--Set Sizing to 5000

13, Setup12--Set Character

14, Setup13--Setup instructions

15，Setup14---Finish

16, Confirmation information

17, Start creating database

18. Back to 46% in the creation process There is an error: ORA-12532 Error: Solution: Do not use @ characters when setting passwords.

19. After re-modifying the password, the installation is completed once.

20. Finally, prompt the file information of installation, and the library is completed.

Thank you for reading, the above is the "Oracle database installation detailed steps" content, after the study of this article, I believe that we have a deeper understanding of the Oracle database installation detailed steps this problem, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

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.