Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle 11g configuration DG

2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

1: modify the parameter file of the main library:

* .DB_UNIQUE_NAME=PHUB*.LOG_ARCHIVE_CONFIG='DG_CONFIG= (MECBS,PHUB)'* .LOG _ ARCHIVE_DEST_2='SERVICE=MECBS LGWR SYNC AFFIRM VALID_FOR= (ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=MECBS'*.log_archive_dest_state_1=enable*.log_archive_dest_state_2=enable*.standby_file_management=auto*.log_archive_dest_1='location=+DATA valid_for= (all_logfiles,all_roles) db_unique_name=PHUB'

Second, install the standby library oracle software:

Install the operating system: slightly

Modify the hostname and hosts file:

[root@dg ~] # more / etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1localhost.localdomain localhost::1localhost6.localdomain6 localhost6172.16.30.228dg

4. Modify system parameters:

[root@dg] # cat > > / etc/sysctl.conf kernel.sem = 32000 100128 > kernel.shmmni = 4096 > kernel.shmall = 1073741824 > kernel.shmmax = 4398046511104 > net.core.rmem_default = 262144 > net.core.rmem_max = 4194304 > net.core.wmem_default = 262144 > net.core.wmem_max = 1048576 > fs.aio-max-nr = 1048576 > net.ipv4.ip_local_port_range = 900065500 > eof [root@dg] # sysctl-pnet.ipv4.ip_forward = 0net.ipv4.conf .default.rp _ filter = 2net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 4294967296fs.file-max = 6815744kernel.sem = 25032000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aioMaxmax- Nr = 1048576net.ipv4.ip_local_port_range = 9000 65500

5. Modify the resource limit profile:

[root@dg] # cat > > / etc/security/limits.conf grid hard nofile 65536 > grid soft nproc 2047 > grid hard nproc 16384 > grid soft stack 10240 > grid hard stack 32768 > oracle soft nofile 1024 > oracle hard nofile 65536 > oracle soft nproc 2047 > oracle hard nproc 16384 > oracle soft stack 10240 > oracle hard stack 32768 > eof [root@dg] # tail-20 / etc/security/limits.conf grid soft nofile 1024grid Hard nofile 65536grid soft nproc 2047grid hard nproc 16384grid soft stack 10240grid hard stack 32768oracle soft nofile 1024oracle hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft stack 10240oracle hard stack 3276

6. Configure the yum source and install the dependency package:

[root@dg ~] # cat / etc/yum.repos.d/local.repo [Redhat6] name= Enterpress6.5baseurl= file:///mnt/Serverenabled=1gpgcheck=0[root@dg ~] # mount / dev/sr0 / mnt/mount: block device / dev/sr0 is write-protected, mounting read-onlyyum-y install binutils compat-libstdc++-33elfutils-libelf\ elfutils-libelf-devel elfutils-libelf-devel-static gccgcc-c++ glibc glibc-common\ glibc-devel kernel-headers ksh libaio libaio-devel libgcclibgomp libstdc++ libstdc++-devel\ make numactl-devel sysstatunixODBC unixODBC-devel pdksh

7. Create users, user groups, installation directories:

[root@dg] # / usr/sbin/groupadd-g 54321 oinstall [root@dg ~] # / usr/sbin/groupadd-g 54322 dba [root@dg ~] # / usr/sbin/groupadd-g 54323 oper [root@dg ~] # / usr/sbin/groupadd-g 54324 backupdba [root@dg ~] # / usr/sbin/groupadd-g 54325 dgdba [root@dg ~] # / usr/sbin/groupadd-g 54327 asmdba [root@dg ~] # / usr/sbin / groupadd-g 54328 asmoper [root@dg ~] # / usr/sbin/groupadd-g 54329 asmadmin [root@dg ~] # / usr/sbin/useradd-u 54321-g oinstall-G asmadmin Asmdba,asmoper,dba grid [root@dg] # / usr/sbin/useradd-u 54322-g oinstall-G dba,backupdba,dgdba,asmadmin,asmdba orac [root@dg] # passwd gridChanging password for user grid.New UNIX password: BAD PASSWORD: it is too shortRetype new UNIX password: Sorry Passwords do not match.New UNIX password: BAD PASSWORD: it is too shortRetype new UNIX password: passwd: all authentication tokens updated successfully. [root@dg ~] # passwd oracleChanging password for user oracle.New UNIX password: BAD PASSWORD: it is based ona dictionary wordRetype new UNIX password: passwd: all authentication tokens updated successfully. [root@dg ~] # mkdir-p / u01/app/grid [root@dg ~] # mkdir-p / u01/app/11.2.0/grid [root@dg ~] # mkdir-p / U01 / app/oracle/product/11.2.0/db_1 [root@dg ~] # chown-R grid.oinstall / U01 [root@dg ~] # chown-R oracle.oinstall / u01/app/oracle [root@dg ~] # chmod-R 775 / U01

8. Configure environment variables:

[root@dg ~] # cat > > / home/grid/.bash_profile > / home/oracle/.bash_profile

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report