WARNING: This web is not used anymore. Please use PDBService.RemoveNode instead!
 
--++ 10g RAC on Linux, removing cluster nodes

Please see also the installation procedure in Installation procedure

Stop Oracle services on the node to be removed from the RAC cluster

  • relocate services running on the node to be evicted to other cluster nodes, when relevant
  • check that you have ocr backups (and take one if needed) with: ocrconfig -showbackup
  • run:
srvctl stop instance -d .. -i ..
srvctl remove instance -d .. -i ..
srvctl stop asm -n ..
srvctl remove asm -n ..
srvctl stop nodeapps -n ..

..as root:
srvctl remove nodeapps -n ..
crs_unregister ora.<nodename>.vip
crs_unregister ora.itrac40.<listener_name>.lsnr
  • check ifconfig -a and set ethX:Y down if needed

Remove DB objects and parameters:

  • connect to the db
  • if in archive log make sure the logs from the deleted instance are archived * select * from v$log where thread#=X; * if needed: alter system archive log all; + check again that logs have been archived
  • alter database disable thread X;
  • repeat for all the groups belonging to the disables thread: * alter database drop logfile group YY;
  • drop tablespace undo...; (drop the undo tablespace forthe removed instance)
  • unset the DB parameters specific to the removed instance
sqlsys_DB
alter system reset local_listener scope=spfile sid='XX';
alter system reset thread scope=spfile sid='XX';
alter system reset undo_tablespace scope=spfile sid='XX';
alter system reset instance_number scope=spfile sid='XX';

alter system reset "__db_cache_size" scope=spfile sid='XX';
alter system reset "__java_pool_size" scope=spfile sid='XX';
alter system reset "__large_pool_size" scope=spfile sid='XX';
alter system reset "__shared_pool_size" scope=spfile sid='XX';
alter system reset "__streams_pool_size" scope=spfile sid='XX';
create pfile='/tmp/pfileDB_for_further_checks' from spfile;
  • analogously unset the ASM parameters
    sqlsys_ASM
    alter system reset local_listener scope=spfile sid='+ASM...';
    alter system reset instance_number scope=spfile sid='+ASM...';
    create pfile='/tmp/pfileASM_for_further_checks' from spfile;
    
  • edit tnsnames.ora (on all nodes)
    • edit the remote_listeners parameter
    • edit tns entries (remove the node from the list of addresses
    • edit afs tnsnames.ora

Remove the node from CRS

  • check the current list of nodes: olsnodes -n
  • on the node to be removed, run as root: $ORA_CRS_HOME/install/rootdelete.sh remote nosharedvar
  • on a node to be kept (as root): $ORA_CRS_HOME/install/rootdeletenode.sh ,*
  • check the current list of nodes: olsnodes -n

Update the Oracle inventory

  • Update the rdbms inventory
$ORA_CRS_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES=<node1>,<node2>,..
  • Update the crs inventory
$ORA_CRS_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORA_CRS_HOME CRS=TRUE CLUSTER_NODES=<node1>,<node2>,..
  • if you have the EM agent, stop it and update the nodelist for EM agent too

Remove Oracle files on the evicted node

Edit | Attach | Watch | Print version | History: r8 | r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r2 - 2006-08-02 - LucaCanali
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback