Archives For smalltalk

if you have access to oracle support there is a good note about deploying the database on linux.

check it out:

Master Note of Linux OS Requirements for Database Server

Advertisements

To summarize all the posts which will get you to your test infrastructure, here is the overview:

  1. Operating System setup
  2. Operating System preperation for oracle
  3. Grid Infrastrucuture Installation
  4. Applying the Latest Patchset Update for the Grid Infrastructure
  5. Creating the ASM instance
  6. Database Software Installation
  7. Creating the database
  8. Applying the Latest Patchset Update for the database

… there are plenty of excellent oracle posts out there. why another one?

When I started working with oracle I had one big problem: There is so much information around that it’s hard to decide where to begin. I started as most of the people would do:

… had a question or issue -> go to an internet search engine -> search -> millions of different answers, some correct, some useful, a lot of them misleading or even wrong

What I always was missing was a clean guide on how to setup a training environment that can be used as a base for trying all the interesting things. This includes, for example:

  • Setting up the Operating System
  • Preparing the Operating for Oracle
  • Installing the Oracle Software
  • Patching the Oracle Software
  • Create an ASM Instance and configure the Grid Infrastructure
  • Create and configure the database instance
  • Start playing with it …. and provide some examples

As you can see from the above list, this are not advanced topics, so we are back to what this blog is about: It is for all those who are at the beginning of their oracle experience. You will see as less screenshots as possible because I believe that you’re not going to learn how things work if you trust the graphical tools. Another big point which still is mess if I look around: Documentation. If you put your work in a script you are documented. People using the graphical tools tend to not document their work and this can be very dangerous if others try to continue. In qualified environments it’s even strictly forbidden to do anything on the server or database without going through an approval process. And it may be even forbidden to use any of the graphical tools.

So let’s try the experiment: Feel free to comment, feel free to correct me, feel free to ask…. Hopefully this is useful to some of you

I will start this blog with a little series on how you may prepare your os, install the oracle software and do the configuration tasks you need to do for getting an oracle instance up and running.

… and please don’t blame me for my English :)