Shulou(Shulou.com)06/01 Report--

In this issue, Xiaobian will bring you an example analysis of suse linux enterprise server10 64bit installation oracle11g. The article is rich in content and analyzed and described from a professional perspective. After reading this article, I hope you can gain something.

Installing Oracle 11g in Suse Linux Enterprise Server10 64bit is a troublesome thing, installing Oracle database is much more difficult than installing Suse operating system itself, and after many tests, it finally succeeds. The specific installation process is as follows for your reference:

1. Check whether the operating system software and hardware environment meets the installation requirements of oracle 11g

2. Create oracle user groups, oracle installation directories, and oracle user environment variables

3. Modify kernel parameters

4. Install database software

5. Create a database to listen to netca

6. Create database dbca

Software and hardware system configuration:

Operating System: Suse Enterprise 10 Linux

Hardware configuration: 16 GB memory

I. Operating system installation (omitted)

Check whether the operating system software and hardware environment meets the installation requirements of oracle 11g.

2.1 check disk space

#df -h /tmp

2.2 Check memory, swap partition, operating system, system kernel

2.3 Check software packages

binutils-2.17.50.0.6-2.el5

compat-libstdc++-33-3.2.3-61

gcc-4.1.1-52

gcc-c++-4.1.1-52

glibc-common-2.5-12

glibc-2.4-31.2

glibc-devel-2.4-31.2

libaio-0.3.106

libaio-devel-0.3.106

ksh-93r-12.9

libgcc-4.1.1-52

libelf-0.8.5

libstdc++-4.1.1

libstdc++-devel-4.1.1-52.e15

make-3.81-1.1

sysstat-7.0.0

unixODBC-2.2.11

unixODBC-devel-2.2.11

How to install the package:

rpm -qa |grep package name (check for this package first)

Then install by rpm -ivh package name or yast2 -i package name

2.4 Modify the operating system locale

#yast

System-Language

Redhat enterprise as 5 Modified language methods

[root@redhat]# vi /etc/sysconfig/i18n

LANG="en_US"

#LANG="zh_CN.UTF-8"

2.5 Modify the OS login interface (/etc/inittab)

#id:5:initdefault:

id:3:initdefault:

Change host name

# vi /etc/hosts

Added 172.29.141.90 linux09

Create oracle user groups, oracle installation directories, and oracle user environment variables

#groupadd oinstall

#groupadd dba

#useradd -g oinstall -G dba oracle

#passwd oracle

#mkdir -p /u01/app/oracle/project/11.1.0/db_1

#chown -R oracle:oinstall /u01

#chmod -R 755 /u01

#su - oracle

Password: XXX

#pwd

/home/oracle

#vi .profile * In redhat, change the environment variable to #vi .base_profile*

ORALCE_BASH=/u01/app/oracle/project

ORACLE_HOME=$ORACLE_BASE/11.1.0/db_1/oracle

* Oracle here is a newly created oracle user *

ORACLE_SID=orcl *oracle sid can be modified by itself *

PATH=$ORALCE_HOME/bin/:path

*Bin directory cannot be wrong, otherwise new monitor and database cannot be created after installation *

Export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

Make the settings work

#source .profile

#source .base_profile(redhat enterprise linux)

4. Modify kernel parameters

#vi /etc/sysctl.conf

# Kernel paramaters required by Oracle 11gR1

fs.file-max = 6553600

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 262144

For the/etc/sysctl.conf changes to take effect immediately, execute the following command.

# sysctl -p

Note: Check if settings are in effect: #/sbin/sysctl -a

On SUSE systems, the above settings are valid only for the time being. To keep the settings after restart, enter the following command:

# /sbin/chkconfig boot.sysctl on

# vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

# vi /etc/pam.d/login

session required pam_limits.so

Note: If you already have this line, you don't need to add it. Some systems may cause TELNET to fail after adding this line (SSH is not affected). You can delete this line.

#vi /etc/profile（ /etc/profile.local）

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

V. Installation of database software

#unzip linux_oracle11g.zip

Log in to the graphical interface with oracle

>cd database

>./ runInstaller

1. Select advanced installation, then you need to use root to execute orainstroot.sh and root.sh, and finally install successfully.

2.> netca create monitor

3. dbca Create database

4、sqlplus /nolog

conn / as sysdba

startup

5, well, you can use PL/SQL Developer tools to connect to the database for development.

The above is a small series for everyone to share the suse linux enterprise server10 64bit installation oracle11g example analysis, if there is a similar doubt, may wish to refer to the above analysis to understand. If you want to know more about it, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.