vmware默认快捷安装RHEL 7.4 ,没有图形界面。虚拟机挂载isomount -r /dev/sr0 /mnt配置一个yum源cat  /etc/yum.repos.d/a.repo[server]name=ISObaseurl=file:///mntenabled=1gpgcheck=0EOF主机改名,配置IPhostnamectl --static set-hostname bj1db01echo "192.168.204.137 bj1db01">> /etc/hosts修改内核参数/etc/sysctl.confcat >/etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 4294967296kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048586EOFsysctl -pcat > /etc/security/limits.conforacle soft nproc 65536oracle hard nproc 65536oracle soft nofile 65536oracle hard nofile 65536EOFecho "session    required     pam_limits.so">>/etc/pam.d/loginsystemctl stop firewalldsystemctl disable firewalldsed -i "s#SELINUX=enforcing#SELINUX=disabled#g" /etc/selinux/config安装相关包yum install binutils -yyum install compat-libstdc++-33 -yyum install compat-libstdc++-33.i686 -yyum install gcc -yyum install gcc-c++ -yyum install glibc -yyum install glibc.i686 -yyum install glibc-devel -yyum install glibc-devel.i686 -yyum install ksh -yyum install libgcc -yyum install libgcc.i686 -yyum install libstdc++ -yyum install libstdc++.i686 -yyum install libstdc++-devel -yyum install libstdc++-devel.i686 -yyum install libaio -yyum install libaio.i686 -yyum install libaio-devel -yyum install libaio-devel.i686 -yyum install libXext -yyum install libXext.i686 -yyum install libXtst -yyum install libXtst.i686 -yyum install libX11 -yyum install libX11.i686 -yyum install libXau -yyum install libXau.i686 -yyum install libxcb -yyum install libxcb.i686 -yyum install libXi -yyum install libXi.i686 -yyum install make -yyum install sysstat -yyum install unixODBC -yyum install unixODBC-devel -yyum install zlib-devel -yyum install elfutils-libelf-devel -y##yum install xhost -yyum install xdpyinfo -y创建用户、组groupadd -g 54321 oinstallgroupadd -g 54322 dbagroupadd -g 54323 oper#groupadd -g 54324 backupdba#groupadd -g 54325 dgdba#groupadd -g 54326 kmdba#groupadd -g 54327 asmdba#groupadd -g 54328 asmoper#groupadd -g 54329 asmadminuseradd -g oinstall -G dba,oper oracleecho "oracle" | passwd --stdin oraclemkdir -p /u01/app/oracle/product/11.2.0.4/db_1chown -R oracle:oinstall /u01chmod -R 775 /u01su - oraclevi /home/oracle/.bash_profileTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIR#ORACLE_HOSTNAME=ol7.localdomain; export ORACLE_HOSTNAME#ORACLE_UNQNAME=ORCL; export ORACLE_UNQNAMEORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOMEORACLE_SID=ORCL; export ORACLE_SIDORACLE_TERM=xterm; export ORACLE_TERMPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHexport NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'umask 022上传介质put /u01/install/p133*.zip启动Xmanager-passive yum -y install xdpyinfoexport DISPLAY=192.168.204.1:0.0安装软件,建库。配置DGalter database force logging;--设置db_unique_name, log_archive_config(这里主库的db_unique_name,出于对现有的生产环境最小影响考虑没有改)--alter system set db_unique_name='jingyu' scope=spfile;  alter system set log_archive_config='DG_CONFIG=(ORCLPRD,ORCLPRDDX)'; --归档日志目录alter system set log_archive_dest_1='LOCATION=/arc VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCLPRD';alter system set log_archive_dest_2='SERVICE=ORCLPRDDX ASYNC LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCLPRDDX';--归档日志文件命名规则alter system set log_archive_format='a%r_%t_%s.arc' scope=spfile;--DG的fal_server和fal_clientalter system set fal_server=ORCLPRDDX;--设置standby_file_management为自动alter system set standby_file_management=AUTO; --设置备库日志文件组,数量一般为目标库日志文件组+1alter database add standby logfile group 11 size 50M; alter database add standby logfile group 12 size 50M; alter database add standby logfile group 13 size 50M; alter database add standby logfile group 14 size 50M; 加一下tnsnames.ora内容ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.204.137)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = ORCL)    )  )ORCLDG =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.204.139)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = ORCLDG)    )  )listener.ora加静态注册SID_LIST_LISTENER =   (SID_LIST =        (SID_DESC =          (GLOBAL_DBNAME = ORCL)          (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/db_1)          (SID_NAME = ORCL)           )      ) 主备口令文件、tnsnames.ora一致orapwd file=$ORACLE_HOME/dbs/orapwORCL password=oracle entries=10 ignorecase=Y主库create pfile from spfile;根据dg环境修改参数:db_unique_namedest_1dest_2创建目录备库启动到startup状态rman target / auxiliary sys/oracle@orcldgduplicate target database for standby from active database nofilenamecheck;见证DG的时刻到了...
09-26 20:53
查看更多