Reference: ORACLE 10G official documentation
Reference: A Bone theory version 2012 Oracle free Video Tutorial
First, install Linux
1, note partition: Memory is less than 4G, then swap partition = memory, memory is greater than 4G, swap partition = memory size;
2, TMP directory is greater than 10G;
3. root directory >25G;
4, the development of the toolkit all selected;
5. After the installation is complete, install one more Sysstat package.
II. Installation of Oracle
1, check the following prerequisite package installation: (command is Rpm-qa|grep XXX)
Binutils-2.15.92.0.2-10.el4
Compat-db-4.1.25-9
Control-center-2.8.0-12
Gcc-3.4.3-9.el4
Gcc-c++-3.4.3-9.el4
Glibc-2.3.4-2
Glibc-common-2.3.4-2
gnome-libs-1.4.1.2.90-44.1
Libstdc++-3.4.3-9.el4
Libstdc++-devel-3.4.3-9.el4
Make-3.80-5
Pdksh-5.2.14-30
Sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
Libaio-0.3.105-2.x86_64
Libaio-devel-0.3.105-2.x86_64
2. Modify the IP address and Hosts file
3. New groups and users
Groupadd Oinstall
Groupadd dba
USERADD-G oinstall-g dba Oracle
4, adjust the Linux kernel parameters: vi/etc/sysctl.conf Add the following:
Kernel.shmall = 2097152
Kernel.shmmax = 2147483648
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Fs.file-max = 65536
Net.ipv4.ip_local_port_range = 1024 65000
Net.core.rmem_default = 262144
Net.core.rmem_max = 262144
Net.core.wmem_default = 262144
Net.core.wmem_max = 262144
5, edit the/etc/security/limits.conf, add the following content:
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536
6, edit the/etc/pam.d/login, add the following content:
Session Required Pam_limits.so
7, edit the/etc/profile, add the following content:
if [$USER = "Oracle"]; Then
if [$SHELL = "/bin/ksh"]; Then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi
8, create the directory and change the owner, the group, set permissions, and so on:
Mkdir/u01/app/oracle-p
Chown-r oracle:oinstall/u01
chmod 755/u01
9, set the Oracle User environment variable, first switch to Oracle user, then VI bash_profile, add at the end
Export Oracle_base=/u01/app/oracle
Export Oracle_home=/u01/app/oracle/product/10.2.0/db_1
Export Oracle_sid=jiagulun
Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
10. Upload the Oracle installation file to the/oraapp directory (if not, create it yourself), unzip, install
Upload command RZ
Unzip Command Zcat 10201_database_linux_x86_64.cpio.gz | Cpio-idmv
11, using Xmanager remote connection linux,root user login, open terminal, switch to Oracle user, and then perform the installation
cd/oraapp/database/
./runinstaller performing the installation
12, the installation, select Custom, select the Isql*plus components, choose to install only data software
13, the installation is complete, before clicking OK, execute two scripts first
Su-oracle
Su
cd/u01/app/oracle/orainventory/
./orainstroot.sh
cd/u01/app/oracle/product/10.2.0/db_1/
./root.sh
14. Click OK to complete the installation
15. More/u01/app/oracle/product/10.2.0/db_1/install/portlist.ini View Isql*plus Port number
16. Set the Oracle user environment variable, vi bash_profile, add at the end
Export path= $PATH: $ORACLE _home/bin:.
17. Use DBCA (Database Configuration Assistant) to configure the database
Install Oracle 10g under Red Hat Enterprise Linux 4 (64-bit)