Re: NT 8.1.7.0 - ora-1403, but what file??

Hi Jared,

Do you have a logon database event trigger that does funky things...just a thought.

Jared wrote:

> Hi, all -
>
> On a newly-installed 8.1.7.0 db, I managed to mess up the password
> file. Followed the Metalink note to recreate it, appeared to work
> correctly, except the database refuses to open after the database is
> recovered.
>
> The alert log shows:
>
> alter database open
> Mon Aug 19 17:28:18 2002
> Thread 1 opened at log sequence 215
> Current log# 2 seq# 215 mem# 0: C:\ORACLE\ORADATA\OEMREP\REDO02.LOG
> Successful open of redo thread 1.
> Mon Aug 19 17:28:18 2002
> SMON: enabling cache recovery
> SMON: enabling tx recovery
> Mon Aug 19 17:28:19 2002
> Updating 7.0.0.0.0 NLS parameters in sys.props$
> -- adding 8.1.7.0.0 NLS parameters.
> ORA-1403 signalled during: alter database open...
>
> ORA-1403 is 'data not found'. Now to judge by the alert log, one
> would think the database is open, however any attempts to log on get
> an ORA-1033 (Oracle initializing or shutdown in progress) error.
> Metalink is not much help here, unfortunately. Has anyone seen this?
> Is there a workaround?
>
> TIA -
>
> Regards,
>
> jh
>
Received on Mon Aug 19 2002 - 22:09:22 CDT