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

Linux6.2 64-bit installation oracle11g

Catalogue

1. Installation environment. 1

Second, system requirements. 1

Third, installation preparation. 1

4. Software environment configuration. 2

1. Essential development tools for oracle. 2

2. Modify the core parameters of the operating system. 3

3. Create oracle users and groups. 4

5. Installation process. 4

VI. Build a database. 15

7. Install the monitor. 23

I. installation environment

Linux server: Red Hat 6.264-bit

Oracle server: Oracle11gR2 64-bit

II. System requirements

System requirements

Description

Memory

Must be higher than 1G of physical memory (memory recommended 2G, virtual memory recommended 4G)

Swap space

Generally, it is twice the size of memory. For example, 1G of memory can be set to 3G size for swap partition.

Hard disk

More than 5G

Third, installation preparation

Installation package: linux.x64_11gR2_database_1of2.zip, linux.x64_11gR2_database_2of2.zip

Hostname modification:

[root@just ~] # hostname / / View hostname just

Modify the following two files to keep the same hostname

[root@just ~] # vi / etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4192.168.2.10 just / / add native IP address and hostname [root@just ~] # vi / etc/sysconfig/networkNETWORKING=yesHOSTNAME=just / / modify to current native hostname

After modifying the host name, restart the computer to make the base effective.

Software environment configuration 1. Necessary development tools for oracle

The installation of oracle 11g is usually carried out on a graphical desktop, so it is recommended to use a RHEL 6 server that already has a GNOME Chinese desktop environment. Software development tools are, of course, essential:

Yum install-y binutils\ compat-libcap1\ compat-libstdc++-33\ compat-libstdc++-33.i686\ gcc\ gcc-c++\ glibc.i686\ glibc\ glibc-devel\ glibc-devel.i686\ libgcc.i686\ libgcc\ libstdc++.i686\ libstdc++\ libstdc++-devel.i686\ libstdc++-devel\ libaio.i686\ libaio\ libaio-devel.i686\ libaio-devel\ make\ sysstat\ unixODBC\ unixODBC.i686\ unixODBC-devel\ unixODBC-devel.i686\ libXext.i686\ libXext\ elfutils-libelf-devel\ pdksh\ unzip

If there is not enough swap space, you can increase it with the following command:

Dd if=/dev/zero of=/test bs=1G count=4mkswap-f / testswapon / testfree-m

2. Modify core parameters of the operating system

Perform the following steps under Root user:

1) modify the user's SHELL restrictions, modify the / etc/security/limits.conf file

Enter the command: vi / etc/security/limits.conf, press I to enter edit mode, and add the following to the file.

Vi / etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536

2) modify the / etc/pam.d/login file, enter the command: vi / etc/pam.d/login, press I to enter edit mode, and add the following to the file.

Vi / etc/pam.d/loginsession required pam_limits.so

3) modify the linux kernel, modify the / etc/sysctl.conf file, enter the command: vi / etc/sysctl.conf, press I to enter edit mode, and add the following to the file

Vi / etc/sysctl.conffs.file-max = 6815744fs.aio-max-nr = 1048576kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576

Note: there are two parameters in the sysctl.conf file, please remember to comment them out.

# kernel.shmmax#kernel.shmall

4) for the / etc/sysctl.conf changes to take effect immediately, execute the following command. Enter: sysctl-p

3. Create oracle users and groups

Groupadd oinstall / / create installation group groupadd dba / / create administrative group mkdir-p / u01/appuseradd-g oinstall-G dba-d / u01/app/oracle oracle / / create running user passwd oracle / / set the password for the oracle user

Modify directory permissions:

Chown-R oracle:oinstall / u01/chmod 755-R / u01 /

5) put the ready installation package: linux.x64_11gR2_database_1of2.zip and linux.x64_11gR2_database_2of2.zip in the oracle user directory, so that the owner and group are oracle:oinstall

5. Installation process

Switch to oracle user:

1) configure environment variables for oracle users

Vi ~ oracle/.bash_profileTMP=/tmp;export TMPTMPDIR=$TMP;export TMPDIRORACLE_BASE=/u01/app/oracle;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;export ORACLE_HOMEORACLE_SID=res;export ORACLE_SIDLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;export LD_LIBRARY_PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLANG=en_US.utf8; export LANGNLS_LANG=american_america.AL32UTF8#NLS_LANG='SIMPLIFIEDCHINESE_CHINA.AL32UTF8'; export NLS_LANG

2) when all the operations of the above system are completed, log out of the system and log in as an Oracle user in the graphical interface. First copy the downloaded Oracle installation package into linux.

Decompress the two zip packages, 1of2 and 2of2, to get the database folder.

Unzip / media/linux_11gR2_database_1of2.zipunzip / media/linux_11gR2_database_2of2.zip

After decompression, cd enters its decompressed directory database.

Enter the command:

Cd database

3) modify the archive value of the relevant development package in the cvu_prereq.xml file. This value defaults to i386 and needs to be changed to i686, otherwise the following error will be reported in the following installation

[root@just ~] # su-oracle [oracle@just ~] $pwd/u01/app/oracle [oracle@just ~] $vidatabase/stage/cvu/cvu_prereq.xml. Omit part of the content . Omit part of the content

4) start installation (log in to the system installation as oracle user)

Go to the database directory and run the installation file to start the installation

#. / runInstaller

Enter the graphical interface and uncheck the I wish step by step. (by individual), click Next, pop up the confirmation box, and then click Yes

Select the second option: Install database software only, install only the database software

Select Singel instance database installation (single instance database installation) and click Next

Select product language, default English, add simplified Chinese, click Next

Select the database version, default enterprise version, and click Next

Configure the Oracle installation directory. Due to the configuration of the environment variables before installation, the installer automatically reads the configuration and automatically selects Oracle Base and Software Location, as shown in the figure, click Next

As above, the Oracle Inventory Directory directory is automatically selected. Click Next.

Keep the default, click Next

Installation check

Two packages elfutils-libelf-devel and pdksh are missing

Install the elfutils-libelf-devel and pdksh packages

Yum install-y elfutils-libelf-devel*

The image disk does not have the rpm package of pdksh. Download the rpm package of pdksh from the Internet and install it.

# rpm-ivh pdksh-5.2.14-30.x86_64.rpmwarning: pdksh-5.2.14-30.x86_64.rpm: HeaderV3 DSA/SHA1 Signature, key ID 73307de6: NOKEYPreparing... # [100%] 1:pdksh #

Click the button Check Again after the above steps are completed, and find that the unsatisfied list is not cleared, but less. Check the check box Ignoreall on the right, and click Next to install it down (memory and cache issues are allocated according to your actual situation)

It is not recommended to use oracle base / U01 / app / oracle as the user's home directory, either yes or no

Execute the following two scripts under the root user to execute the finished OK

Installation completed

VI. Building a database

1) still in the graphical interface of oracle users, oracle users, open a new terminal, directly enter the command dbca will pop up the following interface.

Create a library

Select the first general purpose or business use

Configure the global database name

Configure four built-in Super Admin passwords. A unified password is recommended for easy memory.

Prompt password is too simple, regardless of it, click Yes

The storage location of the database. I use the default here.

Memory allocation (check use automatic memory management)

Memory allocation (check use automatic memory management)

Specify character set

After a long wait, when you see this interface, it shows that the construction of oracle database is complete.

7. Installation of monitoring

1) in the graphical interface of oracle users, oracle users, open a new terminal, enter the command netca will pop up the following interface. Create a listening service (act as an oracle server and let other oracle clients connect to this oracle server)

2) configure the local network service name (act as an oracle client and connect to another oracle server)

Enter the instance name of the database of the connected oracle server

Enter the ip address of the oracle server

It can be tested or not tested. I don't have a test here.

If you want to configure another one, you can Yes. Here I choose No.

Complete

This basically completes the installation and configuration of the oracle server.

Check that there are already two files listener.ora and tnsnames.ora in the oracle home directory.

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.