Install Oracle10g on Ubuntu server 9.10

After Ubuntu server is installed, you want to install Oracle10g as the database servers of various systems in the future. The whole process was long and tortuous, and it took a whole day.

I. Preparations

1. Download Oracle10g for Linux

2. Create a Samba Server

Because my local computer is Windows XP, the downloaded installation file needs to be shared with Ubuntu, so Samba is installed on javastuserver. For detailed installation and configuration process, see 《Install and configure Samba in Ubuntu"

3. decompress the downloaded Oracle Installation Package and place it in the shared folder of ubuntu (the execution permission must be granted after an oracle user is created in Ubuntu)

Ii. Installation Process

1. Install Dependencies

1) apt-Get install GCC make binutils lesstif2 libc6 libc6-dev RPM libmotif3 libaioLibxtst6 Libstdc ++ 5

Libstdc ++ 5In ubuntu9.10Instead of libstdc ++ 6, you need to establish a connection

Enter the lib directoryCD/usr/lib

View All files starting with libstdc ls libstdc *

Link file ln-s libstdc ++. so.6 libstdc ++. so.5

2) Because ubuntu server does not have a graphical interface, and the graphical interface must be started during Oracle installation, the corresponding graphical interface must be installed.Program

Apt-Get install xserver-Xorg x11-xserver-utils (xhost +)

After the installation is complete, set display export display = machine IP: 0.0

Run startx

Install the x11-apps (xclock), xterm (xterm) to verify that the installation was successful, run xclock, and if a clock appears on the interface, it is successful.

2,CreateCreateOracleUseUser

Sudo addgroup oinstall

Sudo addgroup DBA

Sudo addgroup nobody

Sudo useradd-G oinstall-g dba-P password-D/home/Oracle-S/bin/bash Oracle

Sudo passwd Oracle

Sudo usermod-G nobody

There was a slight misunderstanding During the first installation, that it was necessary to create a user named Oracle and use this user to install it. After actual operations, we found that, any user can install it normally,

The several groups created here are just to better control the permissions of the Oracle owner. We call this oracle user as an "Oracle user ". For example, the DBA group is the management permission, and the oinstall is the installation permission,

If you are learning to use it, you do not need to create a dedicated Oracle user. You only need to add these groups and add the users currently in use to these groups.

 

3. Create a directory and Set permissions

Mkdir-P/opt/Oracle
Mkdir/opt/oradata
Chown-r ORACLE: oinstall/opt/ora *
Chmod-r 775/opt/ora *

CreateOracleThe installation directory, the directory location is not required, but the installationOracleYou need to have ownership and operation permissions on the directory.

4,Configuration SystemUnified EnvironmentEnvironment

 

1) modify the sysctl. conf file

Sudo nano/etc/sysctl. conf

Add the following content at the end of the file:

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

These contents are used to modify Linux kernel parameters.Article.

 

2) modify the limits. conf file

Add the following row to/etc/security/limits. conf:

 

* Soft nproc 2407

* Hard nproc 16384

* Soft nofile 1024

* Hard nofile 65536

Some settings on the Internet are to change * to Oracle. I don't know what it means.

3) make the modification take effect

After modifying the preceding file, you must make it take effect, restart the system, or switch to the root user to change the kernel running parameters in the following way:Sysctl-P

4) Establish a soft connection

Ln-S/usr/bin/awk

Ln-S/usr/bin/RPM

Ln-S/usr/bin/basename

Mkdir/etc/rc. d

Ln-S/etc/rc0.d/etc/rc. d/rc0.d

Ln-S/etc/rc2.d/etc/rc. d/rc2.d

Ln-S/etc/rc3.d/etc/rc. d/rc3.d

Ln-S/etc/rc4.d/etc/rc. d/rc4.d

Ln-S/etc/rc5.d/etc/rc. d/rc5.d

Ln-S/etc/rc6.d/etc/rc. d/rc6.d

Ln-S/etc/init. d/etc/rc. d/init. d

These operations do not know what to do.

 

 

5) create a RedHat version declaration File

Create a/etc/RedHat-release file

Nano/etc/RedHat-release

Write

Red Hat Linux release 4.1

6) Modify environment variables (Oracle user login)

Nano ~ /. Bashrc

Write

Export oracle_base =/opt/Oracle
Export ORACLE_HOME = $ oracle_base/product/10.2.0/db_1
Export oracle_sid = orcl
Export Path = $ path: $ home/bin: $ ORACLE_HOME/bin
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib
Export lc_ctype = en_US.UTF-8

7) configure the installer execution permission (Root User)

The Oracle Installation File directory is/home/smbhome/database.

Chmod A + x home/smbhome/Database

Here, the X execution permission is granted to all other users.

5. Install Oracle (Oracle user login)

CD/home/smbhome/Database

./Runinstaller

Displays the Oracle graphical installation interface for installation.