Step By Step Virtual PS Install: Install Database



This is a continuation of my virtual PeopleSoft installation.  In this step, we will discuss how to install the Oracle database.  To see the complete list of steps, click here.

You could use a number of different databases, but we are keeping to Oracle software.  You can download it from here:

Oracle Database Software Downloads

Once you have the zip file downloaded and on the virtual machine.  You need to unzip it.  You could use the command line, or you can just double click on the zip file.  Once you double click on it, click the extract button.  Just remember where you unzip the files to.

51-unzip-db by you.

Then, run the installer.  To do so, you should open up a terminal and run the installer from the command line.  The terminal is in Applications > Accessories > Terminal.  Then, change directories with the cd command to the directory where you unzipped the database.  Type ./runInstaller.

In the installer, I changed the edition to Standard Edition rather than the Enterprise Edition because my focus is on PeopleSoft rather than the database.  I also chose not to create the Starter Database because I wanted to save the hard drive space.

52-run-installer by you.

For the inventory, just accepted the defaults.

53-inventory by you.

The pre-requisite checks may catch a few errors.  To see the results easier, you can open a text editor (Applications > Accessories > Text Editor) and paste the errors there.

54-prerequisite-checks by you.

At this point, the only thing that I did not have that did not pass was the networking, and that is because I still have my networking set to DHCP.  I want to keep the DHCP and access everything through the localhost.  If you have other things that do not pass, check the configuring the OS post.

Now, you should get the summary:

55-Summary by you.

Click install, and it should start installing.

56-installing by you.

After it is done installing, it will ask you to run a couple of scripts as the root user.

57-root-scripts by you.

To run the scripts, open a terminal window (Applications > Accessories > Terminal).  Then, type su to get root access.  The type the full path to the script.  On the second script, just accept the default.  Here is what the terminal looks like:

[pshr@localhost ~]$ su
Password:
[root@localhost pshr]# /home/pshr/oraInventory/orainstRoot.sh
Changing permissions of /home/pshr/oraInventory to 770.
Changing groupname of /home/pshr/oraInventory to pshr.
The execution of the script is complete
[root@localhost pshr]# /home/pshr/app/pshr/product/11.1.0/db_1/root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= pshr
    ORACLE_HOME=  /home/pshr/app/pshr/product/11.1.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@localhost pshr]#

Now, click the next button.  And you should be done.

58-end-of-installation by you.

Just to make things easier, you should probably add the path and oracle home variables to your bashrc.  You can edit the file from a terminal with:

gedit ~/.bashrc

Then, add the following lines to the edit of the file:

#Added for Oracle:
export PATH=/home/pshr/app/pshr/product/11.1.0/db_1/bin/:$PATH
export ORACLE_HOME=/home/pshr/app/pshr/product/11.1.0/db_1

58.5-bashrc by you.

Opinion:This was relatively hard for Linux.  I am used to pointing and clicking on a package to install.  It would be great to have an RPM package for the database.  After all, Postgre and MySQL both have packages that you simply install.

Resources


Share

No Comments

2 Trackbacks

Leave a comment