Stand-alone oracle installation
= = 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