Linux installation oracle11g

Linux installation oracle11g0, download orcle11g

Http://www.cnblogs.com/mmzs/p/9030823.html

1. Upload files to the/install directory of the server or virtual machine

[Email protected] install]# rz–y

If the Rz–y command is not available, it can be resolved as follows:

Yum Install Lrzsz-y

2. Unzip the file to the current directory:

[Email protected] install]# Unzip Linux.x64_11gR2_database_1of2.zip

[Email protected] install]# Unzip Linux.x64_11gR2_database_2of2.zip

If the unzip command is not available, execute the following command in turn:

     Yum List | grep zip/unzip     yum install zip     yum Install unzip  

Move the extracted folder directly to the/software directory:

[Email protected] install]# MV database//software/

[Email protected] install]# Cd/software

[email protected] install]# LL

3. Turn off SELinux

[Email protected] software]# Vim/etc/selinux/config

Set selinux=disabled

[Email protected] software]# Setenforce 0

4. Turn off the firewall

To view the system version:

[Email protected] software]# cat/etc/redhat-release

CentOS Linux release 7.3.1611 (Core)

[Email protected] software]# getconf long_bit

64

If it is 6 and below:

[[Email protected] software]# service iptables stop

[[Email protected] software]# service iptables status

[Email protected] software]# chkconfig iptables off

If it is centenOS7:

[Email protected] software]# systemctl restart Firewalld.service

[Email protected] software]# Systemctl list-unit-files|grep firewalld.service

Firewalld.service disabled

[Email protected] software]# systemctl disable Firewalld.service

5. Install Oracle 11g Dependency Package

[email protected] software]# yum install gcc make binutils gcc-c++ compat-libstdc++-33elfutils-libelf-devel Elfutils-libelf-devel-static ksh libaio libaio-develnumactl-devel sysstat UnixODBC unixodbc-devel pcre-devel–y

6. Add installation users and user groups

[Email protected] software]# Groupadd Oinstall

[[email protected] software]# Groupadd DBA

[Email protected] software]# useradd-g oinstall-g dba Oracle

[Email protected] software]# passwd Oracle

Changing password for user Oracle.

New Password:

Bad Password:the PASSWORD is shorter than 8 characters

Retype new Password:

Passwd:all authentication tokens updated successfully.

[[email protected] software]# ID Oracle

UID=1001 (Oracle) gid=1001 (oinstall) groups=1001 (Oinstall), 1002 (DBA)

7. Modify kernel parameter configuration file

[Email protected] software]# vim/etc/sysctl.conf

Add the following at the end:

FS.AIO-MAX-NR = 1048576fs.file-max = 6815744= 2097152= 1073741824= 4096= 32000= 900065500 = 262144= 4194304=  262144 = 1048576

To see if it was successfully written into the/etc/sysctl.conf file:

[Email protected] software]# sysctl–p

where Kernel.shmmax = 1073741824 is the half of the native physical memory (2G), in bytes.

8, modify the user's limit file

To modify the/etc/security/limits.conf file:

[Email protected] software]# vim/etc/security/limits.conf

Add the following at the end:

Oracle           Soft    nproc           2047Oracle           hard    nproc           16384oracle           soft    Nofile           1024x768Oracle           hard    nofile         65536oracle           soft    stack            10240 

To modify the/etc/pam.d/login file:

[Email protected] software]# Vim/etc/pam.d/login

Add the following at the end:

Session Required  /lib64/security/pam_limits.sosession required   pam_limits.so  

To modify the/etc/profile file:

[Email protected] Myyun software]# vim/etc/profile

Add the following at the end:

#oracle配置 if [$USER = "Oracle" ];   Then if [$SHELL = "/bin/ksh" ];       Then -P      16384-n 65536  else      -u 16384-n 65536  

9. Create the installation directory and set file permissions

[Email protected] software]# mkdir-p/data/oracle/product/11.2.0

[Email protected] software]# Mkdir/data/oracle/oradata

[Email protected] software]# mkdir/data/oracle/inventory

[Email protected] software]# Mkdir/data/oracle/fast_recovery_area

[Email protected] software]# chown-r oracle:oinstall/data/oracle

[Email protected] software]# chmod-r 775/data/oracle

10. Setting Oracle User Environment variables

First switch to the Oracle User:

[Email protected] software]# su-l Oracle

[[email protected] ~]$ vim. Bash_profile

At the end, add the following:

Oracle_base=/data/oracle

Oracle_home= $ORACLE _base/product/11.2.0

oracle_sid=ORCL

Path= $PATH: $ORACLE _home/bin

Export Oracle_base oracle_home Oracle_sidpath

Note that the red place must be created with the database instance name is the same, or the database cannot be accessed after it is started. After the first configuration remember source a bit.

11. Edit the Silent installation response file

Copy the installation folder response to the current Oracle user's home directory:

[Email protected] ~]$ cp-r/software/database/response/.

[Email protected] ~]$ CD response/

[Email protected] response]$ vim DB_INSTALL.RSP

The options you need to set are as follows:

Oracle.install.option=install_db_swonly

Oracle_hostname=centos

Unix_group_name=oinstall

Inventory_location=/data/oracle/inventory

Selected_languages=en,zh_cn

oracle_home=/data/oracle/product/11.2.0

Oracle_base=/data/oracle

Oracle.install.db.installedition=ee

Oracle.install.db.dba_group=dba

Oracle.install.db.oper_group=dba

Decline_security_updates=true

12. Silent installation According to the response file oracle11g

[Email protected] response]$ cd/software/database/

[Email protected] database]$./runinstaller-silent-responsefile/home/oracle/response/db_install.rsp-ignoreprereq

If the execution of the above command error, you will be prompted to format the parameters, according to the prompt parameter format modification can be modified, generally because the font in Word, symbol format copied to the client command line after the inconsistency caused by the modification.

Landlord encountered the problem of insufficient exchange space:

The solution is as follows (executed under root user):

[[email protected]/]# free

[[email protected]/]# dd If=/dev/zero of=swapfile bs=1024 count=500000

500000+0 Records in

500000+0 Records out

512000000 bytes (MB) copied, 1.67013 s, 307 MB/s

[Email protected]/]# Mkswap swapfile

Setting up Swapspace version 1, size = 499996 KiB

No label, UUID=C5E355EB-E73E-4AA0-B882-CB6D1F88E6BC

[Email protected]/]# Swapon swapfile

Swapon:/swapfile:insecure permissions 0644, 0600 suggested.

[[email protected]/]# free

Begins a silent installation of Oracle in the background. During installation, if you are prompted [WARNING] to ignore it, the Setup program is still in the background, and if successfully setup software appears, Setup has stopped.

The log for this installation session can be found at the following location:/data/oracle/inventory/logs/installactions2018-05-13_02-14-55pm.log

You can toggle the terminal execution Top command to see that the background process is always installed, and the/data directory is growing,

When the following prompt appears, the installation succeeds:

Execute the script as required.

Open terminal, log out to root, execute script:

[[Email protected] database]$ exit

Logout

[Email protected] software]# sh/data/oracle/inventory/orainstroot.sh

changing permissions of/data/oracle/inventory.

Adding read,write permissions for group.

Removing Read,write,execute permissions for the world.

Changing groupname of/data/oracle/inventory to Oinstall.

The execution of the script is complete.

[Email protected] software]# sh/data/oracle/product/11.2.0/root.sh

Check/data/oracle/product/11.2.0/install/root_iz2f570bi1k56uz_2018-05-13_14-25-04.log for the output of root script

13. Configure the monitoring in silent mode

Re-use Oracle User login:

[Email protected] software]# su-l Oracle

Last Login:sun-14:09:10 CST 2018 on PTS/3

[Email protected] ~]$ NETCA/SILENT/RESPONSEFILE/HOME/ORACLE/RESPONSE/NETCA.RSP

Note here that you must use the/silent/responsefile format instead of the-silent-responsefile because it is a silent installation.

After running successfully, generate Listener.ora and Sqlnet.ora in/data/oracle/product/11.2.0/network/admin

With the netstat command, you can see that port 1521 is listening.

Yum installs Netstat software, and the package is in Net-tools.

[email protected]/]# Yum install Net-tools

[email protected]/]# Yum install Net-tools

14, to create a new library silently, but also to establish a corresponding example

[Email protected] ~]$ VIM/HOME/ORACLE/RESPONSE/DBCA.RSP

Modify the following parameters in the file:

[general]# Oracle version, cannot change responsefile_version= "11.2.0"# Description:type of Operationoperation_type= "CreateDatabase"[createdatabase]# Description:global database name of the database# global databases=sid+Host Domain Gdbname= "Orcl.test"# Description:system identifier (SID) of the database# corresponding instance name SID= "ORCL"# Description:name of the template# Library template file templatename= "General_purpose.dbc"# Description:password forSYS user# SYS administrator password Syspassword= "123456"# Description:password forSystem user# system Administrator password Systempassword= "123456"# Description:password forsysman user# sysman Administrator password Sysmanpassword= "123456"# Description:password fordbsnmp user# dbsnmp Administrator password Dbsnmppassword= "123456"# Description:location of the data file' s# Data File storage directory Datafiledestination=/data/oracle/oradata# description:location of the data file' s# Recover data storage directory Recoveryareadestination=/data/oracle/fast_recovery_area# Description:character Set of the database# character set, important!!!After you build the library, you can't change it, so make sure it's clear before you build it. # (CHARACTERSET= "Al32utf8" nationalcharacterset= "UTF8") CHARACTERSET= "ZHS16GBK"# Description:total Memory in MB to allocate to oracle# Oracle RAM 1638MB, physical memory 2G*80%totalmemory= "1638" 

To configure silently:

[Email protected] ~]$ DBCA-SILENT-RESPONSEFILE/HOME/ORACLE/RESPONSE/DBCA.RSP

Check the instance process after the database is built:

[Email protected] ~]$ Ps-ef | grep Ora_ | Grep-v grep

To view the listening status:

[Email protected] ~]$ lsnrctl status

Database creation is complete.

For more information, view the log files in the following location:/data/oracle/cfgtoollogs/dbca/orcl/orcl.log.

Database information:

Global database name: orcl.test

System identifier (SID): ORCL

Login to view instance status:

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql> select status from V$instance;

If error: "Ora-12162:tns:net service name is incorrectly specified"

Error reason: "This error is due to the fact that the ORACLE_SID variable was not passed in." 】

Workaround:

1. View current Oracle_sid

[Email protected] ~]$ echo $ORACLE _sid

Orcl

2. Modify the same as in Oracle_sid and/HOME/ORACLE/RESPONSE/DBCA.RSP                                                                                                                                                                             

[Email protected] ~]$ export ORACLE_SID=ORCL

3. If you still cannot log in, try to modify the permissions of the Orcle folder

15, command-line mode silent Delete

1, first check the DBCA Help information

Dbca-help

Modify the following parameters in the/home/oracle/response/dbca.rsp file, the following three parameters are modified according to the actual situation of the database:

Operation_type = "DeleteDatabase"

Sourcedb = "ORCL"

Sysdbausername = "SYS"

Sysdbapassword = "123456"

Then run:

Dbca-silent-responsefile/home/oracle/response/dbca.rsp

Each parameter has the following meanings:

-silent means to silently delete

-responsefile indicates which response file to use, must use absolute path

Responsefile_version the version of the response file template, this parameter does not change

Operation_type installation type, do not change this parameter

Sourcedb database name, not the global database name, which does not contain db_domain

Very simple database uninstallation is complete, please note, only the database is uninstalled, the database software is still in.

2. Uninstalling the database using DBCA

Dbca-silent-delete Database-responsefile DBCA.RSP

A. option-silent means silent installation, no installation interaction, and most installation information is not output

B. Option-responsefile Specify an answer file that requires an absolute path

Reference article:

1. The solution of insufficient swap space when installing Oracle under Linux

2, Sqlplus/as sysdba can not log on the strange error

3, Oracle 11g based CentOS7 silent installation tutorial (no GUI, remote installation)

Linux installation oracle11g