Re: Oracle 817 - Fresh install, what accounts?

Thanks for he info. It is understandably a little more complex than the integration with MS SQL (or seems to be), but will become clear once I get on the training course I expect!

Cheers

dvillalo_at_avega.com (dg) wrote in message news:<921a292a.0301231255.75b23164_at_posting.google.com>...
> They refer to two of the adminstrator accounts created with the
> database.
>
> If I may use a unix example, the SYS account is the equivalent of ROOT
> access to the database. SYSTEM is another administrative account with
> almost as much authority.
>
> If you chose the default installation & had it create a database for
> you, then you also have a user named SCOTT with a password of TIGER.
>
> You log into these accounts from a tool, such as sqlplus, oracle
> enterprise manager etc. (these were also part of the install & you'll
> find them under "programs, Oracle - <oracle_home>" off of your start
> menu.
>
> For example, to log into the database as the "SYS" user, you would go
> to sqlplus, type in "SYS" for the user, "CHANGE_ON_INSTALL" for the
> password, and (based on your example) "uktest" for the host string
> (you can also leave the last one blank if you're logging in from the
> machine where Oracle is installed.
>
> loadofcr_ap_at_yahoo.com (gOD) wrote in message news:<f9cb0ef5.0301230739.2b507465_at_posting.google.com>...
> > Hello,
> >
> > Firstly I know practically nothing about Oracle, but need to get a
> > problem sorted out.
> >
> > I have just installed Oracle 817 (Enterprise Edition) on Win2K. At the
> > end of the install, it threw up (that is what I feel like doing after
> > working with Oracle for a few hours!!) a dialog box saying:
> >
> > *********************************************
> > Database Creation completed.
> >
> > Database Information:
> > global database name: uktest
> > database system identifier (SID): uktest
> > SYS account password: change_on_install
> > SYSTEM account password: manager
> > *********************************************
> >
> > I have also had a bit of a look around and found the Oracle
> > Administrator Assistant for Windows NT, which when I run, tells me
> > that that the OS Database Administrators - Computer, consist of
> > myself. No other accounts are listed.
> >
> > So what passwords do that mentioned above refer to? Where can I manage
> > those accounts from?
> >
> > thanks
Received on Fri Jan 24 2003 - 09:33:14 CET