Oracle Database 11g : Installing Oracle - Configure Kernel Parameters, Get Familiar with Linux

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
12/24/2012 3:14:27 AM

1. Project 2-1 Configure Kernel Parameters

The default install of the Linux operating system has values set for the kernel parameters, but the Oracle requirements may need you to adjust these settings. This project will walk you through step by step to change the kernel parameters and show the values of these settings.

Step by Step

  1. Get the minimum values from the installation guide. Here is a quick list:

    ShmmaxThe lesser of the two: either half the size of the physical memory or 4GB
    ip_local_port_rangeMin: 1024, max: 650000

  2. Verify the parameters that are currently set. There may be values already set above the minimum value, so these would not need to be changed. At the command line type the following:

    # /sbin/sysctl –a | grep <param-name>
  3. Substitute the parameter name for param-name. For example, shm will show the values for the semaphore parameters:

    # /sbin/sysctl –a | grep shm
    kernel.shmmni = 4096
    kernel.shmall = 2097152
    kernel.shmmax = 2147483648
  4. Edit the /etc/sysctl.conf to adjust the kernel parameter values. Use vi or another text editor to add the line as listed under #ORACLE 11gR1 kernel parameters to the end of the file. The other parameter that was changed was kernel.shmmax. Here is the example /etc/sysctl.conf file; the areas that need to change or be added are in bold:

    # CHANGED FOR ORACLE 11g # kernel.shmmax = 1073740324
    kernel.shmmax = 2147483648
    #ORACLE 11gR1 Kernel Parameters – add the following lines
  5. Reload the kernel parameters for the new values to take effect. This can be done by restarting the server or by using the following command to reload:

    # /sbin/syctl –p

The execution of this command and its output are shown in Figure 1.

Figure 1. Verify the kernel parameters using sysctl –p

Project Summary

In walking through this project, you now know how to see the kernel parameters, make changes to the parameters, and verify those changes. In changing the kernel parameters, you are making the necessary optimizations for the Oracle software to run on the Linux platform.

2. Get Familiar with Linux

Having the user interface and the terminal window for access to the command line means that there are a couple of ways to navigate through Linux and do what needs to be done. With previous examples of using the command line, files were edited, users were added, and parameters were set up. In managing some of the Oracle files and directories, it is useful to know some of the basic commands or how to look up the option for the commands. Changing directories, copying and moving files, editing, and being able to look at the content of the file are all basic commands in Linux (and almost the same as what is used in Unix, with a couple of possible differences in the parameter options). The following are some useful Linux commands, with a brief definition:

  • pwd This shows the current directory (print working directory).

  • more filename This lists the file.

  • ls This lists the files in the directory.

  • echo $VAR This shows value of variables or echoes back the text.

  • mv filename newfilename This renames a file.

  • cp filename / newdirectory This copies a file.

  • rm filename This removes (deletes) a file; wildcards can be used but are not recommended for a root directory.

Manual pages are available to provide details for commands as well as available options. There are also examples for how to use the commands in the details. This information can be accessed by typing man and then the command. Here is an example of the command, and Figure 2 show the results of this command and what can be found in the man pages.

Figure 2. OUTPUT of man commands

$man grep
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
Video Sports
programming4us programming4us