Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    20

    Unanswered: Snapshot refresh Problem (Urgent)

    Hi All,

    I have a snap shot which is auto refreshed on the last day of each month.The refresh is a complete refresh .The master table (i.e the source table) resides in anather database and we use a dblink to transfer data .This month end the resfresh process failed and the error found in the alert log is as follows...


    Tue Mar 2 09:06:52 2004
    Errors in file /nad/u01/app/oracle/admin/nadlive/bdump/nadlive_j000_19725.trc:
    ORA-12012: error on auto execute of job 9
    ORA-12008: error in materialized view refresh path
    ORA-04052: error occurred when looking up remote object SEAM.V_NAD_EXCHANGE_POSTCODE@SEAM.ODM
    ORA-00604: error occurred at recursive SQL level 3
    ORA-02085: database link SEAM.ODM connects to SEAM
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
    ORA-06512: at "SYS.DBMS_IREFRESH", line 683
    ORA-06512: at "SYS.DBMS_REFRESH", line 195
    ORA-06512: at line 1

    Can any body help me out with this problem ?
    Thanks in advance
    Regards
    Satya

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Can you communicate to the master site ???
    Is the snapshot log available on the master site ???

    Gregg

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    It almost looks like a global_name problem ... Has the global_name changed or global_name = true in initxxx.ora ???

    Obviously not as urgent a problem as once thought ...

  4. #4
    Join Date
    Jan 2004
    Posts
    20
    Hi Greg,
    Sorry for responding late. You were right it was a global_names problem.The production Dba had changed this parameter to "false" dynamically when the code went into production but he forgot to change it in init.ora file where it was "true". I checked the server uptime which suggested that it was bounced in the last few days so all the dynamic change was lost with the database picking up the physical value out of the init.ora.This resulted in the failure of the Snapshot refresh process .

    Thanks a lot..
    Regards
    Satya

  5. #5
    Join Date
    Jan 2004
    Posts
    20
    Hi Gregg,
    One more thing , if we change the global_names to "false" now in our local database will it affect other dblinks connecting to our database?
    Regards
    Satya

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    It could affect other links ... yes

    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •