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

This article mainly explains the "steps to install oracle11.2.0.4 in centos6.8". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn the steps of installing oracle11.2.0.4 in centos6.8.

Installation environment and system requirements (the following specific parameter values and paths are adjusted according to your own environment)

Operating system: Red Hat Enterprise Linux 6 (x86) or CentOS 6 (x64)

Database: Oracle 11g R2 32-bit for Linux or Oracle 11g R2 64-bit for Linux

Memory: at least 1G of physical memory

Swap space: 1 GB of memory is recommended to set the swap partition to at least 2 GB

Hard disk: at least 5G hard disk space

Configure Linux system parameters for Oracle installation

Perform the following steps under Root user:

Premise:

1. Cat / etc/sysconfig/network (check hostname)

Vi / etc/hosts (add Ip and hostname)

2. Vi / etc/resolv.conf

Add: nameserver 8.8.8.8 at the end of this file

(1) modify the user's SHELL restrictions and modify the / etc/security/limits.conf file

Enter the command: vi / etc/security/limits.conf, press I to enter edit mode, and add the following to the file.

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Press ESC key after editing, and type ": wq" to save and exit.

(2) modify the / etc/pam.d/login file, enter the command: vi / etc/pam.d/login, press the I key to enter edit mode, and add the following to the file.

Session required / lib64/security/pam_limits.so (note that / lib64 is x86cm 64-bit machine, and / lib is 32-bit machine, otherwise it will not be able to log in)

Session required pam_limits.so

Press ESC key after editing, and type ": wq" to save and exit.

(3) modify the linux kernel, modify the / etc/sysctl.conf file, enter the command: vi / etc/sysctl.conf, press I to enter edit mode, and add the following to the file

Fs.file-max = 6815744

Fs.aio-max-nr = 1048576

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 4194304

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Press ESC key after editing, and type ": wq" to save and exit.

(4) Edit / etc/profile, enter the command: vi / etc/profile, press I key to enter edit mode, and add the following to the file.

If [$USER = "oracle"]; then

If [$SHELL = "/ bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

Press ESC key after editing, and type ": wq" to save and exit.

(5) create relevant users and groups as owners of software installation and support groups.

To create a user, enter the command:

Groupadd oinstall

Groupadd dba

To create an Oracle user and password, enter the command:

Useradd-g oinstall-G dba-m oracle

Passwd oracle

Then you will be asked to enter the password, which you can enter twice at will, but it must be consistent. Enter to confirm it.

(6) create database software directory and data file storage directory

Enter the command:

Mkdir / u01/app/oracle

(7) change the directory owner to Oracle user

Enter the command:

Chown-R oracle:oinstall / u01/app/oracle

(8) configure yum source and supplement package

Yum install binutils compat-libcap1 vsftpd compat-libstdc++-33 iptraf gcc gcc-c++

Glibc-devel glibc elfutils-libelf-devel compat-libcap1 compat-libstdc++-33 libaio-devel ksh libgcc

Libstdc libstdc++ libstdc++-devel libaio libaio-devel make sysstat unixODBC unixODBC-devel-y

Perform the following steps under oracle user:

(1) configure the environment variables of oracle users

Enter the command:

Vi .bash _ profile

Press I to enter edit mode and add the following:

PATH=$PATH:$HOME/bin

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

Export ORACLE_SID=nifa

Export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

Press ESC after editing and type ": wq" to save and exit. Execute the command to take effect directly source .bash _ profile

(2) copy the Oracle installation package (take 64-bit as an example) to the home directory of linux, open the terminal command line interface, and run the unzip command to extract the oracle installation file.

Enter the command:

Unzip linux.x64_11gR2_database_1of2.zip

Unzip linux.x64_11gR2_database_2of2.zip

(3) create oraInst.loc (command vim / etc/oraInst.loc does not have this file and will create a new file after you save the following)

Inventory_loc=/u01/app/oracle/oraInventory

Inst_group=oinstall

Press ESC key after editing, and type ": wq" to save and exit.

(4) silently install the software

[oracle@orcl ~] $vi / home/oracle/database/response/db_install.rsp

[oracle@orcl ~] $cat / home/oracle/database/response/db_install.rsp

Oracle.install.option=INSTALL_DB_SWONLY / / installation type, only database software is installed

ORACLE_HOSTNAME=oracle / / Host name (command hostname query)

UNIX_GROUP_NAME=oinstall / / installation group

INVENTORY_LOCATION=/u01/app/oracle/oraInventory//INVENTORY directory (* * the default value is left empty. This example needs to be modified here, depending on the installation directory created by the individual)

SELECTED_LANGUAGES=en,zh_CN / / Select language

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 / / oracle_home * path according to the directory situation, pay attention to modify this example an path / u01/app/oracle

ORACLE_BASE=/u01/app/oracle / / oracle_base * Note modification

Oracle.install.db.InstallEdition=EE / / oracle version

Oracle.install.db.isCustomInstall=false / / Custom installation, No, use default components

Oracle.install.db.DBA_GROUP=dba / / dba user group

Oracle.install.db.OPER_GROUP=oinstall / / oper user group

Oracle.install.db.config.starterdb.type=GENERAL_PURPOSE / / database type

Oracle.install.db.config.starterdb.globalDBName=nifa / / globalDBName

Oracle.install.db.config.starterdb.SID=nifa / / SID (* * notice here that it is consistent with the configuration SID in the environment variable)

Oracle.install.db.config.starterdb.memoryLimit=81920 / / automatically manage memory (M)

Oracle.install.db.config.starterdb.password.ALL=oracle / / set all database users to use the same password

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false / / (false is manually written)

DECLINE_SECURITY_UPDATES=true / / * * Note that this parameter must be set to true

[oracle@orcl ~] $cd database/

[oracle@orcl database] $. / database/runInstaller-silent-force-noconfig-ignorePrereq-responseFile

/ home/oracle/database/response/db_install.rsp

# Parameter description:

/ database is the unzipped path of the installation package. Changes are made here according to the location of the installation package, which varies from person to person.

RunInstaller is the main installation script

-silent silent mode

-force forced installation

-ignorePrereq ignores the direct installation of warning.

-responseFile reads the installation answer file.

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 2533 MB Passed

Checking swap space: must be greater than 150 MB. Actual 2047 MB Passed

Preparing to launch Oracle Universal Installer from / tmp/OraInstall2017-07-30,01-58-53PM. Please wait... [oracle@orcl database] $You can find the log of this install session at:

/ u01/app/oracle/oraInventory/logs/installActions2017-07-30,01-58-53PM.log

The installation of Oracle Database 11g was successful.

Please check'/ u01/app/oracle/oraInventory/logs/silentInstall2017-07-30mm 01-58-53PM. Log 'for more details.

As a root user, execute the following script (s):

1. / u01/app/oracle/11.2.0/product/db/root.sh

Successfully Setup Software.

(5) root executes the script

[root@orcl ~] # / u01/app/oracle/11.2.0/product/db/root.sh

(6) manually configure the monitor. Create one manually if the file does not exist.

[oracle@orcl response] $cat / u01/app/oracle/11.2.0/product/db/network/admin/listerer.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.8) (PORT = 1521))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

)

[oracle@orcl response] $cat / u01/app/oracle/11.2.0/product/db/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File: / u01/app/oracle/11.2.0/product/db/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

NIFA =

(DESCRIPTION =

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = nifa)

)

)

(7) build the database silently with DBCA:

[oracle@orcl bin] $vi / home/oracle/database/response/dbca.rsp

[oracle@orcl bin] $cat / home/oracle/database/response/dbca.rsp (some values are # RECOVERYAREADESTINATION can use default values)

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "nifa"

SID = "nifa"

TEMPLATENAME = "General_Purpose.dbc"

STORAGETYPE=FS

DATAFILEDESTINATION = / oracle/app/oradata

RECOVERYAREADESTINATION=/oracle/app/flash_recovery_area

CHARACTERSET = "AL32UTF8"

NATIONALCHARACTERSET= "AL32UTF8"

LISTENERS=LISTENER

TOTALMEMORY = "7000"

SYSPASSWORD = "oracle"

SYSTEMPASSWORD = "oracle"

[oracle@orcl bin] $$ORACLE_HOME/bin/dbca-silent-responseFile / home/oracle/database/response/dbca.rsp

Copying database files

1% complete

3% complete

11% complete

18% complete

26% complete

37% complete

Creating and starting Oracle instance

40% complete

45% complete

50% complete

55% complete

56% complete

57% complete

60% complete

62% complete

Completing Database Creation

66% complete

70% complete

73% complete

85% complete

96% complete

100% complete

Look at the log file "/ u01/app/oracle/cfgtoollogs/dbca/nifa/nifa.log" for further details.

Description:

"if asm is used, specify-storageType ASM." (note that there is no +)

If it is a 12c database,-createAsContainerDatabase true is specified as the container database

(8) check whether the oracle instance is running properly

[oracle@orcl ~] $ps-ef | grep ora_pmon

Oracle 3400 5309 0 18:01 pts/1 00:00:00 grep ora_pmon

Oracle 31779 1 0 15:45? 00:00:01 ora_pmon_nifa

[oracle@orcl ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 30 18:01:53 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Thank you for your reading, the above is the "centos6.8 installation of oracle11.2.0.4 steps" content, after the study of this article, I believe you have a deeper understanding of the steps of centos6.8 installation of oracle11.2.0.4, the specific use of the need for you to practice and verify. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.