Tutorials
Oracle 9i
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.
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.
| If your goal is to ... | Acquire this software... |
|---|---|
| Learn the basics of SQL, Stored Procedures, Triggers and the Oracle data dictionary e.g., in preparation for the first OCP exam. |
Personal Oracle 8i for Windows NT/2000 or Windows 98 (includes the DBMS and SQL*Plus tool) OR, if you have the necessary disk space and at least 256 MB of RAM, consider Personal Oracle 9i for Windows NT/2000/XP or Windows 98. |
| Learn how to develop client side applications (forms, reports) e.g., for development of a 2 or 3 tier client/server project |
Personal Oracle 8i or 9i (see above) and Oracle Developer 6i or Oracle Developer 9i |
| Learn how to develop client side applications in Java (forms, reports) e.g., for development of a 2 or 3 tier client/server project |
Personal Oracle 8i or 9i (see above) and Oracle JDeveloper 9i |

| :) To development of a 2 or 3 tier client/server project & to have an 1st Paper OCP Exam. Preparation ::) |
| for study & learning of Oracle. I study database. |
|
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. |
| To development of a 2 or 3 tier client/server project & to have an 1st Paper OCP Exam. |
|
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 |
|
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 |
|
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 |
|
hi, My system operating system is windows 2003 can i install oracle 9i in my system |
|
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 |
| if u want to delete oracle replace the .dll with .bak reboot system & then try deleting oracle |
| 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 . |
| how to uninstall 0racle9i from Windows Xp. |
| 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. |
| 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. |
| this tutorial helped me a lot. thanku so much and keep going on like this........ |
|
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. |
| Can I download oracle database to learn |
|
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! |
| my pc is vista can i install oracle9i if not then what would i do?and how? |
| hi my name is kunal acctuly i want to prepration of Dbms plz help me what is dbms how can i prepration for the certification plz help me and give me the books name for the first paper prepration ....... |
|
please help me , i have installed oracle 10g on my laptop , but i don't know how to access the demobld tables, please help in this send me mail to narayana.yadav@gmail.com |
| hai my name is goutham can anybody can please assist me to install windows 9i on windows. |
| hello i m sangeeta i want be a part of the world best database Oracle.I m an M.C.A. |
| hi i need assistance in installing oracle 9i in my computer..im a novice in this subject.. so can someone help me in installing the software please... |
| Hi, from where & how to download oracle 9i software please send me your positive response ASAP |
| hi this site is very nice |
| Can we install oracle9i in Windows Vista® Home Basic Os notebook?if not then what would i do?and how? |
|
Hi! Why dont u people opt fo rOracle 10g express edition. Yoy are able to do almost everything implemented on 9i as well creating functions , procedures and triggers can be done pretty fastas compared to Oracle 9i. Farhan - B.E.Computers |
|
hi Everybody To learn Oracle smartly, developer should have clear concept of Databse system. Developer should be familiar about terms used in Oracle |
| Thanks for this information |
| thank you |
|
I m amjad OCP (Database 8i) i want to learn oracle 9i (developer track) plz. guide me. |
| thanks |
|
Hi, i am shyamprasad to learn more about database we need steps that we follow guidelines from oracle9i |
|
Mohanraj Chozhan , autorun the 1st cd of oracle. from here click uninstalled product the product. After that go to run ==>>regedit==>current user and local machine ==>>delete the oracle folder. -----Reboot the machine. uninstall completed. |
| My OS is Vista SP1 (32bit). Can I install Oracle9i? |
|
hi i'm arun i have working with it company as a Customer Support Engg Of IT Hardware Resently Oracle 9i Has Add To my work profile so that i want to doing a course With Oracle Data base PLZ Suggest me which corse is required for me Arun Kumar Singh |
|
while installing it shows .dll files are error in xp. What could be the reason. Please guide me regarding as I am new to RDBMS. |