CAN ANYONE GIVE ME SOME INPUT ON WHAT I'M DOING WRONG.
 

ANOTHER QUESTION. I INSTALLED BOTH ENTERPRSE EDITION AND PERSONAL
EDITION.I INSTALLED ENERPRISE ON  MY C:/ DIRECTORY AND PERSONAL ON MY
D:/ DIRECTORY. IS THIS CONSIDERED A MULTIPLE ORACLE HOME?  HOW DO I SET
IT UP, AFTER THE INSTALLATION?

Van

2.   Creating the NT Services
When Oracle for NT (in the database assistant or as part of the install)
creates a database it creates two services. The first is called
OracleServiceSID and the second is OracleStartSID. You can see them in
control panel/services. If you are creating your own database you can create
these services yourself using the utility Oradim80. First build your
init.ora or pfile.
To create an instance as well as the OracleServiceSID do this:
C:\......>oradim80 -NEW -SID PLAY -INTPWD INTERNAL
This creates the service named OracleServicePLAY with the instance PLAY with
a password of INTERNAL for internal.
To get rid of the instance and service do this:
C:\......>oradim80 -DELETE -SID PLAY
C:\......>oradim80 -DELETE -SRVC ORACLESERVICEPLAY
To create an instance as well as two oracle services OracleServiceSID and
OracleStartSID do this:
C:\......>oradim80 -NEW -SID PLAY -INTPWD INTERNAL -STARTMODE AUTO -PFILE
G:\ORANT8\INITPLAY.ORA
This creates the services named OracleServicePLAY and OracleStartPLAY with
the instance PLAY and a password of INTERNAL for internal.
To get rid of the instance and services do this:
C:\.....>oradim80 -DELETE -SID PLAY
C:\.....>oradim80 -DELETE -SRVC ORACLESERVICEPLAY
C:\.....>oradim80 -DELETE -SRVC ORACLESTARTPLAY
There are other options that you can see by running oradim80 with no flags:
C:\.....>oradim80
But once you've created the basic services it's probably easier to
manipulate them in control panel/services
3. Start an Instance Then Create the Database
Startup Svrmgr73 and type
connect internal@2:PLAY  (where PLAY is your sid)
password:  internal  (or whatever you set it to when you created the
services)
startup nomount pfile=full path and name of pfile including the .ora suffix
At this point you can type in your create database commands or run one or
more scripts to create the database.  Oracle has a set of sample scripts
that you can look at in buildall.sql.  Search for that file.
4. Post-Creation
There are a number of scripts that should be run after database creation.
You’ll
probably see most of these in buildall.sql.  You should also run pupbld.sql
as user System to set up SQL+ properly.  Otherwise you’ll get an error
message every time you connect using SQL+.
5. Connections
Bequeath Connection
 This is the simplest connection of all.  It doesn’t require any listener to
be created and it doesn’t require any listener service to be started.  You
can make one in a minute by filling in two or three simple pieces of
information in the Oracle Net8 EasyConfig utility.
TCP-IP Connection
 Here’s how to build a TCP connection:
Go to your \windows\hosts\ file and add a line that looks like 127.0.0.1
localhost if it is needed.  Also add one for 127.0.0.1 van (or whatever you
have named your computer)
Let’s say you want to create a connection with an alias of PlayTcp.world
that has these values:
     protocol tcp/ip
     host name: van
     port 1521
     SID Play
Here are the steps to take.
1) Use the Oracle Net8 Assistant to create a new listener.  When the
assistant opens highlight the word listeners.  Then go to the edit menu and
choose create...  In the right pane you will see a drop-down list box with
the words Listening Locations filled in.  There are four steps in the box
and you should go through them one at a time.  Fill in the information for
Listening Locations first, the General Parameters and Database Locations.
Other Services is optional.  When you try to exit the Net8 assistant it will
ask you whether you want to save the information for your new listener.
Save it if it is good.  2) Next go to control panel/services in WindowsNT
and start the Oracle TNSListener80 Service.  Set it to start automatically
if that is what you wish.
3) Finally, go to the tnsnames.ora file and add a block for your new tcp
connection.  You can see a prototype in the Net80\Admin\Sample folder.  It
will look like this:
PLAYTCP.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = van)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = PLAY)
    )
  )
Finally, test your connection using SQL+ or the test button in the
OracleNet8 EasyConfig utility.