Tuesday 14 March 2017

Delete Oracle RAC Database on Oracle Database Appliance (ODA HA X5-2)

This doc describe how to delete Oracle RAC Database on Oracle Database Appliance (ODA HA X5-2)

On ODA we use oakcli command line to delete the database.



1. Execute oakcli delete database command as root user and provide database name.
2. Enter password for SYS
3. Enter Y to confirmation.
4. Verify the database.



[root@ABC1x5-2]# oakcli delete database -db LONDON
INFO: 2017-03-07 16:14:50: Look at the log file '/opt/oracle/oak/log/ABC1x5-2/tools/12.1.2.9.0/deletedatabase_LONDON_8564.log' for more details

Please enter the 'SYS'  password :
Please re-enter the 'SYS' password:

All the storage volumes created for the database 'LONDON' will be deleted. Do you want to continue [Y|N]:Y
INFO: 2017-03-07 16:15:15: Deleting the database LONDON. It will take few minutes. Please wait...
INFO: 2017-03-07 16:15:18: Setting up SSH
...SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --

exclude=*rpm and it returned: RC=0

.........
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO: 2017-03-07 16:16:18: SSH has been successfully established
INFO: 2017-03-07 16:17:08: Successfully deleted the database 'LONDON'


Verify the database with below command.

[root@ABC1x5-2 bin]# oakcli show databases


cheers!!!

No comments:

Post a Comment