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

-

I. hardware requirements

II. Software

Third, pay attention before installation

Fourth, prepare before installation

Install Oracle and make related settings

VI. Testing

-

I. hardware requirements

1. Memory & swap

Minimum: 1 GB of RAM

Recommended: 2 GB of RAM or more

View system memory:

# grep MemTotal / proc/meminfoMemTotal: 1030684 kB# grep SwapTotal / proc/meminfoSwapTotal: 2064376 kB

two。 Hard disk

Since there are almost 4 gigabytes of CentOS after installation, plus the installation of Oracle, etc., please prepare at least 10 gigabytes of hard disk space.

Check disk usage:

# df-hFilesystem Size Used Avail Use% Mounted on/dev/sda2 30G 3.0G 27G 10% / tmpfs 504M 72K 504M 1% / dev/shm/dev/sda1 291M 32M 245M 12% / boot/dev/sr0 3.6G 3.6G 0100% / media/CentOS

II. Software

System: CentOS6.4 32-bit IP:192.168.2.20/24

Oracle version: Oracle 10g R2

10201_database_linux32.zip

Third, pay attention before installation

The graphical interface (X Window System) must be installed when the system is installed, otherwise oracle cannot be installed. It is recommended to use the recommended Xmanager remote management tool. In addition, do not turn on the firewall of SELinux,oracle which is not recommended to use SELinux,CentOS. Please turn it off temporarily to reduce the trouble during installation. In order to prevent garbled code in the process of Oracle installation, it is recommended to use English as the system language to install Oracle.

The system commands described in this article, without special indication, are "#" for root permissions and "$" for oracle permissions.

Fourth, prepare before installing ORACLE

Turn off the firewall and SELinux

# setup

The modification of # vim / etc/selinux/config / / to disabled requires reboot and permanent shutdown. SELINUX=disabled# setenforce 0 / / using this method, selinux can be shut down temporarily without a restart. # getenforce / / View status Permissive

two。 Install dependency packages

Installation packages required by the Oracle official documentation (x86 and x86x64):

Specific inquiry and installation can refer to the following steps, all the required packages should be installed.

# rpm-qa | grep makemake-3.81-20.el6.i686# yum list all | grep ^ makemake.i686 1 virtual 3.81-20.el6 @ anaconda-CentOS-201303020136.i386/6.4makebootfat.i686 1.4-10.el6 c6-media # yum install make- y

Finally, you need to install libXp, the Library, which must be installed, otherwise java Exception will appear when you install Oracle.

# yum install libXp

3. Create oracle groups and users

# groupadd grocl / / create a group grocl and dba# groupadd dba# useradd-m-g grocl-G dba oracle / / create a new oracle user and join the group-m means to create a new home directory for the user oracle-g means to specify a master group-G for the user and to specify a group for the user so that oracle belongs to both the grocl group and the dba group. Usually, it is the grocl group that works # id Oracle / / Test whether the oracle account has been established and completed uid=501 (oracle) gid=501 (grocl) groups=501 (grocl) 502 (dba) # passwd oracle / / set the password for oracle users

4. Add oracle users to the sudo group

# vim / etc/sudoers / / use wq when saving! Or x, read-only document 98 root ALL= (ALL) ALL / / write 99 oracle ALL= (ALL) ALL modeled on line 98 root

5. Configure system kernel parameters

Kernel.shmall = 2097152 / / represents the total amount of shared memory that the system can use at a time (kernel.shmmax = 2147483648 / / defines the maximum size of the shared memory segment in bytes). The default is 32m, which is too low for oracle and is usually set to 2Gkernel.shmmni = 4096 / / to set the maximum number of system-wide shared memory segments. The default value for this parameter is 4096. Usually there is no need to change kernel.sem = 32000 100128 / / semaphore set net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=4194304 / / default receive window size net.core.rmem_max=4194304 / / maximum size of receive window net.core.wmem _ default=262144 / / default Send window size of net.core.wmem_max=262144 / / maximum size of send window

There will be some duplicates with the default parameters of the system, and it is recommended to modify them to those provided on the file.

# vim / etc/sysctl.conf / / modify and add # sysctl-p / / reload net.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1error: " Net.bridge.bridge-nf-call-ip6tables "is an unknown keyerror:" net.bridge.bridge-nf-call-iptables "is an unknown keyerror:" net.bridge.bridge-nf-call-arptables "is an unknown keykernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 4294967295kernel.shmall = 268435456kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 262144

6. Edit / etc/security/limits.conf

# vim / etc/security/limits.conf / / add the following 4 lines oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536

7. Edit / etc/pam.d/login

# vim / etc/pam.d/login / / add these two lines session required / lib/security/pam_limits.sosession required pam_limits.so

8. Modify / etc/profile

# vim / etc/profile / / add the following code if [$USER = "oracle"]; then if [$SHELL = "/ bin/ksh"]; then ulimit-p 16384 ulimit-n 65536 else ulimit-u 16384-n 65536 fifi

9. Modify Linux distribution information

Since CentOS 6 was not released when Oracle 10g was released, Oracle 10g did not confirm support for CentOS 6, so you need to modify the file to make Oracle 10g support CentOS 6. We need to manually modify the release notes of Linux so that Oracle 10g supports CentOS 6.

# vim / etc/redhat-release # CentOS release 6.4 (Final) / / comment out the default version of the system, redhat 4

10. Create an Oracle installation directory and a data storage directory

# mkdir-pv / usr/oracle/datamkdir: created directory `/ usr/oracle' / / Oracle installation directory mkdir: created directory` / usr/oracle/data' / / data storage directory # chown-R oracle.dba / usr/oracle/ change ownership

11. Configure Linux host

Check whether there is a record of localhost in the / etc/hosts file (point to 127.0.0.1). If not, configure it later.

There will be some problems during Oracle monitoring, so that the monitoring cannot be started. You can manually add this record here.

# cat / etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

twelve。 Configure oracle user environment variables

# su-oracle / / switch to the oracle user $pwd/home/oracle $vi .bash _ profile / / add the following configuration ORACLE_BASE=/usr/oracle / / Oracle installation directory created above ORACLE_HOME=$ORACLE_BASE/data / / data storage directory ORACLE_ SID=orclLD_LIBRARY_PATH=$ORACLE_HOME/libPATH=$PATH:$ORACLE_HOME/bin:$HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH$. .bash _ profile / / make the configuration effective

Install Oracle and make related settings

1. Upload and extract the installation file

# unzip 10201_database_linux32.zip# mv database/ / usr/oracle/# chown-R oracle.dba / usr/oracle/# su-oracle $cd / usr/oracle/database/$ lsdoc install response runInstaller stage welcome.html$. / runInstaller / / perform installation

two。 Here is the familiar graphical installation, change the data storage directory, set the password, and then click Next

Similarly, select the group as the dba group and click Next

In this step, click Checking Network Configuration requirements as User Verified, and then click Next

Finally, the Install Summary screen appears. At this time, just click the Install button and the system will begin to install.

The program is being installed.

The program is being installed.

Database setup assistant. You can select password management here to change your password. If you don't need to change it, just click OK.

Before the installation is complete, the following two paragraphs of setup scripts appear

Execute under the terminal:

# sh / usr/oracle/oraInventory/orainstRoot.shChanging permissions of / usr/oracle/oraInventory to 770.Changing groupname of / usr/oracle/oraInventory to dba.The execution of the script is complete# sh / usr/oracle/data/root.shRunning Oracle10 root.sh script...The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / usr/oracle/dataEnter the full pathname of the local bin directory: [/ usr/local/bin]: / / Copying dbhome to / usr/local/bin by default. 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.sh script.Now product-specific root actions will be performed.

After execution, go back to the installation window and press OK to complete all oracle installations. the following screen appears when the installation is complete.

At this point, you can use the following URL as a test. Login account can be sys or system.

ISQL*Plus URL: http://localhost:5560/isqlplusiSQL*Plus DBA URL: http://localhost:5560/isqlplus/dbaEnterprise Manager 10g Database Control URL: http://localhost:1158/em

VI. Testing

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.