Re: Installed Oracle 9i - can't start database

"Elvis" <esamson_at_web.de> wrote in message news:b2nnu7$lbt$05$1_at_news.t-online.com... "DA Morgan" <damorgan_at_exesolutions.com> schrieb im Newsbeitrag news:3E4ECDFE.CAF2F716_at_exesolutions.com...
> 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

Hi, this starts to get a nightmare.. okay I started sqlplus /NOLOG and tried to connect with "CONNECT / AS SYSTEM" which gave me the reply "ERROR: ORA-01031: insufficient privileges".

I downloaded Oracle 9i from Oracle Homepage. I tried to install regular, minimal and userdefined. The regular install works nearly to 100% and then throws an error that an ocx file readproblem has occured. The other installation did work. BUT with all installations I had the problem, that the installation routine did'nt ask me for any passwords and after I rebooted and tried to launch the database with "start" then it asks me for a password. It doen't say which username it uses, so I tried all the oracle standardpasswords which I found in an oracle dcument on their webpage and no one worked.

Help rewarded :-)
Thanks in advice,
Elvis

Try orapwd at the command prompt! It should return:

Usage: orapwd file=<fname> password=<password> entries=<users>

  where
    file - name of password file (mand),     password - password for SYS (mand),
    entries - maximum number of distinct DBA and OPERs (opt),   There are no spaces around the equal-to (=) character.

The password file resides (default) in ORACLE_HOME\database on Windows and it's called PWD{sid_name}.ora

It could look like this:
c:\> orapwd file=C:\Oracle\ora92\database\PWDgorm.ora password=oracle entries=5

Hope this helps!

//Gorm Received on Sun Feb 16 2003 - 16:40:02 CST