Oracle Database Server Construction

This article describes how to build an Oracle database Server. The OS version is Red Hat Enterprise Linux Server release 4/5. In order to pursue higher performance, stability and economy, more and more companies are migrating their database servers to the Linux platform. In combination with their own company's environment, the following documents are prepared for your reference, if any, please point out.

RAID is usually required before OS installation. when RAID 5 or RAID 1 + 0 is used, I/O performance and security are measured based on your own needs. When selecting the installation package, I generally do not advocate full installation. After all, our server resources are very precious and there is no need to install services. We can follow the minimum installation, and then add the installation as needed. Of course, if you can determine the requirements, it is best to directly select the desired package for installation.

I. Linux disk Division:

1. for systems with 2 built-in disks (146 GB), The/directory is 20 GB, the SWAP is equivalent to the memory size (the SWAP is 8 GB for machines with less than 8 GB memory), and The/boot is 100 MB. As a database platform, the 20 GB/dba file system is created as the database software directory, and the remaining disk space is allocated to the/u01 file system as the directory for storing data files.

2. For a built-in 4-6 disk system, the/directory is 40 GB, SWAP is equivalent to the memory size (SWAP is 8 GB for machines with less than 8 GB memory), And/boot 100 MB. As a database platform, the 40 Gb/dba file system is created as the database software directory, and the remaining disk space is allocated to the/u01 file system as the directory for storing data files.

3. Use the mke2fs-j-T largefiles command to create an Oracle data file directory file system.

Ii. Oracle Directory standards (recommended ):

1. oracle Directory standards without external storage (recommended): ORACLE_HOME =/dba/app/oracle/product/10.2.0.4 (specified based on the actual version ); ORACLE_BASE =/dba (dump directory:/dba/admin/sid); Datafile Directory:/u01/oradata/sid; Archive Directory:/u01/oradata/archive_sid

2. oracle Directory standards (recommended) for external storage (/u02): ORACLE_HOME =/dba/app/oracle/product/10.2.0.4 (specified based on the actual version ); ORACLE_BASE =/u01 (dump directory:/u01/admin/sid); Datafile Directory:/u02/oradata/sid; Archive Directory:/u01/oradata/archive_sid

3. oracle databases use the CUSTOMER method to directly change the initial UNDO and TEMP tablespaces to 8 GB (or 4 GB, or increase the number of data files to a larger value based on actual business needs ); the SYSTEM tablespace is 512 MB (OR 1 GB), The Redolog is 100 MB, and the size of a single Datafile is 8 GB (due to the features of the ext3 file SYSTEM, other file systems are configured according to their features). It is best to divide the size of Datafile into 8 GB at a time. We do not recommend using auto-extension.

1 2 Next Page