Re: Newbie.......

Freak on the Linux wrote:

> Hello all,
> I need to do an assignment for my university course. The
> assignment is about designing a database system.
>
> no no....... don't need help with the assignment.
>
> But I need to install oracle on my win2k machine to be able to do this
> assignment.
>
> I tried to install it a few months back, but couldn't get to that point
> where I can get a command prompt type window and write sql queries. At
> university we got that but it is quite far and it would be much easier for
> me if I could do it at home on my own machine.
>
> So if anyone would be willing to help me to go through the installation
> process of Oracle 8i which I have on cd...I would be very grateful.
>
> Please send me an e-mail.
>
> Thanks in advance.

I would be happy to help you through it.

1. Put the CD into the machine (sorry but it is the first step)
2. Choose TYPICAL and let Oracle create the sample database

That is all there is to it unless you have an error (is your machine a Pentium 4? If so read the advisories about Pentium 4s).

3 Go to the Oracle bin directory and run

lsnrctl status

to see if the listener started properly

4. Start server manager (svrmgrl) connect internal and try a simple SQL statement such as:

SELECT COUNT(*) FROM tab$;

If there are any problems be sure to carefully document the nature of the problem and the FULL error message.

5. If all has gone well then you should be able to open a SQL*Plus session and log on as SYSTEM. Create a user for your project. Log on as that user and begin.

Daniel Morgan Received on Tue May 21 2002 - 17:23:48 CDT