New Error after SA Reboots without DB Shutdown 2006-02-17 - By Rick Weiss
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 (See ORA-00604.ora-code.com): error occurred at recursive SQL level
ORA-02248 (See ORA-02248.ora-code.com): 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@(protected)
(406) 495-7356
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>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)</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Another note: RMAN backup ran last night with no errors, so SYSDBA access
is alright. I use controlfile for catalog maintenance.</DIV>
<DIV> </DIV>
<DIV>Messages<BR>-- ----<BR>ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level <
/DIV>
<DIV>ORA-02248 (See ORA-02248.ora-code.com): invalid option for ALTER SESSION</DIV>
<DIV> </DIV>
<DIV>Cause<BR>-- --<BR>An error occurred while processing a recursive SQL
statement<BR>(a statement applying to internal dictionary tables).</DIV>
<DIV><BR>Action<BR>-- ---<BR>If the situation described in the next error on
the stack<BR>can be corrected, do so; otherwise contact Oracle Support.</DIV>
<DIV>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
-- ---</DIV>
<DIV>Message<BR>-- ----<BR>RME-00220: Failed to connect to Repository</DIV>
<DIV> </DIV>
<DIV>Cause<BR>-- --<BR>Failed to connect to the requested Repository.</DIV>
<DIV> </DIV>
<DIV>Action<BR>-- ---<BR>Examine other reported errors for specific details.<
/DIV>
<DIV>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
-- ---</DIV>
<DIV> </DIV>
<DIV>If anyone has ideas on debugging this one, I would appreciate it.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Rick Weiss<BR>Oracle Database Administrator</DIV>
<DIV> </DIV>
<DIV><A href="mailto:rweiss@(protected)">rweiss@(protected)</A><BR>(406) 495-7356<
/DIV></BODY></HTML>
|
|
