How to Uninstall Oracle 10g from windows 7 completely

How to Uninstall Oracle 10g from windows 7 completely

Here I am gonna show you how to uninstall Oracle client software completely from the system. Most of the guys fear about this :-). Just have a look and follow the same steps while uninstalling Oracle from your system:

1.1 Stopping Oracle Services on Windows

To stop Windows services:

1. Open the Services control panel and from the Start menu, choose Control Panel, then Administrative Tools, then Services.
2. If any Oracle services (names begin with Oracle or Ora) exist and have the status Started, then select each of the services, and click Stop.
3. Click Close to exit the Services window.
4. Exit the Control Panel.

1.2 Removing Oracle Database Client with Oracle Universal Installer

Oracle Universal Installer creates Windows services for Oracle components during installation. However, Oracle Universal Installer does not delete all the services created by Oracle Net Configuration Assistant.

To remove components on a Windows computer with Oracle Universal Installer:

1. Ensure that you first follow the instructions in "Stopping Oracle Services on Windows".
2. Start Oracle Universal Installer. The start procedure depends on which version of Oracle Database Client you installed.
   
   1. If you installed the Administrator, Runtime, or Custom versions of Oracle Database Client, then Oracle Universal Installer was also installed. From the Start menu, choosePrograms, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer. The Welcome screen for Oracle Universal Installer appears.
   2. If you installed the Instant Client version of Oracle Database Client, Oracle Universal Installer was not installed. Instead, run it from your installation media or the installation directory you created for downloaded or copied installation files.
   3. To start Oracle Universal Installer from the installation media, insert the CD labeled Oracle Database Client. The Autorun screen automatically appears.
      If the Autorun screen does not appear, from the Start menu, choose Run, and then enter the following command:
      

      DRIVE_LETTER:\autorun\autorun.exe
      
      

      Choose Install/Deinstall Products from the Autorun screen.
   4. To start Oracle Universal Installer from your installation directory, double-click setup.exe.
3. Click the Deinstall Products button.
   The Inventory screen appears.
4. Select the Oracle home you wish to remove. Expand the tree of installed components only if you want to remove selected components of an Oracle home.
   For example, if you installed Oracle Database Client with the Runtime option and later installed additional components with the Custom option, then expand the Oracle home component to display all the components installed in the Oracle home.
5. Check the boxes of components to remove.
6. Click Remove.
   The Confirmation screen appears.
7. Click Yes to remove the selected components.
   
   
   

   Note: A message may appear indicating that removing some components may cause other components to not function properly.

   After the components are removed from your computer, the Inventory screen appears without the removed components.
8. Click Close to close the Inventory screen.
9. Click Cancel to exit Oracle Universal Installer.
10. Click Yes to confirm that you want to exit.
11. After Oracle Universal Installer exits, go to the next section to remove the remaining Oracle Database Client components.

1.3 Manually Removing the Remaining Oracle Database Client Components

1.3.1 Removing Only the Oracle Net Service Registry Key

To remove only the Oracle Net Service registry entry (if it exists):

1. Log in as a member of the Administrators group.
2. Ensure that you first follow the instructions in "Stopping Oracle Services on Windows".
3. From the Start menu, choose Run, and then enter the following command:
   

   regedt32
   
   

4. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete the OracleHOME_NAMETNSListener registry entry.
   When you ran Oracle Universal Installer to deinstall Oracle Database Client, it deleted all other Oracle Net services.
5. Exit the registry editor.
6. Restart your computer.

1.3.2 Removing All Oracle Registry Keys

To remove all Oracle registry keys from a computer (if any exist):

Caution: These instructions remove all Oracle components, services, and registry entries from your computer. Exercise extreme care when removing registry entries. Removing incorrect entries can break your system. Any database files under ORACLE_BASE\ORACLE_HOME\DB_NAME should be deleted only after completing these instructions.

1. Log in as a member of the Administrators group.
2. Ensure that you first follow the instructions in "Stopping Oracle Services on Windows".
3. From the Start menu, choose Run, and enter the following command:
   

   regedt32
   
   

4. Go to HKEY_CLASSES_ROOT.
5. Delete keys that begin with the following:
   
   • ORAMMCPMON10
   • ORCLSSO
   
   

   Note: These registry keys do not appear if you installed Instant Client.

6. Go to HKEY_LOCAL_MACHINE\SOFTWARE.
7. Delete the ORACLE Group key.
8. If you installed Oracle Services for Microsoft Transaction Server, go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services \Eventlog\Application.
9. Delete the Oracle Services for Microsoft Transaction Server key.
10. Go to HKEY_CURRENT_USER\Software.
11. Delete all Oracle keys, including Oracle-HOME_NAME entries under: Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs.
12. Exit the Registry Editor.
13. Restart your computer.

1.4 Updating the PATH Environment Variable Path

Check the PATH environment variable and remove any Oracle entries.

1. From the Start menu, choose Settings, then Control Panel, then System. Select the Advanced tab and then click Environment Variables.
2. Select the system variable PATH and edit it to remove any Oracle entries.
   For example, remove Oracle entries that contain ORACLE_BASE\ORACLE_HOME in the Path variable. You may see a Path variable that contains entries similar to the following:
   

   ORACLE_BASE\ORACLE_HOME\bin;ORACLE_BASE\ORACLE_HOME\jre\1.4.2\bin\client;
   ORACLE_BASE\ORACLE_HOME\jre\1.4.2\bin
   
   

3. Save any changes and exit the Control Panel.

1.5 Removing Oracle Database Client from the Start Menu

Check the Start menu for any Oracle Database Client entries and remove them.
Perform the following steps:

1. Using My Computer or Windows Explorer, navigate to the SYSTEM_DRIVE:\Document and Settings\All Users\Start Menu\Programs folder.
2. Delete the Oracle - HOME_NAME folder.

You can also remove Oracle Database Client menu entries with the following instructions:

1. Right click the Start button to display the context menu.
2. Select the Explore All Users option.
3. Expand the Start Menu\Programs folder if necessary.
4. Delete the Oracle - HOME_NAME folder.

1.6 Removing Oracle Database Client Directories

After removing all Oracle Database Client registry keys and restarting the computer, delete any existing Oracle Database Client directories and files.

1. Using My Computer or Windows Explorer, delete the SYSTEM_DRIVE:\program files\oracle directory.
2. Using My Computer or Windows Explorer, delete all ORACLE_BASE directories on your hard drive.

Source: http://docs.oracle.com/html/B13804_02/deinstall.htm

Installation of MySql Database

Let's see Installation of MySql Database:

1. Go to mysql.com and click on downloads.

2. Click on 'Download from Oracle eDelivery'.

3. It will ask for login credentials. So enter the same if you are already have a user ID and Password else register yourself.

4. After successfully login accept the license agreement by checking the box as showing in picture below:

5. Now choose the  MySql Installer and click finsih.

6. Your downloading done now.

Now we will see how to install it.

Please watch the video for installation:

https://www.youtube.com/watch?v=fd8Cwf_Z9SU

OOPS Concept With Real Life Example

OOPS Concept With Real Life Example

This is the most asked Question in a technical interview in any domain.. OOPS Concept is very very important.. Today I will explain OOPS concept with real Life Example that will help you to grasp the concept well and excel in the interviews...

Objects: Object is the basic unit of object-oriented programming.Objects are identified by its unique name. An objectrepresents a particular instance of a class. There can be more than one instance of an object. Each instance of an object can hold its own relevant data.

An Object is a collection of data members and associated member functions also known as methods.

Classes: Classes are data types based on which objects are created.Objects with similar properties and methods are grouped together to form a Class. Thus a Class represent a set of individual objects. Characteristics of an object are represented in a class as Properties. The actions that can be performed by objects becomes functions of the class and is referred to as Methods.

Example #1:

For example consider we have a Class of Cars under which Santro Xing, Alto and WaganR represents individual Objects.In this context each Car Object will have its own, Model,Year of Manufacture, Colour, Top Speed, Engine Power etc.,which form Properties of the Car class and the associated actions i.e., object functions like Start, Move, Stop form the Methods of Car Class.No memory is allocated when a class is created. Memory is
allocated only when an object is created, i.e., when an instance of a class is created.

Example #2:

An architect will have the blueprints for a house....those blueprints will be plans that explain exactly what properties the house will have and how they are all layed out.  However it is just the blueprint, you can't live in it.  Builders will look at the blueprints and use those blueprints to make a physical house.  They can use the same blueprint to make as many houses as they want....each house will have the same layout and properties.  Each house can accommodate it's own families...so one house might have the Smiths live in it, one house might have the Jones live in it.

The blueprint is the class...the house is the object.  The people living in the house are data stored in the object's properties.

Abstraction: Abstraction means showing essential features and hiding non-essential features to the user.

For Eg.  Yahoo Mail...

When you provide the user name and password and click on submit button..It will show Compose,Inbox,Outbox,Sentmails...so and so when you click on compose it will open...but user doesn't
know what are the actions performed internally....It just Opens....that is essential; User doesn't know internal actions ...that is non-essential things...

For Eg. Tv Remote..
Remote is a interface between user and tv..right. which has buttons like 0 to 10 ,on /of etc but we dont know circuits inside remote...User does not  need to know..Just he is using essential thing that is remote.
 

Encapsulation: Encapsulation means which binds the data and code (or) writing operations and methods in single unit (class).
 

For Example:
A car is having multiple parts..like steering,wheels,engine...etc..which binds together to form a single object that is car. So, Here multiple parts of cars encapsulates itself together to form a single object that is Car.

In real time we are using Encapsulation for security purpose...

Encapsulation = Abstraction + Data Hiding.

Inheritance: Deriving a new class from the existing class,is called Inheritance.
Derived(sub class) class is getting all the features from Existing (super class\base class) class and also incorporating some new features to the sub class.

For Eg.,

class Address
{
String name;
Srting H.no;
String Street name;
}
class LatestAddress extends Address
{
String City;
String State;
String Country;
}
public class Sumit
{
{
LatestAddress la = new LatestAddress();
//Assign variable accordingly...
}
}

In the above Example class LatestAddress getting all features from the Address class.
In the LatestAddress class we have total 6 properties..3 are inherited from Address class and 3 properties are
incorporated. So In the class Sumit we are declaring the object of class LatestAddress and then assign new variables using the properties of the previous base classes... So this is a nice example of inheritance..

Polymorphism :

Polymorphism means ability to take more than one form that an operation can exhibit different behavior at different instance depend upon the data passed in the operation.

1>We behave differently in front of elders, and friends. A single person is behaving differently at different time.

2> A software engineer can perform different task at different instance of time depending on the task assigned  to him .He can done coding , testing , analysis and designing depending on the task assign and the requirement.

3> Consider the stadium of common wealth games. Single stadium but it perform multiple task like swimming, lawn tennis etc.

4> If a girl is married and mother of 2 children doing teaching job then  she is a women first ,, teacher in a school when she is in school,,wife of someone at home,, mother of her children,, and obvious daughter of someone & may be girl friend of someone (just kidding) means a woman plays diffent roles at different times dats the polymorphism (many forms).

Summary:

OOPs have following features:

1. Object             - Instance of Class
2. Class               - Blue print of Object
3. Encapsulation    - Protecting our Data
4. Polymorphism   - Different behaviors at different instances
5. Abstraction        - Hiding our irrelevant Data
6. Inheritence        - One property of object is acquiring to another property of object