Redhat Enterprise Linux Advanced Server V3 Installing Oracle 10g Steps

xiaoxiao2021-03-06  38

Redhat Enterprise Linux Advanced Server V3 Installing Oracle

10g

step

1. Check hardware requirements

a) Memory 512MB #Grep Memtotal / Proc / Meminfo

b) Switch space! GB #Grep swaptotal / proc / meminfo

c) Temporary Space / TMP 400MB #df -k / Temp

d) Software required for the space 2.5GB #df -k

e) Data required space 1.2GB

2. Required package

a) Make-3.79 # rpm -q make

b) binutils-2.11

c) OpenMotif-

2.2.2

-16

d) setArch-1.3-1

e) compat-db-

4.0.14

.5

f) Compat-GCC-7.3-2.96.122

g) COMPAT-GCC-C - 7.3-2.96.122

h) Compat-libstdc - 7.3-2.96.122

I) Compat-libstdc - Devel-7.3-2.96.122

3. Create user groups

a) Viewing the user group exists #grep oinstall / etc / group

b) If there is no existence, create a user group

#groupadd dba

#groupadd oinstall

c) establish a user

If the user does not exist:

# uSERADD ORACLE -G OinsTall -g DBA

#passwd oracle

If the user exists:

# uSERMOD -G OinsTall -G DBA

4. Establish an application directory and data directory

We set the installation directory for / database / oracle

Data catalog / Database / Oracle / ORADATA

Application Directory is / Database / Oracle / App / ORACLE

#mkdir -p / database / oracle / app / oracle

#CD / Database / ORACLE

#mkdir app

Set the directory owner for the user Oracle, the group is Oinstall

#chown oracle.oinstall -R / Database / Oracle

#CHMOD 755 -R / Database / Oracle

5. Configuring the core parameters (Redhat Enterprise AS3 default core parameters have met the requirements, no need to set it)

SEMMSL 250 / Proc / Sys / Kernel / SEM

SEMMNS 32000

SEMMOPM 100

Semmni 128

SHMALL 2097152 / Proc / Sys / kernel / shmall

Half / proc / sys / kernel / shmmax of SHMMAX

SHMMNI 4096 / PROC / SYS / KERNEL / SHMMNIFILE-MAX 65536 / PROC / SYS / FS / FILE-MAX

IP_LOCAL_PORT_RANGE 1024 65000 / Proc / Sys / Net / IPv4 / ip_local_port_range

The parameter allows greater than the above value, if the system parameter is greater than the above value, please do not change casually.

If you do not meet, add the following parameters to the /etc/sysctl.conf file, remove the front ##

# kernel.sem = 250 32000 100 128

# kernel.shmmall = 2097125

# kernel.shmmax = 2147483648

# kernel.shmmni = 4096

# fs.file-max = 65536

# Net.IPv4.ip_local_port_range = 1024 65000

After adding

# / sbin / sysctl -p

6. Set Oracle User Limit Parameters to improve Oracle System Performance

By default, these parameters are smaller, we need to increase them to get better performance in using Oracle

a) Add the following line in the /etc/security/limits.conf file

* Soft Nproc 2047

* Hard Nproc 16384

* Soft Nofile 1024

* Hard Nofile 65536

b) Increase the following lines in the /etc/pams.d/login file

Session Required /LIB/Security/Pam_Limits.so

c) Set Oracle User Shell

Edit / etc / profile file, add the following line

IF [$ user = "oracle"]; then

IF [$ shell = "/ bin / ksh"]; then

Ulimit -p 16384

Ulimit -n 65536

Else

Ulimit -u 16384-N 65536

Fi

Fi

7. Set Oracle User Environment Variables

a) Log in with an Oracle user account or switched to an Oracle user account with su - oracle

Edit .bash_profile file, here you can try your shell environment to change

If it is not a BSH environment, edit other corresponding files to view the environment command for $ Echo $ shell

Add the following lines in .bash_profile file

Umask 022

$. ..bash_profile

b) Set the zero directory, if your hard disk space is insufficient

$ TEMP = Your installation file directory

$ TEMPDIR = Your installation file directory

$ export tempdir

c) Set an Oracle environment variable

$ Oracle_base = / dataBase / Oracle / App / Oracle

$ Oracle_sid = DB

$ export oracle_base oracle_sid

Make sure the following environment variables are not set, if it is already set, cancel

A lot of online information is forced to set a $ ORACLE_HOME variable and other variables, resulting in a problem after the database installation, here we cancel the settings for $ Oracle_Home and $ TNS_ADMIN, because these variables will be in the installation process during the installation process Automatic generated. Use the following command to cancel the set variable $ unset oracle_home

$ unset tns_admin

Check the following environment we set up

$ umask

0022 should be displayed

$ ENV | More

Check if you meet the requirements

d) Set the display IP, if your workman uses Windows Remote installation Oracle 10G on Linux, you need the corresponding X Window display tool, such as XManage, or X-Win32, I use X-Win32, make sure you have run, run the following Command Settings Remote Display

$ Display = IPD address of your working machine: 0.0

$ EXPORT DISPLAY

8. Before installing

a) Solve the issue of the ISQLPLUS and EM Chinese buttons displayed as "mouth mouth"

Enter the installation package directory after entering the decompression, I / TMP / DISK1

$ cd/tmp/disk1/stage/components/oracle.swd.jre/

1.4.2

.0.0 / 1 / DataFiles

$ unzip all_except_bin.jar

$ CD JRE /

1.4.2

/ lib

$ MV FONT.PROPERTIES FONT.PROPERTIES.BAK

$ CP FONT.PROPERTIES.ZH_CN.Redhat 8.0 Font.properties

$ cd ../../../../

$ zip -r all_except_bin.jar.cn jre /

$ mv all_except_bin.jar.cn all_excepte_bin.jar

$ cd /tmp/disk1/stage/components/oracle.jdk/

1.4.2

.0.0 / 1 / DataFiles

$ MKDIR TEMPJRE

$ CD Tempjre

$ unzip ../sol_bin.1.1.jar

$ MV FONT.PROPERTIES FONT.PROPERTIES.BAK

$ CP FONT.PROPERTIES.ZH_CN.Redhat 8.0 Font.properties

$ zip solution_bin.1.1.jar.cn *

$ c ./sol_bin.1.1.jar.cn ../

$ CD ..

$ MV SOL_BIN.1.1.jar.cn SOL_BIN.1.1.jar

$ RM -RF TEMPJRE

Here, complete the solution to Chinese display

In fact, after the above is to decompress the all_except_bin.jar file and SOL_BIN.1.1.jar file, replace the decompressed font.properties file with font.properties.zh_cn.redhat 8.0, from new compression to all_except_bin.jar files and SOL_BIN.1.1.jar file.

b) Let the database support Chinese character sets

During the installation process, there will be a problem with the database language. The default is an English ISO ..., we set him to zHS16GBK.

9. Install Oracle

$ CD / TMP / DISK1

$. / Runinstaller

10. What should I do after installation?

a) Use the DBCA configuration database on the server side

$ DBCA

b) Configure database connections

Here we use NetMGR configuration, although Netca can also be configured, but it feels not very easy to configure.

NETMGR configuration is better to use, run the following command to enter the graphical interface configuration

$ NETMGR

It should be noted that the default is to use the host name, we need to increase the configuration of the IP address corresponding to the host name, which can be connected. On the client, you can use the same tool configuration, and you can operate after the database.

转载请注明原文地址:https://www.9cbs.com/read-59312.html

New Post(0)