1. added the oinstall user group and dba user group, added Oracle users, and added them to these two user groups. The default group is the dba user group;
2. Set oracle user environment variables
Command:
Vi ~ /. Profile (". "indicates hidden files, h-right, j-down, k-up, l-left, o-insert,: w-save,: q-exit, i-insert in the current row, x-delete, u-Undo, esc-return to normal mode, dd-delete) (If the configuration fails, a series of problems may occur after the installation)
Added content:
Export ORACLE_BASE =/home/oracle
Export ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/db_6
Export ORACLE_SID = orcl
Export PATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib
Export NLS_LANG = "SIMPLFILED CHINESE_CHINA.ZHS16GBK"
Export NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
After that, press the Esc key several times, Shift + ":", "w", save successfully, press the Esc key several times, Shift + ":", "q ", exited successfully.
(VI Basic command :)
3. added the core parameters:
Vi/etc/sysctl. conf (run by the root user, su root)
Added content:
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Fs. file-max = 6553600
Net. ipv4.ip _ local_port_range = 1024 65000
Net. core. rmem_default = 4194304
Net. core. wmem_default = 262144
Net. core. wmem_max = 262144
Run the command to confirm:
Sysctl-p (Role: Make the/ect/sysctl. conf change take effect immediately)
Chkconfig boot. sysctl on)
# Vi/etc/security/limits. conf
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
# Vi/etc/pam. d/login
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65535
Fi
Fi
4. Start to check the required RPM package. According to the requirements in the official documents, the rpm packages required by SUSE include:
SUSE Linux Enterprise
Server 11
The following packages (or later versions) must be installed:
Binutils-2.19
Gcc-4.3
Gcc-c ++-4.3
Glibc-2.9
Glibc-devel-2.9
Ksh-93t
Libstdc ++ 33-3.3.3
Libstdc ++ 43-4.3.3_20081022
Libstdc ++ 43-devel-4.3.3_20081022
Libaio-0.3.104
Libaio-devel-0.3.104
Libgcc43-4.3.3_20081022
Libstdc +-devel-4.3
Make-3.81
Sysstat-8.1.5
On SUSE 11:
UnixODBC-32bit-2.2.12 (32-bit) or later
UnixODBC-devel-32bit-2.2.12 (32 bits) or later
Based on past experience, the rpm package must be complete.
In suse, you can take advantage of the following features: computer-install software
· If gcc is missing, search for gcc directly and check the required gcc and gcc ++. Click "accept" to install it automatically. You need to insert a CD during this period.
· Each software can use this step, knowing that all the missing packages have been installed. Run the search command again to find that all packages have been installed.
5. Run./runInstaller in the installation directory of oracle10g. A graphical interface (for oracle users) is displayed );
6. During the installation process, the version may be inconsistent or the software package is missing. Do not use cancel or ignore. You can run the zypper install... command to install the required software package and retry it;
"Ntcontab. o missing": Run zypper install gcc-c ++ as the root user (remember to insert the disc)
"All_no_orcl ihsodbc missing": Run zypper install libstdc ++ 33 as the root user (remember to insert the disc)
At the end of installation, two lines of script will be executed. If you encounter: Enter the full pathname of the local bin directory: [/usr/local/bin]: During execution, press Enter to pass;