CentOS 6.8 System installs Oracle 12.1.0.2.0 database

Resource Preparation

A host that has a CentOS 6.8 x86_64 system installed will need to install a desktop environment with Firefox. If only the command-line environment is installed, after configuring the Yum source, use the command yum groupinstall "Desktop"-Y to install.

Log in to the desktop environment, either locally logged on to the desktop environment, or in a desktop environment (configuration process, see network Search) remotely via a tool such as VNC or Xmanager.

Log in to the desktop environment and use Firefox to access Oracle's official website http://www.oracle.com/Download the latest version of Oracle 12.1.0.2.0 database, download-database-oracle Database If an intranet user or an isolated environment does not have direct access to the Oracle official website, use a host with access to download the installation package and upload it to the host to be installed.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/19/wKioL1drMCXimV46AAD19ilE4CU313.png-wh_500x0-wm_3 -wmp_4-s_2378108844.png "title=" Qq20160623084022.png "alt=" Wkiol1drmcximv46aad19ile4cu313.png-wh_50 "/>

Select the latest version of 12.1.0.2.0 for the Linux x86_64 platform and click "See all" in the back

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/83/19/wKioL1drMJrRPEgJAACxE6-ijsI791.png-wh_500x0-wm_3 -wmp_4-s_846175396.png "title=" Qq20160623084225.png "alt=" Wkiol1drmjrrpegjaacxe6-ijsi791.png-wh_50 "/>

Agree to the agreement, download the two-part compression installation package to the system.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/19/wKioL1drMTyij9fiAACCMdAYkKw432.png-wh_500x0-wm_3 -wmp_4-s_3016182008.png "title=" Qq20160623084539.png "alt=" Wkiol1drmtyij9fiaaccmdaykkw432.png-wh_50 "/>

Start the download by signing in with an existing Oracle account or registering for a free Oracle account

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/83/1A/wKioL1drOGzjVTZnAAAlvQ7gvh0769.png-wh_500x0-wm_3 -wmp_4-s_2025196753.png "title=" Qq20160623091545.png "alt=" Wkiol1drogzjvtznaaalvq7gvh0769.png-wh_50 "/>

Use the cksum command to verify the downloaded installation package CRC check code after download is complete

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/83/1A/wKioL1drNnmSTEJhAABhwhs6bII734.png "title=" Qq20160623090740.png "alt=" Wkiol1drnnmstejhaabhwhs6bii734.png "/>

Verify that the downloaded installation package file is complete by checking the CRC check code with the official website

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/83/1A/wKioL1drNv6ChQ2KAAAVYxbQfyE184.png "title=" Qq20160623091010.png "alt=" Wkiol1drnv6chq2kaaavyxbqfye184.png "/>

Installing the Database

Start the database installation when you are sure that the installation package download is complete.

Verify that the Xorg-x11-utils package is installed and install it using the following command if it is not installed.

Yum Install Xorg-x11-utils-y

Oracle data installation cannot use root user, create an Oracle user and set a password, the installation package and the directory owner of the Oracle installation location is more Oracle users (here dedicated to use a piece of data to store all Oracle data), Use this user to log on to the graphics environment to install Oracle.

Useradd Oracle

passwd Oracle

Chown-r Oracle/data

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/83/1A/wKioL1drQE-DWvb6AABbmmZEpOE547.png-wh_500x0-wm_3 -wmp_4-s_529822603.png "title=" Qq20160623094959.png "alt=" Wkiol1drqe-dwvb6aabbmmzepoe547.png-wh_50 "/>

Switch to the directory where the installation package is located and use the Unzip command to unzip the installation package file

Cd/data

Unzip Linuxamd64_12102_database_1of2.zip

Unzip Linuxamd64_12102_database_2of2.zip

When the decompression is complete, a directory named database, size 2.8GB is obtained. This is actually the two parts of the compressed package together extract all the files.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/83/1B/wKiom1drPjDBHLLvAABJIE1_vSM784.png "title=" Qq20160623094045.png "alt=" Wkiom1drpjdbhllvaabjie1_vsm784.png "/>

Switch to the database directory and start the Setup program./runinstaller

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/83/1B/wKiom1drPmSDd3LXAAAXjr2yVoA723.png "title=" Qq20160623094146.png "alt=" Wkiom1drpmsdd3lxaaaxjr2yvoa723.png "/>

Note that the installation environment requires that the TEMP directory must be greater than 500mb,swap space must be greater than 150MB, display configuration at least 256 colors, and so on. If the condition is met, the passed is displayed, and if there are any failed that do not meet the conditions, then the installer needs to be processed until the condition is met.

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/83/1B/wKiom1drQTGBwvf1AACQlgYx1XM865.png-wh_500x0-wm_3 -wmp_4-s_3026456709.png "title=" Qq20160623095242.png "alt=" Wkiom1drqtgbwvf1aacqlgyx1xm865.png-wh_50 "/>

After a while, open the Oracle Graphics Setup Wizard, where you skip the finer reminder mailbox settings directly

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/83/23/wKiom1drjZDTp_y3AACxh3W7byk926.png-wh_500x0-wm_3 -wmp_4-s_688409752.png "title=" Qq20160623151932.png "alt=" Wkiom1drjzdtp_y3aacxh3w7byk926.png-wh_50 "/>

Install only database software

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/37/wKioL1ds5ETDaamfAACT49EWy1Y024.png-wh_500x0-wm_3 -wmp_4-s_1832758135.png "title=" Qq20160624154136.png "alt=" Wkiol1ds5etdaamfaact49ewy1y024.png-wh_50 "/>

Select the Single instance database installation here

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/83/23/wKiom1drjofAKVk1AACD2KpQMtU977.png-wh_500x0-wm_3 -wmp_4-s_3209933726.png "title=" Qq20160623152326.png "alt=" Wkiom1drjofakvk1aacd2kpqmtu977.png-wh_50 "/>

Default English language

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/83/38/wKioL1ds5JXhjup1AAC0tjY2iXA105.png-wh_500x0-wm_3 -wmp_4-s_1537523127.png "title=" Qq20160624154255.png "alt=" Wkiol1ds5jxhjup1aac0tjy2ixa105.png-wh_50 "/>

Database version Default

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/83/39/wKiom1ds5OOSFVQXAAC0oE_E1i0051.png-wh_500x0-wm_3 -wmp_4-s_1457329704.png "title=" Qq20160624154426.png "alt=" Wkiom1ds5oosfvqxaac0oe_e1i0051.png-wh_50 "/>

Installation configuration, including database location, Oracle software installation location.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/83/3A/wKiom1ds5U2CvuNuAACa8MIKKYw579.png-wh_500x0-wm_3 -wmp_4-s_2273543242.png "title=" Qq20160624154605.png "alt=" Wkiom1ds5u2cvunuaaca8mikkyw579.png-wh_50 "/>

Product Listing Directory settings

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/83/3A/wKiom1ds5aaR9FiUAACXOj7M74s865.png-wh_500x0-wm_3 -wmp_4-s_40046166.png "title=" Qq20160624154738.png "alt=" Wkiom1ds5aar9fiuaacxoj7m74s865.png-wh_50 "/>

Configuring the System User Group

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/83/3A/wKiom1ds5dvzqcQYAADD1jbQhNw153.png-wh_500x0-wm_3 -wmp_4-s_3008173110.png "title=" Qq20160624154828.png "alt=" Wkiom1ds5dvzqcqyaadd1jbqhnw153.png-wh_50 "/>

Environmental requirements check, shown as no, is not satisfied with the need to deal with the conditions.

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/83/23/wKioL1drkPmTEbemAAEW2n8eDU0029.png-wh_500x0-wm_3 -wmp_4-s_1846199632.png "title=" Qq20160623153407.png "alt=" Wkiol1drkpmtebemaaew2n8edu0029.png-wh_50 "/>

Click Repair and check again

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/83/23/wKioL1drkTqBmE6nAADcHlk2a08472.png-wh_500x0-wm_3 -wmp_4-s_209259921.png "title=" Qq20160623153514.png "alt=" Wkiol1drktqbme6naadchlk2a08472.png-wh_50 "/>

Prompt to open a terminal terminal and run the repair script using root login/tmp/cvu_12.1.0.2.0_oracle/runfixup.sh

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/83/24/wKiom1drkaLxPj5UAABAfHOjsNo981.png-wh_500x0-wm_3 -wmp_4-s_819034892.png "title=" Qq20160623153645.png "alt=" Wkiom1drkalxpj5uaabafhojsno981.png-wh_50 "/>

Click OK to automatically check again, found that there are still some non-approved needs. For example, to see the size of the swap space does not meet the demand, the hint needs 16GB size, and actually only 8GB size of space, then the need to manually expand the swap space.

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/83/24/wKiom1drktaxXQHvAADnGmpd3cI077.png-wh_500x0-wm_3 -wmp_4-s_2603460851.png "title=" Qq20160623154115.png "alt=" Wkiom1drktaxxqhvaadngmpd3ci077.png-wh_50 "/>

In terminal terminal operation switch to root user, use DD command to create a file close to 9GB size in the data disk with large remaining space.

DD If=/dev/zero of=/data/swap.file bs=4096 count=2250000

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/83/24/wKioL1drlpDAcPMQAAAvDqjjEdY578.png "title=" Qq20160623155731.png "alt=" Wkiol1drlpdacpmqaaavdqjjedy578.png "/>

Format the file as a swap file system

Mkswap/data/swap.file

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/83/25/wKiom1drlsPgSuCMAAA0EaZky9s133.png-wh_500x0-wm_3 -wmp_4-s_2623900523.png "title=" Qq20160623155847.png "alt=" Wkiom1drlspgsucmaaa0eazky9s133.png-wh_50 "/>

Start the swap file system, and you can then see the swap space successfully expanded to 16GB.

Swapon/data/swap.file

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/83/24/wKioL1drlvygaVx3AAArsOkGjSQ437.png-wh_500x0-wm_3 -wmp_4-s_1153497422.png "title=" Qq20160623155946.png "alt=" Wkiol1drlvygavx3aaarsokgjsq437.png-wh_50 "/>

Write to boot auto mount file/etc/fstab

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/83/25/wKiom1drl3fwl0NIAACZcMIR6U4694.png "title=" Qq20160623160131.png "alt=" Wkiom1drl3fwl0niaaczcmir6u4694.png "/>

Run a check again

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/24/wKioL1drl62DLHxaAADKtoEP1N4512.png-wh_500x0-wm_3 -wmp_4-s_3621956890.png "title=" Qq20160623160225.png "alt=" Wkiol1drl62dlhxaaadktoep1n4512.png-wh_50 "/>

The hint that found swap space is gone, leaving only the package problem. If you see a missing message, use the Yum tool to install any missing packages.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/24/wKioL1drmADzDPgiAADhHMt8KRI508.png-wh_500x0-wm_3 -wmp_4-s_673802630.png "title=" Qq20160623160342.png "alt=" Wkiol1drmadzdpgiaadhhmt8kri508.png-wh_50 "/>

When the host Yum source configuration succeeds, the root user executes to install

Yum install compat-libcap1-1.10 compat-libstdc++-33-3.2.3 ksh libaio-devel-0.3.107-y

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/83/24/wKioL1drmOuDOubHAAAdIOHgvAw632.png "title=" Qq20160623160751.png "alt=" Wkiol1drmoudoubhaaadiohgvaw632.png "/>

Install these packages successfully

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/83/24/wKioL1drmWmyoNXWAAC0V2KWXk4387.png-wh_500x0-wm_3 -wmp_4-s_765690371.png "title=" Qq20160623161008.png "alt=" Wkiol1drmwmyonxwaac0v2kwxk4387.png-wh_50 "/>

Run the re-check on the need to go to the installation information at a glance, if the wrong information can be directly clicked edit to modify, and finally confirm the information is correct to start the installation.

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/83/39/wKioL1ds6H6TPc4ZAACx452uzg8527.png-wh_500x0-wm_3 -wmp_4-s_2955277638.png "title=" Qq20160624155937.png "alt=" Wkiol1ds6h6tpc4zaacx452uzg8527.png-wh_50 "/>

Prompt for execution of configuration scripts may appear during installation

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/83/24/wKioL1drm2OA1o-ZAABWdhjl1CU925.png-wh_500x0-wm_3 -wmp_4-s_3219292266.png "title=" Qq20160623161802.png "alt=" Wkiol1drm2oa1o-zaabwdhjl1cu925.png-wh_50 "/>

Switch directly to the root user at the terminal terminal to execute the appropriate script

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/83/24/wKioL1drnCSxQiEMAADGv6wZq8I785.png-wh_500x0-wm_3 -wmp_4-s_3943761508.png "title=" Qq20160623162145.png "alt=" Wkiol1drncsxqiemaadgv6wzq8i785.png-wh_50 "/>

Click on the box to confirm the completion of the execution.

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/83/25/wKiom1drnGzy4rObAABVjXGkt-0530.png "title=" Qq20160623162238.png "alt=" Wkiom1drngzy4robaabvjxgkt-0530.png "/>

Last prompt for database installation success

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/83/25/wKiom1drnzbjW71TAACM5YrJrAM232.png-wh_500x0-wm_3 -wmp_4-s_1451652553.png "title=" Qq20160623163427.png "alt=" Wkiom1drnzbjw71taacm5yrjram232.png-wh_50 "/>

The log file location for this installation is prompted by the terminal terminal that started the Setup program

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/83/25/wKiom1drn3-y8eYXAACCo9Qzp04080.png-wh_500x0-wm_3 -wmp_4-s_4203637555.png "title=" Qq20160623163539.png "alt=" Wkiom1drn3-y8eyxaacco9qzp04080.png-wh_50 "/>

Create a database

Execute a command to open the Metabase Graphics Wizard

/data/oracle/app/oracle/product/12.1.0/dbhome_1/bin/dbca

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/83/3A/wKioL1ds61binOxtAAAe8n_wV44046.png "title=" Qq20160624161147.png "alt=" Wkiol1ds61binoxtaaae8n_wv44046.png "/>

Create a database

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/83/3A/wKiom1ds656x8V9EAACIpVz17eU998.png-wh_500x0-wm_3 -wmp_4-s_2970253229.png "title=" Qq20160624161253.png "alt=" Wkiom1ds656x8v9eaacipvz17eu998.png-wh_50 "/>

Advanced Mode creation

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/3A/wKiom1ds7E_zbiH-AACy-WY1sK8832.png-wh_500x0-wm_3 -wmp_4-s_251719512.png "title=" Qq20160624161543.png "alt=" Wkiom1ds7e_zbih-aacy-wy1sk8832.png-wh_50 "/>

General purpose or thing handling

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/83/4E/wKiom1dwhpDCEfWhAACMSzLaJl8543.png-wh_500x0-wm_3 -wmp_4-s_1543637744.png "title=" Qq20160627095100.png "alt=" Wkiom1dwhpdcefwhaacmszlajl8543.png-wh_50 "/>

Configure the database name with the SID, created as a container database.

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/83/4E/wKiom1dwhxGxD1bFAADJB_yUo3g332.png-wh_500x0-wm_3 -wmp_4-s_4069807542.png "title=" Qq20160627095303.png "alt=" Wkiom1dwhxgxd1bfaadjb_yuo3g332.png-wh_50 "/>

Administrative options Default

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/83/3A/wKioL1ds7ZPxl3jrAACHoy3zTQQ295.png-wh_500x0-wm_3 -wmp_4-s_3336067969.png "title=" Qq20160624162115.png "alt=" Wkiol1ds7zpxl3jraachoy3ztqq295.png-wh_50 "/>

Database authentication, where the same password is created for all users.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/83/4E/wKioL1dwh1ahxBH9AAChVW5YKG4913.png-wh_500x0-wm_3 -wmp_4-s_4257911122.png "title=" Qq20160627095414.png "alt=" Wkiol1dwh1ahxbh9aachvw5ykg4913.png-wh_50 "/>

Configuring listeners

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/83/50/wKiom1dwlRywsmW-AACejysjS2c114.png-wh_500x0-wm_3 -wmp_4-s_2422657639.png "title=" Qq20160627105301.png "alt=" Wkiom1dwlrywsmw-aacejysjs2c114.png-wh_50 "/>

Configuration of database Storage

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/83/50/wKiom1dwlXqATnKmAADxr80Tt_8194.png-wh_500x0-wm_3 -wmp_4-s_3765576869.png "title=" Qq20160627105433.png "alt=" Wkiom1dwlxqatnkmaadxr80tt_8194.png-wh_50 "/>

Enable archive logging parameter settings

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/4F/wKioL1dwlpbTeX66AAA09Q8Tyac314.png-wh_500x0-wm_3 -wmp_4-s_3919340856.png "title=" Qq20160627105905.png "alt=" Wkiol1dwlpbtex66aaa09q8tyac314.png-wh_50 "/>

Database options

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/83/51/wKiom1dwlw6hAuomAACtXnDZtQU495.png-wh_500x0-wm_3 -wmp_4-s_1082116117.png "title=" Qq20160627110122.png "alt=" Wkiom1dwlw6hauomaactxndztqu495.png-wh_50 "/>

Initialize parameters

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/3C/wKiom1dtCrWjhJN5AAC_h9mHw5A784.png-wh_500x0-wm_3 -wmp_4-s_2115272552.png "title=" Qq20160624182543.png "alt=" Wkiom1dtcrwjhjn5aac_h9mhw5a784.png-wh_50 "/>

Create options

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/83/3C/wKioL1dtCuGilRYEAACfT6aXfWg258.png-wh_500x0-wm_3 -wmp_4-s_3680854963.png "title=" Qq20160624182624.png "alt=" Wkiol1dtcugilryeaacft6axfwg258.png-wh_50 "/>

Requirements check by going directly to the installation information overview, click Finish to start creating the database.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/83/51/wKiom1dwl_DDv9-KAACBJd90gIs929.png-wh_500x0-wm_3 -wmp_4-s_1522801791.png "title=" Qq20160627110504.png "alt=" Wkiom1dwl_ddv9-kaacbjd90gis929.png-wh_50 "/>

Create Complete Close Wizard

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/83/4E/wKiom1dwhQzhqACMAAD40-wyGJc657.png-wh_500x0-wm_3 -wmp_4-s_2246256867.png "title=" Qq20160627094406.png "alt=" Wkiom1dwhqzhqacmaad40-wygjc657.png-wh_50 "/>

Log in to Database

Edit Oracle User environment variable/home/oracle/.bash_profile add

Path= $PATH: $ORACLE _home/bin

Export oracle_base=/data/oracle/app/oracle/

Export oracle_home=/data/oracle/app/oracle/product/12.1.0/dbhome_1/

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/83/4E/wKioL1dwi3PxNJv1AABW4vUGNr8836.png "title=" Qq20160627101138.png "alt=" Wkiol1dwi3pxnjv1aabw4vugnr8836.png "/>

Log off and log back on to the system with the Oracle user, using the command sys user (highest privilege) as the SYSDBA login database.

/data/oracle/app/oracle/product/12.1.0/dbhome_1/bin/sqlplus ' sys '/'! QAZxsw2 ' @oracle as Sysdba

When SYS is logged in as the highest data administrator user, it must be logged in as SYSDBA or Sysoper! QAZXSW is the login password, Oracle is the service name for the database.

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/83/50/wKiom1dwkRSDWXZrAABu3j6DXN0836.png-wh_500x0-wm_3 -wmp_4-s_3111340952.png "title=" Qq20160627103544.png "alt=" Wkiom1dwkrsdwxzraabu3j6dxn0836.png-wh_50 "/>

View User

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/83/50/wKiom1dwkk6habTqAAALedYTOg0595.png "title=" Qq20160627104106.png "alt=" Wkiom1dwkk6habtqaaaledytog0595.png "/>

Querying the database

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/83/51/wKiom1dwmnLh47sKAAAVCePptvA666.png "title=" Qq20160627111535.png "alt=" Wkiom1dwmnlh47skaaavcepptva666.png "/>

This article is from the "Server System Communication" blog, so be sure to keep this source http://1130739.blog.51cto.com/1120739/1793208

CentOS 6.8 System installs Oracle 12.1.0.2.0 database