e-mail   
 Menu
  Home
  Download
  Top 10 Downloads
  Last 15 New Files
  Web Links
  Tips
  Last 15 New Tips
  NLM Programming
  Admins Club





Installation and Administration






Polish Forum SUSE




Novell Connection Magazine


 
Who's Online

 There are currently,
5 guest(s)
that is (are) online.
 


Technical Information

Back to List of Categories

Technical Information about
  A Little YaST Magic
  A Slideshow for Your KDE Wallpaper
  Add Novell Support to Your Firefox Search Engine
  Adding To The Panels In Gnome.
  Akregator - RSS News Reader
  An Introduction to WBEM and OpenWBEM in SUSE LINUX
  Authenticating SUSE LINUX to eDirectory via LDAP
  Basic Mounting Differences between Windows and Linux
  Beginner's Guide to Using Novell SUSE LINUX's Build Utility
  Browsing Files
  Card Readers on SUSE LINUX 9.2 Professional?
  Changing the Default Browser in Gnome
  Developing Perl CGI scripts on SUSE LINUX
  Do I Have Permission?
  Double SYNC -- Using RSYNC Simultaneously With and Without Branch Office for Data Backup
  Dumb Question: Mounting Linux CDs
  Easy Command-Line Introduction
  Easy Way to Debug SSL Connections
  Enabling an Interactive Startup in Novell/SUSE LINUX
  Exploring MySQL 4.1 and PHP 5 on SUSE LINUX
  Extend Your Panels Using Gnome Drawers.
  Firefox Speed Tip
  Fix Java Errors With ConsoleOne On Linux
  Fix Your Mouse Wheel...
  Gimp -- Closing In on Photoshop...
  Gimp Tips Part 1: Resizing Images
  Gimp Tips Part 2: Rounding Corners
  Gimp Tips Part 3: Fading Photography Edges
  Gimp Tips Part 4: Selective Colorization
  Gimp Tips Part 5: Plugins a Plenty - Adding Light
  Gimp Tips Part 6: Using The Clone Tool
  Google Auto-fill Replica for Linux
  How a Corrupted USB Drive Was Saved by GNU/Linux
  How to Implement Login Scripts into a Pure Linux Environment
  How to install and connect an External Modem on a Linux PC
  How to Install the Novell Client for Linux on SUSE Linux 10.0
  How to launch applications at login in Gnome
  How to Remote Control Linux
  How to setup a Linux application to automatically startup when you login.
  How to share Files and Printers Between Linux and MS Windows with Samba
  How to uninstall the Novell Client for Linux
  How to upgrade the Novell Client for Linux
  How to use SMB without turning off the firewall
  How's the Weather?
  HTML Development Tools in Linux
  Informative Bash Prompt
  Install and Use QEMU on SUSE 9.2
  Install Linux Frequently, Without the Hassle
  Installing Apache, PHP, and MySQL on SUSE LINUX Professional
  Installing RPM Files
  Integrating Novell Linux Desktop into a Novell NetWare network
  Introduction to Oracle 10g R1 (10.1.0.3) on SUSE LINUX Professional 9.3
  iPrint Printers on Novell Linux Desktop
  Linux Scheduling Priorities Explained
  Make a Misbehaving Program Quit
  Manually Mounting a USB Flash Drive in Linux
  Migrating To Linux, Advantages Over Windows 9.x And XP
  Minimize Your Maximizing with Multiple Desktops
  Mounting NetWare Volumes On NLD Illustrated
  Move Your /home to Another Computer
  Mozilla Mail Review
  Need a Backup?
  Novell Client Settings with Windows Terminal Server
  Novell Linux Desktop Equivalents of Windows Software - New and Improved
  Novell Linux Desktop System Upgrade How-To
  Partitioning Hard Drive for Linux Install
  Perform Remote SuSE Installations With Virtual Network Computing
  Quick Intro to Klipper
  Quick Shortcuts in The Gimp
  Reset Your Lost Root Password
  Resizing Your Gnome / KDE Panels
  Runlevels in SUSE LINUX
  Running Existing Win32 Applications on SUSE LINUX
  Service Command in /etc/init.d/
  Setting Shortcut Keys
  Setting up a Linux NFS Install Source for Your LAN
  Should I choose Novell Linux Desktop or SUSE LINUX Professional as my desktop?
  Starting Services From the Command Line On SuSE LINUX
  Sticky Notes for Gnome
  SUSE LINUX 9.3 Professional Review
  Sync Up The Taskbar and the Desktop in Gnome
  System Upgrade How-To
  Taking Screenshots in Linux
  The Basics of Messaging in the Cross-Platform GroupWise Client
  The Novell Client for Linux (beta).
  Transparent Panels in Gnome
  Trick Out Your KDE Desktop
  Understanding the YAST Software Module Options
  Updating Your Software with Red Carpet
  Using dsbk on Linux and Unix
  Using iFolder to Synchronize Firefox Bookmarks
  Using Multiple Swap Partitions In 2.4
  Using openSSH to Securely Access Remote Systems
  What FTP client should I use on Linux?
  What Is Logical Volume Management?
  What is so great about Firefox?
  Which Graphic Formats For What?
  Windows Shortcuts for Firefox Tabs on Linux
  Windows to Linux: A Beginner's Guide
  Windows Users Can Feel at Home Exploring Files in Linux
  WLAN interface as the Default
  Work With User Selection Icons In KDM
  YAST Online Update De-Mystified

Technical Information
 Introduction to Oracle 10g R1 (10.1.0.3) on SUSE LINUX Professional 9.3

Printer-friendly version

Posted: 15 Apr 2005

Introduction

This paper is designed to help you get started with Oracle 10g on SUSE LINUX 9.3. This will help you to work on latest SUSE OS and latest Oracle Database 10g from Oracle. Oracle 10g is supported and certified only on SUSE LINUX Enterprise Server (SLES), but occasionally for development and testing purposes you will prefer to have it up and running on your desktop for quick access. Instruction provided here will also work on SUSE LINUX 9.2.

Hardware Requirements

The system must meet the following minimum hardware requirements:

Requirement Minimum Value
RAM 512 MB
Swap space Approx. twice the size of RAM
Disk space in /tmp 400 MB
Disk space for software files 2.5 GB (2621440 KB)
Disk space for database files 1.2 GB

Required Software

You need SUSE LINUX 9.3 and Oracle 10g. Also, Novell/SUSE orarun package will help you to make Oracle pre-Install task simple.

Novell/SUSE

  1. Novell SUSE LINUX 9.3 (ftp install location: ftp://ftp.suse.com/pub/suse/i386/9.3/)
  2. orarun : Get latest version from
    (http://ftp.novell.com/partners/oracle/sles-9/)
  3. Novell/SUSE Documents are available here:
    http://www.novell.com/documentation/
  4. For more "Oracle on SUSE" related information visit
    http://www.novell.com/oracle.

Oracle

Oracle database 10g R1(10.1.0.3) Software is available for download from Oracle web site. File name: ship.db.lnx32.cpio.gz.

  1. URL to Download:
    (http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/linuxsoft.html).
  2. Oracle Documents are available on
    http://www.oracle.com/technology/documentation/database10g.html
  3. Oracle Development Tools:
    http://www.oracle.com/tools/index.html

Installation Steps

  1. Install SUSE LINUX Operating System

    Follow the Installation instructions provided in the SUSE LINUX 9.3 installation manual. We will focus on Oracle related component and make sure you meet Oracle software space requirement.

    SUSE LINUX 9.3 with default packages along with "C/C++ Compiler and Tools" is sufficient for Oracle 10g R1 (10.1.0.3) install. Here is snap-shot from my system.

    Check whether C/C++ compiler is installed. "gcc --version" will show "gcc (GCC) 3.3.3 (SUSE LINUX)". If gcc is not installed, then use YaST setup tool to install "C/C++ Compiler and Tools".



  1. Oracle Install prerequisites

    Refer to Oracle installation document for complete list of prerequisites. Novell/SUSE provides orarun packages to automate most of the Oracle pre-install task. orarun package is not included in SUSE LINUX 9.3 as this is for SUSE LINUX Enterprise Server.

    Note: orarun is only available on x86. You can use orarun on other platforms (x86-64), but on these platforms please comment out the following line from the file "/etc/profile.d/oracle.sh" and "/etc/init.d/oracle":
    #test -d /lib/i686 && export LD_ASSUME_KERNEL=2.2.5

    orarun :

    1. Install orarun package. It will ask to install dependent packages first.
      # rpm -ivh --nodeps orarun-1.8-109.12.i586.rpm
    2. Install libaio, libaio-devel and pdksh from SUSE LINUX 9.3 media.
    3. Please ignore xshared not available conflict reported by YaST. Here is snap-shot:


    1. Now orarun package is installed. Please enable newly created "oracle" user for Oracle 10g installation.
      1. The account for oracle user is disabled. Enable it, by changing the shell for the "oracle" user from "/bin/false" to "/bin/bash", either by using YaST setup tool or by editing the "/etc/passwd" file.
      2. Set a new password for user "oracle" i.e. "/usr/bin/passwd oracle".

      You can use SUSE setup tool YaST to accomplish above tasks.

      /sbin/yast2 -> "security and Users" -> "Edit and create groups"
      (Select users tab and set "System Users" filter to see oracle user.)

      Following are the screen shots of "oracle" user properties:





    1. Now set your Oracle environment variables.
      1. Change Oracle home directory by editing ORACLE_HOME variable in "/etc/profile.d/oracle.sh" file. ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
      2. Default ORACLE_SID set by orarun install is "mydb". Change it to your preferred name in "/etc/profile.d/oracle.sh" file.

    2. Run "/usr/sbin/rcoracle start" to set kernel parameters. Ignore ORACLE_HOME not set message as this will get fixed once Oracle 10g is installed.
    3. Exit from current root user session and login as new "oracle" user. Following is snap-shot verifying current user.


  1. Oracle 10g R1 (10.1.0.3) Installation
    1. Get Oracle 10g R1 (10.1.0.3) Software from oracle web or use your Oracle Database 10g CD. If you have downloaded SW ( ship.db.lnx32.cpio.gz) then use gunzip and cpio to extract files:
      1. gunzip ship.db.lnx32.cpio.gz
      2. cpio -idmv < ship.db.lnx32.cpio

    2. Make sure you are logged in as "oracle" user.
      You will get following Oracle Install error If logged as a root:



    1. Run Oracle Universal installer : ./runInstaller

      If you are installing from CD mounted as /media/cdrom then "cd /tmp && /media/cdrom/runInstaller" will be helpful.

      Note: SUSE LINUX 9.3 comes with latest version of openmotif package. Please ignore openmotif warning and continue with the installation.
    2. Installation will walk you through with self explanatory instructions. Here are screen-shots from simple Oracle 10g Installation:















  2. sqlplus: Startup and Shutdown of the Oracle10g Database (Manual)

    From diagnostic point of view it is very important to check sqlplus is functioning properly. If not then your installation is having problems.



    1. To startup the database:
      sl93$ sqlplus /nolog
      SQL> connect / as sysdba
      SQL> startup
    2. To shutdown the database:
      sl93$ sqlplus /nolog
      SQL> connect / as sysdba
      SQL> shutdown
    Note: "/" connects you to the schema owned by SYS with the privilege SYSDBA.

  3. Oracle Database Start at boot time

    Set parameter START_ORACLE_DB="yes" in "/etc/sysconfig/oracle" file. You can edit file "/etc/sysconfig/oracle" manually or use YaST setup tool to change oracle specific parameters.

    "/sbin/yast2->System->/etc/sysconfig Editor ->Productivity->Databases"



    1. Edit /etc/oratab entry corresponding to your database to "Y".
    2. Edit dbstart, dbshut and dbhome scripts to reflect correct location for ORATAB entry. i.e ORATAB=/etc/oratab

      Note: If you are lazy in editing /etc/oratab entries then following will do:

      #ln -s /etc/oratab /var/opt/oracle/oratab
    3. Create symbolic link to start Apache Server.
      #ln -s /usr/lib/libdb.so.3 /usr/lib/libdb.so.2
    1. Oracle Enterprise Manager
      1. Start Oracle listener, If it is not already started by "lsnrctl start". If it fails, then make sure your listener.ora file has proper SID_DESC entry.
      # listener.ora Network Configuration File: 
      
      /opt/oracle/product/10gR1/network/admin/listener.ora
      # Generated by Oracle configuration tools.
      ...
          (SID_DESC =
            (SID_NAME = orcl)
            (ORACLE_HOME = /opt/oracle/product/10gR1)
            (GLOBAL_NAME = ORCL)
          )
       ....

        1. If dbconsole Oracle services is not started, then start it manually by entering following command "emctl start dbconsole".
        2. Enterprise Manager web interface ( http://localhost:5500/em) to perform routine database administration and tuning tasks.


      Conclusion

      This is first step in getting familiar with Oracle Database. Enjoy and don't forget Oracle 10g is only supported and certified to be used on SUSE LINUX Enterpriser Server.






      Portal posiada akceptację firmy Novell Polska
      Wszystkie materiały dotyczące produktów firmy Novell umieszczono za zgodą Novell Polska
      Portal has been accepted by the Novell Polska
      All materials concerning products of Novell firm are placed with Novell Polska consent.
      NetWare is a registered trademark of Novell Inc. in the United States and other countries.
      Windows is a trademark or a registered trademark of Microsoft Corporation in the United States and other countries.
      Sybase is a registered trademark of Sybase Inc. in the United States of America.
      Other company and product names are trademarks or registered trademarks of their respective owners.