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

This article shows you how to install oracle12c in the Centos7 system, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

I. hardware configuration

CentOS7@VMware ®Workstation 15 Pro, allocate resources: CPU:2, memory: 4GB, hard disk space: 30GB

II. Software preparation

Linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip SecureCRT

III. Configuration of virtual machines

Mount the image, configure the local yum source / etc/yum.repos.d, set network.service (with ip) / etc/sysconfig/network-scripts/ifcfg-ens33 systemctl start network.service ip add to query ip. If there is no ip, look at the network adapter in the lower right corner and change the bridging mode to use SecureCRT to upload files to the root root directory, click connect, and enter it. Click file= > connect sftp session to enter the sftp connection interface after a successful connection. Upload file: cd server some directory lcd local directory put xxx

Extract the file

Extract the file unzip filename. Zip

Direct installation:

Yum-y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.i686 elfutils-libelf-devel gcc gcc-c++ gcc-c++glibc*.i686 glibc glibc-devel glibc-devel*.i686 ksh libgcc*.i686 libgcclibstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.i686 libaiolibaio*.i686 libaio-devel libaio-devel*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686 libXp

Establish users and groups:

Groupadd oinstallgroupadd dbagroupadd operuseradd-g oinstall-G dba,oper oracleecho "123456" | passwd-- stdin oracle # password setting for users, which will be used later

Create the installation directory:

Mkdir-p / u01/app/oracle/product/12.1.0/dbhome_1chown-R oracle:oinstall / u01/appchmod-R 775 / u01/app

Modify the kernel parameter vi / etc/sysctl.conf and add:

Fs.aio-max-nr = 1048576fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 kernel.shmmni = 4096 kernel.sem = 25032000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586

After modification, make it effective: sysctl-p

Change the file limit: add vi / etc/security/limits.d/20-nproc.conf:

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

Modify the environment variables for the Oracle user:

Vi ~ oracle/.bash_profile, add:

ORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1ORACLE_SID=orclexport ORACLE_BASE ORACLE_HOME ORACLE_SID

# if PATH already exists, simply follow the path: $ORACLE_HOME/bin PATH=$PATH:$ORACLE_HOME/bin

Export PATH

Execute mv database / u01/app under the root root directory (database unzipped the oracle installation directory, now cut it to / u01/app (because you have just given permission, put it in another directory may not have permission) execute xhost + under root (with a space in the middle don't forget! )

If there is not enough swap space, log in and add with the root user, and the command is as follows: (in order not to make an error or to perform a steady point)

# dd if=/dev/zero of=/home/swap bs=1024 count=1600000 # mkswap / home/swap # swapon / home/swap turn off # swapoff / home/swap

Log in as the oracle user and start the installation:

. / runInstaller (runInstaller is under / u01/app/database, because it has just been moved from the root root directory)

4. Start the installation:

No account number, no need to choose

Install only the software and build the library later

Install single instance or cluster database, and install single instance

Select language

Enterprise edition

Software storage directory, previously preset

Product list

Configure the installation group

Check the prerequisites, and if there is any failure, it will be displayed above, because it is the experimental environment swap space just ignore it.

If the situation appears as shown in the figure, do not worry about clicking OK first. You need to use the root user to execute the two commands prompted in the figure, and then click OK after execution.

The software was installed successfully

5. Configure monitoring

[oracle@localhost database] $netca

If the situation in the figure indicates that the display environment variable is not set

Solution: export DISPLAY= 's own ip:0.0

Example: export DISPLAY=10.33.37.185:0.0

After startup, go to the window page, select the first item, and configure listening.

Choose to add monitoring here

Choose the listening name here, and the default is fine.

Here is the protocol followed by the monitor, and the default is fine.

Here is the port number for listening. The default is 1521. If you want to change it, you can also use other ports.

After the creation is completed, you will be prompted whether you need to continue to create the next monitor. Just click cancel here.

Under Linux/Unix, start the listener:

$lsnrctl start

Turn off the listener:

$lsnrctl stop

View the monitoring status:

$lsnrctl status

Create a database instance using dbca

Create a database

Create default or advanced mode, select advanced mode

Database usage

CBD container database

EM Enterprise Manager

Set password

Monitoring (monitoring has been configured just now, so you can choose)

Let's just do it in order.

Oracle automatic start and stop script settings

Modify / etc/oratab to add oradb:/opt/u01/app/oracle/product/9.2.0.4:Y

Sid:Oracle_home:Y

If not, oracle lacks permission to the folder etc when oracle is installed.

You can log in with the root user and execute the file under $oracle_home/root.sh and app/*root.sh

The above content is how to install oracle12c in Centos7 system. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.