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

Environment:

(1) Linux localhost.localdomain 2.6.32-358.el6.x86_64 # 1 SMP Tue Jan 29 11:47:41 EST 2013 x86 "64 GNU/Linux

(2) memory: 2GB

(3) hard disk capacity: 30g

(4) the system must have a desktop

(5) YUM is ready in advance.

(6) if you are operating on a virtual machine, mirror it in advance before performing the following steps.

Steps:

Cat 1.txt

Binutils gcc gcc-c++ gcc-32bit gcc43 gcc43-32bit glibc glibc-32bit glibc-devel glibc-devel-32bit ksh libaio libaio-devel libaio-devel-32bit libelf0 libelf1 libgcc43 libgcc43-32bit libstdc++33 libstdc++33-32bit libstdc++43 libstdc++43- 32bit libstdc++43-devel libstdc++43-devel-32bit libstdc++-devel libgomp43-32bit make sysstat libcap unixODBC

Then:

Execute script: sh install.sh

Here is the content of the script:

#! / bin/bash

For i in `cat 1.txt`

Do

Yum install-y $I

Done

#

Groupadd oinstall

Groupadd dba

#

Mkdir-p / opt/app

Useradd-g oinstall-G dba-d / opt/app/u01 oracle

#

Sh mkdi.sh

# useradd-g oinstall-G dba-d / opt/app/u01 oracle

#

Echo "123456" | passwd-- stdin oracle

#

Cp / etc/sysctl.conf / etc/sysctl.conf.bak

#

For i in `cat 2.txt`

Do

Echo $? > > / etc/sysctl.conf

Done

#

Sysctl-p

#

Cp / etc/security/limits.conf / etc/security/limits.conf.bak

#

Echo "oracle soft nproc 2047" > > / etc/security/limits.conf

Echo "oracle hard nproc 16384" > > / etc/security/limits.conf

Echo "oracle soft nofile 1024" > > / etc/security/limits.conf

Echo "oracle hard nofile 65536" > > / etc/security/limits.conf

Echo "oracle soft stack 10240" > > / etc/security/limits.conf

#

Echo "export ORACLE_BASE=/opt/app/product" > > / opt/app/u01/.bash_profile

Echo "export ORACLE_HOME=/opt/app/product/software" > > / opt/app/u01/.bash_profile

Echo "export ORACLE_SID=keyman" > > / opt/app/u01/.bash_profile

Echo "PATH=$PATH:$ORACLE_HOME/bin" > > / opt/app/u01/.bash_profile

#

Chown oracle:oinstall / opt/*

Note: the above can be written in a script and executed at one time.

After completing the above, restart to the oracle desktop user and extract the 2 oracle files

# unzip linux.x64_11gR2_database_1of2

# unzip linux.x64_11gR2_database_2of2

After completing the above actions, get a folder of database and enter into database:

#. / runInstaller execute the file in it

Note: put Oracle Base: / opt/app/product

Software Location: / opt/app/product/software

The rest can be done by default, and the next step will be fine.

When it comes to checking the package, ignore all, in the previous step, we have all installed

Even if it is still said that it is not installed, never mind it, it is a different version, in fact, it has already been installed.

Finally, finished, finish and quit.

So far, to take a breath, we have only installed oracle software, not oracle database or listening listener.

Complete the above steps and continue to do:

# netca configuration monitoring, step by step, all by default.

After completion:

# dbca configuration database. If this command is not recognized, then / opt/app/product/software/bin/dbca is fine.

Next, just do the next step. When configuring the password, you can write 123qweQWE and continue to the next step.

After waiting for 35, the database is complete, and then test it:

Simple verification

[oracle@powerlong4 ~] $sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 24 14:51:10 2015

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > create table z_test (id number,name varchar (20))

Table created.

SQL > insert into z_test select 1 from dual

1 row created.

SQL > select * from z_test

ID NAME

1 a

SQL > commit

Commit complete.

SQL > exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@powerlong4 ~] $

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.