oracle dba工作笔记：运维、数据迁移与性能调优

安装、建库、登录

free -m df -h df -h /tmp uname -r

oralce安装

groupadd oinstall groupadd dba useradd -g oinstall -G dba oracle passwd oracle

修改内核参数

配置用户进程和文件数

mkdir /home/U01 mkdir -p /U01/app/oracle chown -R oracle:oinstall /U01/ chmod -R 755 /U01/

配置环境变量,实例名test

CPUPSU oracle的补丁包... 11.2.0.4

响应文件

image.png

image.png

image.png

创建数据库，删除数据库

dba登录

三种角色：sysdba,sysoper,dba

#######安装 vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536

vi /etc/pam.d/login session required /lib64/security/pam_limits.so session required pam_limits.so

vi /etc/sysctl.conf fs.aio-max-nr=1048576 fs.file-max=6815744 kernel.shmall=2097152 kernel.shmmni=4096 kernel.shmmax = 2147483648 kernel.sem=250 32000 100 64 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

sysctl -p

vi /etc/redhat-release redhat-7

groupadd oinstall; groupadd dba useradd -g oinstall -g dba -m oracle passwd oracle

mkdir -p /home/oracle/app/oracle/product mkdir -p /home/oracle/app/oradata chown -R oracle:oinstall /home/oracle/app

setenforce 0 systemctl stop firewalld.service

yum groupinstall "X Window System" -y yum install xdpyinfo xorg-x11-server-utils-7.7-14.el7 tigervnc-server vnc -y yum install -y binutils-2.23.52.0.1-12.el7.x86_64 compat-libcap1-1.10-3.el7.x86_64 gcc-4.8.2-3.el7.x86_64 gcc-c -4.8.2-3.el7.x86_64 glibc-2.17-36.el7.i686 glibc-2.17-36.el7.x86_64 glibc-devel-2.17-36.el7.i686 glibc-devel-2.17-36.el7.x86_64 ksh libaio-0.3.109-9.el7.i686 libaio-0.3.109-9.el7.x86_64 libaio-devel-0.3.109-9.el7.i686 libaio-devel-0.3.109-9.el7.x86_64 libgcc-4.8.2-3.el7.i686 libgcc-4.8.2-3.el7.x86_64 libstdc -4.8.2-3.el7.i686 libstdc -4.8.2-3.el7.x86_64 libstdc -devel-4.8.2-3.el7.i686 libstdc -devel-4.8.2-3.el7.x86_64 libXi-1.7.2-1.el7.i686 libXi-1.7.2-1.el7.x86_64 libXtst-1.2.2-1.el7.i686 libXtst-1.2.2-1.el7.x86_64 make-3.82-19.el7.x86_64 sysstat-10.1.5-1.el7.x86_64

通过打包，rpm -Uvh *.rpm --nodeps --force

wget http://vault.centos.org/5.11/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm rpm -ivh http://vault.centos.org/5.11/os/i386/CentOS/compat-libstdc -33-3.2.3-61.i386.rpm --nodeps --force rpm -ivh ftp://ftp.icm.edu.pl/vol/rzm3/linux-oracle-repo/EnterpriseLinux/EL4/latest/x86_64/libgcc-3.4.6-3.1.i386.rpm --nodeps --force rpm -ivh ftp://ftp.pbone.net/mirror/www.whiteboxlinux.org/whitebox/4/en/updates/i386/libstdc -3.4.6-11.i386.rpm --nodeps --force rpm -ivh http://vault.centos.org/5.11/os/i386/CentOS/unixODBC-2.2.11-10.el5.i386.rpm --nodeps --force rpm -ivh http://vault.centos.org/5.11/os/x86_64/CentOS/unixODBC-devel-2.2.11-10.el5.x86_64.rpm --nodeps --force rpm -ivh http://vault.centos.org/5.11/os/i386/CentOS/glibc-devel-2.5-123.i386.rpm --nodeps --force

startx