4 Replies Latest reply: Dec 30, 2012 8:39 AM by stefan nebesnak RSS

    ORA-00604: error occurred at recursive SQL level 1

    927253
      I have exexuted a SQL script & recevie below error,please advise why this occure triggers executed succesfully

      Table created.

      SQL> @C:\create_table_interface_ora.sql

      Table created.

      CREATE OR REPLACE PUBLIC SYNONYM interface_ora FOR hrc.interface_ora
      *
      ERROR at line 1:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-20101: error occurred when creating the public synonym INTERFACE_ORA
      ORA-06512: at line 60



      Grant succeeded.


      Grant succeeded.
        • 1. Re: ORA-00604: error occurred at recursive SQL level 1
          ranit B
          ERROR at line 1:
          ORA-00604: error occurred at recursive SQL level 1
          ORA-20101: error occurred when creating the public synonym INTERFACE_ORA
          ORA-06512: at line 60
          This error is caused due to a system level issue and most probably_ not due to any SQL statement.

          I face this every time when our database systems are locked for sync-up and cleaning purposes, and all access (including Read) are revoked.
          • 2. Re: ORA-00604: error occurred at recursive SQL level 1
            927253
            That means if user locks existing it may be the issue
            • 3. Re: ORA-00604: error occurred at recursive SQL level 1
              ranit B
              924250 wrote:
              That means if user locks existing it may be the issue
              Yes. Might be_ , for me it was the cause. But, it was informed prior that databases will be down.

              I'm not a DBA, so will not be able to guide you on this. But guess there's something callled as Hot Backup and Cold Backup done on databases.

              Refer - <b>Hot and Cold Backups - Oracle</b>
              • 4. Re: ORA-00604: error occurred at recursive SQL level 1
                stefan nebesnak
                924250 wrote:
                I have exexuted a SQL script & recevie below error,please advise why this occure triggers executed succesfully

                Table created.

                SQL> @C:\create_table_interface_ora.sql

                Table created.

                CREATE OR REPLACE PUBLIC SYNONYM interface_ora FOR hrc.interface_ora
                *
                ERROR at line 1:
                ORA-00604: error occurred at recursive SQL level 1
                ORA-20101: error occurred when creating the public synonym INTERFACE_ORA
                ORA-06512: at line 60
                When you execute a create statement, Oracle does some recursive SQL statements to update the data dictionary.

                When executing one of these recursive statements, a problem was encountered and the general error message ORA-00604 was returned followed by the actual error message ORA-20101 that should be corrected.

                Check trace files and alert.log file.