Oracle11gR2RAC best practices for deleting nodes

Source: Internet
Author: User
For Oracle11gR2RAC node adding best practices, see: www.linuxidc.comLinux2012-0869270.htm OS information: [grid @ 11grac1 ~] $ Uname-

For the best practices for adding nodes to Oracle 11gR2 RAC, see http://www.linuxidc.com/linux/2012-08/69270.htmosinformation :[grid@11grac1 ~]. $ Uname-

For Oracle 11gR2 RAC best practices for adding nodes, see:
OS information:
[Grid @ 11grac1 ~] $ Uname-
Linux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/Linux
DB information:
SQL> select * from v $ version where rownum
BANNER
------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0-Production
View the current resource status
[Grid @ 11grac1 ~] $ Crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora... SM1.asm application ONLINE 11grac1
Ora... C1.lsnr application ONLINE 11grac1
Ora... ac1.gsd application ONLINE 11grac1
Ora... ac1.ons application ONLINE 11grac1
Ora... ac1.vip ora... t1.type ONLINE 11grac1
Ora... SM2.asm application ONLINE 11grac2
Ora... C2.lsnr application ONLINE 11grac2
Ora... ac2.gsd application ONLINE 11grac2
Ora... ac2.ons application ONLINE 11grac2
Ora... ac2.vip ora... t1.type ONLINE 11grac2
Ora. DATA. dg ora... up. type ONLINE 11grac1
Ora... ER. lsnr ora... er. type ONLINE 11grac1
Ora... N1.lsnr ora... er. type ONLINE 11grac1
Ora. asm ora. asm. type ONLINE 11grac1
Ora. eons ora. eons. type ONLINE 11grac1
Ora. gsd ora. gsd. type ONLINE 11grac1
Ora... network ora... rk. type ONLINE 11grac1
Ora. Solaris ora. productname. type ONLINE 11grac1
Ora. ons ora. ons. type ONLINE 11grac1
Ora. racdb. db ora... se. type ONLINE 11grac1
Ora. scan1.vip ora... ip. type ONLINE 11grac1
[Grid @ 11grac1 ~] $ Srvctl status database-d racdb
Instance racdb1 is running on node 11grac1
Instance racdb2 is running on node 11grac2
Write Test Data
[Oracle @ 11grac1 ~] $ Sqlplus/nolog
SQL * Plus: Release 11.2.0.1.0 Production on Wed Aug 29 10:02:08 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
SQL> conn/as sysdba
Connected.
SQL> sho user
USER is "SYS"
SQL> create table test (id number, name varchar2 (10 ));
Table created.
SQL> insert into test values (1, 'allonking ');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test;
ID NAME
--------------------
1 yallonking

Delete a node instance (either DBCA or the following command can be used to silently delete it)
Run dbca and delete related information according to the wizard.
Instance management-> delete an instance-> enter the account and password of the sysdba user-> select the deleted node instance
[Oracle @ 11grac1 ~] $ Export DISPLAY = 192.168.137.1: 0.0
[Oracle @ 11grac1 ~] $ Dbca
View database status
[Grid @ 11grac1 ~] $ Srvctl status database-d racdb
Instance racdb1 is running on node 11grac1
[Grid @ 11grac1 ~] $ Crsctl check cluster-all
**************************************** **********************
11grac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online.
**************************************** **********************
11grac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online.
**************************************** **********************
[Grid @ 11grac1 ~] $

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.