This discussion is archived
1 2 3 Previous Next 38 Replies Latest reply: Dec 6, 2012 4:23 AM by EdStevens Go to original post RSS
  • 15. Re: Unable to access DBA views
    $phinx19 Newbie
    Currently Being Moderated
    Hi osama,
    Nopes the db was created using DBCA
  • 16. Re: Unable to access DBA views
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    you could run catalog.sql and catproc.sql to create database view .
  • 17. Re: Unable to access DBA views
    $phinx19 Newbie
    Currently Being Moderated
    Hi All,

    It seems that some one has deleted sys objects erroneously and because of which i think i am facing this issue. I don't even have any backup of the DB nor can i perform the export backup of the DB. Even Flash back option is not available. I only need the data for two schemas from this DB

    Kindly suggest how to go about this.

    BR
    sphinx
  • 18. Re: Unable to access DBA views
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    It seems that some one has deleted sys objects erroneously and because of which i think i am facing this issue. I don't even have any backup of the DB nor can i perform the export backup of the DB. Even Flash back option is not available. I only need the data for two schemas from this DB
    Someone !!!! any one have access to your database as sysdba !!!!

    Recreate DB View By Running : located in $ORACLE_HOME/rdbms/admin

    catalog.sql catproc.sql
  • 19. Re: Unable to access DBA views
    $phinx19 Newbie
    Currently Being Moderated
    Hi Osama,

    Well it was one of my colleague but let us not get into that now, and the catlog and catproc scripts i have tried but it did not helped the cause.
    Any other suggestion.
    BR
  • 20. Re: Unable to access DBA views
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    $phinx19 wrote:
    Hi Osama,

    Well it was one of my colleague but let us not get into that now, and the catlog and catproc scripts i have tried but it did not helped the cause.
    Any other suggestion.
    BR
    Did you check dba_registery
  • 21. Re: Unable to access DBA views
    $phinx19 Newbie
    Currently Being Moderated
    Hi Osama,

    I have checked the DBA_Registry, not of anyuse.

    Regards,
  • 22. Re: Unable to access DBA views
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    The best approach for you : if you have any type of backup for your database , restore it if you don't Open SR
  • 23. Re: Unable to access DBA views
    Girish Sharma Guru
    Currently Being Moderated
    Is there anything in alert log i.e. ORA-0600 ?
    It seems that there is some corruption in data dictionary. Try to read and understand [url http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/manage/swkbnch/swkbnch.htm]Analyzing Data Dictionary Corruption Using Support Workbench.
    Database seems to be in serious issue, try to take full export/RMAN backup if possible.

    Regards
    Girish Sharma
  • 24. Re: Unable to access DBA views
    $phinx19 Newbie
    Currently Being Moderated
    Hi Girish,

    No ora-600 but i am getting ora-0604 error and the sad part is that oracle is not allowing me take any backup.
    I am faling to undertsand why i am not able to take even export backup? In what way does the corruption of data dictionary affects the working of exp utilty.
    Thanks for the link.

    BR
    Sphinx

    Edited by: $phinx19 on 05-Dec-2012 01:43
  • 25. Re: Unable to access DBA views
    Girish Sharma Guru
    Currently Being Moderated
    Can you post the output of below queries :

    select owner,trigger_name,trigger_type,triggering_event
    from dba_triggers
    where trigger_type like '%EVENT'
    and triggering_event like '%DDL%'
    order by 1,2
    /

    select owner,object_name from dba_objects
    where status='INVALID' and
    owner not in ('SYS','MDSYS')
    /

    select trigger_type,triggering_event
    from dba_triggers
    where owner='OutPut_of_Above_Query'
    and trigger_name='Object_Name Of Above Query'
    /

    someone created an "after servererror" trigger and is committing in it. consider:
    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:4018285967344

    But, you did not told us how you are exporting or backingup the database by RMAN ? We just wish to see copy and paste of your tries please.

    Regards
    Girish Sharma
  • 26. Re: Unable to access DBA views
    EdStevens Guru
    Currently Being Moderated
    $phinx19 wrote:
    Hi Girish,

    No ora-600 but i am getting ora-0604 error and the sad part is that oracle is not allowing me take any backup.
    I am faling to undertsand why i am not able to take even export backup? In what way does the corruption of data dictionary affects the working of exp utilty.
    Ummm, don't you suppose that exp uses the data dictionary to verify input and gather the information it needs to do its job?

    Thanks for the link.

    BR
    Sphinx

    Edited by: $phinx19 on 05-Dec-2012 01:43
  • 27. Re: Unable to access DBA views
    $phinx19 Newbie
    Currently Being Moderated
    Hi Stevens,

    Ok , i was not sure about that. Thanks for the same.

    BR
    Sphinx
  • 28. Re: Unable to access DBA views
    $phinx19 Newbie
    Currently Being Moderated
    Hi Girish,

    I will need sometime to provide you the same. See, now i have no rman backup, no user managed backup and also no export backup of the same. Currently, my data dictionary is corrupted, till now i have done the following things:
    1.Executed catalog and cataproc.
    2.Tried taking the export backup.
    3.Tried takin online backup.

    As an urgent solution my priority is to get the db up and running, Can you suggest me if there is any way to get the DB up and running.

    BR
    Sphinx
  • 29. Re: Unable to access DBA views
    sb92075 Guru
    Currently Being Moderated
    when was last time DB & Data Dictionary worked without error & as expected?
    what changed since then?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points