1. Installing Oracle software and creating databases

I. Hardware Resources

Memory: 1G or more

Swap space: At least 1.5G, twice times of memory required

Temp Space: 400M

Linux The temporary space is / tmp

Windows The temporary space is as follows:

c:\> Echo%homedrive%%homepath%\local Settings\Temp

Hard disk space: Linux/unix needs 1.3~3.5g

Windows requires 1~1.5g

Ii. OFA Best Flexible Architecture (directory naming)

1 , Linux / Unix below for Mount the naming of points takes /pm the way

P : Character constants, usually u

m : Fixed length, usually 2

For example /u01 , /u02

2 , BASE directories are usually /pm/h/u

h : constants, usually app

u : Directory owner, usually Oracle

For example /u01/app/oracle

3 , Oracle_home directories are usually /pm/h/u/product/v

V : Version number, for example 9.2.0 , 10.2.0

Some of the new components, such as ASM , db_1 It's all under this directory .

For example /u01/app/oracle/product/10.2.0

4 , database-specific management files, such as startup parameter files, dump files

/pm/h/u/admin/d/a

D represents the name of the database

a represents the name of the subdirectory, for example, the parameter file is Pfile , the user directory is Udump

For example /u01/app/oracle/admin/ora10g/ Pfile

5 , key files are usually /pm/q/d

Q is usually Oradata

For example /u02/ Oradata /ora10g

control files are usually Controln.ctl , N represents the number of data bits, usually 2

For example Control01.ctl , Control02.ctl

Redon.log , N is usually 2 , such as Redo01.log , Redo02.log

Data Files tn.dbf , T represents the name of the table space, N is usually 2

For example users01.dbf , users02.dbf wait

Third, check the components that need to be installed

1.redhat4:binutils-2.15.92.0.2-13.el4
Compat-db-4.1.25-9
compat-libstdc++-296-2.96-132.7.2
Control-center-2.8.0-12
Gcc-3.4.3-22.1.el4
Gcc-c++-3.4.3-22.1.el44
glibc-2.3.4-2.9
glibc-common-2.3.4-2.9
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-22.1
libstdc++-devel-3.4.3-22.1
Make-3.80-5
Pdksh-5.2.14-30
Sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
Setarch-1.6-1

2.REDHAT5:

For i in binutils compat-gcc-34 compat-libstdc++-296 control-center \

GCC gcc-c++ glibc glibc-common glibc-devel Libaio libgcc \

libstdc++ libstdc++-devel libxp make openmotif22 setarch

Do

Rpm-q $i &>/dev/null | | f= "$F $i"

Done; Echo $F; unset F

If this command is executed, the output package name should be added to the system.

If there is no output information, the required packages are already in the system.

Iv. Modifying kernel parameters

Vim/etc/sysctl.conf

Kernel.shmall = 2097152: Parameters related to shared memory segments

Kernel.shmmax = 2147483648: Parameters related to shared memory segments

Kernel.shmmni = 4096: Parameters related to shared memory segments

Kernel.sem = 32000: signal-related parameters

Fs.file-max = 65536: Maximum number of files that can be opened at the same time

Net.ipv4.ip_local_port_range = 1024 65000: Network-related parameters

Net.core.rmem_default = 1048576

Net.core.rmem_max = 1048576

Net.core.wmem_default = 262144

Net.core.wmem_max = 262144

V. Increase the nofileandnproc parameters of operating system users

Grep-v ' ^# '/etc/security/limits.conf

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

Nofile : Maximum number of files that the operating system user can open at the same time

Nproc : Number of processes that a single user can open at the same time

[[email protected] ~]# grep ' limit '/etc/pam.d/system-auth

Session Required Pam_limits.so

Vi. creating users, Groups

[Email protected] ~]# groupadd-g Oinstall

[[email protected] ~]# GROUPADD-G 1001 dba

[Email protected] ~]# useradd-u 1000-g oinstall-g dba Oracle

[Email protected] ~]# passwd Oracle

VII. Setting Environment variables

VI ~oracle/.bash_profile

Export Oracle_base=/u01/oracle

Export Oracle_home= $ORACLE _base/product/10.2.0

Export oracle_sid=ora10g

Export path= $PATH: $HOME/bin: $ORACLE _home/bin

Export Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib

Load configuration

The Oracle user logs off the re-login or source. bash_profile

Eight, set up the need directory, setting permissions

[Email protected] ~]# mkdir-p/u01/oracle

[Email protected] ~]# chown-r oracle:oinstall/u01/