Mounting Oracle-redhat 5.4 64-bit

1. Preparing documents

RedHat Enterprise 5.4 64-bit

Oracle 11g R2 64-bit (two files)

2. Create Users and directories

Use root identity

2.1 Creating a User

>/usr/sbin/groupadd Oinstall

>/usr/sbin/groupadd Oinstall

>/usr/sbin/useradd Oracle

>/usr/sbin/usermod–g oinstall–g dba Oracle

>PASSWD Oracle

2.2 Creating a Directory

>mkdir–p/u01/app/

>chown–r oracle:oinstall/u01/app/

>chmod–r 775/u01/app/

3. Installing dependent Packages

Installing from the Rhel image file

>df–h

>mount/dev/scd0./iso

>CD Iso/server

>rpm–ivh./binutils-2.*

4. Configuration parameter 4.1 Configure kernel parameters

Edit/etc/sysctl.conf File

Note the following number of parameters that have a space for the representation value

FS.AIO-MAX-NR = 1048576

Fs.file-max = 6815744

#kernel. Shmall = 2097152

#kernel. Shmmax = 536870912

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

To make the parameters effective:

[Email protected]/]#/sbin/sysctl–p

4.2 Configuring the user's environment variables

First switch to Oracle user

[Email protected]/]$ VI ~/.bash_profile

Add the following environment variables

Oracle_base=/u01/app

Oracle_home= $ORACLE _base/product/11.2/db_1

Oracle_sid=orcl

Path= $ORACLE _home/bin: $PATH $:.

Export Oracle_base oracle_home oracle_sid PATH

Make the environment variable effective immediately:

[Email protected]/]$ source ~/.bash_profile

4.3 Modifying user security restrictions

Modify the/etc/security/limits.conf file, plus the following parameters

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

4.4 Modifying user authentication Options

Modify the/etc/pam.d/login file plus the following parameters

Session Required Pam_limits.so

4.5 Modifying user Profiles

Modify the/etc/profile file by adding the following parameters:

if [$USER = "Oracle"]; Then

if [$SHELL = "/bin/ksh"]; Then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

5. Standard Installation

Log off the current user, log on with an Oracle user (if you do not do so, a color check issue may occur)

Unzip extract two Oracle files to the same directory (in the Oracle User's directory)

Go to database directory and execute Runinstaller

A. Mail may not be filled in

B. Select "Install and configure database"

C. Select Desktop version

D. If the prompt does not have write permission, the Create directory gives write permission

E. If you are prompted for missing settings or dependent packages, configure or install them as prompted

F. Export database information to facilitate later query

G. Follow the prompts to execute two scripts as root

6. Testing

>sqlplus Sys/oracle as Sysdba

Sql>startup

Sql>

Appendix 1: Custom Installation 1. Installation

Log off the current user, log on with an Oracle user (if you do not do so, a color check issue may occur)

Unzip extract two Oracle files to the same directory (in the Oracle User's directory)

Go to database directory and execute Runinstaller

A. Mail may not be filled in

B. Select "Install only database software"

C. Select all installations

D. If the prompt does not have write permission, the Create directory gives write permission

E. If you are prompted for missing settings or dependent packages, configure or install them as prompted

F. Export database information to facilitate later query

G. Follow the prompts to execute two scripts as root

2. Building a library

Enter the graphical build library page with Oracle user input DBCA

>dbca

A. Select Create a Database

B. Select Custom Database

C. Enter the SID name to match the SID name in the Oracle user profile

D. The rest of the election, choose it yourself, too lazy to write

3. Configuring monitoring and local network services

>netca

3.1 act as a server so that other hosts can connect

A. Select Listener Configuration

B. Select Add

C. Press the default always point next

3.2 Acting as a client, connecting to other servers

D. Select the local Service Name configuration

E. Select Add

F. Sevice name with database name such as ORCL

G. Host name fill in its own IP address

H. Select Test Link (Yes, perform a test)

Appendix 2: Issues that may occur 1. Color problem, can not start the graphical installation interface

Log off and re-login to Oracle users to resolve

2. When linking a database ORA-01034

ERROR:

ORA-01034 ORACLE Not available

ORA-27101 Shared Memory Realm does not exist

In fact, this question can be clearly stated in one sentence:

Oracle_home or ORACLE_SID is not set correctly.

In previous versions, if Oracle_sid was not correct, it was generally only prompted for ORA-01034. Oracle 8.1.7 gives an additional message: ORA-27101.

If UNIX, set the oracle_sid correctly in the shell (note the case sensitive issue).

Also, check the ORACLE_HOME environment variable. How to check for commands that refer to the following:

% echo $ORACLE _sid

% Ps-ef |grep Smon

Install Oracle-redhat 5.4 64-bit