Install the Oracle Database 10 Gb in a 64-bit Linux environment

After several days of unremitting efforts, LINUX has been reinstalled three times, and ORACLE has finally installed ORACLE10g R 2 (64-bit) in LiNUXAS4 update6 x86_64.

I will share with you the installation process below, so that more people will spend a lot of time on inexplicable problems like me.

First of all, it should be noted that there are also relevant official documents for installation, but some problems need to be solved in the actual process.

This document is based on relevant instructions. It aims to explain the problem based on the specific environment, but the reason for the level may not be explained. You are welcome to give your comments. Step 1 install rh linux AS4 graphical installation, relatively simple, to install ORACLE note. the SWAP partition should be large enough, preferably 2 GB or above B. install the included package on your own. It is best to hook the development kit with Step 2 to check the version and the required toolkit.

Uname-r

// Kernel version rpm-q gcc make binutils openmotif glibc

// Basic software package, rpm-q gcc make binutils openmotif setarch compat-db compat-gcc openmotif compat-gcc-c ++ compat-libstdc ++-devel is required

// The relevant documents indicate that these software packages need to be checked, but some of them do not exist. It turns out that they are indeed not required.

/*************************************** ***

// The release notes of rhel as 4 mentioned that these software packages have been deleted:

// Compat-gcc-c ++ // compat-glibc // compat-libstdc ++-devel

// They no longer need to be installed.

**************************************** * ***/Grep MemTotal/proc/meminfo

// Check the memory

Grep SwapTotal/proc/meminfo // check the swap Partition

Df-h // view hard disk status step 3 configure Linux3.1 for Oracle to add users and groups and create directories

// This process is generally normal groupadd osintall

// Add group groupadd dba

// Add group useradd-m-g oinstall-G dba oracle

// Add User ID oracle

// Verify passwd oracle

// Set the password mkdir-p/u01/app/oracle

// Main directory mkdir-p/u02/oradata

// Database file directory chown-R oracle: osintall/u01/app/oracle // u02/oradata/

// Directory relationship

Chmod-R 755/u01/app/oracle // u02/oradata/

// Read/write permission setting 3.2 configure Linux kernel parameters according to official instructions, the following parameters should be configured: Kernel Parameter vi/etc/sysctl. conf

// Add 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

Net. core. rmem_default = 262144

Net. core. rmem_max = 262144

Net. core. wmem_default = 262144

Net. core. wmem_max = 262144 // then restart or execute the following command to make the parameter take effect/sbin/sysctl-p3.3 to set the environment variable

// Log on to vi. bash_profile as an oracle user // Add export ORACLE_BASE =/u01/app/oracle

Export ORACLE_HOME = $ ORACLE_BASE/product/102

Export ORACLE_SID = BETAPATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin

// Modify 3.4 to set Shell restrictions for the user/etc/security/limits. conf // Add oracle soft nproc 2047

Hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536 // login verification/etc/pam. d/login // Add session required pam_limits.so

// After this is added, the system cannot log on to the local machine. If the user name is entered correctly, it requires you to enter it again. If the user name is entered correctly, the system will encounter an error. The strange thing is that the system can log on remotely, therefore, the parameter // oracle USER default script/etc/profile // was not modified later to add if [$ USER = "oracle"]; then

If [$ SHELL = "/bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi // now the environment configuration is complete Step 4 install Oralcegunzip 10201_database_linux_x86_64.cpio.gz // decompress cpio-idmv <10201_database_linux_x86_64.cpio // release the file // in graphical mode. /runInstaller // install the database software as needed // when the installation program checks the system, it is recommended that you do not forcibly install the software if you encounter an error or warning. At last, I ignore the warning of one network configuration check and the installation is successful. // Error in invoking target all_no_orcl of makefile/opt/oracle/10.2.0/db_1/rdbms/lib/ins_rdbms.mk may occur during linking installation, is a problem with a U2 package, need upgrade package binutils-2.15.92.0.2-15.0.0.0.2.x86_64.rpm, can be downloaded. After the database system is installed, we can create a database // open the terminal dbca

// Environment variables can be set directly with this command, otherwise enter the corresponding directory // select the appropriate options, install the database // in the process of creating the database, if the error ORA-12547: TNS: lost contact, probably because the package libaio-0.3.103-3.x86_64.rpm is missing, can be found in 4th installation disks. Of course, this error may also be caused by Kernel Parameter errors or System Busy. :) after starting to control the database, lsnrctl startisqlplusctl startemctl start dbconsole can be used to check the database running status through the relevant web pages and programs. After installation, ORACLE will not be started by itself next time, so you need to set your own startup. we can

1. Set/etc/oratab to enable the specified instance automatically. Modify the oratab file su-root as the root user.

Vi/etc/oratab // change the last N to Y

2. Simple Service Startup Script: Set/etc/rc. local $ vi/etc/rc. local

Add the following content:

Su-oracle-c lsnrctl start // start the listener

Su-oracle-c dbstart // start the database