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

I. preparatory work

System: CentOS 6.5

Database: Oracle 12.2.0.1

The inspection includes:

If the system disk is sufficient, it is best to plan well in advance, and try not to install Oracle into the root directory "/", so as to avoid problems caused by the full capacity of the root disk caused by system logs or Oracle-related logs. Install the database to a disk with sufficient capacity.

Memory check, if the production environment and other services are on the same server, make sure that the memory is allocated properly to prevent the Oracle database temporary process from crashing due to errors when the memory is full.

Swap exchange partition, 12C database requires exchange partition is 16G. If the system does not have a swap swap partition or the swap partition size is insufficient, you can reconfigure it. Refer to:

Second, the system configuration before installation

The preparation of Oracle 12c single instance installation is not much different from that of Oracle 11g. 11g installation reference: https://blog.csdn.net/qq_32838955/article/details/104904241https://blog.csdn.net/qq_32838955/article/details/104898405

1. Configure system parameter configuration

(1)

[root@local ~] # vim / etc/sysctl.conf / / copy the following to the end of the file kernel.shmmax = 536870912kernel.shmall = 2097152 kernel.shmmni = 4096kernel.sem = 32000 100128fs.file-max = 6815744fs.aio_max-nr = 1048576net.ipv4.ip_local_port_range = 900065500net.core.rmem_default = 1048576net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576

(2) execute the command to make the modified parameters effective:

[root@local] # sysctl-p

(3) configure parameters about file restrictions:

[root@local ~] # vi / etc/security/limits.conf / / limit the number of files opened by the session oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240oracle hard stack 10240

(4) configure the mapping between IP address and host name

[root@local ~] # vi / etc/hosts 172.16.50.14 local

(5) install the packages required by the Oracle database and execute the following command.

[root@local ~] # yum-y install autoconf automake binutils-devel bison cpp dos2unix ftp gcc gcc-c++ lrzsz python-deve compat-db compat-db42 compat-db43 compat-gcc-34 compat-gcc-34-c++ compat-libstdc++-33 glibc-* glibc-*.i686 libXpm-*.i686 libXp.so.6 libXt.so.6 libXtst.so.6 libgcc_s.so.1 ksh libXp libaio-devel numactl numactl-devel unixODBC unixODBC-devel compat-libcap* elfutils-libelf*

(6) create Oracle database users and user groups: (it is recommended to specify GID and UID (especially in cluster environment))

[root@local ~] # groupadd-g 54321 oinstall [root@local ~] # groupadd-g 54322 dba [root@local ~] # useradd-u 54321-g oinstall-G dba oracle [root@local ~] # passwd oracle (create a password for Oracle system users)

(7) set up the oracle software installation file directory (assuming the installation directory is placed under the new disk / data):

[root@local ~] # mkdir-p / data/app/oracle [root@local ~] # chown-R oracle:oinstall / data

Note: when operating the chwon command, if the system already has / data, and other services have been run or deployed or other types of databases such as mysql have been installed in the directory, do not directly execute chown-R, it will modify all the owners and groups of all directories under / data, if there are other services or other types of databases, it will lead to serious problems with directory permissions.

Therefore, as long as it is not a newly created catalog, it is recommended to modify the owners and groups one by one according to the catalog:

[root@local ~] # chown oracle:oinstall / data [root@local ~] # cd / data [root@local ~] # chown oracle:oinstall / app [root@local ~] # cd app [root@local ~] # chown oracle:oinstall / oracle

(8) set Oracle database system environment variables

[root@local ~] # su-oracle [root@local ~] # vim .bash _ profile / / modify the file export ORACLE_BASE=/data/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.2.1.0export ORACLE_SID=ORCLexport PATH=$PATH:$HOME/bin:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib under the oracle user's home directory

(9) upload the database installation package to the server. In order to upload the installation to the / home/oracle directory and decompress it, decompress it one by one according to the sequence number on the installation package name. After the two packages are decompressed, a database folder will be generated, which is the installation package of the Oracle database:

[oracle@lcoal] # lslinuxx64_12201_ database.zip [oracle @ lcoal] # unzip linuxx64_12201_ database.zip [oracle @ lcoal] # lsdatabase linuxx64_12201_ database.zip3, installation of Oracle database

Oracle database installation generally uses its own UI for graphical installation to avoid configuration errors during silent installation. This is also a graphical installation.

There are two ways to install Oracle graphically:

One is to use VNC to remotely install the Linux system, which requires Linux to install the desktop environment and start it with the desktop environment. VNC configuration reference: https://blog.csdn.net/qq_32838955/article/details/104254488

Second, do not need Linux desktop environment to start, need to install the necessary dependency package groups to support graphical, use Xmanger links in the local graphical call installation, Xmanager configuration method reference: https://blog.csdn.net/qq_32838955/article/details/104254691

This time, the database is installed in the second way:

(the graphical call does not go into detail, but starts directly from the installation interface)

1. Install the Oracle database software after configuring the link:

Start Xstart on Windows and configure the linked Oracle user:

Switch to the Oracle user, then cd to the extracted database directory, and start the installation:

Uncheck the box and click next:

At this point, the installation of Oracle 12c software is complete. The configuration of monitoring can be configured in advance like installing Oracle 11g, and 12 can also be installed at the same time when the instance is created. It is recommended that you configure the method of monitoring this database instance and monitoring at the same time before installing the database instance:

[oracle@local ~] # dbca

At this point, the installation of the Oracle database is complete!

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.