Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the detailed steps of silently installing oracle11g under linux". In the daily operation, I believe that many people have doubts about the detailed steps of silently installing oracle11g under linux. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "detailed steps of silent installation of oracle11g under linux". Next, please follow the editor to study!

One preparation work 1.linux check whether the installation package is complete

Use rpm-qa | grep "package name"-check whether the package exists

If it does not exist, use the command rpm-ivh "package name"-install uninstalled dependent packages

Do the following configuration information on each node Check if dependent rpm packages are installed: binutils-2.* compat-libstdc++-33* elfutils-libelf-0.* libaio-0.* libaio-devel-0.* sysstat-9.* glibc-2.* glibc-common-2.* glibc-devel-2.*glibc-headers-2.* ksh-2* make-3.* libgcc-4.* libstdc++-4.* libstdc++-4.*.i686* libstdc++-devel-4.* gcc-4.*x86_64* gcc-c++- 4. "x86" 64 * elfutils-libelf-0*x86_64* elfutils-libelf-devel-0*x86_64* elfutils-libelf-0*i686* elfutils-libelf-devel-0*i686* libtool-ltdl*i686* ncurses*i686* unixODBC* Here, unixODBC,libaio,libaio-devel and others also need to install 32-bit packages.

Yum install-y binutils* compat* elfutils* libaio* sysstat* glibc* ksh* make* libgcc* libstdc* gcc* libtool* ncurses* readline* unixODBC* smartmontools*

If it cannot be installed, install it using the following command

Yum install compat*

You also need to install the following 32-bit packages:

Cd / mnt/Packages

Rpm-ivh unixODBC-2.2.14-12.el6_3.i686.rpm

Rpm-ivh unixODBC-devel-2.2.14-12.el6_3.i686.rpm

Rpm-ivh libaio-0.3.107-10.el6.i686.rpm

Rpm-ivh libaio-devel-0.3.107-10.el6.i686.rpm

Rpm-ivh libstdc++-4.4.7-4.el6.i686.rpm

Rpm-ivh libgcc-4.4.7-4.el6.i686.rpm

Rpm-ivh elfutils-libelf-0.152-1.el6.i686.rpm

Rpm-ivh compat-libstdc++-33-3.2.3-69.el6.i686.rpm

In addition, install the pdksh package separately:

Error pdksh conflicts with ksh-20100621-12.el6_2.1.x86_64

You also need to uninstall the ksh package first.

Rpm-e ksh-20100621-12.el6_2.1.x86_64

After uninstalling ksh, it will be easy.

Rpm-ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm

Modify 2.OS parameter a modify / etc/sysctl.conf file to add the following:

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 42949672960

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048586

Net.ipv4.tcp_wmem = 262144 262144 262144

Net.ipv4.tcp_rmem = 4194304 4194304 4194304

Execute:

/ sbin/sysctl-p

B modify / etc/security/limits.conf to add the following:

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

C modify / etc/pam.d/login to add the following:

Session required pam_limits.so

D modify / etc/profile

If [$USER = "oracle"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Umask 022

Fi

3. Create oracle belonging groups and add oracle users

Groupadd oinstall

Groupadd dba

Cd /

Mkdir-p / u01/oracle

Useradd-g oinstall-G dba-d / home/oracle oracle

Passwd oracle-set password for Oracle users

Create an oracle software installation directory

Mkdir-p / u01/oracle

Mkdir-p / u01/oraInventory

Chown-R oracle:oinstall / u01/oracle

Chmod-R 775 / U01

4.Oracle environment variable

Export ORACLE_BASE=/u01

Export ORACLE_HOME=$ORACLE_BASE/oracle

Export ORACLE_SID=orcl

Export PATH=$ORACLE_HOME/bin:$PATH

Install 1 configuration oraInst.loc file

1 this step is very important. If you ignore 1, you will eventually prompt that the inventory file directory is not empty, resulting in silent installation failure. It will be explained at the end of the article.

Vi / etc/oracle/olr.loc

Inventory_loc=/u01/oraInventory

Inst_group=oinstall

2 silently install database software

Using debug mode installation, if there is an exception, it is easier to find the cause of the error.

. / runInstaller-silent-debug-force-noconfig-IgnoreSysPreReqs\

Oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0\

Oracle.install.option=INSTALL_DB_SWONLY\

DECLINE_SECURITY_UPDATES=true\

UNIX_GROUP_NAME=oinstall\

INVENTORY_LOCATION=/u01/oraInventory\

SELECTED_LANGUAGES=en,zh_CN,zh_TW\

ORACLE_HOME=/u01/oracle\

ORACLE_BASE=/u01\

Oracle.install.db.InstallEdition=EE\

Oracle.install.db.isCustomInstall=false\

Oracle.install.db.DBA_GROUP=dba\

Oracle.install.db.OPER_GROUP=dba

Start silent installation of Oracle in the background. During installation, if you prompt [WARNING] to ignore it, the installer is still in the background, and if [FATAL] appears, the installer has stopped.

The following information is displayed when the installation is complete:

Sh / u01/oracle/oraInventory/orainstRoot.sh

Sh / u01/oracle/product/11.2.0/db / root.sh

The attached parameters for silent installation of oracle software are as follows:

-silent means to install silently without any prompts

-force means to allow installation to a non-empty directory

-noconfig indicates that the configuration assistant netca is not running

-responseFile indicates which response file to use. Absolute path is required.

Version of the oracle.install.responseFileVersion response file template. Do not change this parameter.

Oracle.install.option installation mode option. In this example, only oracle software is installed. Do not change this parameter.

Whether DECLINE_SECURITY_UPDATES needs online security update. Set it to false. Do not change this parameter.

The group name that the UNIX_GROUP_NAME oracle user uses to install the software

INVENTORY_LOCATION oracle product list catalogue

SELECTED_LANGUAGES oracle operating language environment, generally including citations and simplified and traditional Chinese

ORACLE_HOME oracle installation directory

ORACLE_BASE oracle basic directory

Oracle.install.db.InstallEdition installation version type, usually enterprise version

Whether to customize the installation of oracle.install.db.isCustomInstall is selected by default Partitioning,OLAP,RAT. Select components according to your needs.

Oracle.install.db.customComponents custom installation component list: in addition to the above default, Label Security and Database Vault can be added

The group name used by the oracle.install.db.DBA_GROUP oracle user to grant osdba permissions

The group name used by the oracle.install.db.OPER_GROUP oracle user to grant osoper permissions

3 install db silently

After installing the oracle software, we haven't created the db yet, so we can continue to create the database silently.

Dbca-silent-responseFile / u01/database/dbca.rsp

The content of the dbca.rsp file is as follows: modify it according to your own scene.

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "orcl"

SID = "orcl"

TEMPLATENAME = "New_Database.dbt"

SYSPASSWORD = "oraclesys"

SYSTEMPASSWORD = "oraclesys"

SYSMANPASSWORD = "oraclesys"

DBSNMPPASSWORD = "oraclesys"

DATAFILEDESTINATION = "/ u01/oracle/oradata"

STORAGETYPE=FS

CHARACTERSET = "AL32UTF8"

DATABASETYPE = "MULTIPURPOSE"

AUTOMATICMEMORYMANAGEMENT = "FALSE"

TOTALMEMORY = 8192

The process of silent installation is as follows:

4 configure network monitoring

Netca-silent-responsefile / u01/database/response/netca.rsp

This piece took a long time, and the final listening file, listener.ora, is as follows:

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = 10-0-0-209) (PORT = 1521))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(sid_name = orcl)

(oracle_home = / u01/oracle)

)

)

ADR_BASE_LISTENER = / U01

Lsnrctl status determines the monitoring status

Over.

5 log in to the database

Third, the problems encountered

Problem one, I believe this problem will also be encountered by many people.

1. [FATAL] [INS-32035] Unable to create a new central inventory at the specified location.

2. CAUSE: The central inventory location provided is not empty.

3. ACTION: Please provide another location for the inventory, or clean up the current location.

Solution:

Use root vim / etc/oracle/olr.loc to join

1. Inventory_loc=/u01/oraInventory

2. Inst_group=oinstall

Question two

1. [WARNING] [INS-32055] The Central Inventory is located in the Oracle base.

2. CAUSE: The Central Inventory is located in the Oracle base.

3. ACTION: Oracle recommends placing this Central Inventory in a location outside the Oracle base directory.

Solution:

As prompted, the Inventory directory is installed in the $ORACLE_BASE directory, so adjusting the Inventory directory is not under the $ORACLE_BASE directory to solve the problem.

OraInventory stores the directory information for the installation of Oracle software, which is needed for Oralce installation and upgrade. Deleting or losing the contents of the oraInventory directory will cause the installation / upgrade to fail.

The description of oraInventory in the official Oracle documentation:

1. All Oracle software installations rely on this directory.

2. Ensure that you back it up regularly.

3. Do not delete this directory unless you have completely removed

4. All Oracle software from the system.

The location of the oraInventory directory is determined by the oraInst.loc file:

/ etc/oracle/olr.loc (AIX and Linux Platform)

/ var/opt/oracle/OraInst.loc (Solaris and HP-UX platform)

Four summaries

To say something beside the point because of the project needs to install an oracle system, Google, du Niang silent installation and other key words, most articles are basically the same. I wonder if the person who wrote the article really succeeded in installing it. Does the person who says learning praise on the forum have hands-on verification?

If you feel shallow on paper, you must put it into practice.

To be a reliable person, it is more necessary to be a technically reliable dba.

Error occurred: [FATAL] PRVF-0002: Could not retrieve local nodename

Add the following to / etc/hosts:

Ip Hostnam

An error occurred when the Oracle user executed the dbca command:

DISPLAY not set. Please set the DISPLAY and try again

[solution]:

Switch to the oracle user and execute the following command:

Export DISPLAY=:0.0

At this point, the study of "detailed steps for silently installing oracle11g under linux" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.