CareersNG

Hi guys, I hope you all had a lead into what Oracle Database is all about in chapter 1. In this chapter, we will look into how the installation is done and other important things. Ironically, installing the software might not mean that you even create a database. Installing the Oracle 10g database software means that you now have the tools to create and manage databases at your disposal.
Generally, it’s important to be sure that all prerequisites are met before you install Oracle, though Oracle runs on several Operating System platforms. Apart from the PC configuration requirement I stated in chapter 1 (that was my own opinion), Oracle recommends the following as the minimum system requirements across most platforms:

Recommended Minimum System Requirement
Random Access Memory (RAM ) 512MB
Swap/Page File Space 1GB or Twice the size of RAM
Temp Space 400MB
Disk Space 1.5GB for Oracle Software 1.5GB for starter Database

Note that Oracle always recommends that more RAM be available than specified in the system requirements. This avoids performance problems like paging and swapping due to lack of resources.

From the prerequisites, let’s move to Optimal Flexible Architecture (OFA). This is a method of naming mount points and directories and of organizing datafiles and database components to make it easy for a DBA to locate files and administer the database. How do you come about this? When you insert your Oracle software CD into your PC, there should be an auto run which will bring you the GUI interface called Oracle Universal Installer (OUI). It is a form of an installation wizard which will take you through the installation of the software, and (if you want) the creation of a database. You will first see a screen that gives you the option to install. Click install, then a command-line screen shows, checking if your PC meets the Oracle software installation requirements. After this, the OUI page shows up asking you to ‘Specify File Locations’. Under ‘Source’ you will see the directory from which the Oracle software will be installed from. This is usually from a CD ROM drive. Leave this as it is. Then under ‘Destination’, leave ‘Name’ as it is, but change the ‘Path’ in order to enable OFA. Don’t forget that enabling OFA means that you want the Oracle software and you the DBA to be able to efficiently locate and manage Oracle files for better performance. On the ‘Path’ column, insert the following: C:\app\oracle\product\10.2.0. ‘C:’ stands for the mount point (that’s your local hard disk if that’s the letter you assigned to it), ‘app’ is the standard directory which stands for application, meaning that it’s the folder containing the Oracle software. ‘oracle’ is the name given to the owner’s home. ‘product’ is a literal. That is, a constant folder containing the particular version of the Oracle software, while ’10.2.0’ is the name of the folder referring to the current release of the Oracle software you are installing. In a nutshell, whenever you see or hear ORACLE_BASE, they are referring to the first three namely: ‘C:\app\oracle’ while ORACLE_HOME refers to the last two; ‘\product\10.2.0’. Only the ‘C:’ refers to the hard disk drive, all others are folders. Whenever you see something like ORACLE_BASE\ORACLE_HOME\admin, it simply means, enter into your ‘C’ drive, open the ‘app’ folder, open the ‘oracle’ folder in it, then open a folder called ‘product’, inside which you will see a folder named ’10.2.0’ and finally you will see ‘admin’ which could either be the name of a file or a folder.

Hope I am not telling you what you already know sha!!!

OFA specifies that at least three sets of directories (folders) should be used to reduce contention and provide good performance. One set will be used to store Oracle executable files and support files associated with them. Another will store control files, redo log files and other administration files like parameter files for each database (DB) on the PC (computer). A third one will store all the datafiles. Each set is recommended to be on a separate physical hard disk (not partitions).

INSTALLING THE SOFTWARE
Once you insert the CD, it autoruns and brings you a page allowing you to click on ‘Install’. After clicking ‘Install’, an MSDOS screen shows up checking if your PC meets with installation requirements. Then the OUI comes up with the ‘Specify File Location’ page. Click on ‘Advanced Installation’. Using ‘Basic Installation’ boycotts many thins that should be learnt. On the next screen, ignore the ‘Path’ column under ‘Source’ Leave the ‘Name’ column under ‘Destination’ intact too. Edit the ‘Path’ column under ‘Destination’ to this: C:\app\oracle\product\10.2.0, then click next. A ‘Select Installation Type’ page comes up. Make sure the ‘Enterprise Edition’ radio button is checked, then click next. On the ‘Select Database Configuration’ page, be sure that the ‘Create a Starter Database’ and ‘General Purpose’ are checked since we are installing the software and creating database too. Click next. On the ‘Specify Database Configuration Options’ screen, note the Global Database Name and the SID. For 10g, they always default to ‘orcl’. Global Database Name means the name of the database while the SID means the name of the Instance that connects to the database. Don’t ask me the meaning of ‘Instance’ o, I will tell you later. At the bottom of that screen, check the ‘Create database with sample schemas’ box, in order to create the DB with some sample accounts you will use to connect to is. (for instance, all your yahoo mails are the data in the yahoo database, while your account name is what you use as the user-id and then the password is what identifies you with that name and the whole thing is your account. Understand!). You can change the DB name and the SID name if you want. Just be sure you remember them. On the succeeding screen ‘Select Database Management Option’, click next. This is because we have two options. We either use Grid Control for DB management or use Database Control. Oracle is the first Grid enabled DB. This means that where you have several DB servers connected together (of course on a network), you can manage or tune anyone of them from only one server as if you are tuning on the host itself; this is done through the Oracle powerful tool called Enterprise Manager. But if you use Database Control, it means you can only manage or tune the DB server on the PC alone and cannot tune other DB servers from it. In enabling the Grid Control, you will make use of stuffs like Management Agent, Repository, etc. Pls we won’t go into that here. The stories are in various Oracle textbooks.
The next page gives you ‘Specify Database File Storage Option’. There are three choices here.
1. File System
2. Automatic Storage Management (ASM)
3. Raw Devices

Choosing File System means that the database storage will be managed by the existing Operating System (OS) file system (FAT32, NTFS, etc as the case may be). ASM means that Oracle itself takes charge of the database storage by making use of various hard disk drives, while choosing Raw Devices means that you want your database to be stored on a partitioned/formatted disk (which does not have an OS installed on it).
To choose this, you should be good with dealing with raw partitions.
The next screen asks you whether or not you want to automate your backup of the DB. The next screen shows you the four default accounts (users) that come with the Oracle software installation. They are also called schemas. I mean each is called a schema. When a set of database objects are created and belong to a particular user, they are said to belong to the same schema (they are from the same mother). Here, you have a chance to either give each its own password or give one password to all the four of them. I advise that you give same password to all. The next screen shows you a summary of what will be installed. Click ‘Install’ and wait for several minutes (depending on your system configuration) for the Oracle software to install. After the installation, a screen called ‘Configuration Assistants’ comes up automatically by itself and will try to configure the following:
- Oracle Net
- iSQL*Plus
- Oracle Database (since we said the software should create a starter database earlier)

Oracle Net Configuration Assistant configures the network parameters for communication between the various Oracle components.
iSQL*Plus Configuration Assistant configures the iSQL*Plus server, a browser-based application which interfaces the database. You can enter your SQL statements through the iSQL*Plus to retrieve information from the DB. The Oracle Database Configuration Assistant creates a starter database with certain accounts or users through which you can log in to access data. After the three have been successfully configured, you will see a screen showing you ‘Password Management’, you can click the Password Management button to see the accounts that are locked and those unlocked. You can unlock an account and give it a password. You can ignore this place and later unlock an account manually with a command. On the Password Management page, you will use the URL for the Enterprise Manager and iSQL*Plus, since you will have to access them through the browser. The URLs are as follows; just open a browser (internet explorer) and type,
- to access Enterprise Manager : http://localhost:5500/em
- to access iSQL*Plus : http://localhost:5560/isqlplus

Note that localhost stands for your computer’s name. You can either put localhost OR the IP address of your computer OR the name of your computer. Any of the three would suffice.

Hmmmm……. Thus far God has helped us through chapter 2. To Him be all glory!!

hmmm...prof, carry on...

we are attentive

God be praised

_________________
In Life's Pursuits, Never Outrun God [Prov. 19:21]
1luv...

Thanks for the lecture. I will follow this instruction and get back to the lecture Room should in case I come across those Giant (...you understand what I mean). I think I've learn something new about Oracle Installation today. We'll so get the articles and the previous ones in an acrobat format and make them available for download.
seluwole.

Prof, I appreciate what you are doing for us. I pray that God will reward you.

Prof, there is one favour i want to you to do for me, pls I want you to send to this mail address, odiyeye@yahoo.com, the soft copy of Oracle10g DBA material (Admin I & II) and the latest 10g DBA dumps.

Thanks for your cooperation and understanding.

Expecting your reply.

_________________
Regards,

Odiyeye, Olawole

Hi!

thanks for the novel idea, the installation you have just enumerated, I believe is on windows operating system platform. It might interest you to note that, most major corporations that uses oracle as a dabase management system now do so on the linux/unix environment.
It will be highly appreciated if your training is actually geared towards this regard.
thank you.

_________________
no man can stop an idea whose time has come!!

Prof., U too much!

I dey kampe as ur student.

_________________
No matter how 'elephant' big reach, e no fit cause earthquake!

hello Prof., this is quite a great sacrifice. in fact, it is unparalled. i wish to ask if u culd please get across to me via talktopholu@yahoo.com the latest dumps on ORACLE 10g:OCA & OCP as i wish to write my exams latest next month. this would be quite appreciated. u are really doin a great job. i believe u would live to see and enjoy the fruits of this selfless labour. i believe u are driven by a passion to see people succed by "impacting" into them. i can assure u that u are on ur way to fulfillment and purpose. As u have taken out time to bless lives by addin value to their lives, the Lord will take time to add value to ur life, both at present and in the future. GB, ore welldone.

Hello Odiyeye and thank you for the part you play in this forum too. Honestly, I do not have softcopies of the oracle training materials that could be sent via attachments. They are basically in hard copies. Nonetheless, I will get you some dumps on the OCA and OCP exams. Soon, we will also make the lessons available in .pdf and .doc formats for guys to download.

Thank you.

Deola

Hi Onomzy,

Thank you for your observations. The installation I explained is for windows. Basically, the lessons I am giving are for the Administration of Oracle Database and not an Operating System. The Installation aspect is a very minute part, though is of good use if anyone knows it for linux. Incidentally, in Nigeria, without mentioning names, majority of banks and other organizations using Oracle Database, do so on Windows platform, plus Oracle Corporation also has a greater pact with Microsoft than with Linux (though this doesn't concern us that much).

Beyond chatper 2 which dwells on Installation, the remaining 18 chapters are on Oracle itself to the exclusion of an Operation System. To find information on how to Install Oracle 10g on Linux or any other OS, visit: http://www.oracle.com/pls/db102/homepage Oracle has documents for these. To include OS in my lessons goes beyond my intentions.

Pls accept the little I can offer.

God Bless you!!!

Deola

Prof...we gbadun U o, hope u don chop o...pls do...cos. dis things sap energy (u know)
meanwhile, make guys talk less of getting materials & focus on lectures abeg (no handouts 4now...e no dey tire una)...we'lll get materials across l8r...
Fire on Prof.

_________________
In Life's Pursuits, Never Outrun God [Prov. 19:21]
1luv...

Some ppl re just oliver. ah! ah.. I beg guys make una stop disturbing prof with endless qustions oo.

Don't worry guys. We shall all get there. Make we just take am easy oo. Abi u won kwn pass oracle CEO?

Jiggo, Seluwole,
Please don't stop anyone from asking whatsoever questions from the lecturer..bcos the fact that you can ask real time questions and get answers makes a big deal out of this virtual class.
If deolly tire of questions, him go talk ..
abeg make we get serious and let everyone enjoy the class...

Deolly,
No worries, i dey write names of noise makers already.

We will get there..

_________________
Building a Solution Colony. Gb!

May Jah bless this prof. of ours. Did someone just say Amen?

_________________
No matter how 'elephant' big reach, e no fit cause earthquake!

Hi Guys!!

Thank you all for your contributions! We will continue with chapter 3 on Monday, God willing, then have chapter 4 before the week runs out.

God Bless you all!

Deola

Hello guys!!

I could help out with the current dumps and materials if need be. I could also give u guys coded sites where u cd download d books on oracle 10g.

I just want to see how i can help.

Pls prof give me the go ahead order b4 i give out the sites. The downloads are free of charge.

I await your approval , prof.

Well done!!!

Hi Ellen!!

Thank you very much for your intentions. They are most welcome pls. Though I have sent some dumps to the guys that asked for them, but I was unable to send the soft copies of the books because they are large in megabytes and would not go through attachment. Thus, it will suffice for them (and all of us) to benefit from this sites from which we could download the books.

Thank you once again for your GREAT contribution.

God Bless you!!!

Deola

I guess u are reading our mind. We are almost done with our download solution, we would lunch it very soon. Whats the total size of the files?

_________________
Fowe.
Choices make or mar Chances ... add extra care to your choices today.

Hi deolly. this is really great work that you are doing, you might not know the value now untill we ur students start giving our testimonies. Please send the download round to all of us o! i mean the materials on OCA and OCP. please i need it too and i guess there are others that want it too, not just the dumbs. I also need an original copy of 10g software, how can u get one.

Have a great wkend guys.
We will all get to the top.

love

ellen...we dey wait U o for d materials

_________________
In Life's Pursuits, Never Outrun God [Prov. 19:21]
1luv...

My Prof,

Thank you for your lectures, infact you are a genius.The little i have read today has given me some knowlege of Oracle 10g.But my prof, i would appreciate if you can assist me in anyway you can on reading materials for further research, because i would say that i am a layman in this field and i have no computing knowledge of oracle.

There are some terms you mentioned i would like to find meanings to like the GUI, redo-log files,char,varchar2 and so on.I would not like to pull the class back but would be forever grateful if you could send me soft copies of a good book i could read for further reseach in order to keep abreast with your lessons and move at your pace.My e-mail is josephshotunde@yahoo.com.Hope to hear from you soon.

Kind Regards,

Joseph

God bless our Prof..........................

_________________
SHOTUNDE JOSEPH ABIODUN

GUI means Graphical User Interface,
Char means 'a character' asin in for example an alphabet like 'A' or a digit number like '3' and other characters like &, #, * are all characters. Varchar means: variable character( i guess ), asin variable char. In Dbase systems a varchar can be used to to store more than one character, it can store what is called a String. A string is like a word in english or even a sentence. |E.g "Oracle" is a string, and "I like Oracle" is also a string, all this are what a varchar can store in a database.
Dats all i know ooo, Proff I hope i am in line? Kindly complete the rest

_________________
Fowe.
Choices make or mar Chances ... add extra care to your choices today.

Hi guys,

I`m so sorry i came in late.

Anyway, there are 2 sites where u can download the materails and dumps. it is free and virus free two. i have been checking out that site for virtually everytin IT related.

Pls it is a coded site and very few know about it. i just want to help out cos am abt doing my 10g upgrade exams.

try out this site...www.4shared.com......click on the " i am looking for" tab and write oracle 10g and click search or go. A page wd appear and u`d see diiferent materials on oracle and click on watever book u want there. i wd recommend the ones published by sybex or mcgraw or so. very very easy to understand and very large large prints too.

i`ll be right back be close of day for the rest.

Please bear with me.

got to pay some bills u know.

Well done prof.

Later then.

FOWE,KEMI, SHOTTY and ELLEN


Hi Fowe, the size of the Oracle books I have now are about 30MB. Thanks also for your words on the stuffs that were not clear to Shotty.


Kemi, thanks a bunch for your words. God bless you. Send me your email addy so I can send you the dumps. But for the books, their sizes will not allow them go through attachments. Though, our great people in the forum are already finding a solution for the downloads. Furthermore, one of us, by name, Ellen, has done a great thing for us by opening our eyes to a site from which we can get all we want on Oracle 10g. This is a real big stuff out there. Click on this link to get to the books on the site she gave to us:http://www.4shared.com/network/search.jsp?searchmode=2&searchName=oracle+10g .Stay tuned.


Shotty, thanks for been a part of us. Pls feel very free to ask questions. The essence of this forum is to afford you the opportunity to read, sit for and pass your oracle exams without spending a dime (except for the cost of going to the cafe and of registering for the exams). I can not send books to you by attachment since the files are very large, but you can download them through the site given to us by Ellen. Just click this link to get there: http://www.4shared.com/network/search.j ... oracle+10g As for the dumps, I will forward them to your email at my earliest convenience. For the stuffs that confused you in the lessons, I think Fowe has done justice to them. GUI means Graphical User Interface. This refers to an application (software) that is user-friendly and interactive, on which you can click on a word, button or logo or image to get into what such represents. For redo-log file, we will talk more about it in later lessons. It is one of the three database files. char and varchar2 are datatypes which enforce or prescribe the type of data that you can enter for a column. Note that when you are filling certain forms, if you are supposed to type numbers in a box, but instead, you typed in characters (e.g. alphabets), you will have an alert that tells you that only numbers (numeric values) are acceptable, datatypes are the ones at work. I am saying this in addition to what Fowe has explained. Though we will talk more about all these in later lessons. Cheers!


Ellen, God bless you immensely for the site you have exposed us to. You are making this forum thick. I hope we have more of people like you and the guys that have been contributing greatly on this forum.

You all are GREAT!!!

Watch out for chapter 3 today.

Hi deolly,

Thanks but the whole credit goes to u, my dear. Its not easy cordinating a great site like this.

About the other site, i think i have to send it to u personally too. Its a chinese site but there is a way to go about it and u`ll get all IT related books. At the end of the day, the books come out in English. I`ll send u the site later, maybe 2moro.

Prof, naother tin, i think pracitce makes perfect or dont u think so? These guys need to know how to install the database themselves n not just reading it. Especially the SQL aspect of it that takes a lot of practise and all that.

I have the Oracle 10g R2 and R1 database on my Lap and and will galdly sent it to u, prof to send to the guys. With that they can install and practice at will. If they devleop any prob they can always come back to the forum and u can sort those issues out for them.

Proff u can send me ur addy ad i will gladly send the databse to u (that is if u dont already have it!!). Its a large file but there`s always a way around it, abi?

Pls, am also a novice in this Oracle thing ooo!!. Its just that the quest for more knowledge and a better job is taking me this far.

Anyway, Prof, keep the flag flying.

U are great!!!

Later.

this is seriosly interesting
we r all shot of words

_________________
In Life's Pursuits, Never Outrun God [Prov. 19:21]
1luv...