Re: Oracle 10g Server on Windows XP Pro

"Ian Smith" <ian.smith_at_irascian.com> wrote in message news:de616ff6.0405251436.14b515e9_at_posting.google.com...
> I have done two installs on Windows XP Pro now and find that Oracle
> works fine until a PC reboot and then any attempts to use EM give the
> error: "The database status is currently unavailable. It is possible
> that the database is in mount or nomount state. Click 'Startup' to
> obtain the current status and open the database. If the database
> cannot be opened, click 'Perform Recovery' to perform an appropriate
> recovery operation."
>
> When installing the software I can happily connect to the database and
> use it via web browser and http://localhost:5500/em
>
> After a reboot the same command gives a "DNS or Server error".
> Checking "Services" using Control Panel the "OracleDBConsolenccf" (I
> called my database nccf not orcl) is not started where it had been on
> install and where "Automatic" has been specified as the service
> start-up mode. Manually starting the service seems to work and then
> the http://localhost:5500/em gives the error shown above about the
> database status being unavailable.
>
> If you click "Perform recovery" the damned thing wants not just the
> SYSDBA password but also an "OS Host user name and password". I don't
> use a password as this is a single user-version of XP.

You said you were on XP Pro. When you install XP Pro you have to specify an Administrator account. And when XP Pro first boots up after installation, you have to specify a non-Administrator user account. So you *do* have a multi-user version of XP, and should be able to supply those username details. It is true you can leave passwords for Administrator and other users blank in Windows. That you *can* do so, though, doesn't mean you should.

And if by 'single user version of XP' you actually meant XP Home, then all bets are off, because 10g's not certified for that version.

>The dialogue
> just keeps spitting "Invalid password" at me when I attempt any sort
> of recovery because it seems to object to the "OS Host password" field
> being left blank.
> Having completely uninstalled Oracle 10g twice now and hit the same
> problem after the first reboot I'm stuck. My machine has slowed to a
> crawl too where it was fine with Oracle 9i. Any suggestions as to what
> the problem might be? I can't believe I'm the only one who's hit this
> "issue"!

Without wishing to be unpleasant about it, I suspect at least half the problem is not configuring Windows properly. A Windows without passwords, even for the local Administrator account, strikes me as just asking for trouble. From there, one can only guess whether this machine has a network card/loopback adapter, whether its IP address is configured correctly, and so on.

I've installed 10g on multiple Windows 2000 Pro, Server, Advanced Server, Windows 2003 Server, and XP Pro machines, not to mention assorted Linux distros, and not once had a problem. However, all of those Windows installations are characterised by having proper networking, DNS, and user authentication mechanisms in place before I start.

None of which might be your problem, of course. But it's difficult to think of anything much else it could be on the basis of the information provided.

Regards
HJR Received on Tue May 25 2004 - 18:31:13 CDT