Monday, 23 January 2017

Login Page Issue 500 Internal Server Error

ERROR:

I found that error in application log and Database alert log when hitting the login URL.

Error in executing triggers on connect internal
*** 2017-01-21 18:37:11.364
----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 5


Solutions:

column TRIGGER_BODY format a1000
set pagesize 1000
spool trg.txt

SQL>select OWNER, TRIGGER_NAME,
TRIGGER_TYPE, TRIGGERING_EVENT, STATUS, TRIGGER_BODY
from DBA_TRIGGERS
where trim(triggering_event) = 'LOGON';

Status: Enabled


SQL>alter trigger LOGON_AUDIT_TRIGGER disable;


After disable the trigger Login page is opening.


OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...