Wednesday, October 26, 2011

How to Install Oracle Database Software and Create a New Database

How to Install Oracle Database Software and Create a New Database

For installing Oracle Database Software, you have to take the help of Oracle Universal Installer or OUI. It is graphical tool to install and maintain oracle products installed or to be installed. But before installing Oracle Database software you should fulfill the following requirement.
1. You have to fullfill minimum physical memory requirement. This is 512 MB for Microsoft Windows or Linux and 1024 MB or 1 GB for UNIX or other Operating Systems.
2. You should have enough paging space.
3. Your operation system should be updated to the required Service Pack Level or Kernel version level.
4. You should follow the required file format for the Oracle Database as per Oracle Guidelines.

Whenever you are going to install oracle database software, you have to decide which type of Oracle Database Software Installation you want. The list is like bellow,
Enterprise Edition: It is the installation, where you will get the Oracle Database Product with full features, which is required for the data management at enterprise level.
Standard Edition: It is the installation, where you will get the Oracle Database Product to provide support to a medium size organization. It will provide all the basic database services.
Personal Edition: This type of installation is available only in Microsoft windows. It is same with the Enterprise Edition in case of Features but the limitation is single user option, which is mainly taken for development and deployment scenario.
Custom Install: Here the features are customized from the enterprise edition according to the requirement of the USER.

At the time of installation you can pick the advance installation option. If you pick this option you will be asked some question, which will guide you for the completion of the installation.
 Install Sample Schema?
 What type of storage mechanism do you want your database to use?( File System/Automatic Storage Management/ Raw Devices)
 What are your database management options?
Steps to Install Oracle Database Software
For being Oracle Database basic installation you have to follow the bellow steps.
1. For doing the installation you have to logon as the administrator user. That means that the user should have the authority to install oracle database software, create and run the database.
2. If you are installing from a media, click or run the Oracle Universal Installer (OUI).
3. Then you have to select the Product, In this case Oracle Database 11g. Then Click Next.
4. Select Basic Installation type. You have to give the following input, Oracle Home, Oracle Base Location, Installation Type, UNIX DBA Group, Create Starter Database.
5. If you are doing first time installation, then specify a location which will be Oracle Inventory location. And it is different from ORACLE_HOME
6. It is for UNIX and Linux only; OUI will perform some environment checks and give a success or failure status.
7. In case of windows click next if all the Product-Specific Prerequisite check status succeeded. In case of failure take corrective actions.
8. Click next in the Oracle Configuration Manager Registration window.
9. Start the Install button, after reviewing the summary given in the screen.
10. An optional step is there as in Password Management you can unlock the required user accounts.
11. Click OK to continue installation.
12. At the end of the installation exit the OUI confirming YES.

How to use DBCA to create a Database and manage it?
Coming in Next post.

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...