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

Environmental preparation

In my test environment, I prepared two CentOS7.4 virtual machines and installed 11.2.0.1.0 enterprise version of Oracle11gR2 database software at the same time, in which only the primary server created a database instance and the standby server only installed Oracle database software.

Master database (DB1)

OS

CentOS7.4

Hostname

Hmdb11dg-db1

Oracle Version

11.2.0.1.0

Oracle SID

HMDG (a database created using the DBCA tool)

Standby database (DB2)

OS

CentOS7.4

Hostname

Hmdb11dg-db2

Oracle Version

11.2.0.1.0

Oracle SID

HMDG2

Note: before starting, only oracle database software is installed on the standby server

Oracle user environment variable configuration (~ / .bash_profile)

Export TMP=/tmpexport TMPDIR=$TMPexport ORACLE_TERM=xtermexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=HMDG # DB2-- > HMDG2export PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/lib64if [$USER = "oracle"]; then if [$SHELL = "/ bin/ksh"]; then ulimit-p 16384 ulimit-n 65536 else ulimit-u 16384-n 65536 fifi

Create a new database instance on DB1 (master database)

Steps (figure):

1. Open the DBCA tool (run as oracle user)

Choose to create a database

two。 Enter the name of the data database instance to be created (SID)

3. Database user password (here all user passwords are set to a unified password, it is recommended to set a different password for each user)

4. Select the path where the database file is saved (the default is used here, which will be saved in the $ORACLE_BASE/oradata directory)

5. Quick flashback zone configuration, set the flashback area size (set to 20g here, which should be large enough in the actual environment), and open the archive log

6. SGA and PGA memory settings (default is used here)

Character set configuration (in the current step)

7. Database storage related configuration (tablespace, archive log size configuration)

Table space allocation

SYSAUX

1G

SYSTEM

2G

TEMP

1G

UNDOTABS1

4G

USERS

500M

Archive log

Four groups of archive logs with a size of 500m are created here, and the backup archive logs created later should be the same size as here.

8. For the final step, select [Finish]

Wait for the installation to complete

8. After waiting for the database installation to complete, check to see if the monitoring is normal

[oracle@hmdb11dg-db1 admin] $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0-Production on 22-MAR-2018 17:23:56 Copyright (c) 1991, 2009, Oracle All rights reserved. Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=hmdb11dg-db1) (PORT=1521)) STATUS of the LISTENER----Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0-ProductionStart Date 22-MAR-2018 17:21:43Uptime 0 days 0 hr. 2 min. 14 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File / u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File / u01/app/oracle/diag/tnslsnr/hmdb11dg-db1/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=hmdb11dg-db1) (PORT=1521)) Services Summary...Service "HMDG" has 1 instance (s). Instance "HMDG", status READY, has 1 handler (s) for this service...Service "HMDGXDB" has 1 instance (s). Instance "HMDG", status READY, has 1 handler (s) for this service...The command completed successfully

At this point, the primary database instance has been created, and the physical standby database will be configured (next article)

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.