Oracle 9i: SQL, PLSQL, and SQL *Plus - Software Installation and References

Please use discussion board for any questions you might have in this Learning Series. That helps other users answering the same questions. Next week we will be starting with our first lesson. In the mean time please setup your pc with Oracle Software.

Follow the link to download the appropriate version accorind to your operating system. Download Oracle 9i. You need to register with Oracle for free account to download the free educational version. if you are on windows, I would recommend to get this: Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP.

Click here Installation Instructions on how to install Oracle 9i on Windows PC.

Click here Installation Instructions on how to install Oracle 8i on Windows PC.

The following, short Installation Guide shows how to install Oracle 9.2.0 for SUN Solaris 8. You may download our scripts to create a database, we suggest this way and NOT using DBASSIST. Besides this scripts, you can download our SQLNET configuration files TNSNAMES.ORA. LISTENER.ORA and SQLNET.ORA.

Click here Installation Instructions on how to install Oracle on Solaris PC.

Click Here Installation Instructions on how to install Oracle 9i under RedHat Linux 8.x and 9.x

Click Here Installation Instructions on how to install Oracle 9i under Mac

Even if you are a windows user, I would recommend you to take a look the installation procedure on Unxi also since most of the Production environments are based on Unix.

What Oracle Software will I need to learn Oracle?

Given the vast array of products listed above, one should assume it is not feasible to learn ALL of the Oracle products at one time. Below is a suggested series of steps to gradually build your Oracle knowledge using the minimum amount of software. If you have a reasonably equipped PC (256 MB RAM, 15 GB disk space free, Windows 2000 or XP Professional OS), you can run both a server instance and the client tools on the same machine.

Manish Madhukar said:

:) To development of a 2 or 3 tier client/server project & to have an 1st Paper OCP Exam. Preparation ::)

July 08, 2006

Neeraj Kumar said:

for study & learning of Oracle. I study database.

January 17, 2007

Praveen said:

Hi this is praveen,
Please can any one tell me how to install oracle 9i on winXP.If it is not possible on winXP and how to remove Oracle 9i from WinXP.

Thanks ,
Praveen.

January 27, 2007

ShakthiMahalingam said:

To development of a 2 or 3 tier client/server project & to have an 1st Paper OCP Exam.

February 02, 2007

thank you said:

hi!

First of all, thank you so much for such nice tutorials and stuff.. Its really helpful and saves my time a lot!

Thank you! and keep up the goood wooork!

best regards

thana

March 28, 2007

kk said:

n/ahi!

First of all, thank you so much for such nice tutorials and stuff.. Its really helpful and saves my time a lot!

Thank you! and keep up the goood wooork!

best regards

thana

April 19, 2007

Virus_1983 said:

hi,
i have been unable to install the oracle 9i on my win xp pro SP1, i have got the three cd pack, the first cs installs properly but when i put the second cd in, it says d:stageproduct.jar" cannot be found.please help me with this

regards,
Gulrez

June 07, 2007

rekha_harsha said:

hi,
My system operating system is windows 2003 can i install oracle 9i in my system

July 03, 2007

Richard Rea said:

Gulrez,
You may have to get a new group of CD's from Oracle or download Oracle 9i from Oracle's website to a computer and save to CDs. I had this problem with the first disk, and I was able to fix it using the downloaded version. Keep in mind that if you don't have at least a T1 line the download will take something like 17 hours and may timeout due to bandwidth constraints with your ISP. This is my opinion but I think sometimes when they make the 3 cds one of the files at the end of the disk is getting corrupted by truncation.
Good luck!
Rick

July 13, 2007

asd said:

if u want to delete oracle replace the .dll with .bak reboot system & then try deleting oracle

September 05, 2007

wahid buneri said:

after installation of oracle for loggin into database what name and password is needed as i tried scott as name and tiger password but still not connected what i need to do for this .

September 08, 2007

Mohanraj Chozhan said:

how to uninstall 0racle9i from Windows Xp.

September 10, 2007

Chris_Jones said:

I find all free training sites go directly to teaching SQL. I want help in operating Oracle. In Windows SQL server, starting SQL server, creating a database and writing SQL statements is easy. But in Oracle I don't know what to do. I've successfully installed the software (9i) but am unable to create my own database and to start practicing . What I am saying is what are the necessary steps to start operating the Oracle program. Can anyone help me in showing me how to start Oracle, how to creat a database and so on. I am scared to do anything in case I screw up.

September 26, 2007

venu3455 said:

how to install d2k .iam successfull install oracle 9i.how to install d2k.can any one help me.tell all navigation that how to install.

October 24, 2007

jincy said:

this tutorial helped me a lot. thanku so much and keep going on like this........

January 14, 2008

shina said:

after installation of oracle for loggin into database what name and password is needed as i tried scott as name and tiger password but still not connected what i need to do for this .
My system operating system is windows XP.

February 14, 2008

K I P said:

Can I download oracle database to learn

March 08, 2008

Ranjit Kumar said:

First of all, i thank all person whose support and help for the develope this site, there all basic feature are also avable. i thank so much for such nice tutorials and stuff.
Its really helpful saves my time a lot!

April 03, 2008

mukulika said:

my pc is vista can i install oracle9i if not then what would i do?and how?

April 13, 2008