欢迎来到尧图网

客户服务 关于我们

您的位置:首页 > 文旅 > 文化 > Oracle 11G RAC 删除添加节点(一):添加节点

Oracle 11G RAC 删除添加节点(一):添加节点

2025/4/16 20:15:14 来源:https://blog.csdn.net/qq_29431123/article/details/147159504  浏览:    关键词:Oracle 11G RAC 删除添加节点(一):添加节点

1、在保留节点,进入Oracle_home/oui/bin 目录(grid用户)

1  [grid@lvmrac2 bin]$  ./addNode.sh ‐silent "CLUSTER_NEW_NODES={lvmrac1}"
"CLUSTER_NEW_VIRTUAL_HOSTNAMES={lvmrac1‐vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={lvmrac1 ‐ priv}"
2  Performing pre‐checks for node addition 3
4  Checking node reachability...
5  Node reachability check passed from node "lvmrac2" 6
7
8  Checking user equivalence...
9  User equivalence check passed for user "grid" 10
11 WARNING:
12 Node "lvmrac1" already appears to be part of cluster 13
14 Pre‐check for node addition was successful.
15 Starting Oracle Universal Installer... 16
17 Checking swap space: must be greater than 500 MB.   Actual 2759 MB    Passed
18 Oracle Universal Installer, Version 11.2.0.4.0 Production
19 Copyright (C) 1999, 2013, Oracle. All rights reserved.
20
21
22 Performing tests to see whether nodes lvmrac1 are available
23  ............................................................... 100% Done.
24
25  .
26  ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
27 Cluster Node Addition Summary
28 Global Settings
29    Source: /u01/11.2.0/grid
30     New Nodes
31 Space Requirements
32     New Nodes
33        lvmrac1
34           /: Required 5.00GB : Available 44.62GB
35  Installed Products
36     Product Names
37       Oracle Grid Infrastructure 11g 11.2.0.4.0
38        Java Development Kit 1.5.0.51.10
39        Installer SDK Component 11.2.0.4.0
40       Oracle One‐Off Patch Installer 11.2.0.3.4
41       Oracle Universal Installer 11.2.0.4.0
42       Oracle RAC Required Support Files‐HAS 11.2.0.4.0
43       Oracle USM Deconfiguration 11.2.0.4.0
44       Oracle Configuration Manager Deconfiguration 10.3.1.0.0
45        Enterprise Manager Common Core Files 10.2.0.4.5
46       Oracle DBCA Deconfiguration 11.2.0.4.0
47       Oracle RAC Deconfiguration 11.2.0.4.0
48       Oracle Quality of Service Management (Server) 11.2.0.4.0
49        Installation Plugin Files 11.2.0.4.0
50        Universal Storage Manager Files 11.2.0.4.0
51        Oracle Text Required Support Files 11.2.0.4.0
52       Automatic Storage Management Assistant 11.2.0.4.0
53       Oracle Database 11g Multimedia Files 11.2.0.4.0
54       Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
55       Oracle Globalization Support 11.2.0.4.0
56        Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
57        Oracle Core Required Support Files 11.2.0.4.0
58        Bali Share 1.1.18.0.0
59       Oracle Database Deconfiguration 11.2.0.4.0
60       Oracle Quality of Service Management (Client) 11.2.0.4.0
61        Expat libraries 2.0.1.0.1
62       Oracle Containers for Java 11.2.0.4.0
63        Perl Modules 5.10.0.0.1
64        Secure Socket Layer 11.2.0.4.0
65       Oracle JDBC/OCI Instant Client 11.2.0.4.0
66       Oracle Multimedia Client Option 11.2.0.4.0
67        LDAP Required Support Files 11.2.0.4.0
68       Character Set Migration Utility 11.2.0.4.0
69        Perl Interpreter 5.10.0.0.2
70        PL/SQL Embedded Gateway 11.2.0.4.0
71        OLAP SQL Scripts 11.2.0.4.0
72        Database SQL Scripts 11.2.0.4.0
73       Oracle Extended Windowing Toolkit 3.4.47.0.0
74        SSL Required Support Files for InstantClient 11.2.0.4.0
75        SQL*Plus Files for Instant Client 11.2.0.4.0
76        Oracle Net Required Support Files 11.2.0.4.0
77       Oracle Database User Interface 2.2.13.0.0
78        RDBMS Required Support Files for Instant Client 11.2.0.4.0
79        RDBMS Required Support Files Runtime 11.2.0.4.0
80       XML Parser for Java 11.2.0.4.0
81       Oracle Security Developer Tools 11.2.0.4.0
82       Oracle Wallet Manager 11.2.0.4.0
83        Enterprise Manager plugin Common Files 11.2.0.4.0
84        Platform Required Support Files 11.2.0.4.0
85       Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
86        RDBMS Required Support Files 11.2.0.4.0
87        Oracle Ice Browser 5.2.3.6.0
88        Oracle Help For Java 4.2.9.0.0
89        Enterprise Manager Common Files 10.2.0.4.5
90        Deinstallation Tool 11.2.0.4.0
91        Oracle Java Client 11.2.0.4.0
92       Cluster Verification Utility Files 11.2.0.4.0
93       Oracle Notification Service (eONS) 11.2.0.4.0
94       Oracle LDAP administration 11.2.0.4.0
95       Cluster Verification Utility Common Files 11.2.0.4.0
96       Oracle Clusterware RDBMS Files 11.2.0.4.0
97        Oracle Locale Builder 11.2.0.4.0
98       Oracle Globalization Support 11.2.0.4.0
99        Buildtools Common Files 11.2.0.4.0
100       HAS Common Files 11.2.0.4.0
101       SQL*Plus Required Support Files 11.2.0.4.0
102       XDK Required Support Files 11.2.0.4.0
103       Agent Required Support Files 10.2.0.4.5
104       Parser Generator Required Support Files 11.2.0.4.0
105       Precompiler Required Support Files 11.2.0.4.0
106       Installation Common Files 11.2.0.4.0
107       Required Support Files 11.2.0.4.0
108       Oracle JDBC/THIN Interfaces 11.2.0.4.0
109       Oracle Multimedia Locator 11.2.0.4.0
110       Oracle Multimedia 11.2.0.4.0
111       Assistant Common Files 11.2.0.4.0
112       Oracle Net 11.2.0.4.0
113       PL/SQL 11.2.0.4.0
114       HAS Files for DB 11.2.0.4.0
115       Oracle Recovery Manager 11.2.0.4.0
116       Oracle Database Utilities 11.2.0.4.0
117       Oracle Notification Service 11.2.0.3.0
118       SQL*Plus 11.2.0.4.0
119       Oracle Netca Client 11.2.0.4.0
120       Oracle Advanced Security 11.2.0.4.0
121       Oracle JVM 11.2.0.4.0
122       Oracle Internet Directory Client 11.2.0.4.0
123       Oracle Net Listener 11.2.0.4.0
124       Cluster Ready Services Files 11.2.0.4.0
125       Oracle Database 11g 11.2.0.4.0
126 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
127
128
129 Instantiating scripts for add node (Thursday, March 30, 2017 8:29:51 PM CST) 130 .                                                                   1% Done.
131 Instantiation of add node scripts complete 132
133 Copying to remote nodes (Thursday, March 30, 2017 8:29:54 PM CST)
134 .......................................................................................
........                                 96% Done.
135 Home copied to new nodes
36
137 Saving inventory on nodes (Thursday, March 30, 2017 8:41:21 PM CST)
138 .                                                               100% Done.
139 Save inventory complete
140 WARNING:
141 The following configuration scripts need to be executed as the "root" user in each new cluster node. Each script in the list below is followed by a list of nodes.
142 /u01/11.2.0/grid/root.sh #On nodes lvmrac1
143 To execute the configuration scripts:
144     1. Open a terminal window
145     2. Log in as "root"
146     3. Run the scripts in each cluster node
147
148 The Cluster Node Addition of /u01/11.2.0/grid was successful.
149 Please check '/tmp/silentInstall.log ' for more details.

2、新添加节点, 以root运行root.sh脚本

1  [root@lvmrac1 ~]# /u01/11.2.0/grid/root.sh
2  Performing root user operation for Oracle 11g 3
4  The following environment variables are set as:
5      ORACLE_OWNER= grid
6      ORACLE_HOME=  /u01/11.2.0/grid 7
8  Enter the full path name of the local bin directory: [/usr/local/bin]:
9  The contents of "dbhome" have not changed. No need to overwrite.
10 The contents of "oraenv" have not changed. No need to overwrite.
11 The contents of "coraenv" have not changed. No need to overwrite. 12
13
14 Creating /etc/oratab file...
15  Entries will be added to the /etc/oratab file as needed by
16 Database Configuration Assistant when a database is created
17  Finished running generic part of root script.
18 Now product‐specific root actions will be performed.
19 Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
20 Creating trace directory
21 User ignored Prerequisites during installation
22 Installing Trace File Analyzer
23 OLR initialization ‐ successful
24 Adding Clusterware entries to upstart
25 CRS‐4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node lvmrac2, number 2, and is terminating
26 An active cluster was found during exclusive startup, restarting to join the cluster
27 Start of resource "ora.ctssd" failed
28 CRS‐2672: Attempting to start 'ora.ctssd ' on 'lvmrac1 '
29 CRS‐2674: Start of 'ora.ctssd ' on 'lvmrac1 ' failed
30 CRS‐4000: Command Start failed, or completed with errors.
31  Failed to start Oracle Grid Infrastructure stack
32  Failed to start Cluster Time Synchronisation Service ‐ CTSS at /u01/11.2.0/grid/crs/install/crsconfig_lib.pm line 1288.
33 /u01/11.2.0/grid/perl/bin/perl ‐I/u01/11.2.0/grid/perl/lib ‐
I/u01/11.2.0/grid/crs/install /u01/11.2.0/grid/crs/install/rootcrs.pl execution failed

当出现以上报错时,说明节点1有活跃的css,可以查看一下日志

1  [grid@lvmrac1 ctssd]$cat u01/11.2.0/grid/log/lvmrac1/ctssd/octssd.log

停止crs服务

1  [root@lvmrac1 ~]# /u01/11.2.0/grid/bin/crsctl stop crs
2  CRS‐2791: Starting shutdown of Oracle High Availability Services‐managed resources on 'lvmrac1 '
3  CRS‐2673: Attempting to stop 'ora.cssd ' on 'lvmrac1 '
4  CRS‐2673: Attempting to stop 'ora.mdnsd ' on 'lvmrac1 '
5  CRS‐2677: Stop of 'ora.cssd ' on 'lvmrac1 ' succeeded
6  CRS‐2673: Attempting to stop 'ora.gi pcd ' on 'lvmrac1 '
7  CRS‐2677: Stop of 'ora.mdnsd ' on 'lvmrac1 ' succeeded
8  CRS‐2677: Stop of 'ora.gi pcd ' on 'lvmrac1 ' succeeded
9  CRS‐2673: Attempting to stop 'ora.gpnpd ' on 'lvmrac1 '
10 CRS‐2677: Stop of 'ora.gpnpd ' on 'lvmrac1 ' succeeded
11 CRS‐2793: Shutdown of Oracle High Availability Services‐managed resources on 'lvmrac1 ' has completed
12 CRS‐4133: Oracle High Availability Services has been stopped.

· 再执行root.sh脚本,成功

1  [root@lvmrac1 ~]# /u01/11.2.0/grid/root.sh
2  Performing root user operation for Oracle 11g 3
4  The following environment variables are set as:
5      ORACLE_OWNER= grid
6      ORACLE_HOME=  /u01/11.2.0/grid 7
8  Enter the full path name of the local bin directory: [/usr/local/bin]:
9  The contents of "dbhome" have not changed. No need to overwrite.
10 The contents of "oraenv" have not changed. No need to overwrite.
11 The contents of "coraenv" have not changed. No need to overwrite. 12
13  Entries will be added to the /etc/oratab file as needed by
14 Database Configuration Assistant when a database is created
15  Finished running generic part of root script.
16 Now product‐specific root actions will be performed.
17 Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
18 User ignored Prerequisites during installation
19 Installing Trace File Analyzer
20 Adding Clusterware entries to upstart
21 clscfg: EXISTING configuration version 5 detected.
22 clscfg: version 5 is 11g Release 2.
23 Successfully accumulated necessary OCR keys.
24 Creating OCR keys for user 'root ', privgrp 'root '..
25 Operation successful.
26 PRKO‐2190 : VIP exists for node lvmrac1, VIP name lvmrac1‐vip
27  PRKO‐2420 : VIP is already started on node(s): lvmrac1
28 Preparing packages for installation...
29 cvuqdisk‐1.0.9‐1
30 Configure Oracle Grid Infrastructure for a Cluster ... succeeded

3、保留节点切换到oracle用户,为新添节点安装oracle软件

1  [root@lvmrac2 ~]# su ‐ oracle
2  [oracle@lvmrac2 ~]$ cd $ORACLE_HOME/oui/bin/
3  [oracle@lvmrac2 bin]$ ./addNode.sh ‐silent "CLUSTER_NEW_NODES={lvmrac1}"
4  Performing pre‐checks for node addition 5
6  Checking node reachability...
7  Node reachability check passed from node "lvmrac2" 8
9
10 Checking user equivalence...
11 User equivalence check passed for user "oracle" 12
13 WARNING:
14 Node "lvmrac1" already appears to be part of cluster 15
16 Pre‐check for node addition was successful.
17 Starting Oracle Universal Installer... 18
19 Checking swap space: must be greater than 500 MB.   Actual 2888 MB    Passed
20 Oracle Universal Installer, Version 11.2.0.4.0 Production
21 Copyright (C) 1999, 2013, Oracle. All rights reserved.
22
23
24 Performing tests to see whether nodes lvmrac1 are available
25  ............................................................... 100% Done.
26
27  .
28  ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
29 Cluster Node Addition Summary
30 Global Settings
31    Source: /u01/app/oracle/product/11.2.0/db_1New Nodes
33 Space Requirements
34     New Nodes
35        lvmrac1
36           /: Required 4.39GB : Available 44.53GB
37  Installed Products
38     Product Names
39        Oracle Database 11g 11.2.0.4.0
40        Java Development Kit 1.5.0.51.10
41        Installer SDK Component 11.2.0.4.0
42       Oracle One‐Off Patch Installer 11.2.0.3.4
43       Oracle Universal Installer 11.2.0.4.0
44       Oracle USM Deconfiguration 11.2.0.4.0
45       Oracle Configuration Manager Deconfiguration 10.3.1.0.0
46       Oracle DBCA Deconfiguration 11.2.0.4.0
47       Oracle RAC Deconfiguration 11.2.0.4.0
48       Oracle Database Deconfiguration 11.2.0.4.0
49       Oracle Configuration Manager Client 10.3.2.1.0
50       Oracle Configuration Manager 10.3.8.1.0
51       Oracle ODBC Driverfor Instant Client 11.2.0.4.0
52        LDAP Required Support Files 11.2.0.4.0
53        SSL Required Support Files for InstantClient 11.2.0.4.0
54        Bali Share 1.1.18.0.0
55       Oracle Extended Windowing Toolkit 3.4.47.0.0
56       Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
57       Oracle Real Application Testing 11.2.0.4.0
58       Oracle Database Vault J2EE Application 11.2.0.4.0
59        Oracle Label Security 11.2.0.4.0
60        Oracle Data Mining RDBMS Files 11.2.0.4.0
61        Oracle OLAP RDBMS Files 11.2.0.4.0
62       Oracle OLAP API 11.2.0.4.0
63        Platform Required Support Files 11.2.0.4.0
64       Oracle Database Vault option 11.2.0.4.0
65        Oracle RAC Required Support Files‐HAS 11.2.0.4.0
66        SQL*Plus Required Support Files 11.2.0.4.0
67        Oracle Display Fonts 9.0.2.0.0
68        Oracle Ice Browser 5.2.3.6.0
69        Oracle JDBC Server Support Package 11.2.0.4.0
70       Oracle SQL Developer 11.2.0.4.0
71       Oracle Application Express 11.2.0.4.0
72       XDK Required Support Files 11.2.0.4.0
73        RDBMS Required Support Files for Instant Client 11.2.0.4.0
74        SQLJ Runtime 11.2.0.4.0
75        Database Work space Manager 11.2.0.4.0
76        RDBMS Required Support Files Runtime 11.2.0.4.0
77       Oracle Globalization Support 11.2.0.4.0
78        Exadata Storage Server 11.2.0.1.0
79        Provisioning Advisor Framework 10.2.0.4.3
80        Enterprise Manager Database Plugin ‐ ‐ Repository Support 11.2.0.4.0
81        Enterprise Manager Repository Core Files 10.2.0.4.5
82        Enterprise Manager Database Plugin ‐ ‐ Agent Support 11.2.0.4.0
83        Enterprise Manager Grid Control Core Files 10.2.0.4.5
84        Enterprise Manager Common Core Files 10.2.0.4.5
85        Enterprise Manager Agent Core Files 10.2.0.4.5
86        RDBMS Required Support Files 11.2.0.4.0
87        regexp 2.1.9.0.0
88       Agent Required Support Files 10.2.0.4.5
89        Oracle 11g Warehouse Builder Required Files 11.2.0.4.0
90       Oracle Notification Service (eONS) 11.2.0.4.0
91        Oracle Text Required Support Files 11.2.0.4.0
92        Parser Generator Required Support Files 11.2.0.4.0
93       Oracle Database 11g Multimedia Files 11.2.0.4.0
94       Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
95       Oracle Multimedia Annotator 11.2.0.4.0
96       Oracle JDBC/OCI Instant Client 11.2.0.4.0
97        Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
98        Precompiler Required Support Files 11.2.0.4.0
99        Oracle Core Required Support Files 11.2.0.4.0
100       Sample Schema Data 11.2.0.4.0
101       Oracle Starter Database 11.2.0.4.0
102       Oracle Message Gateway Common Files 11.2.0.4.0
103       Oracle XML Query 11.2.0.4.0
104       XML Parser for Oracle JVM 11.2.0.4.0
105       Oracle Help For Java 4.2.9.0.0
106       Installation Plugin Files 11.2.0.4.0
107       Enterprise Manager Common Files 10.2.0.4.5
108       Expat libraries 2.0.1.0.1
109       Deinstallation Tool 11.2.0.4.0
110       Oracle Quality of Service Management (Client) 11.2.0.4.0
111       Perl Modules 5.10.0.0.1
112       JAccelerator (COMPANION) 11.2.0.4.0
113       Oracle Containers for Java 11.2.0.4.0
114       Perl Interpreter 5.10.0.0.2
115       Oracle Net Required Support Files 11.2.0.4.0
116       Secure Socket Layer 11.2.0.4.0
117       Oracle Universal Connection Pool 11.2.0.4.0
118       Oracle JDBC/THIN Interfaces 11.2.0.4.0
119       Oracle Multimedia Client Option 11.2.0.4.0
120       Oracle Java Client 11.2.0.4.0
121       Character Set Migration Utility 11.2.0.4.0
122       Oracle Code Editor 1.2.1.0.0I
123       PL/SQL Embedded Gateway 11.2.0.4.0
124       OLAP SQL Scripts 11.2.0.4.0
125       Database SQL Scripts 11.2.0.4.0
126       Oracle Locale Builder 11.2.0.4.0
127       Oracle Globalization Support 11.2.0.4.0
128       SQL*Plus Files for Instant Client 11.2.0.4.0
129       Required Support Files 11.2.0.4.0
130       Oracle Database User Interface 2.2.13.0.0
131       Oracle ODBC Driver 11.2.0.4.0
132       Oracle Notification Service 11.2.0.3.0
133       XML Parser for Java 11.2.0.4.0
134       Oracle Security Developer Tools 11.2.0.4.0
135       Oracle Wallet Manager 11.2.0.4.0
136       Cluster Verification Utility Common Files 11.2.0.4.0
137       Oracle Clusterware RDBMS Files 11.2.0.4.0
138       Oracle UIX 2.2.24.6.0
139       Enterprise Manager plugin Common Files 11.2.0.4.0
140       HAS Common Files 11.2.0.4.0
141       Precompiler Common Files 11.2.0.4.0
142       Installation Common Files 11.2.0.4.0
143       Oracle Help for the  Web 2.0.14.0.0
144       Oracle LDAP administration 11.2.0.4.0
145       Buildtools Common Files 11.2.0.4.0
146       Assistant Common Files 11.2.0.4.0
147       Oracle Recovery Manager 11.2.0.4.0
148       PL/SQL 11.2.0.4.0
149       Generic Connectivity Common Files 11.2.0.4.0
150       Oracle Database Gateway for ODBC 11.2.0.4.0
151       Oracle Programmer 11.2.0.4.0
152       Oracle Database Utilities 11.2.0.4.0
153       Enterprise Manager Agent 10.2.0.4.5
154       SQL*Plus 11.2.0.4.0
155       Oracle Netca Client 11.2.0.4.0
156       Oracle Multimedia Locator 11.2.0.4.0
157       Oracle Call Interface (OCI) 11.2.0.4.0
158       Oracle Multimedia 11.2.0.4.0
159       Oracle Net 11.2.0.4.0
160       Oracle XML Development Kit 11.2.0.4.0
161       Oracle Internet Directory Client 11.2.0.4.0
162       Database Configuration and Upgrade Assistants 11.2.0.4.0
163       Oracle JVM 11.2.0.4.0
164       Oracle Advanced Security 11.2.0.4.0
165       Oracle Net Listener 11.2.0.4.0
166       Oracle Enterprise Manager Console DB 11.2.0.4.0
167       HAS Files for DB 11.2.0.4.0
168       Oracle Text 11.2.0.4.0
169       Oracle Net Services 11.2.0.4.0
170       Oracle Database 11g 11.2.0.4.0
171       Oracle OLAP 11.2.0.4.0
172       Oracle Spatial 11.2.0.4.0
173       Oracle Partitioning 11.2.0.4.0
174       Enterprise Edition Options 11.2.0.4.0
175 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
176
177
178 Instantiating scripts for add node (Thursday, March 30, 2017 10:07:08 PM CST) 179 .                                                                   1% Done.
180 Instantiation of add node scripts complete 181
182 Copying to remote nodes (Thursday, March 30, 2017 10:07:12 PM CST)
183 .......................................................................................
........                                 96% Done.
184 Home copied to new nodes 185
186 Saving inventory on nodes (Thursday, March 30, 2017 10:25:37 PM CST)
187 .                                                               100% Done.
188 Save inventory complete
189 WARNING:
190 The following configuration scripts need to be executed as the "root" user in each new cluster node. Each script in the list below is followed by a list of nodes.
191 /u01/app/oracle/product/11.2.0/db_1/root.sh #On nodes lvmrac1
192 To execute the configuration scripts:
193     1. Open a terminal window
194     2. Log in as "root"
195     3. Run the scripts in each cluster node
196
197 The Cluster Node Addition of /u01/app/oracle/product/11.2.0/db_1 was successful.
198 Please check '/tmp/silentInstall.log ' for more details.

4、在新添加节点运行root.sh脚本

1  [root@lvmrac1 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
2  Performing root user operation for Oracle 11g 3
4  The following environment variables are set as:
5      ORACLE_OWNER= oracle
6      ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1 7
8  Enter the full path name of the local bin directory: [/usr/local/bin]:
9  The contents of "dbhome" have not changed. No need to overwrite.
10 The contents of "oraenv" have not changed. No need to overwrite.
11 The contents of "coraenv" have not changed. No need to overwrite. 12
13  Entries will be added to the /etc/oratab file as needed by
14 Database Configuration Assistant when a database is created
15  Finished running generic part of root script.
16 Now product‐specific root actions will be performed.
17  Finished product‐specific root actions.

5、在保留节点运行dbca,添加新添节点实例

 dbca -silent -responseFile /u01/database/response/dbca.rsp

6、添加完节点后查看集群资源状态

1  [root@1vmrac1 ~]# su - grid
2  [grid@1vmrac1 ~]$ crsct1 stat res -t
3  --------------------------------------------------------------------------------
4  NAME           TARGET  STATE        SERVER                   STATE DETAILS
5  --------------------------------------------------------------------------------
6  Loca1 Resources
7  --------------------------------------------------------------------------------
8  ora.ARCH.dg
9                 ONLINE  ONLINE       1vmrac1
1                 ONLINE  ONLINE       1vmrac2
11 ora.DATA.dg
12                 ONLINE  ONLINE       1vmrac1
13                 ONLINE  ONLINE       1vmrac2
14 ora.LISTENER.1snr
15                 ONLINE  ONLINE       1vmrac1
16                 ONLINE  ONLINE       1vmrac2
17 ora.OCR.dg
18                 ONLINE  ONLINE       1vmrac1
19                 ONLINE  ONLINE       1vmrac2
2 ora.asm
21                 ONLINE  ONLINE       1vmrac1                  Started
22                 ONLINE  ONLINE       1vmrac2                  Started
23 ora.gsd
24                 OFFLINE OFFLINE      1vmrac1
25                 OFFLINE OFFLINE      1vmrac2
26 ora.net1.network
27                 ONLINE  ONLINE       1vmrac1
28                 ONLINE  ONLINE       1vmrac2
29 ora.ons
3                 ONLINE  ONLINE       1vmrac1
31                 ONLINE  ONLINE       1vmrac2
32 ora.registry.acfs
33                 ONLINE  ONLINE       1vmrac1
34                 ONLINE  ONLINE       1vmrac2
35  --------------------------------------------------------------------------------
36 C1uster Resources
37  --------------------------------------------------------------------------------
38 ora.LISTENER_SCAN1.1snr39	1	ONLINE	ONLINE	1vmrac2
4	ora.cvu			
41	1	ONLINE	ONLINE	1vmrac2
42 ora.1vmrac.db
43        1        ONLINE  ONLINE       1vmrac1                  Open
44        2        ONLINE  ONLINE       1vmrac2                  Open
45 ora.1vmrac1.vip
46        1        ONLINE  ONLINE       1vmrac1
47 ora.1vmrac2.vip
48        1        ONLINE  ONLINE       1vmrac249 ora.oc4j
50        1        ONLINE  ONLINE       lvmrac2
51 ora.scan1.vip
52        1        ONLINE  ONLINE       lvmrac2
1  [grid@lvmrac1 ~]$ crsctl check crs
2  CRS‐4638: Oracle High Availability Services is online
3  CRS‐4537: Cluster Ready Services is online
4  CRS‐4529: Cluster Synchronization Services is online
5  CRS‐4533: Event Manager is online
``
`

版权声明:

本网仅为发布的内容提供存储空间,不对发表、转载的内容提供任何形式的保证。凡本网注明“来源:XXX网络”的作品,均转载自其它媒体,著作权归作者所有,商业转载请联系作者获得授权,非商业转载请注明出处。

我们尊重并感谢每一位作者,均已注明文章来源和作者。如因作品内容、版权或其它问题,请及时与我们联系,联系邮箱:809451989@qq.com,投稿邮箱:809451989@qq.com

热搜词