Elvis wrote:
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:ef2t4vgh3bcrqt6mv1ss5gcnjrur234j1v_at_4ax.com...
> > On Sat, 15 Feb 2003 18:10:46 +0100, "Elvis" <esamson_at_web.de> wrote:
> >
> > >"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:v4qeddpt0o57dd_at_corp.supernews.com...
> > >>
> > >> "Elvis" <esamson_at_web.de> wrote in message
> > >> news:b2j9hl$4qh$05$1_at_news.t-online.com...
> > >> Hi, I just installed Oracle 9i PE on Win98 System to try some things with
> > >> sqlplus. I worked before with 8i. When I started sqlplus in 8i I just needed
> > >> scott/tiger to login, but now that doen's work anymore. Can anyone help me
> > >> please?
> > >>
> > >> Thanks in advance,
> > >> Elvis
> > >>
> > >>
> > >> Define 'doesn't work'. What error?
> > >
> > >It asks me for a password when I launch the database. I found a document where it says there I have to change the passwords after installation (get asked for the sys password and so) but I wasn't asked for that. With 'doesn't work' I meant that I cannont login as usual with Oracle 8i - the reason is the password I get asked every time the databses starts and I don't know which password I should use or how I can manually change it (in which file).
> > >
> > >Thanks,
> > >Elvis
> >
> >
> > The answer is quite simple. What password would you need during
> > startup? The internal password. What is the default internal password?
> > The name of the product
> >
> This doesn't work. Isn't there a tool which I can start and where I can set the passwords?
>
> Elvis
If you are using 9i and you just installed it ... unless you have made a change try logging on as either:
/ AS SYSDBA (leave password blank)
or
SYSTEM with password manager
Then create a user for your development work.
SELECT tablespace_name
FROM dba_tablespaces
WHERE tablespace_name NOT IN ('SYSTEM', 'UNDO', 'RBS', 'TEMP');
CREATE USER <user_name>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <from above query>
TEMPORARY TABLESPACE temp;
QUOTA UNLIMITED ON <tablespace name from above query>;
GRANT CONNECT TO <user_name>;
Then log on as your new user.
Daniel Morgan
Received on Sat Feb 15 2003 - 17:32:14 CST
