Oracle 11G Single Instance installation

The Oracle database needs to be used recently for work reasons, so you have to use Oracle's database, just need to install the Oracle database here to do a simple collation. The installation of Oracle in both Windows and UNIX systems is recommended using a graphical interface, so that you can see the error message, the installation of Windows is not difficult, the installation of a lot of material, here in the Linux environment to say that Oracle installation. Of course, installing Oracle on Linux recommends using VNC installation to avoid unnecessary problems. Oracle installation Deployment configuration is more complex, can be divided into three parts: first, software installation; second, the establishment of the database; Third, configure the monitoring files and local services;

First, Software Installation

1, in the beginning of the installation to check the corresponding dependent package, here to note that if it is installed on the X64 system remember to install i686 that is X64 system X86 package, this is very important, if the leakage of Oracle is not normal installation, here Pdksh not installed no relationship, You've got Ksh installed here.

[Email protected] ~]# yum-y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc Glibc-comm  On Glibc-devel gcc gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++-devel make Sysstat unixODBC unixodbc-devel Pdksh Ksh libaio.i686 glibc.i686 compat-libstdc++-33.i686 libaio-devel.i686 libgcc.i686 libstdc++.i686 unixODBC.i686 unixodbc-devel.i686

2. Start creating Oracle Users and user groups to ensure the normal installation of Oracle after the dependency package is resolved

[[email protected] ~]# groupadd oinstall[[email protected] ~]# groupadd dba[[email protected] ~]# useradd-g oinstall-g D BA Oracle[[email protected] ~]# passwd Oracle

3, after the Oracle user and user groups are configured, you can now configure the system's limits configuration file

[Email protected] ~]# vim/etc/security/limits.conf ...   A little ... Oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard Nofile 65536oracle Soft Stack 10240

4. Modify kernel variable configuration file

[Email protected] ~]# VIM/ETC/SYSCTL.CONFFS.AIO-MAX-NR = 1048576fs.file-max = 6815744kernel.shmall = 2097152# Kernel.shmmax = Xxxxxxxxxx #共享内存字节数 (typically 75% physical memory, this variable is modified according to the actual situation) Kernel.shmmni = 4096kernel.sem = 32000 _local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586[[email protected] ~]# sysctl-p

5. Configuring environment variable profiles for Oracle users

[[email protected] ~]# su - oracle[[email protected] ~]$ vim . Bash_profile ... Slightly ... export oracle_base=/usr/local/u01/oracleexport oracle_home=/usr/local/u01/oracle/product/11.2.0/ Dbhome_1export oracle_sid=u01export nls_lang= "American_america. ZHS16GBK "export nls_date_format=" Yyyy-mm-dd hh24:mi:ss "export ld_library_path= $ORACLE _home/ Libexport path= $ORACLE _home/bin: $PATHPATH = $PATH: $HOME/binexport path[[email protected] ~]#  mkdir -p /usr/local/u01/oracle && chown -r oracle:oinstall / usr/local/u01/oracle[[email protected] ~]# mkdir -p /usr/local/u01/orainventory  && chown -r oracle:oinstall /usr/local/u01/orainventory[[email protected]  ~]$ env | grep oraoracle_sid=u01oracle_base=/usr/local/u01/oracleoracle_home=/usr/ Local/u01/oracle/product/11.2.0/dbhome_1

This configures the Oracle environment variables and directory files, after the configuration of the above environment, Oracle's pre-preparation work is done, at this time, Oracle installation is recommended to use VNC remote, using a graphical interface installation, as far as the remote part can see HTTP/ jim123.blog.51cto.com/4763600/1911577, here do not do too much to repeat.

6. Install Oracle

[[Email protected] Desktop]# Xhost + #这里要注意使用xhost不然会出现no protocol specified Oracle issues [[email protected] Desktop]# Su-oracle[[emai L protected] ~]$ Lang=en_us. utf-8# change to English, otherwise the installation package will be missing Chinese fonts [[email protected] ~]$ Cd/usr/local/src/oracle/database[[email protected] database]$. Runinstaller

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M01/95/D9/wKioL1kaktzA4tcGAACJHRrTfjY120.png-wh_500x0-wm_ 3-wmp_4-s_1613817825.png "title=" first step "alt=" Wkiol1kaktza4tcgaacjhrrtfjy120.png-wh_50 "/>

Here to remove the hook, do not need to fill in the mail

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/95/DA/wKiom1kak73DgtUtAACN2cKjMtk582.png-wh_500x0-wm_ 3-wmp_4-s_904144138.png "title=" The second Step "alt=" Wkiom1kak73dgtutaacn2ckjmtk582.png-wh_50 "/>

Here to choose the second option

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/95/DA/wKioL1kalD7jzXzMAACDdwI8Gu0377.png-wh_500x0-wm_ 3-wmp_4-s_1736330240.png "title=" The third Step "alt=" Wkiol1kald7jzxzmaacddwi8gu0377.png-wh_50 "/>

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/95/DA/wKiom1kalKPTHE-yAACiNjzXLU8144.png-wh_500x0-wm_ 3-wmp_4-s_2577818500.png "title=" Fourth Step "alt=" Wkiom1kalkpthe-yaacinjzxlu8144.png-wh_50 "/>

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/95/DA/wKiom1kalPih7MNhAACkpuewRwE743.png-wh_500x0-wm_ 3-wmp_4-s_2035531765.png "title=" Fifth Step "alt=" Wkiom1kalpih7mnhaackpuewrwe743.png-wh_50 "/>

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M00/95/DA/wKioL1kalSCwkTwjAACYk3v3ZNg322.png-wh_500x0-wm_ 3-wmp_4-s_2225863865.png "title=" sixth Step "alt=" Wkiol1kalscwktwjaacyk3v3zng322.png-wh_50 "/>

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/95/DA/wKiom1kalVbhRllKAACYriMXAsg395.png-wh_500x0-wm_ 3-wmp_4-s_2806956798.png "title=" Seventh Step "alt=" Wkiom1kalvbhrllkaacyrimxasg395.png-wh_50 "/>

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/95/DA/wKioL1kalYDAWnhmAACbIq09-A0307.png-wh_500x0-wm_ 3-wmp_4-s_3157600650.png "title=" eighth Step "alt=" Wkiol1kalydawnhmaacbiq09-a0307.png-wh_50 "/>

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/95/DA/wKiom1kaldyyoRh4AADDhVfsnVQ544.png-wh_500x0-wm_ 3-wmp_4-s_3245995284.png "title=" nineth Step "alt=" Wkiom1kaldyyorh4aaddhvfsnvq544.png-wh_50 "/>

Here it is necessary to ignore the error, because this is not found i386 package, X64 's package is actually using the i686

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/95/DB/wKioL1kalsPTEXBbAACl17rfQks188.png-wh_500x0-wm_ 3-wmp_4-s_529496428.png "title=" Tenth Step "alt=" Wkiol1kalsptexbbaacl17rfqks188.png-wh_50 "/>

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/96/22/wKiom1kdRuihLmRCAADwgaIuYUY114.png-wh_500x0-wm_ 3-wmp_4-s_903858514.png "title=" 11th Step "alt=" Wkiom1kdruihlmrcaadwgaiuyuy114.png-wh_50 "/>

Note Here is the system in the/TMP directory must have more than 1GB, so as to normal installation, or many of the Oracle temporary files can not be stored

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/96/24/wKiom1kdTebzr8UeAADhElZKRpk718.png-wh_500x0-wm_ 3-wmp_4-s_1532742617.png "title=" 11th step _2 "alt=" Wkiom1kdtebzr8ueaadhelzkrpk718.png-wh_50 "/>

To this, according to the prompt operation can complete the Oracle software installation of the part is complete, here is the hint that the root user to execute 2 shell script, then according to the actual situation to execute

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/96/25/wKiom1kdVPPQp5XJAAAqFaouYSU037.png-wh_500x0-wm_ 3-wmp_4-s_1609244443.png "title=" 12th Step "alt=" Wkiom1kdvppqp5xjaaaqfaouysu037.png-wh_50 "/>

Second, the establishment of the database

1. After the Oracle software is installed and close the appropriate window, it is now necessary to start building the database, or use DBCA to start creating the database using Oracle users in the graphical interface

[Email protected] database]$ DBCA

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M00/96/3A/wKiom1keYgniDJxdAADiRJbteFk155.png-wh_500x0-wm_ 3-wmp_4-s_2277677286.png "title=" dbca_1 "alt=" Wkiom1keygnidjxdaadirjbtefk155.png-wh_50 "/>

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/96/3A/wKiom1keYkjzesF3AADdg3PRBkU474.png-wh_500x0-wm_ 3-wmp_4-s_4287104863.png "title=" dbca_2 "alt=" Wkiom1keykjzesf3aaddg3prbku474.png-wh_50 "/>

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/96/3A/wKioL1keYrPA75JJAADAz9od-Zg272.png-wh_500x0-wm_ 3-wmp_4-s_4077180558.png "title=" Dbca_3 "alt=" Wkiol1keyrpa75jjaadaz9od-zg272.png-wh_50 "/>

Here are 3 templates, where you use the first, general purpose, or transactional processing

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M02/96/3A/wKioL1keY77T-P9BAAC2QCjKtaE802.png-wh_500x0-wm_ 3-wmp_4-s_4080699942.png "title=" Dbca_4 "alt=" Wkiol1key77t-p9baac2qcjktae802.png-wh_50 "/>

Here you need to fill in the SID that was written before in the environment variable file

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M01/96/3A/wKioL1keZLrSTBO-AAC2ejZLREU034.png-wh_500x0-wm_ 3-wmp_4-s_3383023650.png "title=" Dbca_5 "alt=" Wkiol1kezlrstbo-aac2ejzlreu034.png-wh_50 "/>

Oracle's EM Archive, can do a lot of function implementation, can do a lot of functions, but if it is not necessary to remove the hook

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/96/3A/wKioL1keZavireFPAAC60EMi6vY659.png-wh_500x0-wm_ 3-wmp_4-s_1463322059.png "title=" Dbca_6 "alt=" Wkiol1kezavirefpaac60emi6vy659.png-wh_50 "/>

Set the user password here, you can let the user's password is different, here is set to the same

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/96/3A/wKioL1keZnnSNr7PAADSZeGWYAA394.png-wh_500x0-wm_ 3-wmp_4-s_3557089627.png "title=" dbca_7 "alt=" Wkiol1keznnsnr7paadszegwyaa394.png-wh_50 "/>

The file system is used here

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/96/3A/wKioL1keaAGyElc3AADKcOYMH2Q277.png-wh_500x0-wm_ 3-wmp_4-s_2162420294.png "title=" Dbca_8 "alt=" Wkiol1keaagyelc3aadkcoymh2q277.png-wh_50 "/>

Set the Flash back zone size here, it is recommended to 20~30GB, this depends on the time of the disk settings, the Flash back area if the Oracle database will stop, so this needs to be aware

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M00/96/3B/wKiom1keaSDQlA0OAACltw0b3xg656.png-wh_500x0-wm_ 3-wmp_4-s_894949423.png "title=" Dbca_9 "alt=" Wkiom1keasdqla0oaacltw0b3xg656.png-wh_50 "/>

For example, this is not required.

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/96/3B/wKioL1keag-QUDrwAADpNxpt3ds910.png-wh_500x0-wm_ 3-wmp_4-s_3878005192.png "title=" dbca_10 "alt=" Wkiol1keag-qudrwaadpnxpt3ds910.png-wh_50 "/>

Configure some of the default system configurations for Oracle, where you need to be aware of the character set, which needs to be modified as required

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/96/3B/wKioL1keapahnyu5AABTXfy5I_Q990.png-wh_500x0-wm_ 3-wmp_4-s_2872581093.png "title=" Dbca_11 "alt=" Wkiol1keapahnyu5aabtxfy5i_q990.png-wh_50 "/>

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/96/3B/wKiom1keat7TX2SeAADWUbhpjqc355.png-wh_500x0-wm_ 3-wmp_4-s_1127757871.png "title=" Oracle_12 "alt=" Wkiom1keat7tx2seaadwubhpjqc355.png-wh_50 "/>

Start creation of Oracle database, direct finish to create

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/96/3B/wKiom1kea2XTYiZeAAERX9JrpLg434.png-wh_500x0-wm_ 3-wmp_4-s_370912060.png "title=" Dbca_11-1 "alt=" Wkiom1kea2xtyizeaaerx9jrplg434.png-wh_50 "/>

The creation of the database DBCA part of the installation is complete.

Iii. Configuring monitoring files and local services

1, install the Monitoring service configuration, same as DBCA is under the graphical interface under the Oracle User Configuration, using NETCA to start configuration

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M00/96/3B/wKioL1kebsHij_uXAADwwGgm1k8362.png-wh_500x0-wm_ 3-wmp_4-s_1862122152.png "title=" netca_1 "alt=" Wkiol1kebshij_uxaadwwggm1k8362.png-wh_50 "/>

Create a monitoring service that serves as the server for Oracle

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M01/96/3B/wKioL1kebxTQZQDHAADcriWfPZY800.png-wh_500x0-wm_ 3-wmp_4-s_1168337444.png "title=" netcat_2 "alt=" Wkiol1kebxtqzqdhaadcriwfpzy800.png-wh_50 "/>

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/96/3B/wKioL1keb1vh95kYAADXaPEoQUU377.png-wh_500x0-wm_ 3-wmp_4-s_1378442422.png "title=" Netca_3 "alt=" Wkiol1keb1vh95kyaadxapeoquu377.png-wh_50 "/>

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/96/3B/wKiom1keb5fhbZxAAADdUQtf7rs949.png-wh_500x0-wm_ 3-wmp_4-s_3995151591.png "title=" Netca_4 "alt=" Wkiom1keb5fhbzxaaadduqtf7rs949.png-wh_50 "/>

Using the TCP protocol

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/96/3B/wKiom1keb-3C2g4BAADaLkD-G8w730.png-wh_500x0-wm_ 3-wmp_4-s_4253701687.png "title=" Netcat_5 "alt=" Wkiom1keb-3c2g4baadalkd-g8w730.png-wh_50 "/>

The default port for Oracle is 1521

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/96/3B/wKiom1kecFDSHWjxAADT8pVt0g8384.png-wh_500x0-wm_ 3-wmp_4-s_2737422635.png "title=" Netca_6 "alt=" Wkiom1kecfdshwjxaadt8pvt0g8384.png-wh_50 "/>

If you want to create another listening file, select No

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/96/3B/wKioL1kecN2jjNOoAADfVq-3y3I169.png-wh_500x0-wm_ 3-wmp_4-s_4286893434.png "title=" netca_7 "alt=" Wkiol1kecn2jjnooaadfvq-3y3i169.png-wh_50 "/>

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/96/3B/wKiom1kecSXC6o23AADyGtRtbMk126.png-wh_500x0-wm_ 3-wmp_4-s_2858891614.png "title=" Netca_8 "alt=" Wkiom1kecsxc6o23aadygtrtbmk126.png-wh_50 "/>

Configure the local network service name as the client for Oracle

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M01/96/3B/wKioL1kecZ_xbFTBAADhRAzjGKY300.png-wh_500x0-wm_ 3-wmp_4-s_416002063.png "title=" Netca_9 "alt=" Wkiol1kecz_xbftbaadhrazjgky300.png-wh_50 "/>

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M00/96/3B/wKioL1keceyigaywAADY9Tbboi0692.png-wh_500x0-wm_ 3-wmp_4-s_127612464.png "title=" netca_10 "alt=" Wkiol1keceyigaywaady9tbboi0692.png-wh_50 "/>

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/96/3C/wKiom1kecjqQO9bRAADi8aeXQVQ928.png-wh_500x0-wm_ 3-wmp_4-s_3488518766.png "title=" Netca_11 "alt=" Wkiom1kecjqqo9braadi8aexqvq928.png-wh_50 "/>

Here, fill in the IP of the server

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/96/3C/wKiom1kecpHj5NQQAADdP9jKZ-Y886.png-wh_500x0-wm_ 3-wmp_4-s_1026585633.png "title=" Netca_12 "alt=" Wkiom1kecphj5nqqaaddp9jkz-y886.png-wh_50 "/>

Here's the Yes test, and then the end of the same as before, to this Oracle installation deployment has been completed

[[email protected] ~]$ lsnrctl start# Start monitoring

Under Start test under Oracle User

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/96/3C/wKioL1kedVjyIFpHAAGYsGCZas4143.png-wh_500x0-wm_ 3-wmp_4-s_3257076434.png "title=" Qq20170519123143.png "alt=" Wkiol1kedvjyifphaagysgczas4143.png-wh_50 "/>

This article from "Technical essay" blog, declined reprint!

Oracle 11G Single Instance installation