Shulou(Shulou.com)06/01 Report--

Oracle database can be said to be the best and safest database in the world, that is, the price is a little expensive, generally large enterprises, banks, bonds, government departments.

However, with the economic growth, Oracle databases for ordinary enterprises are gradually increasing. In terms of operation and maintenance, Oracle may be given priority. Today, Oracle environment shall be built first.

He needs a lot of variables, and he has to enter them manually.

The first step is to install a brand new 6.5 linux system centos red

Install desktop components, development components, and default java components

Configure IP for virtual machines, turn off firewalls, turn off secondary firewalls, configure some environments, and configure local yum.

Set a permanent host name for the virtual machine, and then you can do DNS or you can do hosts.

In order to skillfully install dns server

Install bind package

yum -y install bind and nothing else but dns

Pointing to dns locally

Then modify the dns file

written to the file

Then add SOA hosts

DNS is done!!

Start installing!!!!!

-----------------

yum install support pack!

These packages can be installed locally on linux cd

One package needs to be installed separately, there is a compatibility conflict, so install it separately rpm

Installation complete. Start setting kernel parameters.

vim /etc/sysctl.conf

This pile has some modifications, and nothing is added by itself.

=======================

Details of parameters:

fs.aio-max-nr：

This parameter limits concurrent outstanding requests and should be set to avoid I/O subsystem failures.

fs.file-max：

This parameter determines the maximum number of file handles allowed in the system. The file handle setting represents the number of files that can be opened in linux.

kernel.shmall：

This parameter controls the total number of pages of shared memory that can be used. Linux shared memory pages are 4KB in size, and shared memory segments are all integer multiples of the shared memory page size. The maximum size of a shared memory segment is 16 GB, so the number of shared memory pages required is 16GB/4KB=16777216KB/4KB=4194304 (pages), that is, 16GB of physical memory under 64Bit system. Set kernel.shmall =4194304 to meet the requirements.

kernel.shmmax：

Is one of the most important of the core parameters, defining the maximum value of a single shared memory segment. The setting should be large enough; too low a setting may result in the need to create multiple shared memory segments, which may degrade system performance. As for the main reason for system degradation, when the instance is started and ServerProcess is created, multiple small shared memory segments may cause slight system performance degradation at that time (multiple virtual address segments need to be created at startup, and multiple segments need to be "identified" by the process at process creation time, which will have some impact), but other times there will be no impact.

Official recommendation:

32-bit Linux system: The maximum value is 4GB (4294967296bytes)-1 byte, i.e. 4294967295. The recommended value is more than half of the memory, so if 32 is the system, the general value can be 4294967295.

64-bit linux system: the maximum value of the physical memory value-1 byte, the recommended value is more than half of the physical memory, for example, if it is 12GB of physical memory, take 12*1024 * 1024-1=12884901887.

kernel.shmmni：

This parameter is the maximum number of shared memory segments. The default value of shmmni is 4096, which is usually enough.

kernel.sem：

For example, kernel.sem= 250 32000 100 128:

250 is the value of the parameter semmsl, indicating the maximum number of semaphores that can be contained in a semaphore set.

32000 is the value of the parameter semmns, indicating the maximum number of semaphores allowed in the system.

100 is the value of the parameter semopm, indicating the number of operations a single semopm() call can perform on a semaphore set.

128 is the value of the parameter semmni, indicating the total number of semaphore sets in the system.

net.ipv4.ip_local_port_range：

Indicates the range of IPv4 ports available to the application.

net.core.rmem_default：

Represents the default value for socket receive buffer size.

net.core.rmem_max：

Represents the maximum socket receive buffer size.

net.core.wmem_default：

Represents the default value for the socket send buffer size.

net.core.wmem_max：

Represents the maximum socket send buffer size.

=========================

Create a system user!!!! assigned to the base group and then to an additional group.

And then create related directories!!!

Write boot load for oracle user

Add shell restrictions to oracle

Number of processes alarm limit

Maximum number of processes

file warning limit

Maximum file limit

vim /etc/pam.d/login

Prevent bad endless loop statements

need to modify

vim /etc/profile

Sometimes there will be garbled, you need to install the corresponding font library,

Create folders to put in files, and then give permissions to files

Turn off the firewall, turn off selinux

Start installing Oracle

First cp the installation package into oracle's host directory and then give it all permissions.

xhost +

Graphics Terminal Cancel all restrictions!!!!!!

Switch users, extract files, start graphics installation files are already in the host directory

su oracle

Graphic is installed according to your own needs

Note that there are storage directories that need to be noted in the graphics, which need to be consistent with the variables set, otherwise there may be obstacles to commands or other functions.

--------------------------------------------------------------------------------------------------------

Set boot up auto-start

vim /etc/oratab

vim /etc/rc.local

Can customize scripts, scripts on the network a lot of self-search, and then set up system services on the line

chkconfig oracle on default startup

chkconfig --list oracle View

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.