Oracle 10g Installation Documentation

1: Modify Kernel parameters

[Email protected] mnt]# vim/etc/redhat-release

Red Hat Enterprise Linux Server Release 4 (Tikanga)

2: Modify host Name

[Email protected] ~]# vim/etc/sysconfig/network

Hostname=dba.up.com

[Email protected] ~]# vim/etc/hosts

192.168.1.88 dba.up.com dba

3: Space Requirements

Memory at least 512M swap partition at least 1G

Oracle Software Installation Location 1.3G

Database installation location at least 1G

/tmp to have enough 400M of surplus

If these directories are subordinate to the root file system, then it needs to be 3G free to install (1.3+1+0.4)

All of the above are part of the minimum requirement which is far enough to run late to add data to use.

And the files that are generated by the oracle itself will gradually grow as you run later. Keep enough space required

Check method

[Email protected] ~]# df-th

File system type capacity used% mount point available

/dev/sda2 ext3 15G 2.3G 12G 17%/

/DEV/SDA1 ext3 99M 12M 83M 12%/boot

Tmpfs tmpfs 506M 0 506M 0%/dev/shm

[Email protected] ~]#

[Email protected] ~]# grep-e ' memtotal| Swaptotal '/proc/meminfo

memtotal:1035108 KB

swaptotal:1076344 KB

[Email protected] ~]#

4: Package Check

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.

5: Operating System resource limits

Add to

vim/etc/sysctl.conf File Bottom

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

Net.core.rmem_default = 1048576

Net.core.rmem_max = 1048576

Net.core.wmem_default = 262144

Net.core.wmem_max = 262144

Make kernel parameters effective

/sbin/sysctl-p

6: User Resource limits

Build Oracle Users and Groups

It is recommended to specify GID and UID methods (especially clustered environments)

[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

Set up Oracle Software installation files directory

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

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

7: Set Oracle 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

8: Run the Install command

If you want to support the Chinese interface after the EM or DBCA interface display Chinese

Installing RPM-IVH ttfonts-zh_cn-2.14-6.noarch.rpm

Export Lang=zh_cn.utf-8

The installation interface uses English to export lang=c

9: Command History rollback

Installing the Software Rlwrap

Vim. BASHRC in the home directory

Alias sqlplus= ' Rlwrap sqlplus '

Alias rman= ' Rlwrap Rman '

Make the file effective:. . BASHRC

10: Modify the System configuration

$ vim/u01/oracle/product/10.2.0/sqlplus/admin/glogin.sql

Set Linesize 150

Set PageSize 200

Set Serveroutput on

Define _editor = Vim

Set Sqlprompt "_user>" Modify prompt for current user

Log off root use the Oracle user login X-window to execute the installation command Runinstaller

If the installation package is mounted on the disc media after you want to leave the disc hanging in the location absolute path execution

Temporary files cannot be created because the Setup program creates a temporary file disc that is read-only

If the current desktop is root with su-oracle switch user needs to be in the root before the switchover # Xhost + Otherwise Oracle user cannot connect to root desktop

[Email protected] ~]#/u01/oracle/orainventory/orainstroot.sh

Change permissions/u01/oracle/orainventory to 770.

Change the group name/u01/oracle/orainventory to Oinstall.

Execution of the script is complete

[Email protected] ~]#/u01/oracle/product/10.2.0/root.sh

Running Oracle10 root.sh Script ...

The following environment variables is set as:

Oracle_owner= Oracle

Oracle_home=/u01/oracle/product/10.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome To/usr/local/bin ...

Copying oraenv To/usr/local/bin ...

Copying coraenv To/usr/local/bin ...

Creating/etc/oratab file ...

Entries'll be added to The/etc/oratab file as needed by

Database Configuration Assistant When a database is created

Finished running generic part of root.sh script.

Now product-specific root actions would be performed.

[Email protected] ~]#

The database is in a startup state after installation ends

In the command behavior Scott user unlocks:

Sql>conn/as SYSDBA Switch to system administrator

Sql>alter user Scott identified by Tiger account unlock; Unlock Scott

Sql>conn Scott/tiger

How to start the database after the system reboot?

Su-oracle

Sqlplus/nolog

Sql>conn/as SYSDBA

Sql>startup

Oracle 10g Installation Documentation