Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Linux Platform Oracle 11g Single Instance Installation Deployment Configuration Quick Reference     - VMWare virtual machine without rebooting way to add virtual disk (Linux)

- PostgreSQL 9.3.5 database installation under Ubuntu Server 14.04 (Database)

- MySQL concat function is SQL injection (Linux)

- Linux Troubleshooting: How to save the status of the SSH session is closed (Linux)

- RabbitMQ tutorial examples: RabbitMQ installation under Windows (Linux)

- Linux systems use IP masquerading anti-hacker (Linux)

- Puppet centralized configuration management system (Server)

- Oracle 11g partition maintenance (two) - Coalescing Partitions (Database)

- Ubuntu 12.04 64-bit installation Redmine + Git + ReviewBoard (Linux)

- Linux System Tutorial: How to browse the Linux command line, weather forecast (Linux)

- To install Redis under Linux (Database)

- Netcat Example (Linux)

- OpenStack Folsom create an instance of the failure of the Quota Fixed_IP articles (Server)

- Linux loopback adapter Driven Design (Programming)

- Spring Integration ehcache annotation implement the query cache and cache update or delete instant (Programming)

- Install JDK 1.7 + Eclipse in CentOS 6.4 in (Linux)

- DataGuard the MRP can not start to analyze and solve problems (Database)

- SELinux multi-level security (Linux)

- Generic mechanism C11 standard (Programming)

- Java integrated development environment common set of operations (Linux)

 
         
  Linux Platform Oracle 11g Single Instance Installation Deployment Configuration Quick Reference
     
  Add Date : 2017-08-31      
         
         
         
  1. Rebuild the Oracle user group of the host UID gid to ensure that the shared storage hook or other requirements of the authority specification

Userdel -r oracle
Groupadd -g 500 oinstall
Groupadd -g 501 dba
Useradd -g oinstall -G dba -u 500 oracle

#id oracle
Uid = 500 (oracle) gid = 500 (oinstall) Group = 500 (oinstall), 501 (dba)

2. Install the rpm package required by Oracle. Install the rpm dependency package

Rpm -q binutils compat-libstdc ++ - 33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc-gcc-c ++ libaio-devel libaio libgcc libstdc ++ libstdc ++ - devel make sysstat unixODBC unixODBC-devel pdksh ksh

Yum install binutils compat-libstdc ++ - 33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc- gcc-c ++ libaio-devel libaio libgcc libstdc ++ libstdc ++ - devel make sysstat unixODBC unixODBC-devel pdksh ksh

Note: pdksh is not installed and can be ignored. Ksh is installed.

3. Modify the configuration file /etc/security/limits.conf

Oracle soft nproc 2047
Oracle hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
Oracle soft stack 10240

4. Modify the configuration file /etc/sysctl.conf

Fs.aio - max - nr = 1048576
Fs.file-max = 6815744
Kernel.shmall = 2097152
Kernel.shmmax = XXXXXXXXXX / / shared memory bytes (usually 75% of the physical memory)
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Net.ipv4.ip_local_port_range = 9000 65500
Net.core.rmem_default = 262144
Net.core.rmem_max = 4194304
Net.core.wmem_default = 262144
Net.core.wmem_max = 1048586

Note: Reboot the host or enter the command sysctl -p to take effect on the current configuration

5.Oracle user environment variable configuration

Export ORACLE_BASE = / u01 / app / oracle
Export ORACLE_HOME = / u01 / app / oracle / product / 11.2.0 / dbhome_1
Export ORACLE_SID = jingyu
Export NLS_LANG = "american_america.ZHS16GBK"
Export NLS_DATE_FORMAT = "YYYY-MM-DD HH24: Mi: SS"
Export LD_LIBRARY_PATH = $ ORACLE_HOME / lib
Export PATH = $ ORACLE_HOME / bin: $ PATH

6. Unzip the oracle software installation package

# Unzip p10404530_112030_Linux-x86-64_1of7.zip; unzip p10404530_112030_Linux-x86-64_2of7.zip
# Chown -R oracle: oinstall database

7.xmanager installation of database software, dbca database, netca create monitoring

If there is no graphics can be installed in silent mode ~ configuration response configuration file can be.

8. According to actual needs to adjust the database memory

9. Adjust the database parameters

Open the database archive, plan the archive path, determine db_recovery_file_dest_size Size

- Adjust processes and open_cursors
Alter system set processes = 1500 scope = spfile;
Alter system set open_cursors = 1000;

System / sysaux table space size;

Undo table space size;

Temp table space size;

10. Migrate win platform src user data

Create tablespace, user, empowerment

Create dblink

SQL> create public database link jingyu connect to src identified by src using 'src_db';

$ Impdp src / src network_link = jingyu schemas = src remap_tablespace = USERS: DBS_D_JINGYU parallel = 2 logfile = src_jingyu.log

LONG type of dblink migration error message:

ORA-31679: Table data object "SRC". "SRC_WF_FLOW" has long columns, and longs can not be loaded / unloaded using a network link

This situation using exp derived, imperialiste can import these data.

11.Rman backup strategy development

Rman backup strategy: manually do a full backup of the database, regularly every Sunday at 3:00 level backup every Wednesday morning 3 1 level backup 4:00 every day backup archive backup window for 7 days.

To increase the level 1 backup efficiency, open block_change_tracking

SQL> alter database enable block change tracking using file '/u01/app/oracle/oradata/jingyu/block_change_tracking.dbf';
SQL> select status from v $ block_change_tracking;
- Make sure the STATUS status is ENABLED
     
         
         
         
  More:      
 
- CentOS 6.5 can not connect to the network under VMware (Linux)
- Killall five options you might not know (Linux)
- Java Collections Framework interfaces map (Programming)
- Redhat Close SELinux correct step (Linux)
- Some security configuration of Linux systems (Linux)
- Depth understanding of the TCP protocol (Database)
- TCP protocol flaw incomplete records (Linux)
- Oracle RMAN repair logical bad blocks (Database)
- Linux beginners to develop the seven habits (Linux)
- Nginx Module Development - get user ip (Server)
- Linux Workstation Security Checklist - from the Linux Foundation Internal (Linux)
- Ubuntu Thunderbird 24.4.0 (Linux)
- Digital jQuery scrolling effect (Programming)
- Save the database data files into Oracle Learning (Database)
- Ten linux version of the system (Linux)
- ORA-01157 & ORA-01110 Troubleshooting (Database)
- HBase Application Development Review and Summary of Series (Database)
- Boot automatically remove Linux operating history records (Linux)
- How to find on Linux and delete duplicate files: FSlint (Linux)
- Basic Operation Linux files and directories (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.