Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ CentOS 6.5_x64 install Oracle 11g R2     - Install minimize RHEL / CentOS 7 things to do (Linux)

- C language preprocessor command (Programming)

- Memcached source installation and configuration under CentOS 6.6 (Server)

- C ++ containers (Programming)

- Linux performance monitoring and common commands Introduction (Linux)

- OpenResty load balancing MySQL (Database)

- Linux basic articles of the boot process (Linux)

- Remote installation of Net-SNMP whole process (Linux)

- Export error: ORA-04063: package body dmsys dbms dm model exp has error (Database)

- Add local search to your Android app (Programming)

- To compile and install MySQL 5.7.7 RC under CentOS 7.1 (Database)

- Boot-Repair Tool - repair of frequent start-up problems (Linux)

- Linux - use chroot command (Linux)

- CentOS Linux Optimization and real production environment (Linux)

- Use chattr and lsattr command to manage linux files and directory attributes (Linux)

- Linux smart small switch rfkill (Linux)

- Shell programming entry (Programming)

- Implement binary search algorithm in C language (Programming)

- Why do I prefer Git (Linux)

- Ubuntu 15.04 installation MATE 1.10 (Linux)

 
         
  CentOS 6.5_x64 install Oracle 11g R2
     
  Add Date : 2018-11-21      
         
         
         
  Installation environment:
Operating System: CentOS6.5_x64 Desktop
Host Name: Oracledb
Memory: 1G (official minimum requirement 1G)
Hard disk: 40G (install the required Enterprise Edition 4.29G and 1.7G data files)
System Preparation before installation:
# Modify the hostname
[Root @ oracledb ~] # sed -i "s / HOSTNAME = localhost.localdomain / HOSTNAME = oracledb /" / etc / sysconfig / network
[Root @ oracledb ~] # hostname oracledb
# Add the host name and IP corresponding record
[Root @ oracledb ~] # vi / etc / hosts
192.168.1.160 oracledb
# Close Selinux
[Root @ oracledb ~] # sed -i "s / SELINUX = enforcing / SELINUX = disabled /" / etc / selinux / config
[Root @ oracledb ~] # setenforce 0
1, the installation dependencies
[Root @ oracledb ~] # yum -y install gcc gcc-c ++ make binutilscompat-libstdc ++ - 33 elfutils-libelf elfutils-libelf-devel glibc glibc-commonglibc-devel
libaio libaio-devel libgcclibstdc ++ libstdc ++ - devel unixODBC unixODBC-devel

2, create users and groups
[Root @ oracledb ~] # sysctl -p
[Root @ oracledb ~] # groupadd -g 200 oinstall
[Root @ oracledb ~] # groupadd -g 201 dba
[Root @ oracledb ~] # useradd -u 440 -g oinstall -G dba oracle
[Root @ oracledb ~] # passwd oracle

3, modify the kernel parameters
[Root @ oracledb ~] # vi / etc / sysctl.conf # end add the following
net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 6815744
kernel.shmall = 10523004
kernel.shmmax = 6465333657
kernel.shmmni = 4096
kernel.sem = 250 32000 100128
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576

4, modify the system resource limits
[Root @ oracledb ~] # vi / etc / security / limits.conf # end add the following
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

[Root @ oracledb ~] # vi / etc / pam.d / login
Add session required pam_namespace.so # following a pam_limits.so
session required pam_limits.so


123456789 [root @ oracledb ~] # vi / etc / profile # This feels not much use
if [$ USER = "oracle"]; then
      if [$ SHELL = "/ bin / ksh"]; then
          ulimit -p 16384
          ulimit -n 65536
      else
          ulimit -u 16384 -n 65536
      fi
fi

5. Create an installation directory and set permissions

[Root @ oracledb ~] # mkdir / opt / oracle / app /
[Root @ oracledb ~] # mkdir / opt / oracle / oradata /
[Root @ oracledb ~] # chmod 755 / opt / oracle /
[Root @ oracledb ~] # chmod 775 / opt / oracle / app /
[Root @ oracledb ~] # chown oracle.oinstall -R / opt / oracle /

6, set the environment variable oracle

[Oracle @ oracledb ~] $ vi ~ / .bash_profile
exportORACLE_BASE = / opt / oracle / app
exportORACLE_HOME = $ ORACLE_BASE / product / 11.2.0 / dbhome_1
exportPATH = $ PATH: $ ORACLE_HOME / bin
export ROACLE_PID = orcl
[Oracle @ oracledb ~] $ source .bash_profile # effective immediately

7, the installation oracle

Download and unzip:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
[Root @ oracledb ~] # unzip /media/linux.x64_11gR2_database_1of2.zip
[Root @ oracledb ~] # unzip /media/linux.x64_11gR2_database_2of2.zip
[Root @ oracledb ~] # xhost + # so that all users can access the graphical desktop
[Root @ oracledb ~] # su -oracle
[Oracle @ oracle ~] #. / Media / database / runInstaller

# Enter to accept some security issues e-mail address

# Select Install database software and create the data, you can choose to install only the second database software

# Select the server version

# Single-instance database

# Advanced mode installation

# Add language support

Select the version you want to install #

# Install the database directory

# Database name and service name

# Enable Automatic Memory Management

# Set the default encoding is UTF8

# Enable Oracle Enterprise Manager console OEM

# Select the database file directory

# Auto Backup settings

# Set the database user name and password

# Authorization group

# Check Oracle installation requirements of some, packs have been installed, simply ignored

#start installation

#The installation is complete

# After the installation is complete, you will come out a dialog box that prompts the use of root user to perform these two scripts

[Root @ oracledb ~] $ /opt/oracle/oraInventory/orainstRoot.sh
[Root @ oracledb ~] $ /opt/oracle/app/product/11.2.0/dbhome_1/root.sh

9, Oracle common commands
[Root @ oracledb ~] # su -oracle
[Oracle @ oracledb ~] # sqlplus / as sysdba
SQL> startup # Start the database instance
SQL> shutdown immediate # close the database instance
SQL> select * from tab; # View all the tables
SQL> select name from v $ datafile # view database storage directory
SQL> show parameter service # view the service name
SQL> select * from v $ instance; # View instance name
SQL> select name from v $ database; # Check the database name
SQL> select * fromdba_users; # View all user information
SQL> select username, password from dba_users; # only query the user and password
SQL> select * fromv $ pwfile_users; # See user with sysdba privileges
SQL> select * fromdba_ustats; # to view the current user information
SQL> select * fromuser_sys_privs # view the permissions of the current user's system
SQL> select * fromuser_role_privs # to view the current user role
SQL> select * fromdba_sys_privs # View system permissions for the specified user has
SQL> select * fromv $ version # See oracle version
SQL> select * fromuser_views # View View Information
[Root @ oracledb ~] # lsnrctl start # turn on the remote listening port
### Remote connection information

10, oracle user
#sys user and system differences
Different 1>. The importance of data storage
sys to store data dictionary base tables and views, maintained by the database itself, no user can manually change, sys user has dba, sysdba, sysoper roles, or privileges, is the highest authority of the user oracle.
The system user only store some level of internal data, such as management information oracle of some of the features or tools. For database management, System Users with ordinary dba role permissions.
2> Different permissions
sys user has sysdba or sysoper system privileges, log em can only use these two identities can not be normal.
system users can only log in with a normal em identity, unless you it is granted sysdba syspoer system privileges or system privileges.
#sysdba sysoper two system privileges and differences
normal ordinary users
sysdba has the highest system privileges, log is sys
sysoper mainly used to start, shut down the database after the user login is public sysoper
The difference #dba and sysdba
First understand the process of creating the next oracle service: Create an instance -> Start Instance -> Create Database
Start the process: Example Start -> Load Database -> Open Database
sysdba management oracle instance, its existence does not depend on the entire database is fully activated, as long as the instance starts, it already exists, log in as sysdba, loading the database, open the database. Only open the database, or the entire database fully activated after, dba role for existence foundation.

After this installation, new to Oracle friends, is no longer a stranger to Oracle it!
     
         
         
         
  More:      
 
- map and hash_map STL containers (Programming)
- Memory leak analysis using Android studio (Programming)
- MySQL completely uninstall and install Configuring Character Sets under Linux (Database)
- CentOS build JDK environment (Linux)
- Generated characters using Java Videos (Programming)
- IronPython and C # to interact (Programming)
- Various sorting algorithms implemented in Python (Programming)
- installation process of Matlab 2012a under Ubuntu 14.04 (Linux)
- Linux system Iptables Firewall User Manual (Linux)
- Installation on the way to the root source Ubuntu Server 14.04 LTS version Odoo8.0 (Server)
- Let OS X support NTFS write file (Linux)
- Distributed File System using MogileFS (Linux)
- Java proxy use and proxy principle (Programming)
- Ubuntu Backup and Recovery (Linux)
- 5 tips to improve your Linux desktop security (Linux)
- Oracle conditional select statements and looping statements (Database)
- CentOS 7 Configure logging (VirtualBox) (Linux)
- PostgreSQL 9.4.3 Installation and Configuration under CentOS 6.5 (Database)
- CentOS 6.5 configuration SSDB 1.8.0 (Server)
- After Oracle 11g dataguard failover rebuild the archive logs are not applied to be NO problem (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.