Notes on How to Install:

NOTE: These installation instructions are for various Windows operating systems.  If you will need to install on either HP, Sun Solaris or Linux platforms you will need to email Dr. Stapleton:

ALSO: If you already have Oracle 8 on your machine, or have an unsuccessful installation of 8i on your machine, take this link for more information including how to get a "clean machine".  Anything you have installed with the Universal Installer you can uninstall.

Other links:

BEFORE the installs - I suggest you drag a shortcut to NT services out on your desktop.  NT services are vital to the proper functioning of Oracle and the OEM on NT machines.  We will check these often.

Step 1) Oracle 8i install -

1a) Put in the 8i CD in your CD-ROM drive.  If you have Autorun take effect then you will see the Universal Installer launch.  Otherwise, you can use the NT Explorer to drill down to the contents of the CD.  Double click on the setup.exe file to launch the Universal Installer.  As you use the installer, always click the Next button once you have completed a step

1b) Choose the Oracle Home Name and Directory for Oracle 8i - I suggest you use the default that Oracle suggests here.

1c) Choose now the option to install the Enterprise Edition of Oracle 8i.  This should be the top choice on your screen.  You do not want to choose the Oracle 8i Client and for now you do not want the bottom choice, Oracle Management Server.  You will choose this last choice later on when you want to install the OEM.

1d) Choose "Typical Install"

1e) Either put your documentation on your hard drive or choose to use the CD

1f) Now you are asked to choose the global database name and SID for your sample database that will be installed.  Global database name : ORCL, SID: ORCL (Make them the same name - if you already have an ORCL database on your machine, you will need to choose another name)

1g) Click on the "Install" button.  This will complete the Oracle 8i installation.

1h) Just to make sure things look good, go to your NT Services and see that you have a new collection of services for Oracle.  You should have one for the ORCL database.  You should also have an agent and a listener service, and some others.

1i) Be sure to reboot your machine now and then go to NT Services and make sure the Agent, Listener and the ORCL database start service are started.  New - Also, go out to your D:\oracle\admin subdirectory and look for an Orcl subdirectory.  Look at this subdirectory.  You should see a pfile subdirectory and in it you should see the file init.ora.  Also, you should have a subdirectory D:\oracle\oradata.  In it you should find an Orcl subdirectory and in here.  In this subdirectory you should see control files and system files and redo log files among other things.  Also, you should have a D:\oracle\ora81\DATABASE subdirectory.  In here you should find a PWDorcl file that is encrypted.

Step 2) Yes, we are making progress ;-)) Installation of the OEM -

2a) This is done with the same 8.1.7 CD in your CD-ROM drive.  If you have Autorun take effect then you will see the Universal Installer launch.  Otherwise, you can use the NT Explorer to drill down to the contents of the CD.  Double click on the setup.exe file to launch the Universal Installer.  As you use the installer, always click the Next button once you have completed a step

2b) Make the choice to install the Management Server.  This is the third and bottom choice on the screen to choose what to install.  I will talk more about the Management Server later - it is new in this version and is a bit of a fix to the old OEM.  Ask me why in class if I forget to mention it.  

2d) Choose the Installation of the Oracle Management Server, the top choice, on the next screen.

2e) Press the "Install" button once presented with it.  Hopefully, all will go smoothly with installing the Oracle Management Server and the OEM console.

Step 3) Installing the 8i DBA Course Curriculum including the sample DBA database

 Getting the correct directory structure in place:

Bdump

Data  (Data has subdirectories Disk 1, Disk 2, Disk3, Disk4, Disk5, Disk 6, Disk7, Disk 8)

Demo

Labs

Solns

Udump

The oraclass directory, besides these subdirectories listed above also contains these very important files: 

NOTE: The directory structure up above is CRUCIAL for you to replicate on your machine.  The course scripts, including the creation of the sample DBA database depend on this structure.  Ideally, a machine should have many disk drives for Oracle peak performance.  We are going to "simulate" a fairly good Oracle install by "faking out" that we have 8 disk drives.  We will learn just what should go on each disk drive.

The Demo, Labs and Solns directories are chock full with what you will need to do your lab exercises.  The scripts you will need to demonstrate certain phenomena are in the Demo subdirectory.  The scripts you will need to do your lab exercises are in the Labs subdirectory.  And, you may have guessed by now, if you are having trouble coming up with how to solve the lab exercises, the Solns subdirectory actually has all the solution scripts that solve the problems posed in the labs.  I recommend for the sake of a good learning experience that you only resort to looking at the solution scripts after you have tried diligently to figure things out on your own. ;-)).   Obviously, you will get from the course what you put into it.  NOTE: These scripts are probably all written for the Unix environment.  In general, be sure you always look at a script before you run it!!!! You may need to make some minor modifications from time to time for the NT environment or for your directory configuration on your machine.

NOW - Important edits to make to the 4 files- run80.bat, credb.sql, credb1.sql, initDBA.ora. These 4 files will create the all important sample database, DBA, that will be used throughout the course.  All the labs, demos, and solutions go hand in hand with this database and its structure.  It is basically a poorly designed database from the Oracle Flexible Architecture (OFA) standpoint and we are going to spend the semester learning from it and "fixing it".

Essentially, all the edits you will have to do these 4 files are with regard to what drive you installed Oracle on.  If you installed it on the D drive then you are good to go since that is what all these files reflect.  If, however, you installed on C, E, F, G, or some other drive letter - you will need to edit each and every one of these 4 files.  CAREFUL!! run80.bat is an MS-DOS executable!! To edit it, right click on it and then click edit.  There are 2 places in that file that you will need to adjust the drive letter.  initDBA.ora is just a text file.  Open it with Notepad.  I suggest a search and replace.  For e.g. Find D:\ and Replace with, say, G:\.  credb.sql and credb1.sql are both SQL script files.  They can be opened safely in Notepad and edited, similarly to initDBA.ora.

4b) NOW, the moment of truth!  (And the one easy to mess up if your edits weren't thorough in 4a, above! ;-)))

You want to go ahead and run the run80.bat file.  You can do this a number of ways.  One way is to hit Start, then run and Browse to find it.  Then click OK. 

TROUBLE SHOOTING: Now, trouble shooting this puppy is the fun part!  Watch it race on by in the DOS window.  If it is successful it will take a long time to run.  If it is unsuccessful, it will take a long time to run. ;-))  I mean a really long time to run!   run80 calls credb and credb calls credb1.  credb and credb1 both will create log files in your oraclass directory, so if you start seeing a bunch of ORA errors flashing by, then you might just close the DOS window and go out to your log file for credb in the oraclass directory (on the Unix install the credb.log is placed in the LABS directory, for NT install it is placed in oraclass) and see what it has to say.  There is an ORA error that is really not an "error" conceptually should you see it.  That is the one that says "can't drop something that doesn't exist".  All the scripts are written to first drop something for safety's sake and then they create it, so this is not really an "error".  Other errors like "database not open" or ?? are really errors.

Since I am not too proud to admit it, I bombed these scripts a couple of times on my many installs.  ALWAYS, it was because I forgot to change a drive letter on ONE LINE of one of those 4 files!  If this happens to you, don't fret much, we can recover.  Depending on how far you went into the scripts before the bomb.  

GENERAL TROUBLESHOOTING: If run80 ran successfully you will have NT services.  Check to see if this is true.  If not, there is something wrong.  You need to use the Database Configuration Assitant to delete the DBA database, also delete whatever password file was created in D:\Oracle\Ora81\DATABASE\ called PWDdba.ORA. You then need to start over again running run80.  Now if your services are there, perhaps credb.sql had an error. Check out the createdb.log first.  If database creation failed because of a bad drive letter on one of the lines in the files, then you will see that right away.  Go through those files with a fine tooth comb and find the bad drive letter and fix the files.

One of the students installing had this error show up in createdb.log

SVRMGR> connect INTERNAL/oracle as sysdba
Connected.
SVRMGR> shutdown immediate
ORA-01034: ORACLE not available
SVRMGR> startup nomount pfile=F:\oraclass\initDBA.ora
ORACLE instance started.
Total System Global Area 6307788 bytes
Fixed Size 65484 bytes
Variable Size 5300224 bytes
Database Buffers 409600 bytes
Redo Buffers 532480 bytes
SVRMGR> CREATE DATABASE DBA
2> LOGFILE 
3> GROUP 1 ('F:\oraclass\DATA\DISK3\redo0101.log',
4> 'F:\oraclass\DATA\DISK4\redo0102.log') size 2M,
5> GROUP 2 ('F:\oraclass\DATA\DISK3\redo0201.log',
6> 'F:\oraclass\DATA\DISK4\redo0202.log') size 2M
7> MAXLOGFILES 32
8> MAXLOGMEMBERS 3
9> MAXLOGHISTORY 1
10> DATAFILE 'F:\oraclass\DATA\DISK1\system01.dbf' SIZE 50M REUSE AUTOEXTEND ON
11> MAXDATAFILES 254
12> MAXINSTANCES 1
13> CHARACTER SET WE8ISO8859P1
14> NATIONAL CHARACTER SET WE8ISO8859P1;
CREATE DATABASE DBA
*
ORA-01501: CREATE DATABASE failed
ORA-01991: invalid password file 'F:\Oracle\Ora81\DATABASE\PWDdba.ORA'

This error occurred for this student because he had trouble with the first run of run80 and he ran it again, but he did not delete the password file that was created in the first run of run80 before he went to run it the second time!  You need to delete this file since the Oracle software expects it *NOT* to be there already since it wants to create it.  Thus the error!

You will also want to check if any files, e.g. a control file or rbs or redo,  have been created on any of the Disk1,...., Disk 4 subdirectories.  If any files have been created on any of these "disks", simply delete them all.  If  you do not delete them all you will get another error when run80 calls credb.sql.

Also, check out createdb1.log.  If there are errors then either the data dictionary was not created or the DBA database did not load properly.  You will need to undo and rerun the appropriate scripts.  I'm happy to assist with individual problems.

Now, hopefully, you are at the stage where you have fixed the 4 files and you have cleaned up what was done the last time you ran them.  Run run80 again now.  Good luck!  We can do more trouble shooting via email or in class if need be.

Be sure to reboot your machine once you can see after much time that the scripts have completed.  

4) Some Oracle Networking stuff!!  This can be tricky..... 

We are going to make sure our new DBA database has what is called a "listener".  A listener is a component that "listens" at a port or ports for attempts to contact a specific database or databases.  We already have a listener from the ORCL database install.  We are going to add to its capabilities the ability to listen for the DBA database as well.  We are also going to assign what's called a "Service Name" to the DBA database.

4a) fix the LISTENER.  From Start, Programs, Oracle-Ora81, Network Administration, click on the Net8 Assistant.  

4b) Give DBA a Service Name.  Now 

Now you are all ready for the OEM to discover both your ORCL database and your DBA database!

5) Getting prepared to launch the OEM!

It is very important now that you check your NT services and if they are all not already started, they need to be started in this order.  I.e., if 2 are not started, start those 2 in this relative order, etc.

First, Start The Ora81TNS Listener  Service if not already started

Second, Start the Database that houses the OEM Repository, in our case the ORCL Database Service if not started

Third, Start the Ora81 Intelligent Agent Service if not started

Fourth, Start the OEMManagementServer Service if not started.

If you have problems here, it is probably because of Net80 issues.  We can trouble shoot via email, phone calls, class time.

6) Launching the OEM!!! The grand finale to this exercise....

6a) From the Start Menu go to Programs, Oracle-OraHome81, Enterprise Manager, Console

6b) You will be asked to login.  Always remember - the login name for the OEM console is sysman, the initial password is oem_temp.

    login: sysman

    password: oem_temp

You will be asked to change the password immediately.  I suggest using  dba as the password for now since it its easy to remember.

6c) the Console launches.  We will be talking about this in detail in class.  For now go to the drop down menu under Navigator and click on Discover Nodes.  Type in your machine name from Network Neighborhood.  You should see info on the ORCL and DBA databases show up.

Now you are set to fully enjoy the course!!

By the way, I suggest you create shortcuts to NT Services, Svrmgrl (do a find on the drive that you installed Oracle on and then create a shortcut by right clicking on the file name and choosing shortcut), Sqlplus (under Oracle-Ora81), Sqlplus Worksheet (under OEM), All 3 networking tools, the OEM Config. Asst., the Database Config. Asst., and the OEM console.  You may find other useful OEM tools that you want as shortcuts through the course of the semester.  I suggest this only because it drives me batty to have to use that darn start menu and go 4 levels deep to get these tools! :-((

ACKNOWLEDGEMENT: Many thanks to my graduate student, Khalid Albarrak for his many hours he spent mastering the Oracle installation procedure and Curriculum Install and all his wonderful help for my Oracle students!  May you always walk in happiness and prosperity!