Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Failed Logon Trigger on DATABASE

Re: Failed Logon Trigger on DATABASE

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 05 Jul 2005 19:01:55 -0700
Message-ID: <1120615337.202250@yasure>


Raymond wrote:

> "DA Morgan" <damorgan_at_psoug.org> ¦b¶l¥ó news:1120571722.88877_at_yasure ¤¤¼¶¼g
> ...
> 

>>Raymond wrote:
>>
>>
>>>ERROR:
>>>ORA-00600: internal error code, arguments: [4406], [0x67B7F044],
>>>[0x67B7F420], [], [], [], [], []
>>>ORA-00600: internal error code, arguments: [17034], [0x31C3274], [0],
> 
> [],
> 

>>>[], [], [], []
>>>
>>>Is there anyway to disable the trigger without logon?
>>
>>And your Oracle version is?
>>
>>First off a 600 ALWAYS means open an iTAR and you should. But the first
>>thing you should try to do is log in using SQL*Plus as "/ as sysdba"
>>and disable then drop the trigger.
>>
>>If you get a 600 open an iTAR.
> 
> 
> Thx, I am using 9.2.0.1.0.  But when I logon as SYS, SQLPLUS returns
> immediately (without any error code).  That means I cannot logon through any
> account right now.

I do not understand what "returns immediately (without any error code) means. And what does SYS mean? Are you using '/ as sysdba'?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jul 05 2005 - 21:01:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US