basic oracle help, please -- time sensitive

[nemaNIN]

i just installed oracle 9i client onto my home pc. im taking a database class and we're using oracle, however the book comes with all the data and the program to build the database we're using for our class project.

so i've installed oracle 9i client, and i know how to create an account (though i dont really know how to apply the proper rights, etc) however, i can't log in to SQL plus because there is no account set up for me. so i cant access anything.

can someone smarter than me please explain how you set up an oracle user on a local machine like this when there are no accounts set up?

i have a project due monday, and getting this set up here will allow me to use dual monitors while i work and save me alot of time in the school computer labs.... can i get some help asap, please 🙂

thanx! i really appreciate your help
nema

 

[eklass]

is there any sort of default account such as root or admin with maybe no password set? i believe mysql is this way

 

[manly]

It sounds like you need to install the Oracle server suite, not just the client access modules.

Sign up for a free account at Oracle Technet and you can access a wealth of searchable Oracle documentation. Free downloads for development as well.

 

[nemaNIN]

yikes.. i have downloaded the server suite, but its 3 700 meg zip files.........

so i really need all that?

 

[tkdkid]

Well, you have to be connecting to some oracle server. If you can connect to the one at school somehow (dialup or something?) then you only need the client. Otherwise, you will need a server somewhere, so you can install one yourself.

 

[loup garou]

As said, you'll need to either install the server suite, or connect to an existing oracle database server. In school, I used to just telnet into the school's Oracle server and run sql*plus from there. Ask your professor about telnet access.