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
- First, get a listing of the nodes being used by the service in question.
Get the serviceid of the service in question.
- Connect to the node using SecureCRT
At the node command prompt type sqlplus vwpoint/vwpoint and press enter
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>
- 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
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>
- 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.
- 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:
- 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 ~]$
At the node command prompt type exit to leave the node.
[vwpoint@colosolutions ~]$ exit
- The above steps need to be repeated on all of the nodes that are being utilized by the service in question.