Quick Reference for installation, deployment, and configuration of a single Oracle 11g instance on Linux

Quick Reference for installation, deployment, and configuration of a single Oracle 11g instance on Linux

1. re-build the Oracle user group of the host and standardize uid gid to ensure the permission specification for shared storage mounting or other requirements

Userdel-r oracle
Groupadd-g 500 oinstall
Groupadd-g 501 dba
User add-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-devel glibc-common glibc-devel gcc-c ++ libaio-devel libaliblibgcc libstdc + + libstdc ++-devel make sysstat unixODBC-devel pdksh ksh

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

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

Yum local ground source configuration reference: http://www.cnblogs.com/jyzhao/p/3938290.html

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

Oracle soft nproc 2047
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 // number of bytes in the shared memory (generally 75% 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: restart the host or enter the command sysctl-p to apply 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 install database software, dbca database creation, and netca listener

If there is no image, you can install it in silent mode ~ Configure the response configuration file.

8. Adjust the database memory as needed

9. Adjust database Parameters

Open the database archive, plan the archiving path, and determine the size of db_recovery_file_dest_size.

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

System/sysaux tablespace size;

Undo tablespace size;

Temp tablespace size;

10. migrate data of src users on win Platform

Create a tablespace, user, and assign Permissions

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 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

In this case, use exp to export and imp to import the data rows.

11. rman backup policy formulation

Rman backup policy: manual full backup of a database, scheduled every Sunday at am level 0 backup every Wednesday at am Level 1 backup every day at am backup archiving backup window for 7 days.

To improve the backup efficiency, enable 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;
-- Confirm that the STATUS is ENABLED