13 Replies Latest reply on Jun 8, 2012 9:43 AM by pvenpven

    Listener: ORA-00604 ORA-01219

      We have a database on

      Sometimes we are able to login, sometimes we get the error below (this is from the client, on the server it works):

      SQL> conn dba@tst
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01219: database not open: queries allowed on fixed tables/views only

      When I restart the listener, we are able to login for a few seconds but the error shown above will return very fast. So it looks like a problem with the listener, hereby the listener-entry:

      (SID_DESC =
      (GLOBAL_DBNAME = TST.world)
      (SID_NAME = TST)
      (ORACLE_HOME = /data/app/oracle/server/
      (PRESPAWN_MAX = 10)

      Anyone an idea what causes this is?