Home » RDBMS Server » Server Administration » Warning: No logon on database at all with logon trigger - bug? (merged)
icon8.gif  Warning: No logon on database at all with logon trigger - bug? (merged) [message #388149] Mon, 23 February 2009 08:16 Go to next message
NanteJena
Messages: 11
Registered: November 2007
Location: Jena
Junior Member
After a regular shutdown/startup no one was able to logon on the database,
even not SYS (as sysdba), system or any other dba's !!!
Following messages:
AlertLog: Completed:ALTER DATABASE OPEN, Errors in diverse trc-Files,
ORA-03113:end-of-file on communication channel; TRC-Files: Skipped error 3113
during the execution of SYSTEM.TRIGGER_LOGON, ksedmp:internal or fatal error,
ORA-03113:end-of-file on communication channel.
An attempt to logon as SYS as sysdba with sqlplus on the server ends either with
hanging sql prompt or with ORA-01075:You are currently logged on. The listener and
the unix processes (HP-UX B.11.31U ia64 Itanium) were running.
The access to the database could only restored by killing all oracle unix processes,
reboot the server and startup the database with dbstart.

After that I dropped the logon trigger immediately, although it runs without problems
so far (and years before under 9.2.0.6.!).

Did such a crash happen to someone?
Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #388151 is a reply to message #388149] Mon, 23 February 2009 08:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Something had changed if you don't know it.
Most likely the trigger is invalid or does something invalid.

Regards
Michel

[Updated on: Mon, 23 February 2009 08:28]

Report message to a moderator

icon13.gif  Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #388239 is a reply to message #388151] Tue, 24 February 2009 00:16 Go to previous messageGo to next message
NanteJena
Messages: 11
Registered: November 2007
Location: Jena
Junior Member
"Something had changed if you don't know it." - that's a great explanation! There wasn't any change.
You know, if the logon trigger get invalid still all users with ADMINISTER DATABASE TRIGGERS privilege like sys, system or dba's, should be able to logon!

Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #388285 is a reply to message #388239] Tue, 24 February 2009 02:20 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>ADMINISTER DATABASE TRIGGERS privilege like sys, system or dba's, should be able to logon!


How your saying all user's having admin rights?? Are you given admin rights to all user?? Confirm us; Post user roles & Privs.

Babu
icon13.gif  Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #388427 is a reply to message #388285] Tue, 24 February 2009 12:52 Go to previous messageGo to next message
NanteJena
Messages: 11
Registered: November 2007
Location: Jena
Junior Member
I don't say that I gave all users admin privileges (Sorry, I'm an OCP-DBA) !!!
I said that all users should be able to logon wich are in possession of the ADMINISTER DATABASE TRIGGERS privilege.
Users wich are in possession of this privilege are SYS and two well-chosen users with the dba role !!!
Now understand?
Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #388448 is a reply to message #388149] Tue, 24 February 2009 20:03 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I said that all users should be able to logon wich are in possession of the ADMINISTER DATABASE TRIGGERS privilege.

GOOGLE reports "Your search - Oracle "ADMINISTER DATABASE TRIGGERS" - did not match any documents."

Please provide URL to document(s) discussing "ADMINISTER DATABASE TRIGGERS privilege".
Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #388567 is a reply to message #388448] Wed, 25 February 2009 08:00 Go to previous messageGo to next message
NanteJena
Messages: 11
Registered: November 2007
Location: Jena
Junior Member
Sorry - The system privilege is "ADMINISTER DATABASE TRIGGER" (without "s" at the end!). That was a spelling mistake!
Details you can find in oracle documentation.
Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #388617 is a reply to message #388567] Wed, 25 February 2009 12:22 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

SQL> select * from v$version where rownum <=  1;

SQL> select * from dba_sys_privs where privilege like 'ADMINISTER DATABASE TR%';


Post output the above two query.

Babu
Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #388710 is a reply to message #388617] Thu, 26 February 2009 00:09 Go to previous messageGo to next message
NanteJena
Messages: 11
Registered: November 2007
Location: Jena
Junior Member
(1) Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
(2) Privilege is granted to SYS, role DBA and some other oracle default users and roles.
Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #393820 is a reply to message #388149] Tue, 24 March 2009 08:53 Go to previous messageGo to next message
NanteJena
Messages: 11
Registered: November 2007
Location: Jena
Junior Member
This was my last question in this forum!

The further enquiries and particularly the answers/remarks from Michel Cadot testify to low level of Oracle knowledge and poor respect of others problems respectively!

There are much better forums with qualified discussions.

Bye, bye
Re: Warning: No logon on database at all with logon trigger - bug? (merged) [message #393825 is a reply to message #393820] Tue, 24 March 2009 09:16 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nice to see you come back just to say this to us.
Thanks.

Michel
Previous Topic: Downgrade from Enterprise to Standard Edition
Next Topic: Finding information about updated tables
Goto Forum:
  


Current Time: Sat Dec 10 03:32:55 CST 2016

Total time taken to generate the page: 0.12110 seconds