-

How I learned to stop worrying and enjoy Oracle installations

 

I have to hand it to the folks at Oracle, they have made installing 12cR1 just that little more complex, which makes us feel really good when it works!

 My only gripe is when you don't have a GUI and and X-Term handy, installation for the uninitiated (read: ME) is a tad more complex.  So break out vi or emacs, and let's get started.  I am doing this in a virtual machine, which may, or may not be officially supported.  But it's so much easier while we're learning.

 1.  You'll need a response file
There's two ways to get one of these.  Unpack the installer, and copy it from database/response or run a GUI install somewhere else and save it off.  The only things you really need to change are the installation points.  Everything else cal remain as-is

 2.  If you're doing Linux, it might as well be Oracle Linux
Yeah, I am well aware that Oracle Linux is fundamentally RedHat in a different red hat; but you do get the warm fuzzy feeling it's all going to hang together.

 Installing Oracle Linux 6 is no different to RedHat or most other distributions, insert media, a handful of mouse clicks and you're done.  For the sake of those following my ramblings, I have three 20G disks.

 sda0 = 4GB Swap
sda1 = Remainder on / as ext4

 sdb1 = /u01 as ext4

 sdc1 = /oradata as ext2

 "Whoa" I hear you say... ext2?  I am a subscriber to the "less is more" theory.  Oracle is really good at handling their data files, and don't need us getting in the way with journalling and the like.  Ext2 is simpler, low overhead and that for me, is all there is to it.  Feel free to disagree...

 Install as a standard server, and add the base development tools, as well as whatever other packages you feel you need in your case.

 3.  Update before you start
Easy.  Just do "yum update" and follow the bouncing ball.

 4.  Install the prerequisites
The easiest way of not messing things up is just to install the prereq package with:

 "yum install oracle-rdbms-server-12cR1-preinstall"

 This will create an "oracle" user, "oinstall" and "dba" groups as well as add any missing packages and tune kernel parameters.

At this point, it's a good idea to do an "su - oracle"


5.  Extract the installer
12c comes as two huge zip files, "linuxamd64_12c_database_1of2.zip" and
"linuxamd64_12c_database_1of2.zip" unzip these to /tmp/oracle.  Having done that, copy your response file to /tmp/oracle

 6.  Set up your directories
mkdir -p /u01/app/oracle
mkdir -p /oradata/data
chown -R oracle:oinstall /u01
chown -R oracle:dba /oradata

 Don't get too hung up on permissions, the installation will adjust them for us as we go

 7.  Create a script
Break out your favourite editor, and create oinst.sh in the /tmp/oracle directory


#!/bin/sh
/tmp/oracle/database/runInstaller -silent -ignoreSysPrereqs
-ignorePrereq -responseFile /tmp/oracle/response/12c-EE.rsp \
oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall \
SELECTED_LANGUAGES=en ORACLE_BASE=/u01/app/oracle  \
ORACLE_HOME=/u01/app/oracle/product/12.1.0.1  \
oracle.install.db.InstallEdition=EE  \
oracle.install.db.DBA_GROUP=dba  \
oracle.install.db.OPER_GROUP=dba \
oracle.install.db.BACKUPDBA_GROUP=dba \
oracle.install.db.DGDBA_GROUP=dba  \
oracle.install.db.KMDBA_GROUP=dba  \
DECLINE_SECURITY_UPDATES=true

 Now run it, as "oracle"

 It will take a while, but you should see:
As a root user, execute the following script(s):
            1. /home/oracle/oraInventory/orainstRoot.sh
            2. /u01/app/oracle/product/12.1.0.1/root.sh

Successfully Setup Software

 Now, go run those two scripts, as root

Congratulations!  You just installed Oracle RDBMS

 8.  Create an actual database

 #!/bin/sh
#
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.1
export PATH=$ORACLE_HOME/bin:$PATH
#
dbca -silent -responseFile NO_VALUE -createDatabase \
   -templateName General_Purpose.dbc -createAsContainerDatabase false \
   -gdbName testdb1 -sid testdb1 -SysPassword Abig5ecret \
   -SystemPassword Abig5ecret -emConfiguration DBEXPRESS \
   -dbsnmpPassword Abig5ecret -storageType FS \
   -datafileDestination /oradata/data \
   -redoLogFileSize 200 -sampleSchema true \
   -characterSet AL32UTF8 -totalMemory 74
The system will grind away and eventually get to 100%,  Around 40%, you should see

"Creating and starting Oracle instance"

 9.  Set up networking

 netca -silent -responseFile /tmp/oracle/netca.rsp

 10.  You're done!

Comments

Post a Comment

Popular posts from this blog

The QYT KT-7900D

-
Image
But is it any good? As you might have noticed, I am now a freshly licensed radio amateur .  As such I do need a transceiver or two in order to get on the air.  This is the story of one of my new radios. I have a limited discretionary budget to use for my new hobby, and I have to say from the outset that my lovely wife has been very supportive.  As such, I want to try and get the best value for our money.  One evening I stumbled upon this little item on Banggood for a little over $A150 including shipping.  Covering both 2m and 70cm bands with a claimed 20W output it seemed almost too good to be true.  I bought one. About ten days later a tiny package arrived for me.  At just 98mm x 43mm x 126mm the photos don't convey quite how small it actually is.  The entire case serves as a heatsink so it is heavier than it looks, but certainly not bulky. The standard power cable comes with a cigarette lighter plug.  As I intended to run it from home using a regulated PSU, I just cut the plug o
Read more

Life with Deep Racer - Part 2

-
Image
 An Update on AWS Deep Racer OK, so AWS Summit Sydney has been run and won.  Not by us however, but there are few interesting tidbits to report: The console is now widely available This is actually pretty big news, because: The console ties together Robomaker, SageMaker and everything else you need in a convenient package There are actual examples of functions included It seems to stay running now There is new firmware for the car Also important; this includes a rolling update for the Ubuntu base as well as the Deep Racer specific bits.  WiFi connection seems more reliable now as well. Our car has a new look Since my employer (Versent) was generous enough to send me to Re:Invent last year (where I got the Deep Racer), I thought it appropriate to deck it out in the company colours, and it was well-received at Summit last week.
Read more

DIY Self-Driving - Part 9 - New Imaging

-
Image
Please Note:    Unlike most of my projects which are fully complete before they are published, this project is as much a build diary as anything else.  Whilst I am attempting to clearly document the processes, this is not a step-by-step guide, and later articles may well contradict earlier instructions. If you decide you want to duplicate my build, please read through all the relevant articles before you start. We have a lot of work to do in pretty short space of time now, with new competitive opportunities in the very near future. To be honest, the line detection has simply not been good enough, and this is leading to some of the poor performance I have been experiencing with the car.  Whilst it really does work, it is not accurate enough.  There are a couple of issues here which need to be dealt with: The core processor is just not powerful enough; and The optics aren't good enough Processing As I noted in my "Next Iteration" article I am looking at othe
Read more