venerdì 14 giugno 2013

How-to Install and Getting-Started on Oracle 11g for OpenSuse Linux 11-12

This is an Easy and Step-by-Step Guide to Install the Oracle 11g R2 Database on OpenSuse Linux 11 and 12 Milestone

Relax and Take the Time to Reading, Understanding and Executing Carefully the Instructions Contained here.

To the Post Bottom you Find Links to Oracle 11g Database Detailed Troubleshooting Guides.

OpenSuse Oracle Camaleon
  1. Download the Oracle 11g R2 Database:

    The Link Contains the List of Oracle 11g r2 Database Releases.
  2. Open a Terminal Window
  3. Login as SuperUser:
    su
  4. Make Network Configuration

    Check you hostname and IP is on /etc/hosts

    Get your hostname:
    hostname
    Get your IP:
    /sbin/ifconfig

    You will Find your Ip under the Output "lo" Section.

    Check if Hostname and IP are already inserted into the Enabled Hosts File.
    cat /etc/hosts
    If It's Not Present then Insert it!
    nano /etc/hosts

    Insert: <IP HOSTNAME.DOMAINNAME HOSTNAME>

    Example: '127.0.0.1 localhost.localdomain localhost' Add you Host IP to the List of Hosts Granted of Connection with the X Server
    xhost +<yourIP>
    Example: #xhost +127.0.0.1
  5. Install dependencies
    zypper install libstdc++46-devel libstdc++33 libstdc++33-devel \
    libelf-devel gcc-c++ libaio-devel sysstat unixODBC unixODBC-devel
    
  6. Add Groups and User
    groupadd -g 502 oinstall
    groupadd -g 503 dba
    groupadd -g 504 oper
    groupadd -g 505 asmadmin
    useradd -u 502 -g oinstall -G dba,asmadmin,oper -s /bin/bash -m oracle
    passwd oracle
  7. Create the directories where Oracle will be installed and give right ownership and permission
    mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
    chown -R oracle:oinstall /u01
    chmod -R 775 /u01
  8. Set Kernel's Parameters Add or amend the following lines in the /etc/sysctl.conf file.
    fs.suid_dumpable = 1
    fs.aio-max-nr = 1048576
    fs.file-max = 6815744
    kernel.shmall = 2097152
    kernel.shmmax = 536870912
    kernel.shmmni = 4096
    # semaphores: semmsl, semmns, semopm, semmni
    kernel.sem = 250 32000 100 128
    net.ipv4.ip_local_port_range = 9000 65500
    net.core.rmem_default=4194304
    net.core.rmem_max=4194304
    net.core.wmem_default=262144
    net.core.wmem_max=1048586
    
    Comment out these lines below than give an error #net.bridge.bridge-nf-call-ip6tables = 0 #net.bridge.bridge-nf-call-iptables = 0 #net.bridge.bridge-nf-call-arptables = 0 Add the following lines to the /etc/security/limits.conf file.
    oracle              soft    nproc   2047
    oracle              hard    nproc   16384
    oracle              soft    nofile  1024
    oracle              hard    nofile  65536
    oracle              soft    stack   10240
    
    Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows.
    SELINUX=disabled
    
    Run the following command to Load the New Kernel Parameters.
    /sbin/sysctl -p
  9. Unzip the Oracle 11g Database, Set oracle as Owner and Move it into the oracle's Home
    cd </path/To/linux_11gR2*.zip>
    unzip linux_11gR2_database_1of2.zip
    unzip linux_11gR2_database_2of2.zip
    chown -R oracle:oinstall database
    mv database /home/oracle
  10. Add Environment Variables to oracle's .bashrc Login as Oracle
    su oracle
    Edit .bashrc file
    nano /home/oracle/.bashrc
    Insert:
    # Oracle Settings
    TMP=/tmp; export TMP
    TMPDIR=$TMP; export TMPDIR
    
    ORACLE_HOSTNAME=<HOSTNAME>; export ORACLE_HOSTNAME
    ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
    ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
    ORACLE_SID=<DBSID>; export ORACLE_SID
    
    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/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
    
    Substitute HOSTNAME and DBSID with the Values you Will Use During Software Installation In this Example Respectively:
    • HOSTNAME = 127.0.0.1
    • DBSID = SID

    Load New .bashrc Settings

    source ~/.bashrc

    Last and Optional to Add Full Env-Integration edit also oracle's .bash_profile

    nano ~/.bash_profile

    Inserting

    if [ -f ~/.bashrc ]; then
         source ~/.bashrc
    fi
    
  11. Install the Oracle 11g Software
    cd /home/oracle/database
    ./runInstaller

    If you Get: "Check if the DISPLAY variable is set. Failed". Look Link Below.

    Link2+ Oracle 11g Database Troubleshooting

    Linux Start Oracle 11g R2 Installation

    On the first screen If you Do Not Dispose of an Oracle Subscription Just Leave Blank eMail and Un-Check the Demand of Security Update Support then Click on Next Linux Oracle 11g R2 Installation Step 1 - Disabling Security Updates

    Then Confirm on Warning and Follow. Linux Oracle 11g R2 Installation - Confirm on Missing eMail Warning

    On "Select Installation Option" Select "Install database software only" and Click on Next Linux Oracle 11g R2 Installation Step 2

    On Step 3 Leave Default "Single instance database installation" and Click on Next Linux Oracle 11g R2 Installation Step 3

    On Step 4 Select your Language and Click on Next Linux Oracle 11g R2 Installation Step 4

    On Step 5 Leave Default Enterprise Edition and Click on Next Linux Oracle 11g R2 Installation Step 5

    On "Installation Location" Set All As Here Below and Click on Next

    • Oracle Base: /u01/app/oracle
    • Software Location: /u01/app/oracle/product/11.2.0/dbhome_1

    These are the Same Settings Inserted into the .bashrc File...

    Linux Oracle 11g R2 Installation Step 6

    On "Create Inventory" if you Setup the Path on .bashrc Like Here Leave Default and Click on Next Linux Oracle 11g R2 Installation Step 7

    On "Operating System Groups" if you Setup the Path on .bashrc Like Here Leave Default and Click on Next Linux Oracle 11g R2 Installation Step 8

    On "Prerequisite Checks" you will Get Easily a "Warning Message" about some Missing Requirements

    Just Check: "Ignore All" and Follow Up with Installation...

    Linux Oracle 11g R2 Installation Step 9

    On the "Summary" Click on "Save Response File" to Take Note of Settings and then Click on Finish Linux Oracle 11g R2 Installation Step 10

    The Installation Product Procedure should Start...

  12. Solve Error in invoking target agent nmhfs of makefile
    Oracle 11g Error in Invoking Target Agent nmhs of makefile Linux Oracle 11g R2 Installation Step 11 Right Before the End of Process a Pop-Up Window will Show the Path to Two Configuration Scripts you Need to Execute on Terminal!

    Last Oracle Should Confirm you of a Successful Installation End.) Linux Oracle 11g R2 Installation Step 12

  13. Create and Run a Listener for Oracle 11g
  14. Linux Penguin Oracle 11g
  15. How-to Create a Database for Oracle 11g

    Guide with Detailed Instruction 2 Create a Database for Oracle 11g.

After you Should Access the "Enterprise Manager" on Browser by the URL shown on the Last Screen. On a Localhost for Example you Should Access the Enterprise Manager by the Address:
https://127.0.0.1:1158/em
And you can Login with: User Name: SYS Password: oracleDatabasePassword From the Drop-down below Select >> Connect as SYSDBA You Should be Able to Access the Database by the Enterprise Manager!
How Managing, Start & Stop Oracle 11g R2 Database by SQLPlus Commands
SQLPlus Oracle 11g DB Quick-Start

Oracle 11g Database Troubleshooting Guides

Enjoy this "Step by Step" Clear Installation and Getting Started... Goodk Luck! :)