How to install Oracle on openSuSE 11.3

Posted under Technical on September 25th, 2010 by
Note: I am writing this for people who just want to install Oracle for personal use, for learning Oracle. This tutorial is not for installing Oracle for production systems or any critical use. The instructions are for 32 bit systems, it should be same for 64 bit systems but I am not sure. I am installing on openSuSe 11.3, but these steps can also work for 11.1 and 11.2, but again I am not sure 🙂

I will write down the instructions as a series of steps.
  • Step 1: Download Oracle from Oracle Website. This is a 32-bit install. For 64-bit systems download from here. You will need UserId for Oracle. You will also need to accept the license agreement. The downloaded file will be “linux_11gR1_database_1013.zip”.

  • Step 2: Install “C/C++ Development” environment from Yast.
    1.C_Compiler

  • Step 3: Dwonload and install Orarun package. You will now get a User for Oracle. Open Yast(Adminsitration Settings), Select “Security and Users” tab and from there open “User Group Management”. On the resulting window set filter to “System Users”. From the list select “Oracle” and edit it. Set the password for user oracle on “User Data” tab.
    2.Ora_user_Password
    Go to “Deatils” tab and set the Login shell to “/bin/bash” (It will be /bin/false there). Save the changes and exit.
    3.Ora_User_Settings
  • Step 4: Just some cosmetic changes, if needed. Open “/etc/profile.d/oracle.sh”. Check parameters ORACE_BASE, ORACLE_HOME, ORACLE_SID. You can change ORACLE_SID if you want it to be something different, by default it is “ORCL”.
    4.oracle_sh_set
    Modify the following parameters in “/etc/sysconfig/oracle”. [code lang=”perl”] AIO_MAX_SIZE=1048576 FILE_MAX_KERNEL=6815744 IP_LOCAL_PORT_RANGE="9000 65500" [/code] Modify the following parameters in /etc/init.d/oracle: 
    test -f /proc/sys/fs/aio-max-nr && echo "  AIO_MAX_SIZE=${AIO_MAX_SIZE:-1048576}"
test -f /proc/sys/fs/aio-max-nr && echo ${AIO_MAX_SIZE:-1048576} > /proc/sys/fs/aio-max-nr
test -f /proc/sys/fs/aio-max-nr || echo
    You will need superuser priviliges for modifying these files.
  • Step 5: Start Oracle server. 
    sudo /usr/sbin/rcoracle start
    You will get a output like:
    8.rcoracle_start
  • Step 6: Either logg off and log in as Oracle user. Or you can Switch to Oracle user (Application Launcher -> Leave -> Switch USer). Login user id is “oracle” and use the password you hav set in Step 2. After logging inCheck some details.

    no images were found
  • Step 7: Unzip the download oracle installation zip file ( Step 1). 
    unzip linux_11gR1_database_1013.zip
    You will now get a new directory “database”. Go to that directory and run “runInstaller” script. Before running set the execution permissions for whole database directory. Check the snapshot below:
    12.runInstaller
  • Step 8: Now the oracle installer will fire up.
    13
    Tick the “Create Starter Database” checkbox if you want the example databses to be installed and enter the password of your choice and click Next button. You may get a warning that directory does not exist, click OK button and move forward. Next window will be to Specify inventory localtion. This should be 
    /opt/oracle/oraInventory
    15
    You will get a warning, click YES there.
    16
    The installer will check for pre-requisites and will throw some warnings and requirements.
    17_Warnings
    You need to manually tick those warnings and requirements.
    18_Warnings_Verified
    After that hit Next button and you will be taken to “Oracle Configuration Manager Registration”. You can skip this window by hitting Next button.
    19_Config_mgr
    Now will come the summary of software which will be installed. Verify and click Next.
    20_Summary
    The installation will start.
    21_Installing
    22_dca
    The installation process will take time so be patient. After installation will finish a window will pop up giving deatils of the installation.
    23_password_mgr
    If you want to unlock accounts and set custom password you can do it by clicking on “Password Management” here.
    24_set_passwords
    After finishing with this, oracle will display a window which will display scrips which you need to run as root.
    25_run_scripts
    Run the scripts and the oracle installation finishes.
    26_install_complete
Now, whenever you want to start your oracle, First fire up konsole and start Oracle service 
sudo /usr/sbin/oracle start
27. oracle_start_service

Then become oracle user (You do not need to login from GUI as you did in Step 6, but doing it from konsole will do). Start Oracle Listner. 

lsnrctl start
Now login to idle session of oracle and connect as sys and start the database. 
sqlplus /nolog
Connect as sys user. 
connect sys as sysdba
And start the Oracle database. 
startup
Check the snapshots below:
28. lsnr_start
29. start_oracle


Let me know if this post has helped you or if I have missed something.
  1. medvedevvu left a comment on January 14, 2011 at 1:57 AM

    when i tryed to install i got this error’s

    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    Starting Oracle Universal Installer…

    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ./runInstaller: line 92: 5524 Segmentation fault (core dumped) $CMDDIR/install/.oui -oneclick

    Reply
  2. medvedevvu left a comment on January 14, 2011 at 11:00 AM

    when i tried to run runInstaller i got this error

    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    Starting Oracle Universal Installer…

    ERROR: ld.so: object ‘/usr/lib/libInternalSymbols.so’ from LD_PRELOAD cannot be preloaded: ignored.
    ./runInstaller: line 92: 5524 Segmentation fault (core dumped) $CMDDIR/install/.oui -oneclick

    Reply
    • Vivek Bhat left a comment on January 21, 2011 at 8:43 PM

      Hi medvedevvu…

      It seems some thing is corrupted… are you installing 11gR1 or 11gR2. I have not succeeded with installing 11gR2 in openSuSE till now 🙁

      Reply
  3. chris left a comment on February 12, 2011 at 5:55 PM

    I have used oratoolkit to prepare the installation -> it is fast and easy and (from my view) better then orarun.

    Cheers
    Chris

    Reply
  4. Petr Vanek left a comment on March 14, 2011 at 9:40 PM

    Playing with it on brand new openSUSE 11.4 with oracle 11R2 64bit. Installation goes very nice with new orarun (orarun-1.9-172.20.21.54.x86_64.rpm). Just intall orarun, change oracle user pass and login shell, start installer (xhost +) and click in the wizard.

    Of course it complains about missing packages (it checkes exact name and versions) but all required libs and tools are in standard repository under different package names.

    Reply
    • Vivek Bhat left a comment on March 14, 2011 at 10:09 PM

      Hey Peter.. great to hear that, I too just made a clean install of openSuSE 11.4 yesterday and was thinking of installing Oracle in it. But I am undecided if I should install it in virtual box or directly.. let’s see 🙂
      btw can you give me the link of orarun-1.9-172.20.21.54.x86_64.rpm you have used(If you have that..) I was running 32 bit openSuSE till now, but with 11.4 I also switched to 64 bit.

      Reply
  5. Petr Vanek left a comment on March 19, 2011 at 8:59 PM

    here it is: http://ftp.novell.com/partners/oracle/sles-11/

    Reply
  6. Roger Appleby left a comment on March 26, 2011 at 1:33 PM

    I have done this for Oracle 11gR2 and everything works fine – the installer comes up – however there is a new check for the packages required (which I have installed) – they all fail. It seems that the oracle user cannot see any of the root packages. There must be something missing (I gave oracle the root group – still no luck). It cannot even read the config files (which I altered per your suggestion). Probably not exactly an Oracle problem – must be missing permissions somewhere. openSuse 11.3. Any suggestions?

    Reply
    • Vivek Bhat left a comment on March 26, 2011 at 2:35 PM

      Hi Roger,

      I installed 11gR2 a week before and it did complain about missing packages which were installed but were under a different version numbers(If you check Petr’s comment above, he also says that it compains about missing dependencies), so I checked the box labeled ignore failures (Or something like that) and proceeded with the installation. The installation was successful.

      May be you should also check the ignore box. If you are installing Oracle for personal use then it should be OK, but if you are installing for some critical application.. then the root cause has to be found out. As for me, I install oracle for just learning purpose and thus this does not cause a lot of concern to me.

      Reply
      • Roger Appleby left a comment on March 26, 2011 at 6:42 PM

        Vivek,

        Thanks, I noticed that this was the case as well. I was working on this at 1 in the morning and my brain was like molasses. Glad to get confirmation though. My installation is in openSUSE in VirtualBox – not bad but to rebuild from the live CD with all the updated is a pain. (yes I use snapshots – but there are times when a rebuild is unavoidable). And yes this is a learning experience for me – but I have a client eagerly waiting.

        Reply
  7. Kay left a comment on June 16, 2011 at 7:20 PM

    Hello Vivek,

    thanks a lot for your work — it was very helpful to me.

    I installed Oracle 11gR2 on openSUSE 11.4, and I could use a lot of the experience you shared.

    Greetings from Germany
    Kay

    Reply
  8. José left a comment on September 5, 2011 at 5:34 AM

    Hi, i’m having problems with orarun.rpm, dont create the oracle user and dba group.
    I’m tried a few times but nothing happened.
    Any suggestions?

    Thanks

    Reply
  9. Installation of Oracle 11g R1 on SuSE Linux Enteprise Server (SLES) 10 and OpenSuSE 10.3 | Wanderer left a comment on November 8, 2012 at 5:19 AM

    […] How to install Oracle on openSuSE 11.3 This entry was posted in Uncategorized by admin. Bookmark the permalink. […]

    Reply

Leave a Comment

Your email address will not be published. Required fields are marked *

CAPTCHA

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.

©2024 By Vivek Bhat.