A First Look at Oracle 11g database on Debian GNU/Linux

Three and half years have passed since my first attempts to install Oracle 10g on an unsupported Debian GNU/Linux distribution. Seeing that Oracle 11g is out, and exclusively for Linux at this time, I decided to download it among the first and see and share with you what it's installation looks like.

The distribution can be downloaded from the Oracle Database Software Downloads page, but let me warn you upfront that the archive is 1.7GB in size, so you'll need quite a big pipe to successfully download it. What makes it even harder is that Oracle insists that you download it from browser window (Wget and similar utilities won't work out of the box, although there are some tricks that can be deployed), so be prepared to have that browser window open for a long time and prey that download doesn't break along the way.

I won't go into details with preparation tasks (stuff you need to do even before you launch the installer), because that is very well documented (Oracle database has great, although a bit overwhelming, documentation). When you unpack the zip archive, you can access the documentation with your browser (iceweasel welcome.html). Suffice to say that you at least have to create an oracle user and group, and recheck you shared memory parameters.

./runInstaller

OK, so after we have launched the installer, we're greeted with the welcome window which gives us opportunity to change the default installation directory, and tune some other aspects of this installation.

I chose the option to create the Starter Database, to see how it works. But at this time I skipped the option to do the Advanced Installation. Some more configuration windows follow, be sure to pick appropriate paths for your new install.

Finally, we reach the step where Oracle checks some system parameters (Prerequisites Check) where it finds that the install is not running on a certified Linux distribution. But it's quite cleverly architected, the installation doesn't break, instead it forces you to confirm that is really what you want. I liked it, readily checked the needed boxes, so that installation could continue.

Before the disk crunching part starts, we have yet another nice summary screen to recheck all the parameters we've given to the installer.

What follows is 15-30 minutes of installing, linking, setting up and configuring of software packages. Go make yourself a cup of tee, there is nothing you need to do until the copying is over. :)

Near the end of the installation, when database configuration assistant and other assistants are launched, I got my first error.

Actually a warning, because everything continued to work correctly after that (not a showstopper, it seems). Peeking into suggested log file revealed that it was an Java exception:

CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control
        at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:868)
        at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:249)
        at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:212)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:234)
        at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:460)
        at java.lang.Thread.run(Thread.java:595)

Nevertheless, after accepting that error, we're greeted with a window that suggests the installation went OK.

Next step is to run two scripts as a superuser. Don't worry, Oracle won't make much trouble to your fine administered Debian machine, it'll copy just a few files to /usr/local/bin, /etc and /opt directories and all are easy to found, should you later decide to uninstall the database.

And that's it, happy end. If you don't believe me, here's the last window you'll see before you're back to prompt.

And yes, your new development database is already started and happily running:

USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
oracle    6389  0.0  0.4  51768  8868 ?        Ssl  18:12   0:00 /ext/oracle/app/or
oracle    6873  0.0  0.7 961116 15148 ?        Ss   18:17   0:00 ora_pmon_orcl
oracle    6875  0.0  0.6 960504 12616 ?        Ss   18:17   0:00 ora_vktm_orcl
oracle    6879  0.0  0.6 960504 12504 ?        Ss   18:17   0:00 ora_diag_orcl
oracle    6881  0.0  0.8 960504 18352 ?        Ss   18:17   0:00 ora_dbrm_orcl
oracle    6883  0.0  0.6 960504 12688 ?        Ss   18:17   0:00 ora_psp0_orcl
oracle    6887  0.0  0.7 961016 14704 ?        Ss   18:17   0:00 ora_dia0_orcl
oracle    6889  0.0  1.3 960504 27208 ?        Ss   18:17   0:00 ora_mman_orcl
oracle    6891  0.0  3.1 963060 65828 ?        Ss   18:17   0:00 ora_dbw0_orcl
oracle    6893  0.0  1.6 976056 34380 ?        Ss   18:17   0:00 ora_lgwr_orcl
oracle    6895  0.0  0.8 961016 17264 ?        Ss   18:17   0:00 ora_ckpt_orcl
oracle    6897  0.0  4.2 963208 88620 ?        Ss   18:17   0:00 ora_smon_orcl
oracle    6899  0.0  0.8 960504 17544 ?        Ss   18:17   0:00 ora_reco_orcl
oracle    6901  0.0  2.9 965284 61748 ?        Ss   18:17   0:00 ora_mmon_orcl
oracle    6903  0.0  0.8 960504 16644 ?        Ss   18:17   0:00 ora_mmnl_orcl
oracle    6905  0.0  0.6 961080 12748 ?        Ss   18:17   0:00 ora_d000_orcl
oracle    6907  0.0  0.5 961068 12312 ?        Ss   18:17   0:00 ora_s000_orcl
oracle    6917  0.0  1.1 962052 23184 ?        Ss   18:17   0:00 ora_fbda_orcl
oracle    6919  0.0  0.6 960504 12880 ?        Ss   18:17   0:00 ora_smco_orcl
oracle    6921  0.0  0.8 960504 16760 ?        Ss   18:17   0:00 ora_qmnc_orcl
oracle    6935  0.0  1.2 967312 25428 ?        Ss   18:17   0:00 ora_w000_orcl
oracle    7011  0.0  1.6 965128 34660 ?        Ss   18:17   0:00 ora_cjq0_orcl
oracle    7013  0.0  1.3 962072 28596 ?        Ss   18:17   0:00 ora_q000_orcl
oracle    7015  0.0  0.9 960500 18984 ?        Ss   18:17   0:00 ora_q001_orcl
oracle    9852  3.3  9.3 918012 194428 pts/1   Sl   18:18   0:30 /ext/oracle/app/or
oracle    9935  0.0  1.5 962128 32292 ?        Ss   18:18   0:00 oracleorcl (LOCAL=
oracle    9939  0.0  1.7 963172 35360 ?        Ss   18:18   0:00 oracleorcl (LOCAL=
oracle   10381  0.0  2.3 964172 47904 ?        Ss   18:18   0:00 oracleorcl (LOCAL=
oracle   10384  3.6  4.3 973416 90640 ?        Ss   18:18   0:32 oracleorcl (LOCAL=
oracle   10387  0.0  2.5 963180 51980 ?        Ss   18:18   0:00 oracleorcl (LOCAL=
oracle   10390  0.0  1.5 962104 32288 ?        Ss   18:18   0:00 oracleorcl (LOCAL=
oracle   10394  0.0  2.5 963156 52124 ?        Ss   18:18   0:00 oracleorcl (LOCAL=
oracle   10397  0.0  2.0 963152 43256 ?        Ss   18:18   0:00 oracleorcl (LOCAL=
oracle   11826  0.1  1.2 962084 25372 ?        Ss   18:33   0:00 ora_j000_orcl

[/ext/oracle/app/oracle]# du -sm *
1       admin
1       cfgtoollogs
3       diag
1       flash_recovery_area
1613    oradata
3417    product

The database obviously needs quite a lot of resources to run, so be sure to install it on an adequate machine (at least 1GB RAM, 10GB of free disk space and so on...). Happy hacking!

Related:
Oracle10g on Debian Linux HOWTO

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

open oracle 11g on linux mint

Hello
i have install oracle 11g on linux mint with setting a new user .I haven't work on oracle yet because i can not open the oracle. can anyone help me how can i open the oracle.

thank you.

run oracle on linux mith

Hello
i have install oracle 11g on linux mint with setting a new user .I haven't work on oracle yet because i can not open the oracle. can anyone help me how can i open the oracle.

thank you.

run out of space

Hello every body!
i have just install oracle 11g on my pc, on D partition, with 40GB free space. I haven't work on oracle yet, but my D partition decreasing space by it self. can anybody help me with that or explain to me

i will be appreciated

KDE users may use konqueror

KDE users may use konqueror and kget to safe download. Just install kget and go to oracle download page.

Oracle 11g installation on Ubuntu 8.04 Server

Hi Guys!

I am new at linux, especially that I had just transferred from being a IT Management secretary to IT Administration. I am currently installing this Oracle 11g on Ubuntu 8.04 Server and when I login as oracle using 'su - oracle' command and I run the installer with './runInstaller -ignoreSysPrereqs' I get an error message saying something about xclock. But the thing is, when I run as a normal user e.g. 'sexyLady' and run the installer, the Installer comes up but then I can't save the database because It's saying that I do not have permission to it. I know this is something to do with the user 'oracle' because I can run the installer with a normal user account. Can any of you guys help me out? please...

Oracle 11g EM console runs on OC4J 10.1.3

I would be curious about attempt:
http://hostname:1158/
To figure out has OC4J instance been brought up or no ?
I believe , the answer is “no”

I'm sorry, but I can't

I'm sorry, but I can't answer your question at this time. Not long after I've had Oracle 11g installed and running, I uninstalled it. I was mostly interested in how the installation would work on Debian, but didn't have much use for it after that, so I deleted it (mostly because it was using too much resources on my machine).

On the bright side, there have been many other articles on the topic in the meantime, so I hope somebody has succeeded running the EM console after installation?

11g Installation on Debian

Can you please provide the list of packages that you have installed on the Debian machine on which you attempted this installation. I'm trying it to but, getting a number of linking errors. When I try to find many of the required packages using the Synaptic Package manager, they simply don't exists. Also, of course, no specific list if provided for Debian (as it is for SuSE, RedHat etc)

I know this would be a paiin to produce but, it really would be most appreciated.

Thanks,

-Joe

Which Debian packages have been installed before Oracle 11g ?

I just compared your post with:-
http://linux.togaware.com/survivor/Oracle_10g.html
and
http://linux.togaware.com/survivor/Preliminary.html
Could you , please , provide information about additional
Debian Etch Packages have been installed before Oracle 11g installation.
Failure to start EM Console is a failure to deploy Oracle JSF application
to some kind of embedded (hidden) clone of OC4J instance or some other kind
of Enterprise Java Container, running inside Oracle 11g server.

Not really

Could you, please, provide information about additional Debian Etch Packages have been installed before Oracle 11g installation.

I didn't install any extra Debian packages to accommodate this Oracle installation. I could provide the list of all Debian packages I have installed, but I'm pretty sure it wouldn't be helpful. Mostly because I have more than 3800 of them (the machine I installed Oracle on is my primary desktop).

So..

You just explained how to do the next->next->next part but not the previous settings to make it work in Debian, the difficult part.
What's the point?

There really is no need to

There really is no need to copy the excellent, but quite long, Oracle document that you need to read before you attempt installation. I think I mentioned that fact in the article. Beside that, I've mentioned (in a comment) the only two sysctls that I changed that affect the Oracle installation. And I also had oracle:dba account from before, but that's hardly a rocket science.

And that's it, your mileage may vary depending on some settings on your machine, but you're really supposed to go through the official documentation, especially if you're attempting your first Oracle install ever.

So, what's the point?

The point is to give you just some insight how the installation looks, to prove that it can work and that it's not very complicated. And maybe the most important fact is that it can work on an unsupported Linux distribution. So after reading this you know you stand a chance if you want to install it on Debian, Ubuntu or similar. I suppose that's good to know before you attempt to download 1.7GB, right?

Yes, this is not a tutorial, but rather, as the title says, a first look. I'm sorry if you were disappointed and expected a tutorial, but I'm sure that with a little bit of searching you can find even that. Or give it some time... or just read the official installation manual which you get bundled in those 1.7GB.

Enterprise Manager

It seems your install failed when trying to set up Enterprise Manager, a web-based GUI shipped with Oracle since version 10g.
Did it work despite the indicated error?
If not, did you try reconfiguring it with the emca scrip?

Also, I can't see how this install is any different then the 10gR2 install.

A third question, when preparing to the install, didn't you need to install any additional packages on your system? previous versions used to require quite a few packages not typically installed by default, such as built-essential, motif and "compat" versions of various libraries, it might be interesting to hear a few details about how your system was set up, do you have the LSB packages installed?

Answers

It seems your install failed when trying to set up Enterprise Manager, a web-based GUI shipped with Oracle since version 10g. Did it work despite the indicated error? If not, did you try reconfiguring it with the emca scrip?

Yes, you're right. After I written the article, I looked for the Enterprise Manager, and it was nowhere to be found. Running emca also produced some error, so it is definitely EM that wasn't configured well. I didn't investigate further.

Also, I can't see how this install is any different then the 10gR2 install.

To be honest, it's not very different. But, I still have this feeling that the whole procedure has been polished a little bit. No problems with glibc (I have 2.6.1 which is really the bleeding edge), not much problem with unsupported distribution (before, the installer would just bail out if it hasn't detected one of RHEL or SLES), no trouble with hugetlbfs and so on, it worked fine. Except that breakage with EM, of course.

A third question, when preparing to the install, didn't you need to install any additional packages on your system? previous versions used to require quite a few packages not typically installed by default, such as built-essential, motif and "compat" versions of various libraries, it might be interesting to hear a few details about how your system was set up, do you have the LSB packages installed?

Good question! I really haven't tweaked a thing on my system before that Oracle install. Deliberately so. But, the truth is that I always have two lines in my /etc/syctl.conf that are actually recommended by Oracle:

kernel.shmmax=536870912
kernel.sem=250 32000 100 128

Beside that, I'm quite sure that my /bin/awk symlink to /usr/bin/awk is also a leftover of some previous installation of Oracle. But that would be about it, being that this is my personal desktop with gobs of software (more than 3800 packages), I actually expected the installation to cope with my system and behave well. ;)

About other specific things that you asked about, I do have installed:

build-essential
lsb-base
lsb-release

But not any other lsb package, nor any graphical libraries except gtk/gnome (definitely no motif). And no compat libraries of any sort, I prefer as fresh as possible versions of everything and get rid of cruft proactively. Few days ago gimp 2.4 came in, it's beautiful. :)

Installation will not work

Installation will not work unless you add

net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

in the /etc/sysctl.conf

At least, mine didn't work

Strange...

All those are fine tuning network parameters. So it's hard to believe that installation would break because of that. In theory, if you don't set those parameters, you could finish with slower network, or run out of ports sooner on a heavy used database. But, I don't think even such scenarios are very likely to happen.

I installed the database without setting those parameters, they're at their kernel defaults.

Unless emca fails because it needs another few thousand ports to start?! ;)

This parameters should be

This parameters should be set according to the Installation Guide. I haven't done this and installation failed. After I changed them, everything went OK

Yes, you're right. After I


Yes, you're right. After I written the article, I looked for the Enterprise Manager, and it was nowhere to be found. Running emca also produced some error, so it is definitely EM that wasn't configured well. I didn't investigate further.

In my case on 10gR2 helped a change in hosts:
127.0.0.1 localhost mycompname
to
127.0.0.1 mycompname localhost
No more errors when creating new databases. Look at $ORACLE_HOME/localhost_sidname folder, after the change it should be $ORACLE_HOME/mycompname_sidname.

Did not try oracle11 yet.

Hm, but the database got

Hm, but the database got created all right. dbca did it's job well. It's just that emca aka Enterprise Manager has some trouble, related to java it seems.

For what I know, Oracle comes with it's own JRE, so it can't be the problem in my Java setup, IMHO.

Are you using Ubuntu?

Or are you using Gnome with something similar to Ubuntu's Human Theme? I am merely guessing from the screenshots.

Anyhow, I am not really very good with using Oracle so I'd like to ask if you know if there will be Oracle Designer running for Debian-based distros soon enough? Thanks!

No, it's definitely Debian.

No, it's definitely Debian. But, it's running compiz-fusion and emerald window decorator which has this nice human-ubuntulooks theme (which reminds a lot of Ubuntu default metacity setup).

I wouldn't know about Oracle Designer, sorry.