How to install Oracle on openSuSE 11.3

Posted on September 25, 2010 by Vivek Bhat
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:
    ?View Code CONF
    1
2
3

    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.
    ?View Code UNIX
    1

    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. [SinglePic not found]
  • Step 7: Unzip the download oracle installation zip file ( Step 1).
    ?View Code UNIX
    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
    ?View Code UNIX
    1

    /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
?View Code UNIX
1

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.

?View Code UNIX
1

lsnrctl start
Now login to idle session of oracle and connect as sys and start the database.
?View Code UNIX
1

sqlplus /nolog
Connect as sys user.
?View Code UNIX
1

connect sys as sysdba
And start the Oracle database.
?View Code UNIX
1

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.

About Vivek Bhat

Born in Srinagar, Kashmir and living in exile since 1989. I completed my schooling from Jammu (J&K) and College from Amravati, Maharashtra. Now I am working as a software engineer. My hobbies are reading, listening music, software development and riding my bi-cycle.
This entry was posted in Technical. Bookmark the permalink.

13 Responses to How to install Oracle on openSuSE 11.3

  1. medvedevvu says:
    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 says:
    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
  3. chris says:
    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 says:
    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 says:
      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
  6. Roger Appleby says:
    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 says:
      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 says:
        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 says:
    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é says:
    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

Leave a Reply

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

*

CAPTCHA Image

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>