 Unable to login into SQL*Plus due to error in After Logon Trigger [message #117559] |
Thu, 28 April 2005 03:30  |
anasuya
Messages: 3
Registered: April 2005
Location: India
|
Junior Member |
|
|
Hello,
I had coded one after LogOn Trigger in the system/manager.
There was some error in that trigger during compilation. Unfortunately, i did not drop/disable that trigger before exit from SQL*Plus.
In the next session when i was trying to log in to SQL*Plus, it failed showing an error message
"ORA-04098 : trigger 'T1' is invalid and failed re-validation"
.
Please note that 'T1' was the name of that After LogOn trigger.
So,kindly mail me if any solution to overcome the above problem is available, so that i can login into my database and recover the existing data.
My mailid is anu_itr@rediffmail.com
With Regards.
Anu
|
|
|
|
|
|
| Sysdba is available in Oracle 8i !!! [message #117739 is a reply to message #117559] |
Fri, 29 April 2005 07:01  |
anasuya
Messages: 3
Registered: April 2005
Location: India
|
Junior Member |
|
|
Hello,
Thanks a lot for ur suggestion.
But i am sorry to write that
I had tried the trigger in Oracle 8i.
And in that sysdba role is not there.
So can u plz. send me the way how can i recover in Oracle 8i.
I tried in sys user but in that also the same error was thrown.
I am explaining my problem once again.
I had coded one after LogOn Trigger in the system/manager.
There was some error in that trigger during compilation. Unfortunately, i did not drop/disable that trigger before exit from SQL*Plus.
In the next session when i was trying to log in to SQL*Plus, it failed showing an error message
"ORA-04098 : trigger 'T1' is invalid and failed re-validation"
.
Please note that 'T1' was the name of that After LogOn trigger.
|
|
|
|
|
|
| Re: Sysdba is available in Oracle 8i !!! [message #117839 is a reply to message #117739] |
Fri, 29 April 2005 23:41 |
anasuya
Messages: 3
Registered: April 2005
Location: India
|
Junior Member |
|
|
Thanks.
But i have not tried that. Is there any possibility to get into Oracle 8i by that means? Won't that trigger fire in that mode?
Plz. send me the detail if that may be one way to recover the data
|
|
|
|
| Re: Sysdba is available in Oracle 8i !!! [message #117853 is a reply to message #117839] |
Sat, 30 April 2005 02:44 |
 |
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
I have merged the two threads together. As Frank said, login as sysdba. Try it. It works. Oracle is specifically made to not fire after logon triggers when you log in as sysdba, so that if you get yourself into this sort of situation you can get out of it. You do have sysdba and it is not a role. Instead of:
system/manager
use:
system/manager AS SYSDBA
If you are connecting through a SQL*Plus login screen, you can put the whole "system/manager AS SYSDBA" in the username box. Then, once you have logged in:
drop trigger t1;
[Updated on: Sat, 30 April 2005 02:45] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
