Re: Adding RAM

Olav wrote:

Michael Soibelman wrote:

He probably doesn't need the extra swap space with all that RAM,
but.....in the Oracle installation literature it does say to make the
swap space equal to 1.5 times the size of the physical ram so it 'might'
be a good idea.

Thanks for the input.

About Oracle, I currently use Mysql for my TM databases but I have been
advised that using Oracle will give a considerable speed increase when
databases are very large.

I understand that Oracle has a free version now and I have been browsing
the Oracle website but I'm unsure of which file(s) to download for a
standalone SUSE 10.1 box (AMD64). Maybe you have a pointer?

The installation procedure also seems very complicated but I suppose it
will be a nice project during autumn storms :).

--
http://home.online.no/~olav.pet/current_view.jpg


Get the XE version. Limited to a 4GB database but that should be adequate
for most uses. The rpm is easy to install and you get a nice tutorial to
get you started. As for the full on version, yes installation is quite
involved... There is a 'howto' page for getting it installed for use with
Compiere (open source ERP/CRM). The drawback is that it (Oracle-10g) wants
a permanent IP address and you MUST do it all 'carefully'... So try
the 'XE' version. At the very least you'll get a good idea what you can do
with it. Here's the link to the Oracle-10g + Compiere installation on SuSE
10.1 :

http://www.dizwell.com/prod/node/51

And here's the link to the 'XE' download:


http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html

I'd recommend installing the 'XE' version. Easy as could be as it's an rpm.
Even gives you a menu item in your kde (or Gnome) menu. You'll have it
running in minutes.

P.S. To install the full version you'll need a lot of space !! At least 4
or 5 GB !! Also, if you follow the Oracle install guide you'll get to a
certain point where you'll fail to get it to work !! But this can be
overcome. I spent quite a while trying to get it to work only to give up.
Then I found the tutorial I pointed to above and saw the one workaround I
needed. Hmmm, as I type this I'm going to look for it. Hold on....

Oh yeah, there it is. Once you get your system prepare for the Oracle
install run the installer like this:

su - oracle
/home/oracle/osource/database/runInstaller -ignoreSysPrereqs

That -ignoreSysPrereqs is the almighty "Gosh, I wish I knew that !!" that I
needed to get it to install. Then everything went o.k. In fact, let me
tell you about that tutorial I pointed to for getting Oracle installed.
The person who wrote that article is quite knowledgable about what he tells
you...however, he is rather arrogant, at least in my opinion. I followed
his suggestions 'EXCEPT' for the fact that I already had a Linux
installation and did not start with a fresh install. Since that was the
case and I had tried to work with him on getting my install complete he
basically told me to screw myself for not following his instructions to the
LETTER !!!! Oh well. I also disagree with his placement of packages
during install. I'd suggest sticking with the Oracle instructions !!
Also, make absolutely certain, when adding the Oracle user to use this
command:

useradd -m oracle -g oinstall -G dba

As it says in the tutorial:

"The -m switch in the useradd command is needed on Suse 10 to get a home
directory created for the new user. Most other distros create one
automatically for you when the user is created, but Suse needs to be forced
to do so."

So there you have it. Try the rpm version of Oracle (XE). Easy to install
and you'll get menu shortcuts and a nice beginners tutorial. When/if you
need the full Oracle DB install just use the Oracle install guide and take
it one step at a time. You'll need to install packages libaio and
libaio-devel as well. Do that first. Then follow the instructions VERY
CAREFULLY !!! make sure to use the '-m' switch as I stated above when
adding the Oracle user. Make sure, after running that command and the
other 3 commands in that section, to check to see that SuSE has created a
home directory for that user. That is a must !! And make sure to run the
install script with the '-ignoreSysPrereqs' switch or you will not
succeed !! Period. That is the one and only step I needed to get from the
tutorial I pointed to above. As far as I'm concerned you'd be far better
off NOT reading that tutorial and just following the Oracle install guide
to the letter remembering to do the libaio install first (SuSE rpm's),
making sure to add the Oracle user with the '-m' switch to ensure a home
folder is created for this (Oracle) user and giving the extra switch to the
install script to ignore system prerequisites. If you do all that you too
will get a full on Oracle 10g2 install with no limits and a VERY powerful
database....

P.S. I don't mean to be disrespectful of the person providing the
previously mentioned tutorial. It was useful to me. The one step to
ignore system prerequisites when running the installer was the one thing I
could not figure out on my own. Period. However, as I said before, the
guy did come off as a bit arrogant/conceded. But then maybe that's because
I'm so humble. Just trying to help out my fellow human beings.. :-)

Enjoy.

P.S. #2 : Really, you should try the 'XE' version. It's probably more
than enough for most uses. If and when you decide to install the full
version and you follow my advice you will feel very proud to have completed
this task. I know I did. Knowledge is power.

Good luck.

P.S. #3: I still use MySQL for most database needs. It is quite powerfull
and is probably all you will need. Also, PostgreSQL is needed by a few
Linux programs, so I use that too. I do like Open Source apps and prefer
them. However, Oracle does let you use there database for free for
non-commercial use. Just read the license terms. Once you learn to use
the 'XE' package you will have a good start on becoming an Oracle Database
Administrator. And even though I was disappointed with the guy who wrote
the Compiere + Oracle installation tutorial ( Howard J. Rogers) I do think
you would learn a lot by reading his articles regarding Oracle DB at:

http://www.dizwell.com/prod/

That's it for now. Bye, bye. (<- A quote from the Mclaughlin Group, which
no longer is on the air. What a shame !)

:-)
.

Relevant Pages

  • Re: AIX 4.3.3 , Oracle 7.3.4 coredumps at startup
    ... I cannot port the database to Oracle 8 or later since the app ... > the apps that are now reserved words in Oracle 8 and later. ... Put away your installation media and forget a new install for the moment. ...
    (comp.unix.aix)
  • Re: how to activate oracle text in 10g enterprise
    ... general purpose database, or if he wanted to study otext, and was ... 'Oracle Text' option from the DBCA screen. ... If you experienced oracle warnings and errors during the install ...
    (comp.databases.oracle.server)
  • Re: Unable to manually create RAC database
    ... some assistance with this as my RAC experience is very limited. ... I have managed to manually create a single instance database (on ... With the Partitioning, Real Application Clusters, OLAP and Oracle Data ... can get with a manual install. ...
    (comp.databases.oracle.server)
  • Re: [SLE] Disaster Recover Preparation -- How to do it?
    ... I am currently running 8.1 Pro, my original SuSE version. ... > do a full recovery, and everything comes back and works perfectly. ... Why not do a full dump of the database, install the newer SuSE fresh, ...
    (SuSE)
  • Re: ADO connection to Oracle
    ... did you install mdac 2.7 on the machine? ... > The program always stops at the connection to the database. ... > connection is made using generic OLE DB, not the Oracle data provider. ...
    (microsoft.public.vb.database.ado)