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' ....
  • When I boot up it hangs on the login screen for awhile, why? Update:10-11

    I have a mid 2011 Macbook Air 13".  It came with Lion but I recently updated to Mountain Lion.  When I wake the laptop from sleep everything is fine.  If it's been awhile since it slept (a couple of hours), the login screen hangs.  What happens is th