Oracle 9i information needed from experts.

[rpk2006]

Hi Oracle experts,
Please let me know if there is a FREE Downloadable version of Oracle 9i database for personal use, similar to IBM DB2.

If yes, from where I can download it.

In SQL Plus which comes with Oracle 9i, which username and password is the default now. Prevously it was SCOTT, TIGER.

Help..

RPK

---------------------------------
Securing a computer system has traditionally been a battle of wits: the penetrator tries to find the holes, and the designer tries to close them. � M.Gosser

 

[sybaseguru]

Hello my friend

You can downlod Oracle 9i from the following site

http://otn.oracle.com/software/content.html

When you download it, it is very simple to install (either win32 or Linux version which I have tried).

During the process of installation, there are two accounts which are important for Oracle. These are "SYSTEM/MANAGER" and "SYS/CHANGE_ON_INSTALL" respectively. The account SYS is the Oracle dictionary owner, and SYSTEM is a DBA account. You have a chance to change their default password when you install the product. If you want to learn Oracle try using the account "HR" which has samples of everything. SCOTT/TIGER is the traditional guest account. Anyway you better off using the HR account. However, you need to unlock this account before use.

So in SQL*Plus do the following (logged in as SYSTEM user):

ALTER USER HR IDENTIFIED BY HRPASSWORD ACCOUNT UNLOCK;

So you can log in to SQL*Plus as user HR/HRPASSWORD. Obviously you can choose whatever password you wish.

Hope these note help you

 

[rpk2006]

Thanks a lot sybaseguru.


---------------------------------
Securing a computer system has traditionally been a battle of wits: the penetrator tries to find the holes, and the designer tries to close them. � M.Gosser

 

[sybaseguru]

You can contact me on "mich@peridale.co.uk" and do not forget to mark this post as helpful

 

[jee]

A little more info... If you follow the link you will see a choice of databases. If you are wanting to use the database on a PC, your best choice is probably Personal Oracle. With Personal Oracle, you can have an unlimited number of sessions, as long as they are all "local". I think you are permitted to have one remote session for administrative purposes. With Personal Oracle you get all of the features of Enterprise Edition Oracle - even the 'extra cost' ones.