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

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sun, 16 Feb 2003 10:23:11 -0800
Message-ID: <3E4FD70F.F94B387B@exesolutions.com>

Elvis wrote:

> "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

This message is clearly telling you that you do not have sufficient privileges to log on as SYS.

What is the user name used to install the Oracle software? What is the user name you are using when trying to connct to Oracle as SYS?

Worst case you use oradim.exe to recreate the password file with any password you wish.

But I am concerned by the ocx file read problem you allude to. Not knowing at what point it blew up or what didn't happen correctly ... I'd likely clean up the machine and reinstall.

Daniel Morgan Received on Sun Feb 16 2003 - 12:23:11 CST