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

This article mainly introduces how to use the yum source to install oracle 11g database, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

* JDK installation *

JDK installation (both database server and application server need to be installed)

* JDK version (JDK1.6.0_29) *

1. Log in using the root user

two。 Modify the execution permissions of the installation file

$chmod 755 / java/jdk-6u29-linux-x64.bin

3. Run the command to execute the installer

$. / jdk-6u29-linux-x64.bin

4. Installation complete. Press any key to exit successfully.

JDK configuration

1. Modify the / etc/profile file to configure environment variables.

JAVA_HOME=/usr/java/jdk1.6.0_29

CLASSPATH=.:$JAVA_HOME/lib/tools.jar

PATH=$JAVA_HOME/bin:$PATH

Export JAVA_HOME CLASSPATH PATH

In this way, after all users log back in, they will get the new environment variables.

two。 After logging out, log in again and verify the Java installation information.

# java-version

Display information:

[root@rhel6 ~] # java-version

Java version "1.6.029"

Java (TM) SE Runtime Environment (build 1.6.0_38-b05)

Java HotSpot (TM) 64-Bit Server VM (build 20.13-b02, mixed mode)

So far, JDK has been installed successfully.

*

# #

Install the required software

-- the environment required for oracle

Yum install binutils-2.* compat-libstdc++-33* elfutils-libelf-0.* elfutils-libelf-devel-* gcc-4.* gcc-c++-4.* glibc-2.* glibc-common-2.* glibc-devel-2.* glibc-headers-2.* ksh-2* libaio-0.* libaio-devel-0.* libgcc-4.* libstdc++-4.* libstdc++-devel-4.* make-3.* sysstat-7.* unixODBC-2.* unixODBC-devel-2.* pdksh*

-- for decompression and remote access

Yum install unzip zip xterm xorg-x11-xauth

Modify kernel vim / etc/sysctl.conf-to be discussed

Kernel.sem = 250 32000 100 142

Kernel.shmall = 4294967296

Kernel.shmmax = 68719476736

Kernel.shmmni = 4096

Kernel.msgmax = 8192

Kernel.msgmnb = 65535

Kernel.msgmni = 2878

Fs.file-max = 6815744

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 4621440

Net.core.rmem_max = 4621440

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Fs.aio-max-nr = 1048576

Make the parameters take effect immediately reflected in the current system: sysctl-p

Edit the / etc/security/limits.conf file. Add the following at the end of the file:

* hard nofile 65536

* soft nofile 4096

* hard nproc 16384

* soft nproc 2047

* hard stack 16384

* soft stack 10240

/ etc/pam.d/login add session required pam_limits.so at the end

-add user

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba oracle

Passwd oracle

Log in as oracle user

Su-oracle

Cd

Modify the environment variable: vi .pash _ profile

Umask=022

TMP=/tmp

TMPDIR=$TMP

Export TMP TMPDIR

ORACLE_SID=SUNTX

ORACLE_BASE=/app1/oracle

Export ORACLE_SID ORACLE_BASE

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

PATH=/usr/sbin:$PATH

PATH=$ORACLE_HOME/bin:$PATH

Export PATH

Export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Create a directory: mkdir / app/software

Mkdir-p / app1/oracle/product/11.2.0/db_1

Ftp uploads oracle installation package to / app/software directory

Xstart (run command: / usr/bin/xterm-ls-display $DISPLAY)

Log in and decompress-". / runInstaller

. / runInstaller after the installation is complete, execute two sh scripts under the root identity when prompted

[root@oracle ~] # cd / app/oraInventory/

[root@oracle oraInventory] #. / orainstRoot.sh

[root@oracle oraInventory] # cd / app/oracle/product/11.2.0/dbhome_1/

[root@oracle dbhome_1] #. / root.sh

Netca (create snooping)

Dbca (create instance)

Define character set content

1 character set check "Use Unicode (AL32UTF8)"

2 National character set, select "AL16UTF16"

3 default language, select "English"

4 default region, select "China"

After the netca (create tns) is complete, the tnsnames.ora file should contain the following in the server's directory / app1/oracle/product/11.2.0/db_1/network/admin:

SUNTX =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 10.80.36.143) (PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = SUNTX)

)

)

# #

If you want to use sql connections, you need to turn off the firewall.

Turn off the firewall: # service iptables stop / / effective immediately

# chkconfig iptables off / / No recovery after restart

* * *

%%

Turn off SELinux:

1. Temporarily shut down (no need to restart the machine):

Setenforce 0 # # set SELinux to permissive mode

# # setenforce 1 sets SELinux to enforcing mode

2. To modify the configuration file, you need to restart the machine:

Modify / etc/selinux/config file

Change SELINUX=enforcing to SELINUX=disabled

Just restart the machine.

# #

About selinux

When I first joined the profession, I studied it for a long time, mainly because I was relatively idle at that time. Stuck to it and did it on his own testing machine. Later, when I got busy, I found that the product was really a waste of time, so I closed it.

Another important point is that this product will restrict access and directly kill the process.

Take the hadoop cluster as an example:

The master node needs to be able to log in to each child node without password ssh. If SELinux is not closed, ssh password-free login will be restricted.

Thank you for reading this article carefully. I hope the article "how to install oracle 11g database using yum source" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.