Current Position:Home > It hangs when I login DB

It hangs when I login DB

Update:10-11Source: network consolidation
Advertisement
It has no response when I try to login database. I cancel the login since I don't have any choices
SQL> connect apps/apps
^CERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
But it is ok if I login as dba role like"/ as sysdba"
Please advice,
Amy

The Best Answer

Advertisement
When did it last work for application users?
What changed?
Identify the faulty trigger & either fix or DROP it.
SQL> desc dba_objects
Name                            Null?    Type
OWNER                                  VARCHAR2(30)
OBJECT_NAME                             VARCHAR2(128)
SUBOBJECT_NAME                         VARCHAR2(30)
OBJECT_ID                             NUMBER
DATA_OBJECT_ID                         NUMBER
OBJECT_TYPE                             VARCHAR2(19)
CREATED                             DATE
LAST_DDL_TIME                             DATE
TIMESTAMP                             VARCHAR2(19)
STATUS                              VARCHAR2(7)
TEMPORARY                             VARCHAR2(1)
GENERATED                             VARCHAR2(1)
SECONDARY                             VARCHAR2(1)SELECT .... WHERE OBJECT_TYPE = 'TRIGGER' ....