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

-- installation background

The last time I encountered a problem, the load caused by cursor:mutex S was too high, and it was said that this problem could be avoided by upgrading to 11.2.0.4, so I was going to rebuild the new version 11.2.0.4.

The installation environment is azure Cloud linux centos6.5.

1. Modify the kernel

1.1 modify the sysctl.conf file

[root@orcltest Downloads] # vim/etc/sysctl.conf# add by tim.mankernel.shmmax = 277495689510912kernel.shmmni = 4096kernel.sem = 32000 100 128net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586fs.file-max = 6815744 # Controls the maximum number of shared memory segments In pages kernel.shmall = 4294967296net.ipv4.tcp_max_tw_buckets = 6000net.ipv4.ip_local_port_range = 9000 65500net.ipv4.tcp_tw_recycle = 0net.ipv4.tcp_tw_reuse = 1net.core.somaxconn = 262144net.core.netdev_max_backlog = 262144net.ipv4.tcp_max_orphans = 262144net.ipv4.tcp_max_syn_backlog = 262144net.ipv4.tcp_synack_retries = 2net.ipv4.tcp_syn _ retries = 1net.ipv4.tcp_fin_timeout = 1net.ipv4.tcp_keepalive_time = 30net.ipv4.tcp_keepalive_probes = 6net.ipv4.tcp_keepalive_intvl = 5net.ipv4.tcp_timestamps = 0fs.aio-max-nr = 1048576

1.2 make the parameter effective

[root@orcltest Downloads] # sysctl-p

2. Add users and groups

[root@orcltestDownloads] # groupadd oinstall [root@orcltestDownloads] # groupadd dba [root@orcltestDownloads] # groupadd oper [root@orcltestDownloads] # useradd-g oinstall-G dba,oper oracle [root@orcltestDownloads] # passwd oracle3, modify limits.conf limit

[root@orcltestDownloads] # vim / etc/security/limits.conforacle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024oracle hard nofile 655364, modified / etc/pam.d/login

[root@orcltestDownloads] # vim / etc/pam.d/loginsession required/lib64/security/pam_limits.so5, modify the bash_profile file

(1) modify profile:

[root@orcltest Downloads] # vim / etc/profile # add by tim.manif [$USER = "oracle"]; thenif [$SHELL = "/ bin/ksh"]; then ulimit-p 16384 ulimit-n 65536else ulimit-u 16384-n 65536fifi

(2) modify bash_profile:

[oracle@orcltest ~] $vim .bash _ profileexport EDITOR=viexport ORACLE_SID=doea5dbexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export INVENTORY_LOCATION=/oraInventoryexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport NLS_LANG= "American_america.zhs16gbk" export NLS_DATE_FORMAT='yyyy-mm-dd hh34:mi:ss'export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:$PATH:$HOME/binumask 022

To make bash_profile effective:

[oracle@orcltest ~] $source .bash _ profile

6, create a directory

[root@orcltest~] # mkdir / data/oracle [root@orcltest~] # chown oracle:oinstall / data [root@azure_earth_dbm1_3_112 app] # mkdir / data/ oracle [root @ azure_earth_dbm1_3_112 app] # mkdir / data/oraInventory [root@azure_earth_dbm1_3_112 app] # cd / oracle/ app [root @ azure_earth_dbm1_3_112 app] # ln-s / data/oracle oracle [root @ azure_earth_dbm1_3_112 app] # ln-s / data/oraInventory oraInventory [root@azure_earth_dbm1_3_112 app] # chown-R oracle.oinstall / data [root @ azure_earth_dbm1_3_112 app] # chown-R oracle.oinstall / oracle [root @ azure_earth_dbm1_3_112 app] # [root@azure_earth_dbm1_3_112 oracle] # mkdir-p/oracle / app/oracle [root@azure_earth_dbm1_3_112 oracle] # chown-R oracle : oinstall / oracle/app/oracle [root@ azure_earth_dbm1_3_112 oracle] # chmod-R 775 / oracle/app/oracle [root@ azure_earth_dbm1_3_112 oracle] # 7 Install the rpms package

Rpm package installation: rpm-ivh *-- force-nodeps

Rpms installation is sometimes not guaranteed to be valid, so you can install it again with yum:

# install with yum As follows: yum install-y binutils*yum install-y compat-libstdc*yum install-y elfutils-libelf*yum install-y gcc*yum install-y glibc*yum install-y ksh*yum install-y libaio*yum install-y libgcc*yum install-y libstdc*yum install-y make*yum install-y sysstat* yum install libXp*-yyum install-y glibc-kernheaders # check that lib is fully installed: [root@powerlong4 ~] # rpm-Q-queryformat%-{name} -% { Version} -% {release} -% {arch} "\ n"\ compat-libstdc++-33 glibc-kernheaders glibc-headers libaio libgcc glibc-devel xorg-x11-deprecated-libs

If it is missing, continue to install the missing package.

8, install vnc

Vnc installation reference: https://www.jb51.net/article/110095.htm

9, decompress

Oracle official website generally can not be downloaded, need a user name password to log in, if you need this Oracle software download, welcome to leave your email address in the message area below, I will send it to you in time.

Here you are just going to deploy dataguard, so you only need to install the two zip packages, 1of7 and 2of7.

Unzipp13390677_112040_Linux-x86-64_1of7.zip

Unzip p13390677_112040_Linux-x86-64_2of7.zip

After unzipping, you will see a database directory.

10pm VNC viewer remote installation

[root@azure_earth_dbm1_3_112 ~] # exportDISPLAY=10.254.3.112: 1.0 [root @ azure_earth_dbm1_3_112 ~] # xhost + access control disabled, clients canconnect from any host [root @ azure_earth_dbm1_3_112 ~] # [oracle@azure_earth_dbm1_3_111 database] $. / runInstaller "You are attempting to install 64-bitOracle on a 32-bit operating system. This is not supported and will not work. "[oracle@azure_earth_dbm1_3_111 database] $vim runInstaller# comment out exit 126 to if [`$ roomE` =" Linux "]; then if [- e $GETCONF]; then value= `$ GETCONF LONG_ BIT` if [$value! = 64]; then echo"\ "You are attempting to install 64-bit Oracle on a32-bit operating system. This is notsupported and will not work.\ "; # exit 126; # corresponding to the exit code of oui fi fifi

Then execute. / runInstaller, there will be the following interface, officially start the interface to install the oracle database, select the prompt to ignore the software update, and click next next, as shown in figure 01.png:

Then select the single instance database installation, as shown in 02.png:

Select UK, SC, and TC from the available languages on the left, as shown in 03.png below:

Then select the enterprise version of 4.7GB, as shown in the following 04.png:

The following oraclebase root directory and software directory do not need to be set by default (of course, you can also change the path if you want to change the path). By default, you can directly next the next step, such as 05.png:

Next, select oinstall when you oraInventorygroup name, as shown in 08.png, next next:

Select dba on databaseadministrator group, select oper on databaseoperator group, and net the next step, as shown in 009.png:

Then, execute the basic components of checksoracle. If prompted by libaio or compat, you can directly IgnoreAll. The next step of next is shown in 010.png:

Then select install installation and start installing the oracle software, as shown in 011.png:

After entering the installation interface, a progress bar% will be displayed, as shown in 012.png:

If the installation is complete, it will pop up as shown in ExecuteConfiguration scripts, and select OK to complete the installation of oracle software, as shown in 013.png:

After that, when you see that oracle is installed to the best step Finish, select close to end, as shown in 014.png:

11, execute the dbca initialization script:

Execute the orainstRoot.sh and root.sh scripts as root (Note: after executing the script, click "ok"):

# find the file path [oracle@azure_earth_dbm1_3_111 database] $find / data/-name orainstRoot.sh/data/oraInventory/ orainstRoot.sh [oracle @ azure_earth_dbm1_3_111 database] $find / data/-name root.sh/data/oracle/product/11.2.0/dbhome_1/inventory/Templates/root.sh/data/oracle/product/11.2.0/dbhome_1/ root.sh [oracle @ azure_earth_dbm1_3 _ 111database] $# start execution of script [root@azure_earth_dbm1_3_111 soft] # sh / data/oraInventory/orainstRoot.shChanging permissions of / oracle/app/oraInventory.Adding read Write permissions for group.Removing read,write,execute permissions for world. Changing groupname of / oracle/app/oraInventory to oinstall.The execution of the script is complete.[ root @ azure_earth_dbm1_3_111 soft] # [root@azure_earth_dbm1_3_111 soft] # sh / data/oracle/product/11.2.0/dbhome_1/root.shPerforming root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / oracle/app/oracle/product/11.2.0/dbhome_1 Enter 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.Finished product-specific root actions. [root @ azure_earth_dbm1_3_111 soft] #

12Based Netca to create oracle snooping

On the shell command line sudo-oracle, and then execute the netca command, the following interface appears, and select the default listener configure configuration, such as 015.png:

Then select Add and add a new listener, such as 016.png:

The default listening name is LISTENER, and then the next step of next is shown in 017.png.

Then proceed to the next step of next, as shown in 018.png:

Select the default port of 1521, and then next the next step as shown in 019.png:

After Ok,listener has been added, click cancel to exit, as shown in 020.png:

13pm VPN remote dbca installs oracle database instance

[root@azure_earth_dbm1_3_112 ~] # exportDISPLAY=192.168.3.112: 1.0 [root @ azure_earth_dbm1_3_112 ~] # xhost + access control disabled, clients canconnect from any host [root @ azure_earth_dbm1_3_112 ~] # [oracle@azure_earth_dbm1_3_111 database] $dbca

The oracle instance installation interface appears after dbca, as shown below, select the first one, and then next as shown in 021.png:

Select create the database, and then next the next step as shown in 022.jpg:

Enter the global instance name and SID, where the default is the same powerdes, and then next as shown in 024.jpg:

Then the next step defaults, as shown in 025.jpg:

Set a unified sys password, as shown in 026.jpg and 027.png:

Select the local data file template address: as shown in 028.jpg:

Then configure the flash area and archive, as shown in 029.jpg:

Select the template schemas, as shown in 030.jpg:

Configure sga and pga. The default is 40%. Since it is a dedicated db server, it can be adjusted to 70%, as shown in 031.png:

Then select the number of connections. The default is 150, which is basically not enough. You can set it to 5000 here, as shown in 032.png:

Then select the character set and set 16GBK, as shown in 033.png:

Then Data Store appears, and you see some files and storage parameters, as shown in 034.jpg:

Then select CreateDatabase and GenerateDatabase Creation Scripts to start create, as shown in 035.jpg:

After that, jump out of the confirmation message interface and click ok to confirm, as shown in 036.jpg:

After that, you will see the configuration screen, which indicates that scripts has been created successfully. Click ok, as shown in 037.jpg:

Then comes the interface for creating db and creating data files, as shown in 038.jpg:

Then start to create the data file, which takes a long time, mainly depends on the disk write speed. If it is a ssd disk, it will end in a few minutes. If it is an ordinary disk, it will take at least an hour. After that, the oracle database instance will be created, as shown in 039.jpg:

14. Modify startup parameters to open archiving and flashback

# modify spfile parameters SQL > alter system set log_archive_dest_1='location=/doea5/arch';SQL > alter system set log_archive_format='arch_%t_%s_%r.log' scope=spfile;SQL > alter system set db_recovery_file_dest_size=20G scope=spfile;SQL > alter system set db_recovery_file_dest='/oracle/app/oracle/flash_recovery'; SQL > alter system set db_flashback_retention_target=10080 scope=spfile;SQL > alter system set undo_retention=10800 # Open Archive and Flashback SQL > shutdown immediateSQL > startup mountSQL > alter database archivelog; SQL > alter database flashback on;SQL > alter database open

OK, so far, the installation of oracle11g2.0.4 has been successfully completed.

If you keep reporting "xhost: unable to open display" and there is no other way to solve it, you can try the following ways:

[root@pddbnew ~] # export DISPLAY=10.251.3.31:1.0 [root@pddbnew ~] # xhost + xhost: unable to open display "10.251.3.31 xhost 1.0" [root@pddbnew ~] # [root@pddbnew ~] # [root@pddbnew ~] # export DISPLAY=pddbnew:1.0 [root@pddbnew ~] # xhost + xhost: unable to open display "pddbnew:1.0" [root@pddbnew ~] #

Solution:

Execute command: export DISPLAY=:1.0

Execute command: xdpyinfo (ps:xdpyinfo command will give you a pile of information)

Execute command: xhost +

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.