How to manually delete a server pool from Oracle VM manger
Sometimes, failed to delete a Oracle VM server pool from Oracle VM manager with following error messages:
"Error
Selected server pool is deleted.
The selected server pool may have been deleted by someone else. "
To manually delete a server pool on Oracle VM manger machine:
1, Setting DB environment;
- # export ORACLE_SID=XE
- # export PATH=$PATH:$ORACLE_HOME/bin
2,
# sqlplus OVS/oracle@xe
....
SQL> select SITE_NAME,SITE_ID from OVS_SITE;
SITE_NAME
--------------------------------------------------------------------------------
SITE_ID
----------
ovm_pool
30
SQL> delete from OVS_SITE where SITE_ID=30;
1 row deleted.
SQL> select SITE_NAME,SITE_ID from OVS_SITE where SITE_ID=30;
"Error
Selected server pool is deleted.
The selected server pool may have been deleted by someone else. "
To manually delete a server pool on Oracle VM manger machine:
1, Setting DB environment;
- # export ORACLE_SID=XE
- # export PATH=$PATH:$ORACLE_HOME/bin
2,
# sqlplus OVS/oracle@xe
....
SQL> select SITE_NAME,SITE_ID from OVS_SITE;
SITE_NAME
--------------------------------------------------------------------------------
SITE_ID
----------
ovm_pool
30
SQL> delete from OVS_SITE where SITE_ID=30;
1 row deleted.
SQL> select SITE_NAME,SITE_ID from OVS_SITE where SITE_ID=30;
0