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

Preparation before installation:

Oracle11gR2 installation media;Linux system sufficient disk space and memory;Linux system needs fixed ip;Xmanager5 (graphical installation required); dependency package can be installed through yum (networking environment required);zip package decompression tool can be installed through yum (networking environment required);root user rights;

Thinking: Set the fixed IP, modify the host name and add the correspondence between the host and IP (if you do not add the error Oracle Net Configuration Assistant failed may be reported later in the installation process); set the fixed IP: vi /etc/sysconfig/network-scripts/ifcfg-Auto_eth4, modified as follows (the contents in the red box in the figure are determined according to their respective machines and can be viewed through ifconfig)

Restart the service after modification and verify the network: service network restart

Change hostname: vi /etc/sysconfig/network Restart takes effect: shutdown -r now

Add the correspondence between hosts and IPs: vi /etc/hosts

Set kernel parameters, modify system resource limits (seemingly to improve Oracle performance) root user;

* Set kernel parameters: vi /etc/sysctl.conf

The red box in the figure below shows the new content

net.ipv4.ip_local_port_range= 9000 65500

fs.file-max = 6815744

kernel.shmall = 10523004

kernel.shmmax = 6465333657

kernel.shmmni = 4096

kernel.sem = 250 32000 100128

net.core.rmem_default=262144

net.core.wmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_max=1048576

fs.aio-max-nr= 1048576

Modify system resource limits: vi /etc/security/limits.conf #Add the following at the end

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

vi /etc/pam.d/login

session required pam_namespace.so #Add pam_limits.so below this line

session required pam_limits.so

3. Create oracle user (which depends on the corresponding user group oinstall, dba), and install Oracle11gR2 under this user; * groupadd oinstall #Create a user group oinstall * groupadd dba #Create user group dba *useradd -g oinstall -G dba -d /opt/oracle -s /bin/bash -m oracle #Create user oracle and join user groups oinstall and dba * passwd oracle4. Create installation directories and set permissions; * mkdir -p /opt/oracle/app/ * mkdir -p /opt/oracle/oradata/ * chmod 755 /opt/oracle/ * chmod 775 /opt/oracle/app/ * chown oracle.oinstall -R /opt/oracle/

Set environment variables of oracle user (switch to oracle user);su - oraclevi ~/.bash_profile

Add the following at the end:

export ORACLE_BASE=/opt/oracle/app

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=orclsource .bash_profile #Effective immediately

Close Selinux (trouble, less information about it in the circle), need root user vi /etc/selinux/config to modify SELINUX=disabledsetenforce 0reboot

close firewall service iptables stopchkconfig iptables off

Download dependency package yum -y install gcc gcc-c++ make binutilscomppat-libstdc ++-33elfutils-libelf elfutils-libelf-devel glibc glibc-commonglibc-devel libaiolibaio-devel libgcclibstdc++ libstdc++-devel unixODBC unixODBC-devel compat-libstdc++-3.2.3-69.el6 Check if graphical interface is installed If not installed, install startx #See if graphical interface can be started yum groupinstall "GNOME Desktop" #Install graphical interface Install media Upload to oracle user directory, extract and delete installation media; Upload to/opt/oracle/directory by FTP tool Unzip command Extract installation media (preferably in order) Install XmanagerXmanager Standard Version 5 Download address: http://xiazai.xshellcn.com/trial/Xmanager-5.0.1062_yy.exe Installation method is no different from general.exe file, normal installation can be done; after installation, the screenshot is as follows

Open Xstart and configure it as follows:

Click Install Dependency Package Before Running, otherwise the following error will be prompted. The command is as follows (root permission is required):

yum install xtermyum install xclock Verify GUI: xclock

Extract oracle installation package and delete installation package unzip linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_2of2.ziprm -rf linux.x64_11gR2_database*

Execute oracle installation script (executed in xmanager pop-up console, oracle user login required)cd /opt/oracle/database./ runInstaller

After the graphical interface is displayed, basically the next step is the default installation. In the middle, you will be prompted to execute two scripts (root permission is required). For details, please refer to the screenshot: cd /opt/oracle/oraInventory/./ orainstRoot.shcd /opt/oracle/app/product/11.2.0/dbhome_1/./ root.sh

Default post-installation monitoring has been configured, verification method: telnet Ip:1521sqlplus sys as sysdba

17. Oracle modifies character set to ZHS16GBK sqlplus sys as sysdbaconn /as sysdbashshutdown immediate;startup mountALTER SYSTEM ENABLE RESTRICTED SESSION;ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;ALTER SYSTEM SET AQ_TM_PROCESSES = 0;alter database open;ALTER DATABASE CHARACTER SET ZHS16GBK; #hint our character set: The new character set must be a superset of the old character set, in which case we can skip the superset check and make changes ALTER DATABASE character set INTERNAL_USE ZHS16GBK;select * from v$nls_parameters;shutdown immediate;startupselect * from v$nls_parameters;quit;

Reference link:

1: Oracle installation tutorial: blog.csdn.net/zhaohuihui6628/article/details/51179998

2: Oracle Character Set Modification Tutorial: jingyan.baidu.com/article/c1465413af2fb20bfcfc4c3e.html

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.