Is the database actually open? If you can login as sys/sysdba, I'd restart the
database and ensure that it starts up with no problems.
- Rick Weiss <RWeiss_at_safmt.org> wrote:
> Yesterday afternoon our SA rebooted the server 10.2 on RedHat/VM Ware
> with out insuring the database had shut all the way down. They still
> haven't let me modify the root shutdown script; it's still set to
> SHUTDOWN; (not immediate)
>
> Anyway - after we got everything restarted, I cannot connect to one of
> my databases. I get the following errors from all client access attempts
> (SQP*Plus, Designer, ...) I captured the following from the Designer
> login error as it provides the best documentation of what's happened. I
> am going to open an SR as soon as I send off this message as usually I
> get better response from the list than from OWS. I can connect as SYS
> from SQL*Plus, so it appears something in the generic user login process
> has been broken.
>
> Another note: RMAN backup ran last night with no errors, so SYSDBA
> access is alright. I use controlfile for catalog maintenance.
>
> Messages
> -------
> ORA-00604: error occurred at recursive SQL level
> ORA-02248: invalid option for ALTER SESSION
>
> Cause
> -----
> An error occurred while processing a recursive SQL statement
> (a statement applying to internal dictionary tables).
>
> Action
> ------
> If the situation described in the next error on the stack
> can be corrected, do so; otherwise contact Oracle Support.
>
> Message
> -------
> RME-00220: Failed to connect to Repository
>
> Cause
> -----
> Failed to connect to the requested Repository.
>
> Action
> ------
> Examine other reported errors for specific details.
>
>
> If anyone has ideas on debugging this one, I would appreciate it.
>
>
>
> Rick Weiss
> Oracle Database Administrator
>
> rweiss_at_safmt.org
> (406) 495-7356
>
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 17 2006 - 11:29:22 CST
