After installing Oracle 10g on Linux

Introduction

Recently I want to study LoadRunner to test Oracle performance, and then I started to try to install Oracle on Linux. I felt that this was not easy. I heard a friend say that he had to pay a lot of twists and turns during the installation and re-installed it many times. I asked a lot of people to solve it, however, after installation, it is easy. Now I want to share my experience with you. I am also a Linux cainiao.

Material Source: detailed image description of Oracle 10g database installation under Fedora8

Note: The red letter indicates my installation experience.

Environment Introduction

VMWare7.1, Fedora 8 (a relatively old version under Rad hat), Oracle 10g

 

Installation preparation

Download 10201_database_linux_x86_64.cpio.gz on Windows.

Then decompress the package into A. cpio file using WINRAR. I downloaded the package to LINUX on the virtual machine through a WEB link. For N other methods, find a method you are familiar.

Installation Process

1. Extract

Cpio-idmv <(this is similar to WINRAR, It is very troublesome to decompress twice)

 

2. Set kernel parameters:

(1) Add the following to the/etc/sysctl. conf file: (for beginners, you can perform interface operations. If you are familiar with it, you can use the vi editor etc .)
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
# Semaphores: semmsl, semmns, semopm, semmni
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 (2) run the following command to change the parameters of the current kernel:
/Sbin/sysctl-p

 

3. Add the following content to the/etc/security/limits. conf file.
* Soft nproc 2047
* Hard nproc 16384
* Soft nofile 1024
* Hard nofile 65536

 

4. Add the following content to the/etc/pam. d/login file.
Session required/lib/security/pam_limits.so

 

5. Add the following content to the/etc/selinux/config file. If this setting already exists, change the value.
SELINUX = disabled

 

6. Use the following command to check required packages
Rpm-q package name
The required packages include:
Binutils-2. * elfutils-libelf-0. * glibc-2. * glibc-common-2. * libgcc-4 .*
Libstdc ++-4. * make-3. * elfutils-libelf-devel-0. * glibc-devel-2. * gcc-4 .*
Gcc-c ++-4. * libstdc ++-devel-4. * unixODBC-2 .*
Use the following command to install
Yum install package name
(Note: The package name can be written in the above format)

 

7. Create users and groups
Groupadd oinstall
Groupadd dba
Groupadd rule

Useradd-g oinstall-G dba oracle
Usermod-G oinstall oracle
Passwd oracle

 

8. Create a directory
Mkdir-p/usr/app/oracle/product/10.2.0/db_1
Chown-R oracle. oinstall/usr/app

 

9. Modify the/etc/redhat-release file

Content: redhat-4

 

10. Add the following content to the/etc/profile file:
# Oracle Settings
TMP =/tmp; export TMP
TMPDIR = $ TMP; export TMPDIR
ORACLE_BASE =/usr/app/oracle; export ORACLE_BASE
ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID = TSH1; export ORACLE_SID
ORACLE_TERM = xterm; export ORACLE_TERM
PATH =/usr/sbin: $ PATH; export PATH
PATH = $ ORACLE_HOME/bin: $ PATH; export PATH
LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH = $ ORACLE_HOME/jre: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib; export CLASSPATH
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi
Restart the computer after setting

 

11. Log On As A root user and run the following command:
Xhost +

 

12. Switch to an oracle user
Su oracle

Run: export DISPLAY =: 0.0

 

13. Go to the oracle Installation File directory
Run:./runInstaller
Note: You must execute the cd command in the decompressed directory of the current Oracle database (the same as DOS). Remember to execute the command under the oracle account; otherwise, an error will be thrown.

 

14. After installation starts, if the following exceptions occur:
(1) Exception java. lang. unsatisfiedLinkError:/tmp/OraInstall2005-09-07_01-21-03AM/jre/1.4.2/lib/i386/libawt. so: libXp. so.6: cannot open shared object file: No such file or directory occurred
Solution: Run rpm-p--whatprovides libXp. so.6 to print the installation package on which this file depends, and run yum install [Printed file name].

Note: errors reported here may vary depending on the update of some packages. The most convenient method is to directly use the yum command for packages with incorrect installation packages. Some virtual machines do not support the yum command, you can install it on your own. There are many tutorials on the Internet.

(2) after entering the graphical installation interface and verifying the installation conditions, if an error occurs, please enter the log file as prompted.
If the following error occurs: xcb_xlib.c: 50: xcb_xlib_unlock: Assertion 'C-> xlib. lock failed.
Solution:
A. Log On As the root user and execute the following content:
Yum -- enablerepo = development update libxcb

Note: Some situations are not the same here. If the command is not updated successfully, the system always reports that a resource error cannot be found. Then, use yum update libxcb to continue running without any errors.

B. Return to the oracle user and execute the following content:
Export LIBXCB_ALLOW_SLOPPY_LOCK = 1

 

15. Enter the page for Installation

 

(1) select Advanced Installation

 

(2) next step

 

 

(3) Select Enterprise Edition

 

 

(4) next step

 

 

(5) Check your installation conditions. The installation conditions must all pass. Otherwise, the installation will fail.

 

Note:

(1) first, some problems may occur here. While Checking operating system package requirements (that is, verifying the integrity of the operating system package) has installed all the packages according to the 6th procedures, however, in some special cases, some packages may be missing. If an Error or Warning occurs, you must check the following logs. The packages are Fail. You can directly install them using the yum command.

(2) there is an option to verify network settings. You can open the/etc/hosts file in the vi editor and change 120.0.1 to a fixed IP address.

(3) there may be some special situations. This is related to your Linux version and the updated package. If not, you can update the latest version, you can still Delete the corresponding error package and install the specified version.

 

(6)

 

 

(7)

 

 

(8)

 

 

(9)

 

 

(10)

 

 

(11)

 

 

(12)

 

 

(13)

 

 

(14)

 

Note: Remember to check the log after an error is reported. You can see the cause of the error. I encountered a problem in Link pending... if an exception is thrown during the process, I find the corresponding log and cannot find a log called/urs/lib/libstdc ++. so.5, and only one file in the folder is called libstdc ++. so.6 files, obviously higher than Orecla 10g, but Orecla 10G does not recognize this package. I used the ln command to solve this problem. Command: ln-s-f libstdc ++. so.6 libstdc ++. so.5. If the package is missing, you can directly use the yum or rpm command to install the package.

 

(15)

 

 

(16)

 

 

(17)

 

 

(18)

 

 

(19)

 

 

16 try Oracle

The command is as follows:

> Sqlplus

> UserName: sysman

> PassWord: ***** (passWord entered in step 1)

SQL> select * from dba_tables where ROMNUM <= 10 (find all the table information under the current number)

 

Summary

During the installation process, you may encounter various problems and write a lot on the Internet, but it may not be your current problem, don't worry, you only need to follow the Oracle Install Guides operation. Other problems are basically caused by the need to update the package and Install similar problems. If you encounter a special problem, you only need to go online to query the problem and find the solution.