Re: open with migrate??

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 13 Dec 2005 20:11:53 +0100
Message-ID: <127up1toko94p1fnmi0jlgq4e2l2i2cu8m@4ax.com>

On Tue, 13 Dec 2005 16:02:19 +0200, pnp <pnpNOSPAM_at_softlab.ntua.gr> wrote:

>mess that was created by their former oracle admin that left. What can I
>say...
>
>When I try to open the database I get the error: ORA-1092 and then the
>database closes

I'm not sure why the error log doesn't show this error. I would downgrade to 8.1.7 *ASAP*, or better still : Get someone from Oracle in, or your database is probably toast. I would make sure you have consistent database, and a *cold* backup has been made, prior to proceeding any further. You should disregard nirav's advice, as that is dangerous: the database has never been upgraded to 9i, you don't know whether you have a consistent database, and the upgrade is likely going to fail hopelessly, and you'll get busted for it.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 13 2005 - 13:11:53 CST