Oracle
Although the Windows platform Oracle has been installed a few back, but Linux has not tried. Look at the documents on the web, it seems more complex than Windows installed, change system parameters, create User&group, check the necessary software packages, set environment variables, such as a lot of work to do. So take advantage of the weekend in VMware, write down the specific steps for future reference.
OS version: Red Hat Enterprise Linux as Release3 Update2 Kernel 2.4.21-15.el (Install kernel development tools)
Oracle version: Oracle 10.1.0.2 for Linux x86
ORACLE10G's download Address: http://otn.oracle.com/software/products/database/oracle10g/htdocs/linuxsoft.html
Ready to install
Check disk space
Oracle Universal Installer approx. 400M/TMP space required
# DF-K/tmp
If the current/TMP space is not sufficient, you can create a new temporary directory on the filesystem of other space
# mkdir/<anotherfilesystem>/tmp
# chown Root.root/<anotherfilesystem>/tmp
# chmod 1777/<anotherfilesystem>/tmp
# Export Temp=/<anotherfilesystem>
# Export Tmpdir=/<anotherfilesystem>
Install Oracle and return to its original state
# rmdir/<anotherfilesystem>/tmp
# unset TEMP
# unset Tmpdir
Oracle needs approximately 3G of space (default installation and includes initial library), please plan well beforehand
Check memory and Swap areas
View physical Memory Size
# grep Memtotal/proc/meminfo
Viewing the Swap area size
# grep Swaptotal/proc/meminfo
Installing Oracle requires a large enough memory and swap area, so it's best to find a better machine. Oracle recommended the best memory 512M above, swap 1G above. If just install a play, actually not so much also does not matter, my virtual machine is only divided into 384M of memory and 768M of swap.
Check Package
Using directives
# Rpm–qa | grep packname \ Where Packname is the name of the package that needs to be checked
Ensure that the following packages (or later) are installed. If you don't, you can find it in Redhat's installation tray.
Gcc-3.2.3-34
Make-3.79.1-17
Binutils-2.14.90.0.4-35
Openmotif-2.2.2-16
Setarch-1.3-1
compat-db-4.0.14.5
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.96.128
Install the RPM package
# RPM-UVH Packname
Add Group and User
#/usr/sbin/groupadd Oinstall
#/usr/sbin/groupadd DBA
Establish an Oracle user whose default group is Oinstall and also a member of the DBA Group
#/USR/SBIN/USERADD-G OINSTALL-G dba Oracle
Modify the Oracle user's password
# passwd Oracle
You can check it after you've built it.
# ID Oracle
uid=500 (Oracle) gid=500 (oinstall) groups=500 (Oinstall), 501 (DBA)
modifying system core Parameters
Edit sysctl.conf
# vi/etc/sysctl.conf
Add the following content
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
After you save the exit, execute the following command to take effect (of course, restart is also possible ^-^)
# sysctl–p
Check to see if the above operation is correct:
#/sbin/sysctl-a | grep sem
#/sbin/sysctl-a | grep SHM
#/sbin/sysctl-a | grep File-max
#/sbin/sysctl-a | grep ip_local_port_range
These parameters can also be directly changed/proc/sys/kernel under the corresponding file to implement, please refer to the details
Http://download-west.oracle.com/docs/html/A96167_01/pre.htm#CHDHDABJ
In the case of a production library, for performance reasons, the following settings are also required to improve the Oracle user's nofile (maximum number of file descriptors to open) and Nproc (the maximum number of processes available to individual users). If you are only testing the installation, you may not need to modify it.
# vi/etc/security/limits.conf
Add the following line
* Soft Nproc 2047
* Hard Nproc 16384
* Soft Nofile 1024
* Hard Nofile 65536
# Vi/etc/pam.d/login
Add the following line
Session required/lib/security/pam_limits.so
# Vi/etc/profile
Add the following sections:
if [$USER = "Oracle"]; Then
if [$SHELL = "/bin/ksh"]; Then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi
After that, verify
# su Oracle
$ ulimit-a
Setting environment variables
# su Oracle
$ cd ~
$ vi. Bach_profile
Add the following content
Export Oracle_base=/opt/oracle
Export Oracle_home= $ORACLE _base/product/10.1.0/
Export ORACLE_SID=DB01
Export path= $PATH: $HOME/bin: $ORACLE _home/bin
Export Ld_library_path= $ORACLE _home/lib:/usr/lib
Export Lc_ctype=en_us. UTF-8
In which/opt/oracle please build and give the appropriate permissions, a simple one can set its owner to Oracle (Chown–r oracle.oinstall/opt/oracle), as an Oracle installation directory (you can plan their own )
Confirm and modify the entry into force
$ source. bash_profile
Start installation
Since I was installed with a virtual machine, I copy the oracle10g (ship.db.cpio.gz) from the Internet to the hard drive, the directory is/tmp, first for CRC verification, so as not to download Oracle has problems.
# cksum Ship.db.cpio.gz
Decompression
# gzip–d Ship.db.cpio.gz
Solution Package Ship.db.cpio
# CPIO-IDMV < Ship.db.cpio
Get the installation directory/tmp/disk1, if you have a burner, you can engrave the catalogue on the disc. Here I install from the hard drive.
# su Oracle
$ cd/tmp/disk1
$./runinstaller
If you receive the following error
Xlib:connection to "localhost:0.0" refused by server
Xlib:client is isn't authorized to connect to server
Exception in thread "main" Java.lang.InternalError:can ' t connect to X11 Window server using ' localhost:0.0 '
At .....
Workaround:
# Xhost +
Access control disabled,clients can connect to any host.
\\xhost + is to enable all users from any one terminal can access Xserver (after the setup may have security risks);
# Xhost + yourip
Yourip being added to acces control list
\\xhost + Yourip enables users on IP to access xserver
Smooth, should appear welcome picture, point "Next" continue.
Specify the Inventory directory and the group to use when installing, using the default value, click Next
A window pops up that lets you open another terminal and executes the following command as root:
#/home/oracle/orainventory/orainstroot.sh
Point "Continue" continues after execution
Next, modify the installation file path and modify the "next" button as you actually need it.
Choose to install the type, here I choose "Enterprise Edition" Install Enterprise Edition, "Next" continue next.
This will automatically check if your system meets the installation requirements (you can click "Stop") and the results are as follows:
Hecking Operating System Certification
Expected Result:one of redhat-2.1,redhat-3,unitedlinux-1.0
Actual result:redhat-3
Check complete. The overall result of this check is:passed
=======================================================================
Checking Kernel Parameters
Checking for version=2.4.9.25; Found version=2.4.21. Passed
Checking for shmall=2097152; Found shmall=2097152. Passed
Checking for shmseg=10; Found shmseg=4096. Passed
Checking for semmsl=250; Found semmsl=250. Passed
Checking for semmni=128; Found semmni=128. Passed
Checking for filemax=65536; Found filemax=39321. Passed
Checking for shmmni=4096; Found shmmni=4096. Passed
Checking for semmns=32000; Found semmns=32000. Passed
Checking for semopm=100; Found semopm=32. Passed
Checking for Shmmin=1; Found Shmmin=1. Passed
Checking for shmmax=2147483648; Found shmmax=33554432. Passed
Check complete. The overall result of this check is:passed
=======================================================================
Checking Recommended Operating System packages
Checking for make-3.79; Found MAKE-3.79.1-17. Passed
Checking for binutils-2.11.90.0.8-12; Found binutils-2.14.90.0.4-35. Passed
Checking for gcc-2.96; Found gcc-3.2.3-34. Passed
Checking for openmotif-2.1.30-11; Found openmotif-2.2.2-16. Passed
Check complete. The overall result of this check is:passed
=======================================================================
Checking Recommended GLIBC version
Expected result:2.2.4.31.7
Actual result:2.3.2.95.20
Check complete. The overall result of this check is:passed
=======================================================================
Validating oracle_base location (if set)
Check complete. The overall result of this check is:passed
=======================================================================
If all passed, continue to the next step. Otherwise, make the appropriate modifications to the prepared installation section, and then "retry" again until passed to the next step.
Next choose the type of library, here I do not build a library, to be installed after the use of DBCA to build a library or manually build a library (how to use DBCA to build a library, please go to http://www.google.com search the corresponding article). So select "Do not create a starter database" after "Next".
Appear "Summary" screen, confirm and press "Install".
Finally, a dialog box pops up asking to execute $oracle_home/root.sh as root
# $ORACLE _home/root.sh
Friendly Tips
If an error occurs during installation, use Google to search for the appropriate solution.
Reference articles
Fenng installing Oracle 10g on RHEL as 3 step-by-step
Http://www.dbanotes.net/Oracle/Install-Oracle10g-RHEL3.htm
Werner Puschitz's 10g Installation Guide
Http://www.puschitz.com/InstallingOracle10g.shtml
Oracle Database Quick Installation Guide G Release 1 (10.1) for Linux x86
Http://download-west.oracle.com/docs/html/B10813_01/toc.htm
