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

Write to yourself: linux Operation and maintenance Road, do it yourself.

Reference: http://www.cnblogs.com/yingsong/p/6031235.html

-

Preparatory work:

Memory and swap requirements

Swap is 1.5 times for 1-2 GB of physical memory.

Swap is equal when physical memory is 2-16g.

Swap 16G when the physical memory is greater than 16G

Hard disk space > 20g

Turn off the firewall and SELINUX

Modify kernel parameters:

# vi/etc/sysctl.conf net.ipv4.ip_local_port_range= 9000 65500fs.file-max = 6815744 kernel.shmall = 10523004 kernel.shmmax = 6465333657 kernel.shmmni = 4096 kernel.sem = 25032000 100128 net.core.rmem_default=262144 net.core.wmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_max=1048576 fs.aio-max-nr = 104857 sysctl-p

Modify user restriction file

# vi / etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 102405

Create users and groups

# groupadd dba # useradd-m-g dba oracle#passwd oracle

Create an installation directory

# mkdir-p / ora11/product/11.2.0/db_1

Data file storage directory

# mkdir-p / ora11/oradata

Data recovery catalog

# mkdir-p / ora11/recovery_data

Log directory in the process of database creation and use

# mkdir-p / ora11/oraInventory

Modify the permissions of the installation directory

# chown-R oracle:dba / ora11#chmod-R 775 / ora11

Log in to the oracle user and set the environment variable

# su-oracle$vim .bash _ profileexport ORACLE_BASE=/ora11export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64export ORACLE_SID=rac1export PATH=$PATH:$ORACLE_HOME/bin$source .bash _ profile / / to make the setting take effect

Install dependency packages

Sort it out by yourself (it's all here)

# yum install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686\ elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc.i686 glibc-devel\ glibc-devel.i686 ksh libgcc libgcc.i686 libstdc++ libstdc++.i686 libaio\ libaio.i686 libaio-devel libaio-devel.i686 make sysstat

-

Upload the installation package to the oracle user's home directory

Link: http://pan.baidu.com/s/1bNvf22 password: zxmv

Linux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zip#unzip linux.x64_11gR2_database_1of2.zip#unzip linux.x64_11gR2_database_1of2.zip#cd database#su-oracle

Database installation profile

/ database/response/db_install.rsp installation answer profile

/ database/response/dbca.rsp create database reply

/ database/response/netca.rsp establish monitoring, local service name and other network settings reply

Modify the configuration file db_install.rsp and install (instance name is rac1, password is 12345678)

# vim / home/oracle/database/response/db_install.rsporacle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0oracle.install.option=INSTALL_DB_AND_CONFIGORACLE_HOSTNAME=centos6-1 UNIXautomatically grouped name name installed dbaINVENTORYLOCATIONANG ora11 orInventorySELECTEDLANGUAGESPREREN LNG UAGESPREREN 11.2.0Unitable1oracle.install.db.InstallEditionEEoracle.install.install.db.isCustomInstallfake falseoracle.install.db.customComponentsfalseoracle.install.customComponentsfalseoracle.install.2.0.1.0 Oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0 Oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0 Oracle.rdbms.rat:11.2.0.1.0oracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=dbaoracle.install.db.config.starterdb.type=GENERAL_PURPOSEoracle.install.db.config.starterdb.globalDBName=rac1oracle.install.db.config.starterdb.SID=rac1oracle.install.db.config.starterdb.characterSet=AL32UTF8oracle.install.db.config.starterdb.memoryOption=trueoracle.install.db.config.starterdb.memoryLimit=400oracle.install.db.config.starterdb.installExampleSchemas=falseoracle.install.db.config.starterdb.enableSecuritySettings=trueoracle.install.db.config. Starterdb.password.ALL=12345678oracle.install.db.config.starterdb.control=DB_CONTROLoracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=falseoracle.install.db.config.starterdb.automatedBackup.enable=falseoracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGEoracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/ora11/oradataoracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/ora11/recovery_dataDECLINE_SECURITY_UPDATES=true

Log in to the oracle user to perform the installation

# su-oracle$./runInstaller-silent-ignorePrereq-responseFile / home/oracle/database/response/db_install.rsp

Where-silent refers to silent installation,-ignorePrereq ignores the check results of prerequisite, and responseFile is the installation file.

During installation, if you prompt [WARNING] to ignore it, the installer is still in progress, and if [FATAL] appears, the installer has stopped.

Open another terminal and execute the command

# tail-100f / u01/app/oracle/oraInventory/logs/installActions.log

You can track and view the installation log in real time to understand the progress of the installation.

-

After the error, you need to delete the directory you have created and install it again

Rm-rf / ora11/*mkdir-p / ora11/product/11.2.0/db_1 / ora11/oradata / ora11/recovery_data / ora11/oraInventorychown-R oracle:dba / ora11chmod-R 775 / ora11

Starting Oracle Universal Installer...

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

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

Preparing to launch Oracle Universal Installer from / tmp/OraInstall2017-04-22. 09-18-14PM. Please wait... [oracle@centos6-1 database] $[WARNING] [INS-32055] The Central Inventory is located in the Oracle base.

CAUSE: The Central Inventory is located in the Oracle base.

ACTION: Oracle recommends placing this Central Inventory in a location outside the Oracle base directory.

[WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.

CAUSE: Oracle recommends that the ADMIN password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].

ACTION: Provide a password that conforms to the Oracle recommended standards.

[WARNING] [INS-32055] The Central Inventory is located in the Oracle base.

CAUSE: The Central Inventory is located in the Oracle base.

ACTION: Oracle recommends placing this Central Inventory in a location outside the Oracle base directory.

[WARNING] [INS-30011] The password entered does not conform to the Oracle recommended standards.

CAUSE: Oracle recommends that the ADMIN password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].

ACTION: Provide a password that conforms to the Oracle recommended standards.

You can find the log of this install session at:

/ ora11/oraInventory/logs/installActions2017-04-22 September 09-18-14PM.log

The following configuration scripts need to be executed as the "root" user.

#! / bin/sh

# Root scripts to run

/ ora11/oraInventory/orainstRoot.sh

/ ora11/product/11.2.0/db_1/root.sh

To execute the configuration scripts:

1. Open a terminal window

2. Log in as "root"

3. Run the scripts

4. Return to this window and hit "Enter" key to continue

If this occurs, it means that the installation is successful, then you need to follow the prompts and return Enter successfully after the operation.

Execute the following two scripts as the root user

/ ora11/oraInventory/orainstRoot.sh/ora11/product/11.2.0/db_1/root.sh

Https://192.168.88.61/em username sys password 12345678 connection identity SYSDBA

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.