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

This article mainly explains the "Rhel7_Oracle11g_rac installation method is what", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "what is the Rhel7_Oracle11g_rac installation method" bar!

1. Disable selinux

Getenforcesetenforce 0vim / etc/selinux/config

2. Turn off the firewall and disable boot.

Systemctl stop firewalld.servicesystemctl disable firewalld.service

3. Modify the host name

It is forbidden to use an underscore "_" in the host name. It is recommended to use lowercase letters and log in again after modifying the hostnamectl set-hostname mydb1hostnamectl set-hostname mydb2 with a length of less than 8 digits.

4. Configure yum

Mount-t iso9660-o loop / dev/sr0 / media/cat rhel7.repo [base] name=rhel7.7baseurl= file:///mediaenable=1gpgcheck=0

5. Shut down unnecessary services

Redhat6:service iptables stopservice ip6tables stopchkconfig iptables offchkconfig ip6tables offservice sshd startchkconfig sshd onservice Bluetooth stopchkconfig Bluetooth offservice postfix stopchkconfig postfix offservice cups stopchkconfig cups offservice cpuspeed offchkconfig cpuspeed offservice NetworkManager stopchkconfig NetworkManager offservice vsftpd stopchkconfig vsftpd offservice dhcpd stopchkconfig dhcpd offservice nfs stopchkconfig nfs offservice nfslock stopchkconfig nfslock offservice ypbind stopchkconfig ypbind offRedhat7:.

5. Install the dependency package

-- check rpm-Q-- qf'% {NAME} -% {VERSION} -% {RELEASE} (% {ARCH})\ n'\ binutils\ compat-libcap1\ compat-libstdc++-33\ gcc\ gcc-c++\ glibc-devel\ ksh\ libstdc++\ libstdc++-devel\ libaio-devel\ make\ sysstat-- install yum-y install binutils compat-libstdc++-33 gcc gcc-c++ glibc glibc-common glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat openssh-clients compat- Libcap1 xorg-x11-utils xorg-x11-xauth elfutils unixODBC unixODBC-devel libXp elfutils-libelf elfutils-libelf-devel smartmontools

6. Kernel parameter modification

-- calculation method: cat / proc/sys/fs/file-max + 512 * process * instance numberfs.file-max = 6815744kernel.sem = 32000 100 128kernel.shmmni = 4096 ‬-calculation method: getconf PAGE_SIZE TOTAL RAM IN BYTES / PAGE_SIZEkernel.shmall = ‭ 536870912 ‬-- calculation method: HALF OF TOTAL RAM IN BYTESkernel.shmmax = ‭ 1073741824 ‬ net.ipv4.ip_local_port_range = 9 65500net.core.rmem_default = 262144net.core.wmem_default = 262144net.core. Rmem_max = 4194304net.core.wmem_max = 1048576fs.aio-max-nr = 4194304vm.dirty_ratio=20vm.dirty_background_ratio=3vm.dirty_writeback_centisecs=100vm.dirty_expire_centisecs=500vm.swappiness=10vm.min_free_kbytes=524288#rp_filter It is assumed that both eth3 and eth4 are the maximum / minimum memory consumption of private Nic net.ipv4.conf.ens39.rp_filter = 2net.ipv4.conf.ens39.rp_filter = 2#IP sharding aggregation, and the formula is numCPU * 130000 and logical cpu is 96. It is recommended that the high parameter be set to at least 12m. At the same time, the low parameter is 1m less than the high parameter. Net.ipv4.ipfrag_high_thresh=16777216net.ipv4.ipfrag_low_thresh=15728640net.ipv4.ipfrag_time=60- is modified as follows: fs.file-max = 6815744kernel.sem = 32000 100128kernel.shmmni = 4096kernel.shmall = 536870912kernel.shmmax = 1073741824net.ipv4.ip_local_port_range = 900065500net.core.rmem_default = 262144net.core.wmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_max = 1048576fs.aio-max-nr = 4194304vm.dirtyratio = 20vm.dirty _ background_ratio= 3vm.dirtybones writebackwritten sections = 100vm.dirtyweights reinstalled secs = 500vm.swappiness= 10vm.mingling freeway kbytes = 524288net.ipv4.conf.ens39.rp_filter = 2net.ipv4.conf.ens39.rp_filter = 2net.ipv4.ipfrag_high_thresh=16777216net.ipv4.ipfrag_low_thresh=15728640net.ipv4.ipfrag_time=60

7. Close the transparent page of the operating system

Redhat7# cat / sys/kernel/mm/transparent_hugepage/enabledalways madvise [never]-add transparent_hugepage=nevercat / etc/default/grubGRUB_TIMEOUT=5GRUB_DISTRIBUTOR= "$(sed's, release. * $) G'/ etc/system-release) "GRUB_DEFAULT=savedGRUB_DISABLE_SUBMENU=trueGRUB_TERMINAL_OUTPUT=" console "GRUB_CMDLINE_LINUX=" rd.lvm.lv=myvg/swap rd.lvm.lv=myvg/usrvconsole.font=latarcyrheb-sun16 rd.lvm.lv=myvg/root crashkernel=autovconsole.keymap=us rhgb quiet transparent_hugepage=never "GRUB_DISABLE_RECOVERY=" true "- effective for grub # grub2-mkconfig-o / boot/grub2/grub.cfgGenerating grub configuration file... Found linux image: / boot/vmlinuz-3.10.0-123.el7.x86 _ 64Found initrd image: / boot/initramfs-3.10.0-123.el7.x86_64.imgFound linux image: / boot/vmlinuz-0-rescue-41c535c189b842eea5a8c20cbd9bff26Found initrd image: / boot/initramfs-0-rescue-41c535c189b842eea5a8c20cbd9bff26.imgdone-- shutdown the tuned service # systemctl stop tuned.service# systemctl disable tuned.service-- restart reboot-- confirm cat / sys/kernel/mm/transparent_hugepage/enabledredhat6, Redhat7 adds the following configuration to the / etc/rc.d/rc.local file Restart takes effect: if test-f / sys/kernel/mm/transparent_hugepage/enabled Thenecho never > / sys/kernel/mm/transparent_hugepage/enabledfiif test-f / sys/kernel/mm/transparent_hugepage/defrag; thenecho never > / sys/kernel/mm/transparent_hugepage/defragfi confirms the result after restart as follows: cat / sys/kernel/mm/transparent_hugepage/defragalways [never] cat / sys/kernel/mm/transparent_hugepage/enabledalways [never]

8. Ntp settings

Redhat6 configuration: # vi / etc/sysconfig/ntpd# Drop root to id 'ntp:ntp' by default.OPTIONS= "- x-u ntp:ntp-p / var/run/ntpd.pid" # start fine-tuning mode # Set to' yes' to sync hw clock after successful ntpdateSYNC_HWCLOCK=yes # synchronize hardware bios time # vi / etc/ntp.confserver xx.xx.xx.xx prefer # add ntp server address as primary address server 127.127.1.0 iburst# Add native as secondary synchronization address # vi / etc/ntp/step-tickersxx.xx.xx.xx# add ntp server address After setting the automatic synchronization time configuration when ntp starts, restart the ntpd service, and check the status chkconfig ntpd onservice ntpd restartntpstat# to check the ntpd service status date # check whether the time is normal redhat7 configuration: yum install ntpvi / etc/ntp.confserver 10.5.26.10 iburstvi / etc/sysconfig/ntpdOPTIONS= "- x-g" systemctl start ntpd.servicesystemctl enable ntpd.servicesystemctl status ntpd.service

9. Bind the network card

Red6touch / etc/modprobe.d/bonding.confecho "alias bondeth0 bonding" > > / etc/modprobe.d/bonding.confvi / etc/sysconfig/network-scripts/ifcfg-bond0DEVICE=bond0ONBOOT=yesBOOTPROTO=staticUSERCTL=noNM_CONTROLLED=noIPADDR=10.1.2.3NETMASK=255.255.255.0GATEWAY=10.1.2.254BONDING_OPTS= "mode=1 miimon=100" vi / etc/sysconfig/network-scripts/ifcfg-eth0DEVICE=eth0ONBOOT=yesBOOTPROTO=noneMASTER=bond0SLAVE=yesUSERCTL=noNM_CONTROLLED=noecho "ifenslave bond0 eth0 eth2" > > / etc/rc.d/rc.local restart server to view status cat / sys/class/net/bonding_masterscat / sys/ Class/net/bondeth0/bonding/modecat / proc/net/bonding/bondeth0 verifies red7 nmcli team by unplugging the network cable

10. Network check

(1)。 Ensure that the inter-node communication network (private network) is connected through a separate switch, not directly connected. (2)。 Make sure that all nodes have the same network card name and network subnet connected to the same network. For example, the name of the network card connected to the public network is eth0, the IP address subnet is 133.37.x.0, and the subnet mask is 255.255.255.0. (3)。 Ensure that there is one and only one default route in the system and that the default route is reached through the public network. (4)。 Make sure that the bandwidth from the network card to the network is correct. # ethtool eth2Settings for eth2:Supported ports: [TP] Supported link modes: 10baseT/Half 10baseT/Full100baseT/Half 100baseT/Full1000baseT/FullSupports auto-negotiation: YesAdvertised link modes: 10baseT/Half 10baseT/Full100baseT/Half 100baseT/Full1000baseT/FullAdvertised auto-negotiation: YesSpeed: 1000Mb/sDuplex: FullPort: Twisted PairPHYAD: 1Transceiver: internalAuto-negotiation: onSupports Wake-on: umbgWake-on: gCurrent message level: 0x00000003 (3) Speed: 1000Mb/s above Link detected: yes indicates that the actual network bandwidth of the connection is 1000Mbps. Although switches and network cards are 1000Mbps or above bandwidth, sometimes due to port problems, network cable problems and other reasons, the actual bandwidth is not so much. (5)。 Make sure that multicast is enabled on the private network. You can download the mcasttest.pl script on the Oracle official support website to check.

11. Storage multipath configuration

See https://www.modb.pro/db/14031

12. Create a user group

Groupadd-g 1000 oinstallgroupadd-g 1001 dbagroupadd-g 1002 opergroupadd-g 1003 asmadmingroupadd-g 1004 asmopergroupadd-g 1005 asmdbauseradd-u 1000-g oinstall-G dba,oper,asmdba oracleuseradd-u 1001-g oinstall-G dba,asmadmin,asmdba,asmoper,oper grid

13. Limits restrictions

Touch / etc/security/limits.d/99-grid-oracle-limits.confgrid soft nproc 16384grid hard nproc 16384grid soft nofile 10240grid hard nofile 65536grid soft stack 10240grid hard stack 32768grid soft memlock unlimitedgrid hard memlock unlimitedgrid soft core unlimitedgrid hard core unlimitedoracle soft nproc 16384oracle hard nproc 16384oracle soft nofile 10240oracle hard nofile 65536oracle soft stack 10240oracle hard stack 32768oracle soft memlock unlimitedoracle hard memlock unlimitedoracle soft core unlimitedoracle hard core unlimitedtouch / etc/profile.d/oracle-grid.sh#Setting the appropriate ulimits for oracle and grid userif [$USER = "oracle"]; then if [$SHELL = "/ bin/ksh"] Then ulimit-u 16384 ulimit-n 65536else ulimit-u 16384-n 65536 fifiif [$USER = "grid"]; then if [$SHELL = "/ bin/ksh"]; then ulimit-u 16384 ulimit-n 65536else ulimit-u 16384-n 65536 fifi

14. Create a directory

Cluster software BASE directory: / u01/app/oracle cluster software HOME directory: / u01/app/11.2.0/grid database software BASE directory: / u01/app/oracle database software HOME directory: / u01/app/oracle/product/11.2.0/db_homemkdir-p / u01/app/gridmkdir-p / u01/app/11.2.0/gridmkdir-p / u01/app/oraInventorychown-R grid:oinstall / u01/mkdir-p / u01 / App/oracle/product/11.2.0/db_homechown-R oracle:oinstall / u01/app/oracle/chmod-R 755 / U01

15. Set oracle and grid user environment variables

Oracle:export TMP=/tmpexport TMPDIR=$TMPexport ORACLE_SID=racdb1 Export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_homeexport ORACLE_TERM=xtermexport PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport LANG=en_US.UTF-8umask 022grid:export ORACLE_SID=+ASM1export ORACLE_OWNER=gridexport ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/ App/11.2.0/gridexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib PATH=$PATH:$HOME/bin$:$ORACLE_HOME/binexport LANG=en_US.UTF-8export PATH umask 022

16. Modify hosts file

Public IP: the alias directly uses the hostname, that is, the machine name returned by uname-a; Private IP: the alias is the hostname-priv. Virtual IP: alias is hostname-vip. SCAN IP: alias is database name-scan. # Public Ip192.168.0.203 mydb1192.168.0.204 mydb2#Virtual Ip192.168.0.205 mydb1-vip192.168.0.206 mydb2-vip#Private Ip192.168.124.203 mydb1-priv192.168.124.204 mydb2-priv#Scan Ip192.168.0.207 racdb-scan

17. Set up mutual trust

When installing the grid software, use sshUserSetup.sh to quickly create mutual trust, and the parameter of the $node1 $node2 variable needs to be adjusted according to the actual node name. It can be executed on one node (which can be executed under the root user):. / sshUserSetup.sh-user grid-hosts "$node1 $node2"-advanced-exverify-confirm./sshUserSetup.sh-user oracle-hosts "$node1 $node2"-advanced-exverify-confirm

18. Naming convention

1) the naming rule of cluster (CLUSTER), Cluster name, has no special purpose and is only useful when using other management tools to manage different RAC instances. It should not exceed 15 characters. ${DB_NAME}-cls2) the naming convention for SCAN the SCAN name has no special purpose in itself and is only useful for unified management using other management tools, with no more than 15 characters. ${DB_NAME}-scan

19. Check the ignore option during installation

1) Package:pdksh-5.2.142) Device Checks for AM3) Task resolv.conf Integrity

20. Install grid cluster software and add ohas service before executing root.sh script

Touch / usr/lib/systemd/system/ohas.servicechmod 777 / usr/lib/systemd/system/ohas.serviceohas.service: [Unit] Description=Oracle High Availability ServicesAfter= syslog.target [service] ExecStart=/etc/init.d/init.ohasd run > / dev/null 2 > & 1 Type=simpleRestart= always [install] WantedBy=multi-user.targetsystemctl daemon-reloadsystemctl enable ohas.servicesystemctl start ohas.servicesystemctl status ohas.service

21. Execute orainstRoot.sh and root.sh scripts on both nodes

Execution order: 1 node orainstRoot.sh,2 node orainstRoot.sh 1 node root.sh,2 node root.sh1 node: [root@mydb1 system] # / u01/app/oraInventory/orainstRoot.shChanging permissions of / u01/app/oraInventory.Adding read,write permissions for group.Removing read,write Execute permissions for world.Changing groupname of / u01/app/oraInventory to oinstall.The execution of the script is complete. [root@mydb1 system] # / u01/app/11.2.0/grid/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= / u01/app/11.2.0/gridEnter the full pathname of the local bin directory: [/ usr/local/bin]: Copying dbhome to / usr/local/bin... Copying oraenv to / usr/local/bin... Copying coraenv to / usr/local/bin... Creating / etc/oratab file...Entries will be added to the / etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: / u01/app/11.2.0/grid/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerOLR initialization-successful root wallet root wallet cert root cert export peer wallet profile reader wallet pa wallet peer wallet keys pa wallet keys peer cert Request pa cert request peer cert pa cert peer root cert TP profile reader root cert TP pa root cert TP peer pa cert TP pa peer cert TP profile reader pa cert TP profile reader peer cert TP peer user cert pa user certAdding Clusterware entries to inittab**ohasd failed to start** # # this prompt requires you to restart the ohas.service service Failed to start the Clusterware. Last 20 lines of the alert log follow: 2020-01-1008 CRS-2101:The OLR was formatted using version 3.CRS-2672: [client (23496)] CRS-2101:The OLR was formatted using version 3.CRS-2672: Attempting to start 'ora.mdnsd' on' mydb1'CRS-2676: Start of 'ora.mdnsd' on' mydb1' succeededCRS-2672: Attempting to start 'ora.gpnpd' on' mydb1'CRS-2676: Start of 'ora.gpnpd' on' mydb1' succeededCRS-2672: Attempting to start 'ora.cssdmonitor' on' mydb1'CRS -2672: Attempting to start 'ora.gipcd' on' mydb1'CRS-2676: Start of' ora.cssdmonitor' on' mydb1' succeededCRS-2676: Start of 'ora.gipcd' on' mydb1' succeededCRS-2672: Attempting to start' ora.cssd' on' mydb1'CRS-2672: Attempting to start 'ora.diskmon' on' mydb1'CRS-2676: Start of' ora.diskmon' on' mydb1' succeededCRS-2676: Start of 'ora.cssd' on' mydb1' succeeded has successfully created and started ASM. Disk group OCRDG was created successfully. Clscfg:-install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user 'root' Privgrp 'root'..Operation successful.CRS-4256: Updating the profileSuccessful addition of voting disk 992a298111ba4fb8bf16c75cdd232ca8.Successfully replaced voting disk group with + OCRDG.CRS-4256: Updating the profileCRS-4266: Voting file (s) successfully replaced## STATEFile Universal IdFile Name Disk group---1. ONLINE 992a298111ba4fb8bf16c75cdd232ca8 (/ dev/mapper/asm_ocr1p1) [OCRDG] Located 1 voting disk (s). Sh: / bin/netstat: there is no such file or directory CRS-2672: Attempting to start 'ora.asm' on' mydb1'CRS-2676: Start of 'ora.asm' on' mydb1' succeededCRS-2672: Attempting to start 'ora.OCRDG.dg' on' mydb1'CRS-2676: Start of 'ora.OCRDG.dg' on' mydb1' succeeded package is in preparation. Cvuqdisk-1.0.9-1.x86_64Configure Oracle Grid Infrastructure for a Cluster. Succeeded2 node: [root@mydb2 etc] # / u01/app/oraInventory/orainstRoot.shChanging permissions of / u01/app/oraInventory.Adding read,write permissions for group.Removing read,write Execute permissions for world.Changing groupname of / u01/app/oraInventory to oinstall.The execution of the script is complete. [root@mydb2 etc] # [root@mydb2 etc] # cd [root@mydb2 ~] # / u01/app/11.2.0/grid/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= / u01/app/11.2.0/gridEnter the full pathname of the local bin directory: [/ usr/local/bin]: Copying dbhome to / usr/local/bin. Copying oraenv to / usr/local/bin... Copying coraenv to / usr/local/bin... Creating / etc/oratab file...Entries will be added to the / etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: / u01/app/11.2.0/grid/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerOLR initialization-successfulAdding Clusterware entries to inittab**ohasd failed to start** # # this prompt requires you to restart the ohas.service service Failed to start the Clusterware. Last 20 lines of the alert log follow: 2020-01-1008 CRS-2101:The OLR was formatted using version 3.CRS-4402: [client (21808)] CRS-2101:The OLR was formatted using version 3.CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node mydb1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the clustersh: / bin/netstat: there is no file or directory package in preparation... cvuqdisk-1.0.9-1.x86_64Configure Oracle Grid Infrastructure for a Cluster. Succeeded

22. Ignore the error report

1) Configure Oracle Grid Infrastructure for aCluster2) Oracle Cluster Verification Utility

23. Ignored items in database software installation check

1) Package:pdksh-5.2.142) Task resolv.conf Integrity3) Single Client Access Name (SCAN)

23. Installation error report

Hint: Error in invoking target 'agent nmhs'of makefile' / u01 apprenticespact oracle.productUniverse 11.2.0 apprenticeships sysmanplagen.mkpictures. The solution is as follows: cd $ORACLE_HOME/sysman/libcp ins_emagent.mk ins_emagent.mk.bakvi ins_emagent.mk/NMECTL quick positioning, modified as follows: $(MK_EMAGENT_NMECTL)-lnnz11 description: the first is the letter l followed by the number 1, and then click Retry

24. Under root users, execute root.sh on two nodes respectively

/ u01/app/oracle/product/11.2.0/db_home/ root.sh [root @ mydb2 ~] # / u01/app/oracle/product/11.2.0/db_home/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= / u01/app/oracle/product/11.2.0/db_homeEnter the full pathname of the local bin directory: [/ usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the / etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.

25. Use asmca to configure the disks required for instance installation

REDODG

DATADG

ARCHDG

26. Create an instance using dbca

27. Configure hugepage, large page memory

What are the benefits of using large memory pages:

1. Reduce the page table (Page Table) size. Each Huge Page corresponds to continuous 2MB physical memory, so the physical memory of 12GB only needs the Page Table of 48KB, which is much less than the original 24MB. 2. Huge Page memory can only be locked in physical memory and cannot be swapped to the swap area. This avoids the performance impact caused by switching. 3. Due to the reduction of the number of page tables, the hit rate of TLB in CPU (which can be understood as CACHE of CPU to page tables) is greatly improved. 4. The page table for Huge Page can be shared among processes, and the size of Page Table is reduced. In fact, this can reflect the shortcomings of Linux in the paging processing mechanism. Other operating systems, such as AIX, avoid this problem of Linux by sharing the same page table for memory such as shared memory segments. For example, in a system maintained by the author, the number of connections is usually more than 5000, and the SGA of the instance is about 60GB. If you press the Linux paging method, most of the memory in the system will be used by the page table.

The implementation steps are as follows:

1) check / proc/meminfogrep-I hugepage / proc/meminfo2) calculate the HugePages_Total size and use the hugepages_settings.sh script to calculate: #! / bin/bashKERN= `uname-r | awk-F. '{printf ("% d% d\ n", $1) }'`# Find out the HugePage sizeHPG_SZ= `grep Hugepagesize / proc/meminfo | awk'{print $2}'`# Start from 1 pages to be on the safe side and guarantee 1 free HugePageNUM_PG=1# Cumulative number of pages required to handle the running shared memory segmentsfor SEG_BYTES in `ipcs-m | awk'{print $5}'| grep "[0-9] [0-9] *" `doMIN_PG= `echo "$SEG_BYTES/ ($HPG_SZ*1024)" | bc-q`if [$MIN_PG-gt 0] ThenNUM_PG= `echo "$NUM_PG+$MIN_PG+1" | bc-q`fidone # Finish with resultscase $KERN in'2.4') HUGETLB_POOL= `echo "$NUM_PG*$HPG_SZ/1024" | bc-q`; echo "Recommended setting: vm.hugetlb_pool = $HUGETLB_POOL";; '2.6') MEM_LOCK= `echo "$NUM_PG*$HPG_SZ" | bc-q` Echo "Recommended setting within the kernel boot command line (/ etc/sysctl.conf): vm.nr_hugepages = $NUM_PG" echo "Recommended setting within / etc/security/limits.d/99-grid-oracle-limits.conf: oracle soft memlock $MEM_LOCK" echo "Recommended setting within / etc/security/limits.d/99-grid-oracle-limits.conf: oracle hard memlock $MEM_LOCK";; '3.10') MEM_LOCK= `echo "$NUM_PG*$HPG_SZ" | bc-q` Echo "Recommended setting within the kernel boot command line (/ etc/sysctl.conf): vm.nr_hugepages = $NUM_PG" echo "Recommended setting within / etc/security/limits.d/99-grid-oracle-limits.conf: oracle soft memlock $MEM_LOCK" echo "Recommended setting within / etc/security/limits.d/99-grid-oracle-limits.conf: oracle hard memlock $MEM_LOCK"; *) echo "Unrecognized kernel version $KERN. Exiting. " Esac#end-3) modify / etc/sysctl.conf file, add as below, according to the hugepages size calculated in the previous step: vm.nr_hugepages=92184) effective sysctl-p5) modify / etc/security/limits.d/99-grid-oracle-limits.conf, add the following, set the oracle user can lock the memory size, in KB, can be set to a specific value, can also be set to unlimited:oracle soft memlock unlimitedoracle hard memlock unlimited6) restart the instance

28. Modify the local and cluster listener port number to 11521

1) confirm before modification: [grid@mydb1 ~] $srvctl config listenerName: LISTENERNetwork: 1, Owner: gridHome: End points: TCP:1521 [grid@mydb1 ~] $srvctl config scan_listenerSCAN Listener LISTENER_SCAN1 exists. Port: TCP:15212) modify listener and scan_listener port to 11521 under the cluster, execute srvctl modify listener-l LISTENER-p "TCP:11521" srvctl modify scan_listener-p 115213) modify local_listener on one node, and enter sqlplus;alter system set local_listener ='(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.205) (PORT = 11521)) 'scope=both sid='racdb1' Alter system set local_listener ='(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.206) (PORT = 11521)) 'scope=both sid='racdb2';4) modify remote_listeneralter system set remote_listener='racdb-scan:11521' scope=both 5) disable local listening on the first node, modify listener.ora, endpoints_listener.ora, tnsnames.ora, and restart local listening srvctl stop listener-l LISTENER-n mydb1cd $ORACLE_HOME/network/admin-- change 1521 to 11521vi endpoints_listener.oravi listener.orasrvctl start listener-l LISTENER-n mydb1srvctl status listener-l LISTENERsrvctl config listener6) turn off local monitoring on the second node, modify listener.ora, endpoints_listener.ora, tnsnames.ora And restart local listening srvctl stop listener-l LISTENER-n mydb2cd $ORACLE_HOME/network/admin-- modify 1521 to 11521vi endpoints_listener.oravi listener.orasrvctl start listener-l LISTENER-n mydb2srvctl status listener-l LISTENERsrvctl config listener7) modify ASM listening port (if you do not modify asm listening port, lsnrctl status will not show asm service listening status when viewing listening status) su-gridsqlplus / as sysdbaalter system set local_listener=' (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.0.205) (PORT=11521)) 'scope=both sid='+ASM1' Alter system set local_listener=' (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.0.206) (PORT=11521)) 'scope=both sid='+ASM2';lsnrctl status

29. Asm parameter optimization

ASM disk groups use the default 1m AU size, which results in a large memory footprint and a slight impact on performance for large databases. It is recommended to appropriately increase the AU size for the new ASM disk groups used to place data files, such as 4m or 8m (the power of 2). According to the practical experience of telecom operators, it is recommended to set AU to 4m.

30. Recommended for database parameter modification

Alter system set resource_manager_plan='FORCE:' scope=spfile sid='*';Alter system set audit_trail=none scope=spfile sid='*';alter system set undo_retention=10800 scope=spfile sid='*';alter system set session_cached_cursors=200 scope=spfile sid='*';alter system set db_files=2000 scope=spfile sid='*';alter system set max_shared_servers=0 scope=spfile sid='*';alter system set sec_max_failed_login_attempts=100 scope=spfile sid='*';alter system set deferred_segment_creation=false scope=spfile sid='*';alter system set parallel_force_local=true scope=spfile sid='*' Alter system set parallel_max_servers=32 scope=spfile sid='*';alter system set sec_case_sensitive_logon=false scope=spfile sid='*';alter system set open_cursors=3000 scope=spfile sid='*';alter system set open_links = 40 scope=spfile sid='*';alter system set open_links_per_instance = 40 scope=spfile sid='*';alter system set db_cache_advice=off scope=spfile sid='*';alter system set "_ b_tree_bitmap_plans" = false scope=spfile sid='*';alter system set "_ gc_policy_time" = 0 scope=spfile sid='*' Alter system set "_ gc_defer_time" = 3 scope=spfile sid='*';alter system set "_ lm_tickets" = 5000 scope=spfile sid='*';alter system set "_ optimizer_use_feedback" = false sid='*';alter system set "_ undo_autotune" = false scope=both sid='*';alter system set "_ bloom_filter_enabled" = FALSE scope=spfile sid='*';alter system set "_ cleanup_rollback_entries" = 2000 scope=spfile sid='*';alter system set "_ px_use_large_pool" = true scope=spfile sid='*' Alter system set "_ optimizer_extended_cursor_sharing_rel" = NONE scope=spfilesid='*';alter system set "_ optimizer_extended_cursor_sharing" = NONE scope=spfilesid='*';alter system set "_ optimizer_adaptive_cursor_sharing" = false scope=spfilesid='*';alter system set "_ optimizer_mjc_enabled" = FALSE scope=spfilesid='*';alter system set "_ sort_elimination_cost_ratio" = 1 scope=spfilesid='*';alter system set "_ partition_large_extents" = FALSE scope=spfilesid='*' Alter system set "_ index_partition_large_extents" = FALSE scope=spfile sid='*';alter system set "_ clusterwide_global_transactions" = FALSE scope=spfile sid='*';alter system set "_ part_access_version_by_number" = FALSE scope=spfile;alter system set "_ partition_large_extents" = FALSE scope=spfile;alter system set "_ sort_elimination_cost_ratio" = 1 scope=spfile;alter system set "_ use_adaptive_log_file_sync" = FALSE scope=spfile;alter system set "_ lm_sync_timeout" = 1200 scope=spfile;alter system set "_ ksmg_granule_size" = 134217728 scope=spfile Alter system set "_ optimizer_cartesian_enabled" = false scope=spfile;alter system set "_ external_scn_logging_threshold_seconds" = 3600 scope=spfile;alter system set "_ datafile_write_errors_crash_instance" = false scope=spfile;alter system set event='28401 TRACE NAME CONTEXT FOREVER, LEVEL 1purl 60025 trace namecontext forever:10949 trace namecontext forever,level 1 'sid='*' scope=spfile Thank you for your reading, the above is the content of "what is the Rhel7_Oracle11g_rac installation method", after the study of this article, I believe you have a deeper understanding of what the Rhel7_Oracle11g_rac installation method is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.