Install Oracle Database 10g_2 on Linux x86

If you have installed Linux according to the preceding instructions and all kernel parameters use the default values, you only need to log on as the root user and run the following command.

Cat>/etc/sysctl. conf <EOF

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

EOF

/Sbin/sysctl-P

 

For example:

# Cat>/etc/sysctl. conf <EOF

> 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

> EOF

#/Sbin/sysctl-P

Net. ipv4.ip _ forward = 0

Net. ipv4.conf. Default. rp_filter = 1

Kernel. sysrq = 0

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

Run the following command as the root user to verify your settings:

/Sbin/sysctl-A | grep SHM

/Sbin/sysctl-A | grep SEM

/Sbin/sysctl-A | grep file-max

/Sbin/sysctl-A | grep ip_local_port_range

 

For example:

#/Sbin/sysctl-A | grep SHM

Kernel. shmmni = 4096

Kernel. Shmall = 2097152

Kernel. shmmax = 2147483648

Kernel. SHM-use-bigpages = 0

#/Sbin/sysctl-A | grep SEM

Kernel. SEM = 250 32000 100 128

#/Sbin/sysctl-A | grep file-max

FS. File-max = 65536

#/Sbin/sysctl-A | grep ip_local_port_range

Net. ipv4.ip _ local_port_range = 1024 65000

If the system parameter settings are smaller than the preceding parameter values, edit the/etc/sysctl. conf file and add or modify these parameters. Then, run the following command to activate the change:

/Sbin/sysctl-P

ForSles 8After completing the preceding steps, run the following command.

/Sbin/chkconfig boot. sysctl on

Set shell restrictions for oracle users

We recommend that you set a limit on the number of processes that can be used and the number of opened files for each Linux Account. To make these changes, run the following command as the root user:

Cat>/etc/security/limits. conf <EOF

Oracle soft nproc 2047

Hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

EOF

 

Cat>/etc/PAM. d/login <EOF

Session required/lib/security/pam_limits.so

EOF

ForRHEL 1, 2.1AndRHEL 3, Use the following command:

Cat>/etc/profile <EOF

If [\ $ user = "oracle"]; then

If [\ $ shell = "/bin/KSh"]; then

Ulimit-P 16384

Ulimit-N 65536

Else

Ulimit-u 16384-N 65536

Fi

Umask 022

Fi

EOF

 

Cat>/etc/CSH. login <EOF

If (\ $ user = "oracle") then

Limit maxproc 16384

Limit descriptors 65536

Umask 022

Endif

EOF

ForSles 8, Use the following command:

Cat>/etc/profile. Local <EOF

If [\ $ user = "oracle"]; then

If [\ $ shell = "/bin/KSh"]; then

Ulimit-P 16384

Ulimit-N 65536

Else

Ulimit-u 16384-N 65536

Fi

Umask 022

Fi

EOF

 

Cat>/etc/CSH. login. Local <EOF

If (\ $ user = "oracle") then

Limit maxproc 16384

Limit descriptors 65536

Umask 022

Endif

EOF

Avoid errors! (Sles 8 only)

Install Oracle Enterprise Manager 10 on sles 8GThere is an error-the installation fails because the required port is reserved for/etc/services. The OEM dbconsole requires port 1830. In sles8, this port is reserved for/etc/services. The error code of this error on Metalink is 3513603.

To avoid problems during installation, log on as the root user and install Oracle 10GThe software previously commented out the corresponding lines from Port 1830 to port 1849 in the/etc/services file. (Note: At this time, you 'd better restart the server to make sure the above changes take effect .)

Oracle user environment variables

To use ORACLE products, you must set several environment variables. For database servers, we recommend that you set the following environment variables:

Oracle_base
ORACLE_HOME
Oracle_sid
Path

If you have installed Multiple Oracle products or databases on the same server, the ORACLE_HOME, oracle_sid, and path variables may be changed. The oracle_base variable should not be changed and can be set in your login configuration file as needed. Oracle provides a utility called oraenv to set other variables.

Log On As an oracle user and add oracle_base to the logon configuration file by adding a downstream user in. bash_profile or. Profile (bash or KSh:

Oracle_base =/u01/APP/Oracle; export oracle_base

Or Add the following lines in. login (CSH:

Setenv oracle_base/u01/APP/Oracle

This change will take effect the next time you log on to your Oracle account. To change the current session to active, you only need to run this command from the command line.

Part 1: Installing Oracle

Oracle Database 10 can be downloaded from OTNG. Oracle provides a free development and testing license. However, this license is not supported and cannot be used for production purposes. OTN provides a complete license agreement.

To enable Oracle 10GThe distribution kit media can be used on the server. The simplest way is to download it directly to the server.

Use graphical logon to log on as an oracle user.

Create a directory to store Oracle 10GRelease kit:

Mkdir 10g _ DB

To download the Oracle Database 10 GB from OTN, point to http://www.oracle.com/policy/software/products/database/oracle10g/htdocs/linuxsoft.html. Enter the eligibility export restrictions page and read the OTN license agreement. If you accept the restrictions and license agreement, clickI accept.

Click the ship.db.cpio.gz link and save the file in the directory (10g_db) created for this purpose. If you have not logged on to OTN, you may be prompted to log on.

Decompress this file:

CD 10g _ DB

Gunzip ship.db.cpio.gz

Cpio-idmv <ship. DB. cpio

Install software

Log on with an oracle account.

Specify the Database Name (oracle_sid ). The name generally consists of no more than five characters. Install and useDemo1.

Set environment variables:

• Borne shell and Korn Shell

· Oracle_base =/u01/APP/Oracle; export oracle_base

· Oracle_sid = demo1; export oracle_sid

• C Shell

· Setenv oracle_base/u01/APP/Oracle

· Setenv oracle_sid demo1

Change directory to Oracle 10GWhere the software is extracted.

For example:

$ CD $ home/ 10g _ DB

Change the directory to disk1.

For example:

$ CD disk1