giles,
try: conn system_at_your_database_name [Enter]
then enter password for system.
To create a user: "create user user_name identified by user_password;"
then grant: "grant resource, connect to user_name;"
By the way, you should log in as SYS to create a new user.
--
Steve - CloudSpace New Media
steve_at_cloudspace.com
http://www.cloudspace.com
"gdw" <me_at_gileswright.com> wrote in message
news:9u3nov$vit$1_at_newsg1.svr.pol.co.uk...
> right, have got a login using sys/change_on_install, system/manager, but
how
> do I connect to the database I created and how do I add users???
>
> The error message was just invalid username/passwd.
>
> cheers,
>
> giles.
>
>
> > the default logins are: sys/change_on_install, system/manager, and
> > scott/tiger
> >
> > anyways, what's the exact error message?
> >
> > --
> > Steve - CloudSpace New Media
> > steve_at_cloudspace.com
> > http://www.cloudspace.com
> > "gdw" <me_at_gileswright.com> wrote in message
> > news:9u37fq$qop$1_at_newsg4.svr.pol.co.uk...
> > > Hi,
> > > Did the default install. Have tried connecting through sqlplus using a
> > > variety of usernames. The Global Name of the database is gdw.oracle
and
> > the
> > > SID is obviously gdw.
> > >
> > > Have tried:
> > > username - scott_at_gdw
> > > passwd - change_on_install, manager
> > >
> > > and various other combinations, names etc.
> > >
> > > When I check what processes are running TNSLSNR.exe is there as is
> > > oracle.exe but not those you suggested below...
> > >
> > > :-(
> > >
> > >
> > > > Assuming you did the default/typical install then you
> > > > should connect to scott/tiger_at_SID first of all. SID is the > name
you
> > gave
> > > your database when you created it.
> > >
> > > > If that doesn't get you in, you may find that the listener
> > > > and/or the database service(s) are not running. Check
> > > > for Oracle*TNSListener and OracleServiceSID are
> > > > both started. (You might like to set the others to manual > and
> stopped
> > > too - you won't need them for a while :o))
> > >
> > > > Regards,
> > > > Norman.
> > >
> > >
> > > > Hi,
> > > >
> > > > I realise this question has come up before but am still having
> problems
> > > > solving it.
> > > >
> > > > Have just installed the personal edition of oracle 8i on win2000
> server.
> > > > Created a database on install and am trying to connect using
sqlplus.
> > > > Have
> > > > tried the passwords given during creation, 'change_on_install' and
> > > > 'manager'
> > > > with the name of the database I created, but am having no luck...
> > > >
> > > > any suggestions???
> > > >
> > > > giles,
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
>
>
Received on Thu Nov 29 2001 - 08:17:57 CST
