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

Centos 7 install oracle database

2025-01-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

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

1. Create a user

Su-root

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-g dba-m oracle

Centos7

Adduser-g oinstall-g dba-m oracle

Passwd oracle

two。 Configure X11

Whether to install X Window System or not

Use rpm-qa | grep-I x11

If there is no installation, install

Configure X11

Su-root

Vi / etc/gdm/custom.conf

[security]

AllowRemoteRoot=true

[xdmcp]

Port=177

Enable=true

Xhost +

Enables the installation interface of oracle to be displayed on the client

# you don't have to operate #

[oracle@localhost oracle] $echo $DISPLAY

[oracle@localhost oracle] $DISPLAY= "client IP address: 0.0"

If it is a VNC remote installation, you need to change the address and screen number to

[oracle@localhost oracle] $DISPLAY= "client IP address: 1.0"

[oracle@localhost oracle] $export DISPLAY

[oracle@localhost oracle] $echo $DISPLAY

3. Set the coding language (do it in Chinese, not in English)

System default Encoding Settings File

Below Centos7 / etc/sysconfig/i18n

Centos7 and above / etc/locale.conf

LANG= "en_US" (no garbled code)

LANG= "zh_cn.UTF-8"

4. Copy a file

Ssh oracle@ address

Enter the oracle password

Scp remote host: file path local file path preferably / home/oracle directory

Or use the storage medium to store the database software xshell login and upload

Mount iso as yum source under root

Mkdir / media/cdrom

Mount-o loop xxx.iso / media/cdrom

Unzip

If you finish executing. / runInstaller, if you don't have the installation interface. Just restart it.

Note: if there is a dead process or yum process occupies and kills process kill-s 9

5. Install dependency package software

Pdksh compat-libstdc++ elfutils-libelf-devel libaio-devel libstdc++-devel unixODBC unixODBC-devel

Mpfr cpp ppl cloog-ppl gcc gcc-c++ binutils binutils-devel elfutils-libelf expat expat-devel glibc glibc-common glibc-devel glibc-headers libaio libgcc libstdc++ make sysstat

6. Install database software

Save directory information during installation by default

Execute in the unzipped directory (one more parameter setting than before)

. / runInstaller-jreLoc / usr/lib/jvm/jre-1.8.0

1. Check out the mailbox.

two。 Choose to create and configure a database (first)

3. Select Server class

4. Select a single instance, namely single

5. Advanced installation Advanced install

6. Language selection English and Traditional Chinese

7. Select the standard version 4.22G

8. Installation location default

9. Create restore default

10. Select General Purpose/Transaction Processing for configuration type

The other is the data warehouse. Do not choose.

11. Global data name: cwall SID:cwall

twelve。 Configuration option sets the character set to AL32UTF8, other defaults

13. Management options default

14. Data storage default

15. Backup and restore, select default

16. Scheme and password, choose to set the same password King@2018

17. Default

eighteen

It will be stuck at 68% during installation.

7. Set the environment variable for oracle

[oracle@localhost] $vi ~ / .bash_profile

Export ORACLE_BASE=/home/oracle/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1

Export ORACLE_SID=cwall

Export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

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

8. Optimization (optional)

Modify the configuration file

Modify operating system core parameters

Vi / etc/security/limits.conf

Add the following:

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Modify / etc/pam.d/login file

Vi / etc/pam.d/login

Session required / lib/security/pam_limits.so

Session required pam_limits.so

[root@localhost] # vi / etc/sysctl.conf

Add the following

Fs.file-max = 6815744

Fs.aio-max-nr = 1048576

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 4194304

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

[root@localhost] # sysctl-p # make the file effective

[root@localhost] # vi / etc/profile

Edit / etc/profile

Add the following:

If [$USER = "oracle"]; then

If [$SHELL = "/ bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

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: 237

*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

Servers

Wechat

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

12
Report