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