Rabu, 22 Februari 2017

Oracle database installation

This blog shows you how to install the Oracle Database 11gR2 software on Microsoft Windows along with a default instance of an Oracle Database that contains example schemas ( including the HR schema).

Hardware and Software Requirements


Before installing the software, Oracle Universal Installer (OUI) performs several automated checks to ensure that your computer fulfills the basic hardware and software requirements for an Oracle Database installation. If your computer does not meet the requirements, an error message is displayed. Some of the requirements to install the software are:

  • Minimum 2 GB of physical memory
  • Sufficient virtual memory (swap)
  • At least 10 GB of free disk space
Let's see how the database can be installed on the windows machine.

1) Expand the database folder where you have extracted the database. Double-click setup.exe

.

2) The Configure Security Updates window appears. Enter your email address and My Oracle Support password to receive security issue notifications via email. If you do not wish to receive notifications via email, deselect "I wish to receive security updates via My Oracle Support". Click Next to continue. Click "Yes" in the confirmation window to confirm your preference.



3) The Download Software Updates window appears with the following options:

  • Select "Use My Oracle Support credentials for download" to download and apply the latest software updates. 
  • Select "Use pre-downloaded software updates" to apply software updates that you previously downloaded. 
  • Select "Skip software updates" if do not want to apply any updates. 
Accept the default and click Next.


4) The Select Installation Option window appears with the following options:

  • Select "Create and configure a database" to install the database, create database instance and configure the database. 
  • Select "Install database software only" to only install the database software. 
  • Select "Upgrade an existing database" to upgrade the database that is already installed.

In this blog, we create and configure the database. Select the Create and configure a database option and click Next


5) The System Class window appears. Select Desktop Class or Server Class depending on the type of system you are using. In this, we will perform the installation on a server. Select Server Class and click Next


6) Select the radio button for ‘Single instance database installation’. This is selected as we are gonna to install the database on single machine not on cluster.


7) Select the ‘Advanced install’ option so the database installation parameters may be changed. Click ‘Next’.

8) Select the languages that you want your database to hold the information in what all languages.


9) Select the ‘Enterprise Edition’ radio button and then click ‘Next’


10) Select the install location to be the E:\app_112040. Use the rest of the path as the default path. Click ‘Next’.

11) Select ‘General purpose/Transaction Processing’ radio button and click ‘Next’


12) Enter the Global database name and the SID, both as OSBPRD. Click ‘Next’


13) This the configuration screens. On the ‘Memory’ tab, let the ‘Enable Automatic Memory Management’ be checked.

By default, the database is set to take 40% of the available physical RAM of the machine, which in this case is approx. 13GB. Make it 8GB

Do not click ‘Next’ yet! Click on the ‘Character sets’ tab next to the ‘Memory’ tab.


On the ‘Character sets’ tab, select the ‘Use Unicode (AL32UTF8)’ radio button. Click ‘Next

14) Let the default option, ‘Use Oracle Enterprise Manager Database control for database management’ be selected and click ‘Next’.


15) Let the default, ‘File System’ radio button be selected and let the path be the default path. Click ‘Next’.

16) Let default ‘Do not enable automatic backup’ be selected. Click ‘Next’.


17) Enter the password. This password will be used later to log into administrator accounts such as SYS and SYSTEM. Click Next.


18) Click Next


19) Click Install


20) Wait through as the installation finishes. Let whatever popup’s open during the process and cancel nothing.


21) On the database configuration window that opens up, click on the ‘Ok’ button.



22) The database would have successfully installed. Click ‘Close’.



Tidak ada komentar:

Posting Komentar