Install oracle10g in redhat5

 

Installation Process

1. hardware resources:

Brief description: The system memory should be larger than 1 GB, And the swap space should be at least GB, which is twice the physical memory, and the temporary space should be larger than MB. (The temporary space directory in linux is/tmp)

 

2. the rpm package required for Oracle installation:

Run the rpm command to view and install the required rpm package.

# Rpm-qa make

Make-3.81-3.el5

# Rpm-qa binutils

Binutils-2.17.50.0.6-12.el5

# Rpm-qa openmotif

Openmotif-2.3.1-2.el5

# Rpm-qa setarch

Setarch-2.0-1.1

# Rpm-qa | gerp compat

Compat-libgcc-296-2.96-138

Compat-glibc-headers-2.3.4-2.26

Compat-libstdc ++-296-2.96-138

Java-1.4.2-gcj-compat-src-1.4.2.0-40jpp.115

Java-1.4.2-gcj-compat-devel-1.4.2.0-40jpp.115

Avahi-compat-libdns_sd-0.6.16-6.el5

Compat-libf2c-34-3.4.6-4

Compat-glibc-2.3.4-2.26

Compat-gcc-34-3.4.6-4

Compat-gcc-34-c + +-3.4.6-4

Java-1.4.2-gcj-compat-1.4.2.0-40jpp.115

Compat-libstdc ++-33-3.2.3-61

Compat-gcc-34-g77-3.4.6-4

Compat-libcom_err-1.0-7

Compat-db-4.2.52-5.1

# Rpm-qa libaio

Libaio-0.3.106-3.2

 

3. Modify Linux kernel parameters to support oracle:

# Less/etc/sysctl. conf

Kernel. shmmax = 536870912

Kernel. shmmni = 4096

Kernel. shmall = 2097152

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

 

Add the preceding content to the Kernel configuration file. After modification, use # sysctl-p to make the modified configuration take effect.

 

4. added the nofile and nproc parameters for operating system users:

# Less/etc/security/limits. conf

Oracle soft nofile 65536

Oracle hard nofile 65536

Oracle soft nproc 16384

Hard nproc 16384

 

Add the above content at the end of the configuration file

Nofile: the maximum number of files that can be opened by operating system users at the same time.

Nproc: Number of processes simultaneously opened by a single user

 

5. Create oracle users and user groups:

# Groupadd oinstall

# Groupadd dba

# Useradd-g oinstall-G dba oracle

# Passwd oracle (enter the password under the prompt, two confirmations are required)

 

6. Set oracle user environment variables:

# Less. bashrc (first use cd to the oracle user's home directory)

Export ORACLE_BASE =/u01/app/oracle

Export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1

Export PATH = $ ORACLE_HOME/bin: $ PATH

Export ORACLE_OWNER = oracle

Export ORACLE_SID = orc1

Export ORACLE_TERM = vt100

Export THREADS_FLAG = native

Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ LD_LIBRARY_PATH

Export PATH = $ ORACLE_HOME/bin: $ PATH

 

Add the preceding environment variables to the file.

 

7. create the required program directory and Set permissions:

# Mkdir-p/u01/app/oracle

# Chown-R oracle: oinstall/u01

 

The directory can be determined based on the actual situation. This is the default installation directory of oracle.

 

8. In the linux GUI, open a terminal window:

# Export DISPLAY =: 0.0

# Xhost +

 

Run as root

 

9. Officially install oracle

# Su-oracle (switch to oracle user)

# Unzip 10201_database_linux32.zip-d/tmp/oracle (decompress the oracle Installation Package)

# Cd database (directory for decompressing cd to oracle package)

 

Before installing oracle, modify the oracle program file (redhat5 is not supported by oracle by default). Run the following command:

# Vim./database/install/oraparam. ini

Linux-redhat-5.0-optional

TEMP_SPACE = 80

SWAP_SPACE = 150

MIN_DISPLAY_COLORS = 256

In the oraparam. ini file, locate "[Certified Versions]" and add the following red font

 

[Certified Versions]

Linux = redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1, asianux-2

 

Linux-redhat-5.0-optional

TEMP_SPACE = 80

SWAP_SPACE = 150

MIN_DISPLAY_COLORS = 256

 

UnitedLinux-1.0-optional

TEMP_SPACE = 80

SWAP_SPACE = 150

MIN_DISPLAY_COLORS = 256

 

Then you can run the installation script to install oracle. Go to the database directory and find the runInstaller script and execute

 

#./RunInstaller (execute the installation script)

 

After the script is executed, it will go to the oracle graph installation, and the sub-step is next.

The first step will prompt you to set the oracle password,

 

Enter and confirm the password in the database password

 

 

In these two steps, the configuration of each item is checked. If an error occurs, a prompt is displayed, indicating that the installation will exit the modification.

If a network problem is prompted, manually check and verify and next to continue installation

 

Finally exit and exit.

Note: two scripts will be prompted to be executed before the final completion.

/U01/app/oracle/oraInventory/orainstRoot. sh

/U01/app/oracle/product/10.2.0/db_1/root. sh

After the execution is complete, click "OK" in the prompt figure (it must be executed as root)

The installation is complete.

View the content of the listener File

# Less/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames. ora

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.100) (PORT = 1521 ))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

 

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

# Less/u01/app/oracle/product/10.2.0/db_1/network/admin/listener. ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

)

 

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.100) (PORT = 1521 ))

)

)

The above content indicates that the listener is normal. In the above content, red indicates the Server IP address, and 1521 indicates the oracle listening port.

Log on to oracle's sqlplus

Switch oracle user execution

# Dbca graphical configuration database

# Netca graphical configuration of oracle listeners

# Lsnrctl listening command (parameter start, stop)

 

# Sqlplus/nolog can also be # sqlplus/as sysdba direct Login

SQL> connect/as sysdba link to sysdba system users

SQL> startup

SQL> shutdown immediate shut down the oracle database

SQL> exit

 

Several Shutdown options:

Shutdown: Shut down. Wait for each user to exit the system.

Shutdown transactional

Shutdown immediate: Close the program directly, cancel all user conversations (enable rollback), and run the program normally.

Shutdown abort: Stop shutdown. When the database is shut down, there is no automatic checkpoint logging switch.

After completing the preceding steps, an oracle database can be used normally.

 

 

 

 

This article is from the "Harmony blog" blog