新建库:Red Hat Enterprise Linux Server release 6.0 (Santiago)
旧库:Red Hat Enterprise Linux Server release 5.4 (Tikanga)
都是64位的。
在新库上进行操作:
检查SELINUX iptable ( service iptables status)
cat /etc/selinux/config
Selinux=disable
Reboot
安装先修改LINUX的核心:
2.修改 vi /etc/sysctl.conf ,执行 /sbin/sysctl -p
kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144net.core.wmem_max=262144
3.修改 vi /etc/security/limits.comf
* soft nproc 65536 * hard nproc 65536 * soft nofile 65536 * hard nofile 655364.修改vi /etc/pam.d/login
session required /lib/security/pam_limits.so5.修改 /etc/selinux/config
SELINUX=disabled6.创建用户组,权限。
groupadd oinstall groupadd dba useradd -m -g oinstall -G dba oracle id oracle 为Oracle 用户设置密码: passwd oracle7.创建安装目录,权限
mkdir -p /u01/app/oracle/product/10.2.0/db_1 chown -R oracle.oinstall /u01/app/oracle/ chmod -R 775 /u01/app/oracle/
8.设置oracle下 .bash_profile
export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORACLE_SID=orcl export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin 生效:source .bash_profile vi /etc/redhat-release Red Hat Enterprise Linux Server release 6.0 (Santiago)Red Hat Enterprise Linux Server release 5 (Tikanga)
在旧库上打包oracle目录 (建议旧库升级到10.2.0.4)
tar cfz oracle.tar
上传到新库/u01/app/
解包安装目录tar xvf oracle.tar
重新执行root.sh:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
在新库创建数据库
dbca
有报错ORA-27125: unable to create shared memory segment
解决方法也很简单,首先检查oracle用户的组信息:
[oracle@yans1 ~]$ id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
[oracle@yans1 ~]$ more /proc/sys/vm/hugetlb_shm_group
0
下面用root执行下面的命令,将dba组添加到系统内核中:
# echo 502 > /proc/sys/vm/hugetlb_shm_group
[root@primary ~]# more /proc/sys/vm/hugetlb_shm_group
502
添加到/etc/sysctl.conf 随系统启动
vm.hugetlb_shm_group=502
中间还碰到好多问题,后面更新。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12131609/viewspace-701906/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12131609/viewspace-701906/