Go---CentOS Installation Oracle database detailed introduction and FAQ summary

First, pre-installation preparation

1. Software Hardware Requirements

Operating system: CentOS 6.4 (32bit)
Oracle Database version: Oracle 10g (10201_database_linux32.zip)
Minimum Memory: 1G (check command: #grep memtotal/proc/meminfo)
Minimum swap:2g (check command: #grep swaptotal/proc/meminfo)

2. Installing dependent Packages

# rpm-q binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf-devel gcc gcc-c++ glibc glibc.i686 glibc-c Ommon glibc-devel glibc-devel.i686 glibc-headers ksh libaio libaio.i686 libaio-devel libaio-devel.i686 LIBGCC libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel make Sysstat

If the not installed key is not present, all of the form's dependent packages are installed, otherwise the missing dependency package needs to be installed.

Install the missing dependency package via Yum with the following command:

# yum-y Install Elfutils-libelf-devel libaio-devel libaio-devel.i686

Finally, you need to make sure that LIBXP is installed, otherwise exception will appear when you install Oracle Java.lang.UnsatisfiedLinkError

# Yum y install Libxp

3. Create Oracle Users and Groups

New Oinstall and DBA user groups

# Groupadd oinstall# Groupadd dba

Create a new Oracle user and join it to the Oinstall and DBA groups

# useradd-m-G oinstall-g dba Oracle

Test if Oracle account is established

# ID Oracle

Create an Oracle user password

# passwd Oracle

4. Modify the/etc/sysctl.conf file

# vi/etc/sysctl.conf, press the letter I into edit mode

# controls the maximum shared segment size, in Byteskernel.shmmax = 2147483648# Controls The maximum number of shared memo  Ry segments, in pageskernel.shmall = 2097152kernel.shmmni = 4096kernel.sem = 32000 (128net.ipv4.ip_local_port_range) = 1024x768 65000net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 262144

After editing, press ESC to enter command mode, then enter: Wq Save exit
Execute: # sysctl–p, enable modify

5. Modify the/etc/security/limits.conf file

# vi/etc/security/limits.conf, add the following:

Oracle  Soft        nproc   2047oracle  hard        nproc   16384oracle  soft        nofile  1024oracle  hard        nofile  65536

6. Modify the/etc/pam.d/login file

# Vi/etc/pam.d/login, add the following:

Session Required/lib/security/pam_limits.sosession Required Pam_limits.so

7. Modify the/etc/profile file

# Vi/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

8. Create an Oracle installation folder and a data storage folder

#mkdir/opt/oracle#mkdir/opt/oracle/102#chown-r oracle:dba/opt/oracle

9. Configure Oracle User Environment variables

Using the Oracle User login, $/home/oracle/vi. Bash_profile, modify and add the following:

Oracle_base=/opt/oracle                      oracle_home= $ORACLE _base/102oracle_sid=orclld_library_path= $ORACLE _home/libpath=$ Path: $ORACLE _home/bin: $HOME/binexport oracle_base oracle_home oracle_sid ld_library_path Path

After saving, use the following command to make the changes take effect

$ source/home/oracle/.bash_profile

Ii. Start installation of Oracle database

1. Unzip the installation file

Using an Oracle user login, copy the downloaded database installation files to/opt/oracle and go to the Oracle folder: $ cd/opt/oracle
Run the extract command: $ unzip 10201_database_linux32.zip

2. Run the Setup program

After the decompression is complete, the database folder is created in the Oracle folder, and the CD database enters the folder and runs./runinstaller-ignoresysprereqs Start Installation
Because CentOS6.4 has not been released at the time of oracle10g release, the Oracle installer will fail when the system version check is performed, the installation will automatically terminate, the system version check can be ignored using the IGNORESYSPREREQS parameter option

Start the Setup program

Click Next directly to proceed to the next step

Since the installation path was previously configured, just select the DBA group, click the drop-down box to select DBA, then click Next to go to the next step

Select the enterprise or standard version according to your actual needs, then click Next to go to the next step

The path here should automatically load the previously configured paths, if the path is not correct, it is possible that the previous configuration/home/oracle/.bash_profile file is incorrect, direct next

Click to select Checking Network Configuration requirements for user verified, click Next

Default create a database, direct next

Default general transaction, direct next

Since the global SID=ORCL has been configured in the previous, so there is no change here, choose the appropriate database encoding as needed, please choose carefully here, if you choose the wrong change is very troublesome

Select database management options, default, direct next

Database storage using default file system, direct next

Do not enable automatic backup, direct next

Set Sys,system and other accounts to share the same password, and enter the database management password, then click Next

Complete the installation customizations, click Install to start the database installation

Wait for installation to complete ...

Before the installation is complete, prompt to use the system root user to execute the displayed script, open a new terminal, log in with the root account, execute both scripts in sequence

After execution, go back to the Oracle installation interface, click OK to complete all the installation actions, pop up the installation Success prompt screen, click Exit to exit the Setup program.

Iii. Summary of Installation FAQs

1. "Exception Java.lang.unsatisfiedlinkerror:......libxp.so.6:cannot Open Shared Object File" appears during installation

Solution: Use the command: # rpm–q LIBXP to view the installed package version, because using the Yum installation defaults to installing the latest version instead of libxp-1.0.0-15.1.el6.i686.rpm

Use the # yum remove libxp-1.0.2-2.1.el6.i686.rpm, then download the libxp-1.0.0-15.1.el6.i686.rpm version and go to the folder where the file is located, by command:
RPM-IVH libxp-1.0.0-15.1.el6.i686.rpm Install the correct version to resolve the issue.

2.Oracle Installation Interface garbled display

This is generally due to the fact that CentOS is using Chinese as the result of executing the following command before performing the./runinstaller-ignoresysprereqs.

$ export Nls_lang=american_america. utf8$ Export Lc_all=c

3.putty+xming Implementing a remote Linux installation Oracle database

Because the server is generally placed in the computer room, so the software installation operation is generally by remote to operate, when we use Putty remote connection to the Linux server, the default is SSH connection, does not have X Window function, unable to open the Oracle graphical installation interface, So you need to configure the Xming tool to turn on the graphical interface function.
Download the Xming tool, use the default installation directly, and then locate Xming->xlaunch startup Xming in the Start menu

Generally do not need to modify, according to the default configuration, directly click Next

Leave the default selection and continue to the next step

Continue to click Next

Do not need to make a task modification, directly click Finish, the Windows tray will appear xming icon, indicating that X window has started to run
Run the Putty tool, enter the IP address of the Linux host you want to connect to, use SSH by default, then expand Connection->ssh->x11, tick enable X11 forwarding,
X Display location field input localhost:0, click Open to open remote connection

Log in to the Oracle user and run Runinstaller to successfully open the graphical installation interface.

This article is based on the following blog post and successful attempts to summarize
Installing Oracle 10g R2 under CentOS 6.3 (X86_32)
Installing the oracle10g under CentOS
Putty + Xming for Oracle Graphics installation

Go---CentOS Installation Oracle database detailed introduction and FAQ summary