Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Install Oracle 11g illustrations and dependent libraries under SUSE11     - Commonly used Linux system camouflage method (Linux)

- Into the Java keyword instanceof (Programming)

- When RHEL7 use fdisk partition, all partitions can not be used (Linux)

- Using the Linux folder wc statistics number of lines of code for all files (including subdirectories) (Linux)

- RHEL5 establish a local yum source (Linux)

- MongoDB uses aggregate, group, match mysql achieve in having (count (1)> 1) features (Database)

- How do I delete a NEEDS RECOVERY rollback state of undo tablespace (Database)

- Linux gprof oprofiling and performance testing tools (Linux)

- To create someone else can not afford to delete the administrator user (Linux)

- Using Vagrant to build multi-platform environment (Server)

- MySQL Data Types (Database)

- Swift string common method (Programming)

- ORA-12154: TNS: could not resolve the connect identifier specified solve (Database)

- How to install CentOS CentOS web page (Server)

- Linux boot process and run level (Linux)

- CentOS7 installation GAMIT and GMT (Linux)

- Ubuntu 15.04 using the Eclipse 4.4, Java 8 and WTP (Linux)

- HBase Application Development Review and Summary of Series (Database)

- YUM install desktop environment in CentOS (Linux)

- Linux loopback adapter Driven Design (Programming)

 
         
  Install Oracle 11g illustrations and dependent libraries under SUSE11
     
  Add Date : 2018-11-21      
         
         
         
  Installation Environment

Linux server: SUSE11-linux 64/32 bit
Oracle Server: Oracle11gR2 64/32 bit
System Requirements

Memory: must be higher than 1G of physical memory
Swap space: generally 2 times the memory, for example: 1G memory can be set to swap partition size to 3G
Hard: 5G more
Installation package

In order to select the correct version of ORACLE, we need to understand some basic information about the server: the system name for the SUSE Linux Enterprise Server 11 (x86_64), so our ORACLE installation package for: linux.x64_11gR2_database_1of2.zip and linux.x64_11gR2_database_2of2.zip.
On SUSE 11, Oracle 11g installation must rely on the following packages (Oracle official installation documentation can be found based on system version):
binutils-2.19
gcc-4.3
gcc-c ++ - 4.3
glibc-2.9
glibc-devel-2.9
ksh-93t
libstdc ++ 33-3.3.3
libstdc ++ 43-4.3.3_20081022
libstdc ++ 43-devel-4.3.3_20081022
libaio-0.3.104
libaio-devel-0.3.104
libgcc43-4.3.3_20081022
libstdc ++ - devel-4.3
make-3.81
sysstat-8.1.5
You can use the following command to view these packages have not been installed:

rpm -qa | grep *

Such as:
rpm -qa | grep binutils

Required version must be equal to greater than the above versions, and if not, locate the package and install the above packages can be found in the SUSE installation disk: / suse / x86-64.

If dependencies are not installed, install

System Configuration

First, perform the following steps under the root user:

1) modify the user's SHELL limit, modify /etc/security/limits.conf file, enter the command: vi /etc/security/limits.conf, press i key to enter the edit mode, the following was added to the file

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

2) Modify /etc/pam.d/login file, enter the command: vi /etc/pam.d/login, press i key to enter the edit mode, the following was added to the file after editing press the Esc key, enter ": wq "save and exit. (if not configured when you will be prompted to install anything less space, less than xxx ... claim can not be installed),

session required /lib/security/pam_limits.so
session required pam_limits.so
Edit When finished, press the Esc key, enter ": wq" to save and exit

3) Modify the linux kernel, modify /etc/sysctl.conf file

fs.file-max = 6815744

fs.aio-max-nr = 1048576

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

 4) To make the /etc/sysctl.conf changes take effect immediately, execute the following command.

Input: sysctl -p

5) Edit / etc / profile, enter the command: vi / etc / profile, press i key to enter the edit mode, the following was added to the file

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

Edit When finished, press the Esc key, enter ": wq" to save and exit

 6) Create relevant users and groups, as software installation and support team owner

Create a user group, enter the command:

groupadd oinstall
groupadd dba

(Create users and groups)

Creating Oracle user and password, enter the command to give permission :()

useradd -d / home / oracle -g oinstall -G dba -m oracle

passwd oracle

Then let you enter a password, enter the password at any second, but it must be consistent Confirm

7) Create a directory database software and data files and directories, directory, according to their own situation to be, watch the disk space can be, where I put it into the oracle user, for example:

Enter the command:

mkdir -p / opt / oracle

mkdir -p / opt / oracle / oradata

8) Change directory owner, all for the Oracle user, enter the command:

chown -R oracle: oinstall / opt / oracle

chmod 755 -R / opt / oracle

Perform the following steps in the oracle user:

9) configuring the oracle user's environment variables, first, switch to the oracle user under the newly created

Enter: su - oracle, then directly enter: vi /home/oracle/.bash_profile,

Press i edit .bash_profile (Note: You can also configure the .profile oracle installation path or .bashrc file), enter edit mode, add the following:

umask 022

export ORACLE_BASE = / opt / oracle

export ORACLE_HOME = $ ORACLE_BASE / product / 11.0.1 / db_1

export ORACLE_SID = orcl

export PATH = $ ORACLE_HOME / bin: $ PATH

export LC_ALL = "en_us"

export LANG = "en_us"

export NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"

export NLS_DATE_FORMAT = "YYYY-MM-DD HH24: MI: SS"

Edit When finished, press the Esc key, enter ": wq" to save and exit

Configuring the oracle user environment variables

oracle @ linux-unvz: ~> vi .bashrc

export ORACLE_BASE = / opt / oracle

export ORACLE_HOME = $ ORACLE_BASE / product / 11.0.1 / db_1

export ORACLE_SID = orcl

export PATH = $ PATH: $ HOME / bin: $ ORACLE_HOME / bin

export LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / usr / lib

export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.AL32UTF8"

Save and exit;

Install oracle system

1, when the above-described system requires all operations completed, log off the system, the graphical interface to the oracle user login. First, download the Oracle package to install linux, it is recommended to use the copy ftp Xmanager or other tools,

The oracle installation package linux_11gR2_database.zip transmitted by oracle user / opt / oracle at

(The following two steps need to be performed under the root user)

Unzip

unzip linux.x64_11gR2_database_1of2.zip

unzip linux.x64_11gR2_database_2of2.zip

Confers just unzipped folder permissions

chmod 777 -R / opt / oracle / database /

2, the installation oracle database software on the user oracle

 Enter the command:
  cd / opt / oracle / database
  ./runInstaller

3, to solve the garbage (not the same character set, then the installation may be garbled, resolved as follows :)

Enter the command:

export LANG = en_US

If you start the graphical interface error, the solution is as follows

linux-unvz: ~ # vi / etc / hosts

192.168.100.84 hostname

Establishment of the database

1) or in the Oracle user graphical interface oracle users, open a new terminal, enter commands directly dbca following interface will pop up.

Here we use custom database, if not start Note .bash_profile environment variables and display issues (xclock, xhost +)

Configure the monitoring network and local services

1) in the Oracle user graphical interface oracle users, open a new terminal, enter the command netca configuration interface will pop up

Create monitoring services (acting as oracle server, allowing other clients to connect oracle The oracle server)

Select the connection is tested

(If you do not test is successful, check the network is smooth, whether oracle connected server starts listening for whether to activate other reasons)


Start the database

1, the default database established after the start, and if the server is restarted, it would have to start it manually, the command is as follows:

export ORACLE_SID = orcl (choose their start database SID)

echo $ ORACLE_SID (display instance name)

connect / as sysdba

startup

2, start listening

First exit above to start a database of sql execution, use quit or exit to exit to common command line

Start the listener: lsnrctl start (if this is not the default listener name, then start your monitor corresponding name)

Establishment of table space ------------ ### Reference Network

1, create a temporary table space, create a temporary table space must first create a database table space between the front and two user table space, or else use the default table space is not good

create temporary tablespace ha_temp tempfile '/ u01 / app / oracle / oradata / orcl / ha_temp.dbf' size 1024m autoextend on next 100m maxsize 10240m extent management local;

Explanation:

1) zd_temp temporary table space name

2) / u01 / app / oracle / oradata / orcl / database file to hold the place, usually after the installation database has control files, data files and log files folder, plus the name of the table to create space + dbf (data file)

3) The initial size of the table space 1024m

4) 100m automatically increase the size of the table space

5) 10240m maximum size of the table space

2. Create a data table space

create tablespace ha logging datafile '/ u01 / app / oracle / oradata / orcl / ha.dbf' size 1024m autoextend on next 100m maxsize 10240m extent management local;

3, create a user and specify the table space

create user ha1 identified by zd315 default tablespace ha;

4, grant privileges to users

grant dba, connect, resource, CTXAPP, create view to ha1;

Under linux imp dmp file import oracle database

 Enter the command:

imp ha1 / zd315 @ orcl file = / opt / oracle / hadrp.dmp ignore = y full = y

Description: ha1: user name;

            zd315: password;

          orcl: database instance name;

          Behind file is the path dmp file placement.
     
         
         
         
  More:      
 
- To install MySQL 5.6 binary packages under CentOS 6.4 64bit (Database)
- Unetbootin make use U disk loading Linux system (Linux)
- Fedora && Arch Linux - the most romantic thing to happen now (Linux)
- VMware installed Linux system and JDK deployment (Linux)
- Bad name two variables (Linux)
- Linux SU command security Suggestions (Linux)
- grep command Series: grep command to search for multiple words (Linux)
- rpm package specify the installation path (Linux)
- MySQL partition table Comments (Database)
- Oracle data files deleted recover after physical (Database)
- JavaScript file loader LABjs API Explanation (Programming)
- Simple solution CC attack under Linux VPS (Linux)
- Squid proxy server configuration under Linux (Server)
- PHP 5.3 New Features Detail (Linux)
- Linux system started to learn: Teaches you install Fedora 22 on VirtualBox (Linux)
- The Concept and Semantics of Java Memory Model (Programming)
- Zabbix using Omsa monitor hardware information of Dell server (Server)
- Confrontation dragged Library - Web front-end encryption slow (Linux)
- Nine trick to let you speed up the old machine running Ubuntu Linux (Linux)
- Several Ceph performance optimization of new methods and ideas (2015 SH Ceph Day after flu reference) (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.