Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The most complete installation process of Oracle database 12C in CentOS7 (full

2025-02-27 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Before installation, you can download 12 installation packages from the second edition on the Oracle official website.

Step 1: you need to add a 20g hard disk to install Oracle, and format the disk as XFS# to enter the server. First, close the firewall systemctl stop firewalld.service systemctl disable firewalld.service setenforce 0 to format and partition: cd / devfdisk / dev/sdb Welcome to fdisk (util-linux 2.23.2). The changes remain in memory until you decide to write them to disk. Think twice before using the write command. Device does not contain a recognized partition table uses the disk identifier 0xc21d9b12 to create a new DOS disk label. Command (enter m for help): nPartition type: P primary (0 primary, 0 extended, 4 free) e extendedSelect (default p): P partition number (1-4, default 1): start sector (2048-41943039, default is 2048): the default 2048Last sector will be used, + sector or + size {KMagg G} (2048-41943039, default is 41943039): will use the default value 41943039 partition 1 has been set to Linux type Set the size to 20 GiB command (enter m for help): wThe partition table has been altered calling ioctl () to re-read partition table. Synchronizing disks. Mkfs-t xfs / dev/sdb1mkdir / orcvim / etc/hostname second line add: HOSTNAMME=oraclevim / etc/hosts third line add: 192.168.18.128 oracle (add your own linux IP address here) hostnamectl set-hostname oraclesumount / dev/sdb1 / orc configure system environment: yum install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel-y modify kernel parameters: vim / etc/ Sysctl.conf# inserts the following in the last line: fs.aio-max-nr = 1048576 # number of asynchronous Io requests the recommended value is: 1048576 it is actually equal to 1024K fs.file-max = 6815744 # the maximum number of open file handles Problem preventing file descriptor exhaustion kernel.shmall = 2097152 # Total shared memory pages Memory divided by 4K kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.sem = 32000 100 128#SEMMSL: maximum number of signals per signal set SEMMNS: maximum number of signals used to control the entire Linux system SEMOPM kernel parameters are used to control the number of signal operations that can be performed per semop system call SEMMNI: kernel parameters are used to control the maximum number of signal sets in the entire Linux system net.ipv4.ip_local_port_range = 9000 65500 # Port range for outgoing connections net.core.rmem_default = 262144 # default value of socket receive buffer size net.core.rmem_max = 4194304 # maximum size of socket receive buffer size net.core.wmem_default = 262144 # default value of socket send buffer size net.core.wmem_max = 1048576 # maximum size of socket send buffer # press Esc to exit insert mode after modification Enter: wq save exit sysctl-p # effective user environment configuration: groupadd oinstallgroupadd dbauseradd-g oinstall-G dba oraclepasswd oracle change the password of user oracle. New password: 123123 invalid password: password less than 8 characters re-enter the new password: 123123passwd: all authentication tokens have been successfully updated. Mkdir-p / orc/app/oraclechown-R oracle:oinstall / orc/app/chmod-R 755 / orc/app/oracle/vim / home/oracle/.bash_profile 10-12 lines deleted Insert the following content: umask 022ORACLEBASPATH = $PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/binLANG=zh_CN.UTF-8export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID configuration resource restriction: vim / etc/pam.d/login# insert session required / lib/security under line 7 of vim / Oracle / pam_limits.sosession required pam_limits.so# after modification, press Esc to exit the insert mode Input: wq save exit vim / etc/security/limits.conf # insert oracle soft nproc 2047 # number of processes available to a single user oracle hard nproc 16384oracle soft nofile 1024 # number of files user can open oracle hard nofile 65536oracle soft stack 10240 # Stack Settings # press Esc to exit insert mode after modification Input: wq save exit change system environment variable: vim / etc/profile# insert if [$USER = "oracle"] then if [$SHELL = "/ bin/ksh"] then ulimit-p 16384 # buffer size ulimit-n 65536 # number of files else ulimit-u 16384-n 65536 # number of files fifi shares the database text on the host Item: smbclient-L / / 192.168.10.190/mkdir / abcmount.cifs / / 192.168.10.190/database / abc note here: enter xhost + under the root account before switching users to oracle Enter the following command: su-oracle export DISPLAY=:0.0cd / abc. / runInstaller will automatically open the installation window, the following is a description of the installation steps:

1. Accept the security update to check, click next, and select Yes

two。 System class selection: service class

3. The installation option is default: create and configure database, single instance database

4. Installation type: typical installation

5. Typical installation configuration: enter the password abc123, other paths do not need to make any changes, click install

6. The prompt window for executing the script pops up during installation, and the process is as follows:

7. At this point, you need to switch to the root user to execute the following command:

/ orc/app/oraInventory/orainstRoot.sh

/ orc/app/oracle/product/12.2.0/dbhome_1/root.sh after this command hits enter, you need to enter yes

Reminder: be sure to go back to the installation interface after execution and click OK!

8. Click next when the progress reaches 100%, and the installation is completed, and the URL address of oracle will be displayed:

Oracle Enterprise Manager Database Express URL: https://oracle:5500/em

The above is the whole installation process of Oracle Database 12C!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report