Database Solutions

Oracle Uninstall Database Standalone Binary  For DBA installation and uninstallation binary is common activity. You can find many blogs on the installation online but difficult to find blogs on uninstallation. In this blog , We will discuss about how to uninstall binary using deinstall utility provided by the Oracle. 1) Make sure backup of the binary mount point is completed.  2) Use $ORCLE_HOME/deinstall to uninstall binary. $ORACLE_HOME/deintsall/deinstall -tmpdir <Directory with more the 5G free space>  -logdir <log directory> 3) Above command will delete all the file and directory in Oracle home ,unless there are files/directory owned by some other user. 

Uninstall Commercial MySQL Server on Ubuntu As part DB server decommission , We need to uninstall DB binary/packages from the DB server post DB backup with long term retention.  Below are the steps for uninstalling MySQL Server package from ubuntu server: 1) On Ubuntu server , MySQL Server is installed as DEB package. 2) Before Uninstalling MySQL Server package , We need to stop MySQL server. shell> sudo service mysql stop 3) Remove all the depending package . 4) Remove package from the server. If you want to preserve configuration files and data, remove the package using dpkg command with -r option. shell> sudo dpkg -r mysql If you want to remove everything including configuration files and data, remove the package using -P option. shell> sudo dpkg -P mysql-server mysql-client mysql-commercial-client mysql-commercial-client-core mysql-commercial-server mysql-commercial-server-core mysql-common Logs: root@mysqlhost01:/etc/mysql/mysql.conf.d# dpkg -l |grep -i mysq...

Uninstallting Microsoft SQL Server 2016 From time to time keep getting request to decommission Database and Uninstall Database Binary. To cater to such kind of request, We have come up with todays blog which discuss about uninstallation of the Microsoft SQL Server 2016. (If you want to install Microsoft SQL Server 2016 , Look at out blog  Installing Micosoft SQL Server 2016 ) 1) Stop Microsoft SQL Server and SQL Agent Service on the server.  2) On Server , Go to Control Panel > Programs > Programs & Features. Right Click Microsoft SQL Server 2016 software. 3) Click on Remove. 4) Remove Microsoft SQL Server Window will pop up and Global Rules will be checked. Click Next. 5) Select SQL Server Instance needed to be uninstalled. And Click Next. 6) Select the Features need to be Uninstalled and Click Next. 7) On Ready to Remove , Check and Verify Summary Screen and Click Remove. 8) Removal Progress Screen will come which will show progress of Uninstallation . 9) Removal...