操作系统要求(OS requirement): # cat /proc/version Asianux Server 3 SP2 Oracle Linux 4 Update 7 Oracle Linux 5 Update 2 (with Red Hat Compatible Kernel) Oracle Linux 5 Update 5 Oracle Linux 6 Oracle Linux 6 (with Red Hat Compatible Kernel) Red Hat Enterprise Linux 4 Update 7 Red Hat Enterprise Linux 5 Update 2 Red Hat Enterprise Linux 5 Update 5 (with the Oracle Unbreakable Enterprise Kernel for Linux) Red Hat Enterprise Linux 6 Red Hat Enterprise Linux 6 (with the Oracle Unbreakable Enterprise Kernel for Linux) SUSE Linux Enterprise Server 10 SP2 SUSE Linux Enterprise Server 11 内核需求(kernel requirements): # uname -r On Oracle Linux 4 and Red Hat Enterprise Linux 4 2.6.9 or later On Oracle Linux 5 Update 5 2.6.32-100.0.19 or later On Oracle Linux 5 Update 2 2.6.18 or later (with Red Hat Compatible Kernel) On Oracle Linux 6 2.6.32-100.28.5.el6.x86_64 or later On Oracle Linux 6 2.6.32-71.el6.x86_64 or later (with Red Hat Compatible Kernel) On Red Hat Enterprise Linux 5 Update 5 with the Oracle Unbreakable Enterprise Kernel for Linux 2.6.32 or later On Red Hat Enterprise Linux 6 with the Oracle Unbreakable Enterprise Kernel for Linux 2.6.32-100.28.5.el6.x86_64 or later On Red Hat Enterprise Linux 6 2.6.32-71.el6.x86_64 or later On Asianux Server 3, Oracle Linux 5 Update 2, and Red Hat Enterprise Linux 5 Update 2 2.6.18 or later On SUSE Linux Enterprise Server 10 2.6.16.21 or later On SUSE Linux Enterprise Server 11 2.6.27.19 or later Installation: 1. 修改sysctl.conf文件,在文件末尾插入 Edit sysctl.conf file,at the end of file add in vi /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 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 2. 执行sysctl –p,确保输出结果与第一步的数据相同 Enter sysctl –p, make sure the output is the same as step 1 3. 修改limits.conf,在文件末尾插入 Edit limits.conf file,at the end of file add in vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle hard stack 10241 | 4. 关闭selinux,把enforcing 改为disabled Turn off selinux, change enforcing to disabled vi /etc/sysconfig/selinux selinux=disabled | 5. 关闭linux防火墙 Turn off iptables service iptables stop chkconfig iptables off | 6. 查看防火墙启动状态 Check iptables status 7. 配置yum Yum configuration mkdir /iso umount /dev/sr0 mount /dev/sr0 /iso vi /etc/yum.repos.d/local.repo [server] name=server baseurl=file:///iso enabled=1 gpgcheck=0 | 8. Yum install Create users and groups groupadd dba groupadd oinstall groupadd oper useradd oracle 创建oracle用户 /usr/sbin/useradd -g oinstall -G dba,oper oracle usermod -g dba oracle 把oracle用户加到dba组里 passwd oracle 给oracle用户建密码 | 10. 给oracle建安装目录 Create install dirctory for oracle mkdir -p /u01/app/oracle chown -R oracle:dba /u01/app/oracle 把文件属主改为oracle chmod -R 777 /u01/app/oracle 把文件权限改为777 | 11. 配置oracle用户环境变量(home、base、sid、path、umask) Configure oracle user's environment variable su - oracle vi /home/oracle/.bash_profile ORACLE_BASE=/u01/app/oracle ORACLE_SID=sales ORACLE_HOME=$ORACLE_BASE/11.2.4/dbhome_1 export ORACLE_BASE ORACLE_SID ORACLE_HOME export PATH=$ORACLE_HOME/bin:$PATH | (ORACLE_HOME路径跟安装路径一定要一致) (ORACLE_HOME must be the same with install path) 12. 使新环境变量生效 Make new environment variables effective 13. 添加/etc/hosts Edit /etc/hosts su vi /etc/hosts (写本机ip和主机名) (write your ip and username) 14. Reboot 15. 上传oracle文件到/u01并解压 Upload oracle files to /u01 and unzip 16. 切换到oracle用户 Switch to oracle user dbca NEXT NEXT NEXT SID与环境变量中的SID一致 SID here must be the same as SID in .bash_profile 不勾选 Do not tick 输入密码 Enter password NEXT NEXT 勾选 这个就会装练习用的表,不选就是空白数据库 Tick this will have sample schemas, otherwise is empty database 第 一个是内存分配,第二个是进程分配,第三个是字符集,第四个是pga运行方式 NEXT NEXT 建监听(Listener configuration) -
netca -
NEXT -
NEXT -
NEXT -
NEXT -
NEXT -
NEXT 向AI问一下细节 AI 助 手 | | | | | | | |