Get the App
SLTechnology News&Howtos  ›  Database  › 

Stand-alone oracle installation

Shulou Source: shulou.com Published: 2022-06-01 04:41:38 11月19日 Update

= = configure YumSource =

[base]

Name=rhel6-base

Baseurl= file:///os

Enabled=1

Gpgcheck=0

[Server]

Name=rhel6-Server

Baseurl= file:///os/Server

Enabled=1

Gpgcheck=0

[HighAvailability]

Name=rhel6-HighAvailability

Baseurl= file:///os/HighAvailability

Enabled=1

Gpgcheck=0

[LoadBalancer]

Name=rhel6-LoadBalancer

Baseurl= file:///os/LoadBalancer

Enabled=1

Gpgcheck=0

[ResilientStorage]

Name=rhel6-ResilientStorage

Baseurl= file:///os/ResilientStorage

Enabled=1

Gpgcheck=0

[ScalableFileSystem]

Name=rhel6-ScalableFileSystem

Baseurl= file:///os/ScalableFileSystem

Enabled=1

Gpgcheck=0

= required to install the software oracle

Echo 'multilib_policy=all' > > / etc/yum.conf = = install 32-bit and 64-bit

Yum install-y binutils

Yum install-y compat-libstdc++-33

Yum install-y elfutils-libelf

Yum install-y elfutils-libelf-devel

Yum install-y elfutils-libelf-devel-static

Yum install-y gcc

Yum install-y gcc-c++

Yum install-y glibc

Yum install-y glibc-common

Yum install-y glibc-devel

Yum install-y glibc-headers

Yum install-y kernel-headers

Yum install-y ksh

Yum install-y libaio

Yum install-y libaio-devel

Yum install-y libgcc

Yum install-y libgomp

Yum install-y libstdc

Yum install-y libstdc++-devel

Yum install-y make

Yum install-y sysstat

Yum install-y unixODBC

Yum install-y unixODBC-devel

=

Yum install-y binutils

Yum install-y compat-libcap1

Yum install-y compat-libstdc++-33

Yum install-y glibc

Yum install-y glibc-devel

Yum install-y ksh

Yum install-y libaio

Yum install-y libaio-devel

Yum install-y libX11

Yum install-y libXau

Yum install-y libXi

Yum install-y libXtst

Yum install-y libgcc

Yum install-y libstdc++

Yum install-y libstdc++-devel

Yum install-y libxcb

Yum install-y make

Yum install-y nfs-utils

Yum install-y net-tools

Yum install-y smartmontools

Yum install-y sysstat

=

Binutils-2.23.52.0.1-12.el7 (x86 / 64)

Compat-libcap1-1.10-3.el7 (x86x64)

Compat-libstdc++-33-3.2.3-71.el7 (i686)

Compat-libstdc++-33-3.2.3-71.el7 (x86x64)

Glibc-2.17-36.el7 (i686)

Glibc-2.17-36.el7 (x86 / 64)

Glibc-devel-2.17-36.el7 (i686)

Glibc-devel-2.17-36.el7 (x86 / 64)

Ksh

Libaio-0.3.109-9.el7 (i686)

Libaio-0.3.109-9.el7 (x86 / 64)

Libaio-devel-0.3.109-9.el7 (i686)

Libaio-devel-0.3.109-9.el7 (x86 / 64)

Libgcc-4.8.2-3.el7 (i686)

Libgcc-4.8.2-3.el7 (x86 / 64)

Libstdc++-4.8.2-3.el7 (i686)

Libstdc++-4.8.2-3.el7 (x86 / 64)

Libstdc++-devel-4.8.2-3.el7 (i686)

Libstdc++-devel-4.8.2-3.el7 (x86 / 64)

Libxcb-1.9-5.el7 (i686)

Libxcb-1.9-5.el7 (x86 / 64)

LibX11-1.6.0-2.1.el7 (i686)

LibX11-1.6.0-2.1.el7 (x86x64)

LibXau-1.0.8-2.1.el7 (i686)

LibXau-1.0.8-2.1.el7 (x86 / 64)

LibXi-1.7.2-1.el7 (i686)

LibXi-1.7.2-1.el7 (x86 / 64)

LibXtst-1.2.2-1.el7 (i686)

LibXtst-1.2.2-1.el7 (x86 / 64)

Make-3.82-19.el7 (x86 / 64)

Net-tools-2.0-0.17.20131004git.el7 (x86 / 64) (for Oracle RAC and Oracle Clusterware)

Nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS)

Smartmontools-6.2-4.el7 (x86 / 64)

Sysstat-10.1.5-1.el7 (x86 / 64)

Planning:

1. IP planning

127.0.0.1 localhost.localdomain localhost

119.23.147.63 shardcat

119.23.134.20 shardnode1

119.23.134.28 shardnode2

2. Disk planning

+ CRS three 10G disks

+ DGDATA 4 200G disks

+ ARCH 1 x 200G

1. Create users and groups

/ usr/sbin/groupadd-g 1001 oinstall

/ usr/sbin/groupadd-g 1002 dba

/ usr/sbin/groupadd-g 1003 oper

/ usr/sbin/useradd-u 1001-g oinstall-G dba,oper-m oracle

Echo nihao123, | passwd-- stdin oracle

2. Create a folder

Mkdir-p / oracle/app/

Chown-R oracle:oinstall / oracle/app/

Chmod-R 775 / oracle/app/

Mkdir-p / oracle/app/oraInventory

Chown-R oracle:oinstall / oracle/app/oraInventory

Chmod-R 775 / oracle/app/oraInventory

Mkdir-p/oracle / app/oracle

Chown-R oracle:oinstall / oracle/app/oracle

Chmod-R 775 / oracle/app/oracle

3. Edit .bash _ profile

# for grid

Export TMP=/tmp

Export TMPDIR=$TMP

Export ORACLE_SID=+ASM1

Export ORACLE_BASE=/oracle/app/oracle

Export ORACLE_HOME=/oracle/app/grid/product/11.2.0/grid

Export NLS_DATE_FORMAT= "yyyy-mm-dd HH24:MI:SS"

Export THREADS_FLAG=native

Export PATH=$ORACLE_HOME/bin:$PATH

Export THREADS_FLAG=native

Export PATH=$ORACLE_HOME/bin:$PATH

If [$USER = "oracle"] | | [$USER = "grid"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Umask 022

Fi

# for oracle

Export TMP=/tmp

Export TMPDIR=$TMP

Export ORACLE_BASE=/oracle/app/oracle

Export DB_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export GSM_HOME=$ORACLE_BASE/product/11.2.0/gsm

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export ORACLE_SID=shardcat

Export ORACLE_TERM=xterm

Export PATH=/usr/sbin:$PATH

Export PATH=$ORACLE_HOME/bin:$PATH

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

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

Export NLS_DATE_FORMAT= "yyyy-mm-dd HH24:MI:SS"

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

If [$USER = "oracle"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Umask 022

Fi

Alias gsm_env='. / home/oracle/gsm_env'

Alias db_env='. / home/oracle/db_env'

= =

Gsm_env

Export ORACLE_HOME=$GSM_HOME

Export PATH=$ORACLE_HOME/bin

Db_env

Export ORACLE_HOME=$DB_HOME

Export PATH=$ORACLE_HOME/bin

4. Modify system parameters

Vi / etc/security/limits.conf

Oracle soft nproc 16384

Oracle hard nproc 16384

Oracle soft nofile 10240

Oracle hard nofile 65536

Oracle soft stack 10240

Oracle hard stack 10240

=

Vi / etc/pam.d/login

# oracle

Session required / lib64/security/pam_limits.so

=

Vi / etc/sysctl.conf

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Kernel.panic_on_oops = 1

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 1048576

Net.core.rmem_max = 4194304

Net.core.wmem_default = 1048576

Net.core.wmem_max = 1048576

=

Set up vnc

Yum install-y tigervnc-server

Cp / lib/systemd/system/vncserver@.service / etc/systemd/system/vncserver@:3.service

Vi / etc/systemd/system/vncserver@:3.service

[Unit]

Description=Remote desktop service (VNC)

After=syslog.target network.target

[Service]

Type=simple

# Clean any existing files in / tmp/.X11-unix environment

ExecStartPre=/bin/sh-c'/ usr/bin/vncserver-kill% I > / dev/null 2 > & 1 | |:'

ExecStart=/usr/sbin/runuser-l oracle-c "/ usr/bin/vncserver% I-geometry 1024x768"

PIDFile=/home/oracle/.vnc/%H%i.pid

ExecStop=/bin/sh-c'/ usr/bin/vncserver-kill% I > / dev/null 2 > & 1 | |:'

[Install]

WantedBy=multi-user.target

= =

[root@shardnode1 ~] # systemctl daemon-reload

[root@shardnode1 ~] # systemctl start vncserver@:3.service

=

Unix platform

Oracle11g parameter (required)

Archive_lag_target=3600

Audit_trail = none

Control_file_record_keep_time = 90

Db_files=5000

Deferred_segment_creation=false

Enable_ddl_logging=true

Fast_start_mttr_target=300

Open_cussors=1000

Open_links=50

Processes=2000

Remote_login_passwordfile = none

Sessions=2200

Undo_retention=300

Sec_max_failed_login_attempts=30

Parallel_max_servers=30

(adjustable memory parameters)

Memory_max_target=0

Memory_target=0

Pga_aggregate_target=800M

Sga_target=5G

Shared_pool_size=1G

Db_cache_size=3G

Large_pool_size=256M

Java_pool_size=256M

Stream_pool_size=256M

Log_buffer=30M

(optional parameters)

Ddl_lock_timeout = 10

Sec_case_sensitive_logon=false

Sec_return_server_release_banner=true

Use_large_pages = false

Filesystemio_options=SETALL-there is a BUG under ext4, which cannot be set, only if the data file is on the local file system.

ASM instance parameters:

Memory_target = 1g (at least 1g)

Alter system set archive_lag_target=3600 scope=both

Alter system set audit_trail = none scope=spfile

# alter system set control_file_record_keep_time = 90 scope=both

# alter system set db_files=5000 scope=both

Alter system set deferred_segment_creation=false scope=both

Alter system set enable_ddl_logging=true scope=both

Alter system set fast_start_mttr_target=300 scope=both

Alter system set open_cussors=1000 scope=both

Alter system set open_links=50 scope=both

# alter system set processes=2000 scope=both

Alter system set remote_login_passwordfile = none scope=spfile

# alter system set sessions=2200 scope=both

Alter system set undo_retention=300 scope=both

Alter system set sec_max_failed_login_attempts=30 scope=both

Alter system set parallel_max_servers=30 scope=both

Tags: Parameters files planning system three under memory instance platform data folder user disk software adjustable configuration stand-alone Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Linux Microsoft Redmi Shulou Information NVidia