Linux Install Oracle Notes

Linux Installation Oracle1Increase swap space, memory is greater than 8G and swap is equal to memory sizemkdir/home/Swap CD/home/SwapDD if=/dev/zero of=swapfile bs=1g count= tomkswap swapfile swapon swapfile #增加到swap分区 (31G+ 31G =62G) #设置开机自动添加swapfileVI/etc/Fstab:/home/swap/swapfile Swap Defaults0 0    2. Turn off firewall and SELinux Ntsysv/chkconfig service iptables Stop/usr/sbin/sestatus-v Setenforce3Install dependent packages #检查依赖包安装情况 rpm-Q binutils compat-libstdc++- -compat-libstdc++- -Elfutils-libelf Elfutils-libelf-develGCC GCC-c++ glibc glibc glibc-common glibc-devel glibc-devel glibc-headers ksh libaio libaio libaio-devel libaio-devel libgcc Lib GCC libstdc++ libstdc++ libstdc++-devel MakeSysstat is not installed on the manual installation4Set System Parameters #如果系统是oracle Linux, most of it has been preset for you .VI/etc/security/limits.conf:oracle Soft Nproc2047Oracle Hard Nproc16384Oracle Soft Nofile1024x768Oracle Hard Nofile65536*-Core10240*   -Data Unlimited*   -Fsize Unlimited*   -Memlock Unlimited*-Nofile1048500*   -RSS Unlimited*   -Stack Unlimited*   -CPU Unlimited*   -Nproc Unlimited*   -As Unlimited*-Maxlogins -*-Maxsyslogins +*   -Priority Unlimited*   -Locks Unlimited*   -Sigpending Unlimited*   -Msgqueue UnlimitedVI/etc/pam.d/Login: Session required pam_limits.so session required/lib/security/pam_limits.soVI/etc/Sysctl.conf:fs.file-max =6815744Fs.aio-MAX-NR =1048576Kernel.shmall=2097152Kernel.shmmax=2147483648Kernel.shmmni=4096Kernel.sem= - 32000  -  -Net.ipv4.ip_local_port_range=9000 65500Net.core.rmem_default=4194304Net.core.rmem_max=4194304Net.core.wmem_default=262144Net.core.wmem_max=1048576#修改sysctl. conf and make it effective immediately sysctl-P5. Create user groups and users groupadd Oinstall groupadd dba Useradd-G Oinstall-G dba OraclepasswdOracle #密码设置为Oracle123 $6. Install Oracle Export Java_home=/home/oracle/JDK Export CLASSPATH= $JAVA _home/lib/tools.jar: $JAVA _home/lib/Dt.jar: $CLASSPATH export PATH= $JAVA _home/Bin: $PATH securecrt session OptionsRemote/x11->forward X11 Packet (F) (Mandatory authentication do not choose!!) )./runintaller DBCA NETCA Database account password: SYS/eastcom

The old library guides the new library, exporting only the user's object definitions:

' /home/oracle/admin/ipnet/dpdump/ ' ; GRANT READ, WRITE on DIRECTORY data_pump_dir to SYS;

' /home/oradata/fm.dbf ' SIZE 30720M; CREATE USER FM identified by FM1234DEFAULT tablespace FM; GRANT CONNECT, RESOURCE, CREATE any VIEW to FM;DROP USER FM CASCADE;

EXPDP \'/As Sysdba\ ' Directory=data_dump_dir dumpfile=users.dump schemas=rm,fm,nhm content=metadata_ only IMPDP \'/As Sysdba\ ' Directory=data_dump_dir dumpfile=users.dump schemas=rm,fm,nhm

Linux Install Oracle Notes