Oracle project that's the thing----Building a library (1)

The star is wide, the moon Chant River, is with colleagues bragging blow, the boss came, cough a sound. Everyone immediately quiet, each back to you, do each thing.

I just sat down and the boss came to me. There is a built library of live, time is tight, only two days time, will be our platform database installed. No information on the hardware platform

The bridge is good, the scene communicates with the engineer.

The next day, went to the customer site, the reception of Engineers is a system engineering engineer A, a workers looking at the beard, the face of vicissitudes, the heart of the surface happy, today one year old everyone Tim,

Not alone I am old. Do it finally find a few than I am old, later a ask, age don't I still small, damn!! Don't say this, it's far away.

A workers, introduced their environment,

The hardware platform is the Dell PowerEdge R815 Server, the high-end goods in DELLPC server, not bad.

The company's software platform, most of which is Redhat ES4.4.

There is no plan to connect to the storage until the future RAC is connected.

Install Oracle 10.2.0, patch to hit full.

CPU * 4,64G memory, Overall good.

After these things understand, the heart has a bottom, and then to confirm some LVM, and other planning. Although these things a work estimate also do not know, but in order to explain or to a work to mention.

In addition to the implementation of this report is not required, it is estimated that the library is at most testing phase. oneself also lightly.

Talk less and start working.

One. Install Redhat ES 4.4 (Mentally retarded!) ）

1. Setting language, national characters

2. Setting up the disk boot loader

3. Set up network devices, Nic Ip,dns, etc., pay attention to shutting down the firewall, and disable Selinux

4. Disk partitioning, according to disk planning,

is an LVM or an ordinary disk partition, some of which are certain to know

LVM Logical Disk Volume group management,

PV physical volume, or physical disk, an LVM can hold 128 physical volumes

The PP physical partition, which is the partition on the physical disk, is the unit of physical Disk Management, typically 4M

You can run multiple logical volumes on an LV logical volume, on an LVM, or on a disk.

LP logical partitioning, interface directly with the upper-level application software interaction. Can be linked to file system, System log dump device, and bare equipment, etc.

LVM differs from non-LVM: LVM is dynamic Disk Management, loading disks, extending logical volumes, and managing logical partitions without down-to-the-machine conditions. Non-LVM is not.

After the disk is divided, after formatting, mount the device.

5. Select the installed software, this does not say, the server side of the software, System management software, and development-related libraries a not missing all to me. Lest you add to yourself later.

Two. Configure the system core parameters

1. Memory parameter Configuration

Supposedly configured before, need to look at their own disk situation, whether to meet the requirements of the installation, whether to meet the requirements of the system expansion, in the early stage of the information Bridge good, will be a lot of trouble to reduce later. The memory parameters are believed to be a lot of people, but how much do you really understand the meaning behind it?

There are four types of Oracle-related memory parameters

Shared memory: Shared memory is a mechanism for process communication, and shared memory can be shared by multiple processes specified and is a system resource.

In the form of segments, the maximum size and number of segments is limited.

When Oracle startup, execution Shmget () allocates memory for the SGA.

Here we have to mention Sga_target (the size of the SGA currently allocated, whose value is not 0, is automatically assigned within its region) and sga_max_size (the maximum size that the SGA can allocate)

Kernel.shmmax: The maximum size of each memory segment, so the value should be greater than or equal to sga_max_size, so that access to shared memory does not span segments.

Kernel.shmmni: The maximum number of shared memory segments the system can allocate. If each SGA does not exceed a single memory segment, the value is the maximum number of instances that Oracle can start.

Kernel.shmall: For any given moment, the system can allocate the maximum value of the sum of all memory segments.

Semaphores: It is well known that the method of controlling access to shared resources of the system. In particular, the system congestion can be controlled at a time of high concurrency. Oracle mainly uses semaphores to control memory.

File Open pages:

Fs.file-max maximum number of files that can be opened per process

Socket cache for client connections:

The NET.IPV4.TCP_RMEM is used to specify the maximum value, minimum, and default value of the buffer when the socket data is sent.

The NET.IPV4.TCP_WMEM is used to specify the maximum value, minimum, and default value of the buffer when the socket data is received.

After the installation of the official documentation is configured.

2. User group management, permissions replication, setting environment variables

This is simple, no need to be cumbersome. However, you should not forget the permissions of the directory if you have data critical, or if you are managing files into different file directories.

3. Installation

So easy! Next,next!!!! With a big saying that a dog, give a steamed bun, it will be installed!

4. Building a library

Dbca

NETCA,

Netmgr

That is, configure the listener, configure the Tnsname, build the library! Game over!

Summarize the issues that arise throughout the process:

1. I do not know why/u01/oracle/admin folder permissions are root, in the library times TNS no perimission error

After the change, the normal installation

2. When configuring the listener, the Tnsname.ora connection string is preceded by a space, which causes the listener connection to fail. get rid of normal!

Ext.: http://www.cnblogs.com/jerryxing/archive/2012/07/26/2606114.html

Oracle project that's the thing----Building a library (1)