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

This article mainly introduces how to install oracle 12c release2, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let's take a look at it.

0. The following files need to be added

Remarks: the content of / etc/oraInst.loc is

Inventory_loc=/home/oracle/oraInventory

Inst_group=oinstall

1. Download the Oracle 12c zip file with only one zip file

two。 Add user groups and create directories:

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba oracle

Passwd oracle

Mkdir / u01; mkdir / u02; mkdir / u03

Mkdir-p / u01/app/oracle/product/12.2.0.1/db_1

Chown-R oracle:oinstall / U01

Chown-R oracle:oinstall / U02

Chown-R oracle:oinstall / U03

3. Modify / etc/hosts file

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

192.168.6.128 dbserver

4. Modify / etc/sysctl.conf

Fs.file-max = 6815744

Kernel.sem = 250 32000 100 128

Kernel.shmmni = 4096

Kernel.shmall = 1073741824

Kernel.shmmax = 4398046511104

Kernel.panic_on_oops = 1

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Net.ipv4.conf.all.rp_filter = 2

Net.ipv4.conf.default.rp_filter = 2

Fs.aio-max-nr = 1048576

Net.ipv4.ip_local_port_range = 9000 65500

Make the parameter effective

Sysctl-p

5. Configuration / etc/security/limits.d/oracle-rdbms-server-12cR2-preinstall.conf

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft nproc 16384

Oracle hard nproc 16384

Oracle soft stack 10240

Oracle hard stack 32768

Oracle hard memlock 134217728

Oracle soft memlock 134217728

6. Modify / etc/pam.d/login

Session required pam_limits.so

7. Install the missing packages required by oracle

Yum install binutils-y

Yum install compat-libcap1-y

Yum install compat-libstdc++-33-y

Yum install compat-libstdc++-33.i686-y

Yum install glibc-y

Yum install glibc.i686-y

Yum install glibc-devel-y

Yum install glibc-devel.i686-y

Yum install ksh-y

Yum install libaio-y

Yum install libaio.i686-y

Yum install libaio-devel-y

Yum install libaio-devel.i686-y

Yum install libX11-y

Yum install libX11.i686-y

Yum install libXau-y

Yum install libXau.i686-y

Yum install libXi-y

Yum install libXi.i686-y

Yum install libXtst-y

Yum install libXtst.i686-y

Yum install libgcc-y

Yum install libgcc.i686-y

Yum install libstdc++-y

Yum install libstdc++.i686-y

Yum install libstdc++-devel-y

Yum install libstdc++-devel.i686-y

Yum install libxcb-y

Yum install libxcb.i686-y

Yum install make-y

Yum install nfs-utils-y

Yum install net-tools-y

Yum install smartmontools-y

Yum install sysstat-y

Yum install unixODBC-y

Yum install unixODBC-devel-y

Yum install gcc-y

Yum install gcc-c++-y

Yum install libXext-y

Yum install libXext.i686-y

Yum install zlib-devel-y

Yum install zlib-devel.i686-y

Yum install e2fsprogs-y

Yum install e2fsprogs-libs-y

Yum install libs-y

Yum install libxcb.i686-y

Yum install libxcb-y

8. Modify / etc/selinux/config

SELINUX=permissive

Save after modification and execute as follows

# setenforce Permissive

9. Turn off the firewall

# systemctl stop firewalld

# systemctl disable firewalld

10. Add environment variabl

# touch / etc/profile.d/setora.sh

The file adds the following:

# Oracle Settings

Export TMP=/tmp

Export TMPDIR=$TMP

# export oracle.install.db.config.starterdb.globalDBName=oracle.sunyard

Export ORACLE_HOSTNAME=dbserver

Export GLOBAL_NAME=odb

Export ORACLE_UNQNAME=hgs

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1

Export ORACLE_SID=hgs

Export PATH=/usr/sbin:/usr/local/bin:$PATH

Export PATH=$ORACLE_HOME/bin:$PATH

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

Export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

11. Upload the linuxx64_12201_database.zip to the server and decompress it. After decompression, the directory is

Silent installation requires configuration of responseFile

To configure the database/response/db_install.rsp in the directory, modify the configuration, otherwise you will report an error during installation and follow your own real configuration.

INVENTORY_LOCATION=/home/oracle/oraInventory

ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1

ORACLE_BASE=/u01/app/oracle

Oracle.install.db.OSDBA_GROUP=oinstall

Oracle.install.db.OSOPER_GROUP=oinstall

Oracle.install.db.OSBACKUPDBA_GROUP=oinstall

Oracle.install.db.OSDGDBA_GROUP=oinstall

Oracle.install.db.OSKMDBA_GROUP=oinstall

Oracle.install.db.OSRACDBA_GROUP=oinstall

Oracle.install.db.config.starterdb.globalDBName=orcle12c

Oracle.install.db.config.starterdb.SID=hgs

Oracle.install.db.config.starterdb.characterSet=AL32UTF8

Oracle.install.db.config.starterdb.memoryLimit=1024

Oracle.install.db.config.starterdb.password.SYS=HGShgs912122_

Oracle.install.db.config.starterdb.password.SYSTEM=HGShgs912122_

Oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u02

Save Fil

twelve。 Installation

What is identified in the figure is the file to be run

You can. / runInstaller-- help to view help

Run the following installation

. / runInstaller-silent-responseFile / u03/database/response/db_install.rsp-showProgress

There will be a progress hint.

13. Create a database

Cd $ORACLE_HOME/dbs

Cp init.ora inithgs.ora

Chown oracle:oinstall inithgs.ora

Modify the inithgs.ora as follows: adjust the memory size according to the real situation

* .audit_file_dest='/u01/app/oracle/admin/orcl/adump'

* .audit_trail='db'

* .compatible='11.2.0'

* .control_files='/u01/app/oracle/controls/ora_control1','/u01/app/oracle/controls/ora_control2'

* .db_block_size=8192

* .db_domain=''

* .db_name='hgs'

* .db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

* .db_recovery_file_dest_size=2G

* .diagnostic_dest=''

* .dispatchers=' (PROTOCOL=TCP) (SERVICE=ORCLXDB)'

* .memory_target=3G

* .open_cursors=300

* .processes=150

* .remote_login_passwordfile='EXCLUSIVE'

# * .undo _ tablespace='UNDOTBS1'

Switch to oracle user

Su-oracle

Sqlplus / as sysdba

Startup nomount

CREATE DATABASE hgs

USER SYS IDENTIFIED BY sys_password

USER SYSTEM IDENTIFIED BY system_password

LOGFILE GROUP 1 ('/ u01max SIZE SIZE 1000m)

GROUP 2 ('/ u01ax SIZE SIZE 1000m)

GROUP 3 ('/ u01ax SIZE SIZE 1000m)

MAXLOGFILES 16

MAXLOGMEMBERS 2

MAXLOGHISTORY 1

MAXDATAFILES 100

CHARACTER SET AL32UTF8

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE'/ u01 SIZE DATAFILE'/ u01 REUSE

SYSAUX DATAFILE'/ u01 SIZE SYSAUX DATAFILE'/ u01 REUSE

DEFAULT TABLESPACE users

DATAFILE'/ u01qapplash oracleandoradataUniplicatehgsusers01.dbf'

SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE'/ u01qapplash oracle.oradataUniplicatetemp01.dbf'

SIZE 500M REUSE

UNDO TABLESPACE undotbs

DATAFILE'/ u01qapplash oracle.oradataUniplicatehgsOndotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

Several sql scripts need to be executed after the creation is completed

Sys user

@? / rdbms/admin/catalog.sql

@? / rdbms/admin/catproc.sql

System user

@? / sqlplus/admin/pupbld.sql

At this point, you have finished installing oracle and creating the database.

Thank you for reading this article carefully. I hope the article "how to install oracle 12c release2" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.