课程第23次：2020-03-23星期一

botang

在客户端上做：

1. RACDB =
   
2.   (DESCRIPTION =
   
3.     (ADDRESS = (PROTOCOL = TCP)(HOST = scan4.example.com)(PORT = 1521))
   
4.     (CONNECT_DATA =
   
5.       (SERVER = DEDICATED)
   
6.       (SERVICE_NAME = racdb.example.com)
   
7.     )
   
8.   )
   
9. 
   
10. 
    
11. SRV1 =
    
12.   (DESCRIPTION =
    
13.     (ADDRESS = (PROTOCOL = TCP)(HOST = scan4.example.com)(PORT = 1521))
    
14.     (CONNECT_DATA =
    
15.       (SERVER = DEDICATED)
    
16.       (SERVICE_NAME = srv1.example.com)
    
17.     )
    
18.   )
    

复制代码

1. Usage: srvctl add service -d -s {-r "" [-a ""] [-P {BASIC | NONE | PRECONNECT}] | -g [-c {UNIFORM. SINGLETON}] } [-k   ] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}] [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z ] [-w ] [-t ] [-f]
   
2.     -d       Unique name for the database
   
3.     -s              Service name
   
4.     -r ""    Comma separated list of preferred instances
   
5.     -a ""    Comma separated list of available instances
   
6.     -g            Server pool name
   
7.     -c {UNIFORM. SINGLETON} Service runs on every active server in the server pool hosting this service (UNIFORM) or just one server (SINGLETON)
   
8.     -k              network number (default number is 1)
   
9.     -P {NONE | BASIC | PRECONNECT}        TAF policy specification
   
10.     -l                 Role of the service (primary, physical_standby, logical_standby, snapshot_standby)
    
11.     -y               Management policy for the service (AUTOMATIC or MANUAL)
    
12.     -e        Failover type (NONE, SESSION, or SELECT)
    
13.     -m      Failover method (NONE or BASIC)
    
14.     -w              Failover delay
    
15.     -z              Failover retries
    
16.     -t              Edition (or "" for empty edition value)
    
17.     -j   Connection Load Balancing Goal (SHORT or LONG). Default is LONG.
    
18.     -B      Runtime Load Balancing Goal (SERVICE_TIME, THROUGHPUT, or NONE)
    
19.     -x   Distributed Transaction Processing (TRUE or FALSE)
    
20.     -q AQ HA notifications (TRUE or FALSE)
    
21. Usage: srvctl add service -d -s -u {-r "" | -a ""} [-f]
    
22.     -d       Unique name for the database
    
23.     -s              Service name
    
24.     -u                       Add a new instance to service configuration
    
25.     -r        Name of new preferred instance
    
26.     -a       Name of new available instance
    
27.     -f                       Force the add operation even though a listener is not configured for a network
    
28.     -h                       Print usage
    
29. 
    
30. 
    
31. srvctl add service -s srv1 -d racdb  -serverpool srvpool1
    
32. srvctl modify service -s srv1 -q TRUE -P BASIC -e SELECT -z 180 -w 5 -j LONG  -d racdb -y automatic
    
33. srvctl start service -s srv1 -d racdb
    
34. select  inst_id , machine, status  from gv$session where username='HR';
    
35. select  inst_id, host_name  from gv$instance;
    

复制代码

1. FIREWALLD的zone匹配

---对classroom.example.com启用防火墙：