clicksor ad

Thursday, January 12, 2006

Oracle 9.2 on SUSE 9.3














































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


Installation Steps

  1. Install SUSE Linux Operating System

    2. 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

      2. 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.

        2. # rpm -ivh --nodeps o

        rarun-1.8-109.12.i586.rpm

      1. Install libaio, libaio-devel and pdksh from SUSE Linux 9.3 media.

      2. 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/10g
        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 <>

      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:



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

      2. 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.

    2. Oracle Database Start at boot time

      3. 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".
        i.e. mydb:/opt/oracle/product/10g:Y

      2. Edit dbstart, dbshut and dbhome scripts to reflect correct location for ORATAB entry. i.e ORATAB=/etc/oratab

        3. 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.

        4. #ln -s /usr/lib/libdb.so.3 /usr/lib/libdb.so.2





visit http://www.novell.com/coolsolutions/feature/14631.html
Posted by Ramesh at 3:18 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
Disclaimer:This blog was created as a service to those looking for oracle Database Administration related expert material and might not have resources . It is not the purpose of this site to infringe on any author's rights. If you are an author, and a article of yours is listed here, and it is not your intention to make it freely available, please contact me it.infotech@gmail.com and the article will be removed.I do not have control over what is posted on the numerous oracle groups and forums , I am merely listing those articles that I have found from numerous searches.