Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Linux Platform Oracle 11g Single Instance Installation Deployment Configuration Quick Reference     - Oracle VirtualBox Problem Solving Case (Linux)

- In addition to wget and curl, what better alternatives (Linux)

- Use Oracle Data Guard to complete cross-platform database migration cases (Database)

- Check the Linux server performance with ten or so commands in a minute (Server)

- RHEL 6.5 KVM analytical use (Server)

- Linux stand-alone OGG synchronous Oracle 11g DB test (Database)

- Use XtraBackup to MySQL database online incremental backup and recovery (Database)

- Linux server startup and logon security settings (Linux)

- Linux / Raspberry Pi using the following command-line based web browser (Linux)

- Oracle 12c detailing the new features (Database)

- How to use Aptik to backup and restore Apps/PPAs under ubuntu (Linux)

- MBR partitions under Linux (Linux)

- VMware installed Linux system and JDK deployment (Linux)

- Repair Chrome for Linux is (Linux)

- Linux system boot process detail (Linux)

- JavaScript, some conclusions about the implicit conversion (Programming)

- GNU Linux use diff to generate a patch with the patch (Linux)

- Linux more efficient than select a model epoll (Linux)

- Linux Thread Synchronization (Programming)

- Java collections series (Programming)

  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 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
- Linux Variable content removal and replacement (Linux)
- Hadoop 2.6.0 stand-alone / pseudo-distributed installation (Server)
- Ubuntu 14.04 VirtualBox can not start solution (Linux)
- Basic Java JNI (Programming)
- Linux novice common commands (Linux)
- Java concurrent programming combat (using synchronized synchronization method) (Programming)
- Python method to traverse folders and file read and write (Programming)
- How to restart after a crash Cinnamon (Linux)
- The new features of MySQL 5.7 Generated Column (index function) (Database)
- How to Install SeaMonkey 2.25 for Ubuntu (Linux)
- MySQL optimization tabs (Database)
- Empty password Linux operating system (Linux)
- MySQL partition summary (Database)
- Ubuntu upgrade to Linux Kernel 4.2.3 Kernel (Linux)
- CentOS 6.5 install Maven and Nexus warehouse agent (Server)
- FreeRadius installation process record (Linux)
- Ubuntu 14.04 How to set up an SSH without password (Linux)
- A brief introduction to some important Docker commands (Server)
- Based Corosync + Pacemaker + DRBD + LNMP Web server to achieve high availability cluster (Server)
- Linux system security knowledge (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.