If a maintenance windows fails to be removed from a node, you can use the following process to remove it.

Note: Before starting this procedure it would probably be a good idea to make a note of the maintenance windows that are supposed to be in place. Then, if the wrong maintenance window happens to be deleted they can be re-created in the GNW web interface.

Removing Maintenance Windows from the Nodes

  1. First, get a listing of the nodes being used by the service in question.
  2. Get the serviceid of the service in question.

  3. Connect to the node using SecureCRT
  4. At the node command prompt type sqlplus vwpoint/vwpoint and press enter

  5. This brings you to the database command prompt which is represented as SQL>

    [vwpoint@colosolutions ~]$ sqlplus vwpoint/vwpoint 
    
    SQL*Plus: Release 10.2.0.1.0 - Beta on Mon Nov 16 14:10:24 2009
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
    
    SQL> 
    
  6. At the SQL command prompt enter the following query using the serviceid of the service in question:
    select * from servicemaint where serviceid = 32545; 
     

    Remember to replace 32545 with the correct serviceid number. Note: the query must have a semicolon at the end. An example of running the above query:

    SQL> select * from servicemaint where serviceid = 32545; 
    
     SERVICEID  DAYOFWEEK  STARTTIME    ENDTIME
    ---------- ---------- ---------- ----------
         32545          7          5       2350
    
    SQL> 
     
    This shows that there is a maintenance window for serviceid 32545 that is in effect 7 days a week from 00:05 to 23:50
  7. The following command will remove all maintenance windows for the serviceid 32545;

    delete from servicemaint where serviceid = 32545; 
     
    Remember to replace 32545 with the correct serviceid. An example of running the delete command:
    SQL> delete from servicemaint where serviceid = 32545; 
    
    1 row deleted.
    
    SQL> 
    
  8. After running the delete command the changes will not be permanent until they are committed. At the SQL command prompt type the following commit command and press enter.
    SQL> commit;  
     
  9. If for some reason you need to undo the delete you can do so as long as the commit command has not been issued. To undo use the rollback command at the SQL prompt:
    SQL> rollback; 
     
  10. After committing the change, type quit at the SQL prompt to leave the database and return to the node command prompt.
    SQL> quit 
    Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
    [vwpoint@colosolutions ~]$ 
     
  11. At the node command prompt type exit to leave the node.

    [vwpoint@colosolutions ~]$ exit 
     
  12. The above steps need to be repeated on all of the nodes that are being utilized by the service in question.

Remove Maintenance Windows from Nodes (last edited 2011-08-10 21:37:41 by Bryce Camp)