Thursday, March 3, 2011

Oracle Software Installation steps

This document briefs about the step by step procedure of installing Oracle software (Database/Client).

Step 1: Decide the Oracle database software (version and release) to be installed on the server.

Step 2: Go to download.oracle.com and sign in with your username/password and download the Oracle database software.

Step 3: Transfer the downloaded file to the desired server in which the installation has to be made. (ftp/sftp/scp)

Step 4: Unzip the file.
            Note: If the file is in cpio.gz format, use the following command to unzip
            $ cpio -icvdu < 10gr2_aix5l64_client.cpio.gz where 10gr2_aix5l64_client.cpio.gz is the file name

Step 5: For Unix based servers do the following before installing the software.
            1. Download mocha X server freeware software from the link
http://www.mochasoft.dk/freeware/x11.htm (Optional if already installed)
            2. Install mocha X server on your windows based OS (Optional if already installed)
            3. Run mocha X server from your windows based OS
            4. Open putty tool and configure putty for the sync of mocha X server and putty session.
                        a. Enter host name
                        b. click ssh under connections tab
                        c. click x11
                        d. click on the 'enable x11 forwarding' check box
                        e. Enter ip address of your windows based OS in the 'X display location' tab.
    e.g. 135.117.1.20:0.0
                        f. save settings and open putty session for the desired server

Step 6: Export the display by following command
            $ export DISPLAY=135.117.1.20:0.0
            Note: To test display type 'xclock'

Step 7: Check for the pre-requisites has been completed for Oracle software installation.

  • Logging In to the System as root
  • Checking the Hardware Requirements
  • Checking the Software Requirements
  • Installation Fixup Scripts
  • Enabling Core File Creation
  • Installing the cvuqdisk Package for Linux
  • Checking the Network Setup
  • Creating Required Operating System Groups and Users
  • Check Resource Limits for the Oracle Software Installation Users
  • Configuring Kernel Parameters for Linux
  • Identifying Required Software Directories
  • Identifying or Creating an Oracle Base Directory
  • Choosing a Storage Option for Oracle Database and Recovery Files
  • Creating Directories for Oracle Database or Recovery Files
  • Configuring Storage for Oracle Database Files Using Block Devices
  • Configuring Disk Devices for Oracle Database
  • Stopping Existing Oracle Processes
  • Configuring the oracle User's Environment

Note: For detailed explanation of the above, please refer to Oracle installation guide for different platforms from Oracle documentation.

Step 8: After all the pre-requisites has been done, start the Oracle universal installer.
            1. Go to the specific directory where the database software is present
            2. $ ./runInstaller
            Note: For AIX based servers run rootpre.sh before invoking OUI.
            3. GUI window will be popped up for installation.
            4. Follow the instructions to complete the installation.

Step 9: Edit the .profile/.bash_profile for setting Oracle environment.
            For e.g. ORACLE_BASE=/oracle/app; export ORACLE_BASE
                                 ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
                                 PATH=/usr/sbin:$PATH; export PATH
                                 PATH=$ORACLE_HOME/bin:$PATH; export PATH
                                 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
                                CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export CLASSPATH

Step 10: Test the installation by doing the following
1.      $ .oraenv
2.      ORACLE_SID = [oracle] ? (click enter)
3.      ORACLE_HOME = [/home/oracle] ? (Your oracle home as per installation)
4.      $ sqlplus


Following these steps would lead to a successful Oracle Database/Client Software installation on the server.

2 comments:

  1. Hi Mamu
    Can you please post a screen shot for this part.

    Step 5: For Unix based servers do the following before installing the software.
    1. Download mocha X server freeware software from the link
    http://www.mochasoft.dk/freeware/x11.htm (Optional if already installed)
    2. Install mocha X server on your windows based OS (Optional if already installed)
    3. Run mocha X server from your windows based OS
    4. Open putty tool and configure putty for the sync of mocha X server and putty session.
    a. Enter host name
    b. click ssh under connections tab
    c. click x11
    d. click on the 'enable x11 forwarding' check box
    e. Enter ip address of your windows based OS in the 'X display location' tab.
    e.g. 135.117.1.20:0.0
    f. save settings and open putty session for the desired server


    Thanks


    Ghufran

    ReplyDelete
    Replies
    1. It is not necessary to use mocha X server but you can use any available X windows client like Xming, VNC viewer, etc,.

      Delete

I don't know what you think about my creation, but every words of you help me grow better and stronger!!