Thursday, February 11, 2010

Installing Linux for Oracle Database

.
In this tutorial, you learn how to install Oracle Database 10gR2 on Oracle Enterprise Linux 4 Following are the linux distributions certified for Oracle Database 10g Release 2:

Oracle Enterprise Linux 5 (OEL5)
Oracle Enterprise Linux 4 (OEL4)
Red Hat Enterprise Linux 5 (RHEL5)
Red Hat Enterprise Linux 4 (RHEL4)
Red Hat Enterprise Linux 3 (RHEL3)
Novell SUSE Linux Enterprise Server 10 (SLES10)
Novell SUSE Linux Enterprise Server 9 (SLES9)
Asianux 2.0
Asianux 1.0

This guide assumes a server with the following hardware:

· 800MHz Pentium III CPU
· 1024MB of RAM
· SCSI host adapter (Ultra SCSI 160)
· Four SCSI disk drives (1 x 9GB + 3 x 36GB)
· One 100Base-T Ethernet adapter

Your hardware does not have to match this in order to use this guide. All that is necessary for a basic database install is a single CPU, 1024MB of RAM, and one disk drive (IDE, SCSI, or FireWire) with at least 7GB of free space.

1. Boot the server using the first CD.
You may need to change your BIOS settings to allow booting from the CD.

2. The boot screen appears with the boot: prompt at the bottom of the screen.
Select Enter to continue with a graphical install on the console. (For other installation methods and options, refer to the Red Hat Installation Guide.)
The installer scans your hardware, briefly displays the Red Hat splash screen, and then begins a series of screen prompts.

3. Language Selection
Accept the default.

4. Keyboard ConfigurationAccept the default.

5. Welcome ScreenClick on Next.

6. Disk Partitioning SetupA thorough treatment of disk partitioning is beyond the scope of this guide, which assumes that you are familiar with disk partitioning methods.
(WARNING: Improperly partitioning a disk is one of the surest and fastest ways to wipe out everything on your hard disk. If you are unsure how to proceed, stop and get help, or you will risk losing data!)
This guide uses the following partitioning scheme, with ext3 for each filesystem:

The 9GB disk on the first controller (/dev/sda) will hold all Linux and Oracle software and contains the following partitions:
-100MB /boot partition

-1,500MB swap partition—Set this to at least twice the amount of RAM in the system but to no more than 2GB. (Thirty-two-bit systems do not support swap files larger than 2GB.) If you need more than 2GB of swap space, create multiple swap partitions.

-7,150MB root partition—This partition will be used for everything, including /usr, /tmp, /var, /opt, /home, and more. This approach is purely to simplify installation for the purposes of this guide. A more robust partitioning scheme would separate these directories onto separate filesystems.

7. Boot Loader Configuration
Accept the default.

8. Network Configuration
It is usually best to configure database servers with a static IP address. To do so, click on Edit .
A pop-up window appears. Uncheck the Configure using DHCP box, and enter the IP Address and Netmask for the server. Be sure that Activate on boot is checked, and click on OK .
In the Hostname box, select manually and enter the hostname.
In the Miscellaneous Settings box, enter the remaining network settings.

9. Firewall ConfigurationFor the purposes of this walk-through, no firewall is configured. Select No firewall
Select Disabled on the "Enable SELinux" drop down list.
Click on Proceed when the "Warning - No Firewall" window appears.

10. Additional Language SupportAccept the default.

11. Time Zone Selection
Choose the time settings that are appropriate for your area. Setting the system clock to UTC is usually a good practice for servers. To do so, click on System clock uses UTC

12. Set Root PasswordEnter a password for root, and enter it again to confirm.

13. Package Installation Defaults
Select Customize software packages to be installed.

14. Package Group Selection
Select only the package sets shown here and leave all others unselected.

Desktop: X Window System ,Gnome
Applications: Graphical Internet (optional)
Servers: Do not select anything in this group
Development: Development Tools
System: Administration Tools , System Tools
Add the package 'sysstat' by clicking on the Details link and selecting "sysstat - The sar an iostat system monitoring commands." from the Optional Packages list.
Miscellaneous: Do not select anything in this group.
Click on Next to proceed.

15. Installing Packages
Software will be copied to the hard disk and installed. Change disks as prompted.

16. Congratulations
Remove the installation media from the system, and click on Reboot .

17. The system automatically reboots and presents a new welcome screen.
Click on Next.

18. License Agreement
Read the license agreement. If you agree to the terms, select Yes, I agree to the License Agreement and click on Next.

19. Date and Time
Set the Date and Time.
If you want to use an NTP server (recommended), select Enable Network Time Protocol and enter the name of the NTP server.

20. Display
Accept the defaults or change as required.

21. Red Hat Login
Enter your Red Hat Network login and password or create a new one.

22. System User
Create an account for yourself.
Do not create an account for oracle at this time. Creating the oracle account is covered later in this section.

23. Additional CDsClick on Next.

24. Finish Setup
Click on Next.

25. A graphical login screen appears.
Congratulations! Your RHEL4 software is now installed
Verifying Your Installation

Required kernel version: 2.6.9-5.0.5.EL This kernel, or any of the kernels supplied in updates, works with Oracle Database 10g Release 2 .

Check your kernel version by running the following command:

$ uname -r
2.6.9-22.ELsmp

Once you've completed the steps above, now install following packaged required for Oracle Database 10g Release 2

binutils-2.15.92.0.2-10.EL4
compat-db-4.1.25-9
control-center-2.8.0-12
gcc-3.4.3-9.EL4
gcc-c++-3.4.3-9.EL4
glibc-2.3.4-2
glibc-common-2.3.4-2
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-9.EL4
libstdc++-devel-3.4.3-9.EL4
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
libaio-0.3.96
openmotif21-2.1.30-11

To see which versions of these packages are installed on your system, run the following command:

rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio openmotif21

Installing Required Packages
1. Using GUI environment go to Applications > System Setting > Add Remove Application and select appropriate package.
2. or Login as “root” user and navigate to /media/cdrecoder/Enterprise/RPMS and install package

$ cd /media/cdrecoder/Enterprise/RPMS
rpm -Uvh setarch-1*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
rpm -Uvh libaio-0*
rpm -Uvh gcc-3*
rpm -Uvh compat-gcc-32-3*
rpm -Uvh compat-gcc-32-c++-3*

.

1 comments:

sap implementation methodology said...

Thank you for writing such a wonderful tutorial on Installing Linux for Oracle Database . I read complete post and found it very interesting one especially for students.