Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Construction LVM-based raw device Oracle10g Database on Oracle Linux 5.11     - Math objects easily overlooked but very convenient method --JavaScript (Programming)

- Supervisor Installation and Configuration (Server)

- Java environment to build a number of issues (Linux)

- Java object serialization (Programming)

- Build RPM package uses Docker mirror (Linux)

- Using FTPClient to upload and download files in Java (Programming)

- Monitor traffic Linux Shell Edition (Programming)

- Python kills corresponding process according to pid (Programming)

- Linux Powerful command Awk Introduction (Linux)

- Using Ruby to build a simple HTTP service and sass environment (Server)

- MySQL and MariaDB new master from the cluster configuration GTID (Database)

- Linux Getting Started tutorial: Experience QEMU virtual machine articles (Linux)

- Linux environment variables inside (Linux)

- How to fix Not Enough Free Disk Space On / boot on Ubuntu (Linux)

- Introduction and use of the Raspberry Pi (Linux)

- Oracle 12C RAC on temporary table space Enlighten (Database)

- Build the first ASP.NET 5 Web project in Mac OS X Yosemite 10.10.3 (Server)

- 6 common PHP security attacks (Linux)

- MongoDB Installation under CentOS 6.6 (Database)

- CentOS7 install JAVA notes (Linux)

 
         
  Construction LVM-based raw device Oracle10g Database on Oracle Linux 5.11
     
  Add Date : 2018-11-21      
         
         
         
  Software: VMware11

Operating System: Oracle Linux 5.11 x64
Database: Oracle 10.2.0.5 x64
Host Name: odb.test.local
IP address: 192.168.223.100 # using a virtual machine host network
Examples: odb

First, the system is installed
Process slightly, the installation process, select GNOME Desktop environment, "Development Libraries", "Development Tools", "Legacy Software Development" remember the election on installation, and other according to the default, such as JAVA, do not install OFFICE like.
Second, the system basic configuration
1. Insert the CD-ROM is configured as a local yum install source
[Root @ odb ~] # cd /etc/yum.repos.d/
[Root @ odb yum.repos.d] # cat local.repo
[Local]
name = local
baseurl = file: /// media / cdrom / Server
gpgcheck = 0
enable = 1
 
2. Disable selinux, iptables Service
[Root @ odb ~] # sed -i 's / = enforcing / = disabled / g' / etc / sysconfig / selinux
[Root @ odb ~] # chkconfig iptables off
[Root @ odb ~] # chkconfig ip6tables off
Other system services according to the actual situation of disabled
 
3. Install oracle-validated package, carry out pre-oracle environment configuration
[Root @ odb ~] # yum -y install oracle-validated.x86_64
[Root @ odb ~] # oracle-validated-verify
Automatically after executing the command oracle install the necessary software environment configuration, such as installing missing packages, add sysctl configuration, ulimited related, etc., as the oracle user, like the dba group is automatically created when the system is installed, use this than the much more convenient to use CentOS
[Root @ odb ~] # sed -i '1i RedHat 4' / etc / redhat-release
[Root @ odb ~] # sed -i '$ a 192.168.223.100 odb.test.local odb' / etc / hosts
 
4. Install rlwrap software (can sqlplus when using this software increases up and down history records and other functions)
[Root @ odb ~] # tar -xf rlwrap-0.42.tar.gz -C / tmp /
[Root @ odb ~] # cd /tmp/rlwrap-0.42/
[Root @ odb rlwrap-0.42] # ./configure; make all; make install
 
5. Install vmware-tools, process slightly
6. Installation and Configuration vncserver
[Oracle @ odb ~] # yum -y install vncserver
[Oracle @ odb ~] # cd / etc / sysconfig /
[Oracle @ odb sysconfig] # vim vncservers
VNCSERVERS = "1: root"
VNCSERVERARGS [1] = "- geometry 1024x768 -depth 24"
After a good save after configuration,
[Root @ odb ~] # vncserver # first performance will be prompted to enter vnc password, and automatically generate the initial configuration in the user directory
[Root @ odb ~] # cd .vnc
[Root @ odb .vnc] # vim xstartup
#! / Bin / sh
 
# Uncomment the following two lines for normal desktop:
unset SESSION_MANAGER
exec / etc / X11 / xinit / xinitrc
 
[-x / Etc / vnc / xstartup] && exec / etc / vnc / xstartup
[-r $ HOME / .Xresources] && xrdb $ HOME / .Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24 + 10 + 10 -ls -title "$ VNCDESKTOP Desktop" &
#twm &
gnome-session &
It is easy to modify, the upper two rows of red uncommented, comment out the last line, add the use of gnome-session & on the line
 
7. Set the oracle installation directory, basic environment
[Root @ odb ~] # mkdir -p / opt / oracle /
[Root @ odb ~] # chown -R oracle: oinstall / opt / oracle /
[Root @ odb ~] # chmod -R 775 / opt / oracle /
Add oracle environment variables
[Oracle @ odb ~] $ su - oracle
[Oracle @ odb ~] $ vim .bash_profile # add the following
 
export ORACLE_SID = odb
export ORACLE_BASE = / opt / oracle
export ORACLE_HOME = $ ORACLE_BASE / product / 10.2.0 / db_1
export PATH = $ PATH: $ ORACLE_HOME / bin
export ORACLE_TERM = xterm
export LD_LIBRARY_PATH = $ LD_LIBRARY_PATH: $ ORACLE_HOME / lib
export CLASSPATH = $ ORACLE_HOME / jre: $ ORACLE_HOME / jlib: $ ORACLE_HOME / rdbms / jlib
alias sqlplus = 'rlwrap sqlplus'
alias rman = 'rlwrap rman'
 
Three, Oracle database software installation
Preliminary work done in preparation for the formal installation of oracle database using vnc client to connect to the server (how to connect this can not be taught, and their information search bar), when connected, open a new terminal
[Root @ odb ~] # xhost +
access control disabled, clients can connect from any host
[Root @ odb ~] # export DISPLAY =: 1
[Root @ odb ~] # su - oracle
 
[Oracle @ odb ~] $ cpio -idmv [Oracle @ odb ~] $ cd database /
[Oracle @ odb database] $ ./runInstaller
Back is the graphical installation process, and do not bother to say, if some pass, you can modify the prompts, you can choose to only install the software when installed in the environment inspection.
After installing the patch installation
[Oracle @ odb ~] $ unzip /mnt/hgfs/Oracle/Oracle10g/linux.x64/p8202632_10205_Linux-x86-64.zip -d.
[Oracle @ odb ~] $ cd Disk1 /
[Oracle @ odb Disk1] $ ./runInstaller
It is a graphical interface, process too lazy to say
 
Fourth, the raw device environment configuration
1. Online scsi add a virtual hard disk, and use the following methods to restart the system to recognize when not to
[Root @ odb ~] # echo "- - -"> / sys / class / scsi_host / host0 / scan
2. Create a logical volume group and related
[Root @ odb ~] # fdisk / dev / sdb # to create a separate partition
[Root @ odb ~] # pvcreate / dev / sdb1
[Root @ odb ~] # vgcreate oradata / dev / sdb1
Then create oracle database need lvm logical volumes
lvcreate -L 8M -n lv_spfile oradata
lvcreate -L 20M -n lv_control01 oradata
lvcreate -L 20M -n lv_control02 oradata
lvcreate -L 20M -n lv_control03 oradata
lvcreate -L 100M -n lv_redo01 oradata
lvcreate -L 100M -n lv_redo02 oradata
lvcreate -L 100M -n lv_redo03 oradata
lvcreate -L 1g -n lv_system01 oradata
lvcreate -L 1g -n lv_sysaux01 ​​oradata
lvcreate -L 1g -n lv_users01 oradata
lvcreate -L 1g -n lv_undo01 oradata
lvcreate -L 1g -n lv_temp01 oradata
Once created using lvscan glance
[Root @ odb ~] # lvscan
  / Dev / hdc: open failed: No medium found
  ACTIVE '/ dev / oradata / lv_spfile' [8.00 MB] inherit
  ACTIVE '/ dev / oradata / lv_control01' [20.00 MB] inherit
  ACTIVE '/ dev / oradata / lv_control02' [20.00 MB] inherit
  ACTIVE '/ dev / oradata / lv_control03' [20.00 MB] inherit
  ACTIVE '/ dev / oradata / lv_redo01' [100.00 MB] inherit
  ACTIVE '/ dev / oradata / lv_redo02' [100.00 MB] inherit
  ACTIVE '/ dev / oradata / lv_redo03' [100.00 MB] inherit
  ACTIVE '/ dev / oradata / lv_system01' [1.00 GB] inherit
  ACTIVE '/ dev / oradata / lv_sysaux01' [1.00 GB] inherit
  ACTIVE '/ dev / oradata / lv_users01' [1.00 GB] inherit
  ACTIVE '/ dev / oradata / lv_undo01' [1.00 GB] inherit
  ACTIVE '/ dev / oradata / lv_temp01' [1.00 GB] inherit
  ACTIVE '/ dev / VolGroup00 / LogVol00' [14.06 GB] inherit
  ACTIVE '/ dev / VolGroup00 / LogVol01' [5.81 GB] inherit
3. Bind the raw device, and set the boot automatically load
[Root @ odb ~] # vim / etc / sysconfig / rawdevices
/ Dev / raw / raw1 / dev / oradata / lv_spfile
/ Dev / raw / raw2 / dev / oradata / lv_control01
/ Dev / raw / raw3 / dev / oradata / lv_control02
/ Dev / raw / raw4 / dev / oradata / lv_control03
/ Dev / raw / raw5 / dev / oradata / lv_redo01
/ Dev / raw / raw6 / dev / oradata / lv_redo02
/ Dev / raw / raw7 / dev / oradata / lv_redo03
/ Dev / raw / raw8 / dev / oradata / lv_sysaux01
/ Dev / raw / raw9 / dev / oradata / lv_system01
/ Dev / raw / raw10 / dev / oradata / lv_users01
/ Dev / raw / raw11 / dev / oradata / lv_undo01
/ Dev / raw / raw12 / dev / oradata / lv_temp01
[Root @ odb ~] # chkconfig rawdevices on
[Root @ odb ~] # /etc/init.d/rawdevices start

[Root @ odb ~] # ll / dev / raw *
total 0
cr - r ----- 1 root root 162, 1 Jan 18 21:52 raw1
cr - r ----- 1 root root 162, 10 Jan 18 21:52 raw10
cr - r ----- 1 root root 162, 11 Jan 18 21:52 raw11
cr - r ----- 1 root root 162, 12 Jan 18 21:52 raw12
cr - r ----- 1 root root 162, 2 Jan 18 21:52 raw2
cr - r ----- 1 root root 162, 3 Jan 18 21:52 raw3
cr - r ----- 1 root root 162, 4 Jan 18 21:52 raw4
cr - r ----- 1 root root 162, 5 Jan 18 21:52 raw5
cr - r ----- 1 root root 162, 6 Jan 18 21:52 raw6
cr - r ----- 1 root root 162, 7 Jan 18 21:52 raw7
cr - r ----- 1 root root 162, 8 Jan 18 21:52 raw8
cr - r ----- 1 root root 162, 9 Jan 18 21:52 raw9
 
4. Set the raw device is a group and access rights (direct modification is useless after the restart will automatically recover root is a group)
[Root @ odb ~] # vim /etc/udev/rules.d/60-raw.rules
ACTION == "add", KERNEL == "raw *", OWNER = "oracle", GROUP = "dba", MODE = "0660"
[Root @ odb ~] # start_udev
Starting udev: [OK]
[Root @ odb ~] # ll / dev / raw *
crw-rw ---- 1 oracle dba 162, 0 Jan 18 21:52 / dev / rawctl
 
/ Dev / raw:
total 0
crw-rw ---- 1 oracle dba 162, 1 Jan 18 21:52 raw1
crw-rw ---- 1 oracle dba 162, 10 Jan 18 21:52 raw10
crw-rw ---- 1 oracle dba 162, 11 Jan 18 21:52 raw11
crw-rw ---- 1 oracle dba 162, 12 Jan 18 21:52 raw12
crw-rw ---- 1 oracle dba 162, 2 Jan 18 21:52 raw2
crw-rw ---- 1 oracle dba 162, 3 Jan 18 21:52 raw3
crw-rw ---- 1 oracle dba 162, 4 Jan 18 21:52 raw4
crw-rw ---- 1 oracle dba 162, 5 Jan 18 21:52 raw5
crw-rw ---- 1 oracle dba 162, 6 Jan 18 21:52 raw6
crw-rw ---- 1 oracle dba 162, 7 Jan 18 21:52 raw7
crw-rw ---- 1 oracle dba 162, 8 Jan 18 21:52 raw8
crw-rw ---- 1 oracle dba 162, 9 Jan 18 21:52 raw9
 
5. Create a data file points to the raw device soft link
[Root @ odb ~] # mkdir -p / opt / oracle / oradata / odb
ln -s / dev / raw / raw1 / opt / oracle / oradata / odb / spfile
ln -s / dev / raw / raw2 / opt / oracle / oradata / odb / control01
ln -s / dev / raw / raw3 / opt / oracle / oradata / odb / control02
ln -s / dev / raw / raw4 / opt / oracle / oradata / odb / control03
ln -s / dev / raw / raw5 / opt / oracle / oradata / odb / redo01
ln -s / dev / raw / raw6 / opt / oracle / oradata / odb / redo02
ln -s / dev / raw / raw7 / opt / oracle / oradata / odb / redo03
ln -s / dev / raw / raw8 / opt / oracle / oradata / odb / sysaux01
ln -s / dev / raw / raw9 / opt / oracle / oradata / odb / system01
ln -s / dev / raw / raw10 / opt / oracle / oradata / odb / users01
ln -s / dev / raw / raw11 / opt / oracle / oradata / odb / undo01
ln -s / dev / raw / raw12 / opt / oracle / oradata / odb / temp01
After creating the soft connection, it is recommended is a group and permissions of these files can also change what links
[Root @ odb ~] # chown -R oracle: oinstall / opt / oracle / oradata / odb /
[Root @ odb ~] # chmod -R 775 / opt / oracle / oradata / odb /
 
6. Create a raw device mapping file DBCA_RAW_CONFIG.txt
[Root @ odb ~] # su - oracle
[Oracle @ odb ~] $ vim DBCA_RAW_CONFIG.txt
spfile = / opt / oracle / oradata / spfile
control1 = / opt / oracle / oradata / odb / control01
control2 = / opt / oracle / oradata / odb / control02
control3 = / opt / oracle / oradata / odb / control03
redo1_1 = / opt / oracle / oradata / odb / redo01
redo2_1 = / opt / oracle / oradata / odb / redo02
redo3_1 = / opt / oracle / oradata / odb / redo03
sysaux = / opt / oracle / oradata / odb / sysaux01
system = / opt / oracle / oradata / odb / system01
users = / opt / oracle / oradata / odb / users01
undotbs1 = / opt / oracle / oradata / odb / undo01
temp = / opt / oracle / oradata / odb / temp01
 
7. The first run netca create LISTENTER TNSNAMES and the like, the process is slightly
8. Run DBCA to create the database
[Oracle @ odb ~] $ export DBCA_RAW_CONFIG = / home / oracle / DBCA_RAW_CONFIG.txt
[Oracle @ odb ~] $ dbca
Slightly behind the installation process, recommended to choose custom installation, the installation process if not to the raw device file, you can manually specify the soft link file location
 
These are the bare LVM-based installation ORACLE database approach.
     
         
         
         
  More:      
 
- Use Swift remove the spaces in the string (Programming)
- JavaScript prototype and prototype chain and project combat (Programming)
- VMware ghost Linux card error (Linux)
- Swift acquaintance of values and references, the circular reference, Agent Precautions (Programming)
- Linux GCC 5.1.0 compiler installation (Linux)
- Servlet 3.0 interfaces of AsyncListener (Programming)
- To get Java class / jar package path (Programming)
- Android working with Volley Comments (Programming)
- LinkedList Basic Usage (Programming)
- On event processing browser compatibility notes (Programming)
- C language print various graphic (Programming)
- Those functions under Linux you do not know the df command (Linux)
- Linux FTP setting file description (Server)
- Linux novice common commands (Linux)
- Redis logging system (Database)
- Flask installation environment (Linux)
- Interesting example of Linux Sort command (Linux)
- MySQL database master never solve the synchronization method (Database)
- PHP Performance Analysis and Experiment: Performance Micro Analysis (Programming)
- Raspberry Pi 2 to install the latest version of the FPC and Lazarus 1.5 (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.