Installing and Configuring Oracle Database 1. Linuxby Ian Jones. Database Specialists, Inc. About Database Specialists, Inc. Database Specialists, Inc. Since 1. 99. 5, we have been providing Oracle database consulting in Solaris, HP- UX, Linux, AIX, and Windows environments. We are DBAs, speakers, educators, and authors. Our team is continually recognized by Oracle, at national conferences and by leading trade publications. Learn more about our remote DBA, database tuning, and. Or, call us at 4. Introduction. This paper will walk you through the steps of installing Oracle Database 1. How to install Oracle Instant Client on Linux for development with C based applications - this applies to popular scripting languages such as Ruby, Node.js, Python, PHP, Perl and R. Instant Client allows the Oracle. I have just tried to install Forms 11g on to a Windows XP PC for a development environment but it always fails when it reaches the congiuration section of.
Oracle version 1. Linux environment. About 9. 0% of the material presented here applies to other platforms as well. Everything you read in this paper is hands on, roll- up- your- sleeves- and- get- busy material for Oracle users who want to get an Oracle database up and running quickly without reading hundreds of pages of documentation and . In order to keep the steps reasonably simple this paper does not cover Real Application Clusters (RAC), nor does it cover Oracle Internet Directory (OID), Automatic Storage Management (ASM), or Grid Control. In this paper we will install the 1. Oracle Database 1. This is the base distribution of Oracle Database 1. Be sure to check Oracle Support. You will need a valid Customer Service Identifier (CSI) number in order to access the Metalink website. We ran our Oracle installations on servers equipped with Intel Xeon processors running Red Hat Enterprise Linux ES release 5 (Tikanga), update 4 (x. Oracle Database 1. Linux distributions as well. Note that with Red Hat Enterprise Linux, the ES and AS varieties are supported while WS is not. There are four phases to getting Oracle up and running on your server: Prepare the server. Install the Oracle software and latest patch set. Create a database. Complete the server configuration. We will walk through these phases one at a time, detailing all the steps involved. The end result will be a very usable database that can be scaled up quite large, and an Oracle installation that follows industry- recognized best practices. Of course, every implementation is unique, and you will need to evaluate each step carefully against your particular requirements. However, this paper will get you off to a very solid start. The author wishes to acknowledge that this paper draws heavily from the previous Database Specialists, Inc. Prepare the Server. These steps configure your database server so that it will be ready to accept the Oracle software and database. In this section, we will make sure your server meets Oracle. All of the steps in this section are run as the root user. Make sure that your hardware platform (processor architecture) is certified by Oracle Corporation for use with Oracle Database 1. Oracle software for your hardware platform. As of May 2. 01. 0, the supported hardware platforms for Oracle on Linux are as follows: Supported Hardware Platforms for Oracle Database 1. Intel and AMD processor chips that adhere to the x. AMD6. 4/EM6. 4T and Intel processor chips that adhere to the x. The following commands can be used to identify the processor architecture on your database server: $ uname - m. Note that certifications vary by hardware platform. As of May 2. 01. 0, the supported Linux distributions are as follows: Supported Linux Distributions for Oracle Database 1. Oracle Enterprise Linux 5 update 2, kernel 2. Oracle Enterprise Linux 4 update 7. Red Hat Enterprise Linux AS/ES 5 update 2 or later. Red Hat Enterprise Linux AS/ES 4 update 7 or later. SUSE Linux Enterprise Server 1. SUSE Linux Enterprise Server 1. SP2 or later, kernel 2. Asianux 3. 0. Asianux 2. Be sure to check Oracle Support. Which packages and versions are required will vary depending on your Linux distribution and hardware platform. The package version specified is typically a minimum, meaning that newer versions of the package are usually acceptable. Required Packages for Red Hat Enterprise Linux 4. Oracle Enterprise Linux 4 and Asianux 2. Hardware Platform)binutils- 2. ODBC- 2. 2. 1. 1unix. ODBC- devel- 2. 2. Required Packages for Red Hat Enterprise Linux 5. Oracle Enterprise Linux 5 and Asianux 3. Hardware Platform) binutils- 2. ODBC- 2. 2. 1. 1unix. ODBC- devel- 2. 2. Required Packages for Red Hat Enterprise Linux 4. Oracle Enterprise Linux 4 and Asianux 2. Hardware Platform) binutils- 2. ODBC- 2. 2. 1. 1 (both 3. ODBC- devel- 2. 2. Required Packages for Red Hat Enterprise Linux 5. Oracle Enterprise Linux 5 and Asianux 3. Hardware Platform)binutils- 2. ODBC- 2. 2. 1. 1 (both 3. ODBC- devel- 2. 2. Required Packages for SUSE Linux Enterprise Server 1. Hardware Platform)binutils- 2. R2 Clusterware disk)unix. ODBC- 2. 2. 1. 1 (if intending to use ODBC)unix. ODBC- devel- 2. 2. ODBC)Required Packages for SUSE Linux Enterprise Server 1. Hardware Platform)binutils- 2. You can confirm that both have been installed with a command similar to the following: $ rpm - qa - -queryformat . There is a facility for performing non- interactive installations (. Your X environment can be the console on the database server, but it does not need to be. You can also use a Windows X emulator like Cygwin. If the database server is in a remote location, you can use SSH to securely forward X traffic from the database server back to your desktop. You can also use VNC to install remotely. We have run installations from a Windows desktop using both Cygwin and VNC and have had no problems with either. Over slow networks, VNC seems to be faster than X. Make sure that your hardware is sufficient. This will let you perform a . If you will be downloading the Oracle software from Oracle Technology Network at http: //www. Gb of additional disk space to download and unpack the Oracle software. A production implementation typically requires more RAM and more disk space than the minimums listed here. The following commands will allow you to check physical memory and swap space. Mem. Total /proc/meminfo. Swap. Total /proc/meminfo. The Oracle installer will need access to a directory with at least 1 Gb of free space for writing temporary files during installation. Usually /tmp serves this purpose. If /tmp on your database server has less than 1 Gb of free space, then you will need to locate another directory with sufficient free space for use during the installation. You can point at this other directory by setting the TMP and TMPDIR environment variables in the oracle user’s environment. Make sure that the Linux kernel on the database server has parameters set sufficiently high for Oracle. The Oracle architecture makes extensive use of shared memory segments for sharing data among multiple processes and semaphores for handling locking. Many operating systems, including Linux, do not by default offer sufficient shared memory or semaphores for optimal Oracle performance. Thankfully, you can change kernel parameters in Linux simply by editing the /etc/sysctl. The following script will show the current settings of the Linux kernel parameters relevant to Oracle. K=. Set to either (4. GB - 1) or 1/2 the size of physical memory (in bytes) whichever is lowersemmsl. Maximum number of semaphores per setsemmns. Maximum number of semaphoressemopm. Maximum operations per semop callsemmni. Maximum number of semaphore setsfile- max. Maximum number of open filesip. If you decide to configure a very large buffer cache or library cache for your database down the road, or if you choose to run a large number of databases on one server, then you may need to increase the shmall setting and possibly the shmmax setting as well. In addition, if you configure your database to allow a large number of concurrent sessions without using Oracle’s shared server architecture, then you may need to increase the semmsl and semmns settings as well. Note that these recommended settings assume you have no other applications running on the database server that use shared memory segments or semaphores. You can view current shared memory and semaphore usage on your system with the following command: $ ipcs. In general, if your Linux kernel already has any of these parameters set larger than recommended here, you should not reduce the settings. We added the following lines to the end of our /etc/sysctl. Kernel parameter settings for Oracle. You can call it anything you like, but the standard is . This group is often called the . If you will be installing Oracle on multiple servers on your network, you might want to keep the groupid the same on all servers. You can create your oinstall group with a command like. If you are using SUSE Linux, then you must also enter the GID of the oinstall group as the value for the parameter /proc/sys/vm/hugetlb. Doing this grants members of the oinstall group permission to create shared memory segments. For example, where the oinstall group GID is 5. You can call it anything you like, but the standard is . Anybody who logs onto the database server with a Linux login that belongs to this group will be able to log onto all databases that run from this Oracle software installation with DBA privileges. If you will be installing Oracle on multiple servers on your network, you might want to keep the groupid the same on all servers. You can create your dba group with a command like. Create a Linux user that will be the Oracle software owner. You can call it anything you like, but the standard is . If you will be installing Oracle on multiple servers on your network, you might want to keep the userid the same on all servers. You can create your oracle user with commands like. Oracle software owner' - d /home/oracle \. G dba - m - u 5. 01 - s /bin/bash oracle. The useradd command shown here gives your oracle user the Bash shell. You could just as easily choose Korn or Bourne shell instead. It is necessary to increase limits that the shell imposes on the oracle user for maximum number of open file descriptors and processes. Follow these steps to increase the limits. Add the following lines in the /etc/security/limits. Add the following lines to the /etc/pam.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2016
Categories |