Insufficient privileges in 10g after conn / as sysdba!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Insufficient privileges in 10g after conn / as sysdba!

  1. #1
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Insufficient privileges in 10g after conn / as sysdba!

    SQL> conn / as sysdba
    Connected.
    SQL> exec dbms_stats.gather_fixed_objects_stats('ALL');
    BEGIN dbms_stats.gather_fixed_objects_stats('ALL'); END;

    *
    ERROR at line 1:
    ORA-20000: Insufficient privileges to analyze an object in Fixed Ob
    ORA-06512: at "SYS.DBMS_STATS", line 11802
    ORA-06512: at "SYS.DBMS_STATS", line 12085
    ORA-06512: at "SYS.DBMS_STATS", line 12599
    ORA-06512: at line 1

    SQL> select * from v$version;

    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bi
    PL/SQL Release 10.1.0.2.0 - Production
    CORE 10.1.0.2.0 Production
    TNS for Solaris: Version 10.1.0.2.0 - Production
    NLSRTL Version 10.1.0.2.0 - Production

    What do you suggest??
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Insufficient privileges in 10g after conn / as sysdba!

    Originally posted by julian
    What do you suggest??
    First lets understand why its needed? ( fixed table and stats ? ).. --- probably new in 10g.. but why
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Re: Insufficient privileges in 10g after conn / as sysdba!

    Originally posted by abhaysk
    First lets understand why its needed? ( fixed table and stats ? ).. --- probably new in 10g.. but why
    OK, in 10g Oracle recoomends to analyze them but only once (unless the workload footprint changes).

    So how about the problem: I have never run into Insufficient privileges error after logging as sysdba :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116

    Talking

    wild guess, it is because fixed object cannot be analyzed.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    zainalj :

    GATHER_FIXED_OBJECTS_STATS Procedure
    This procedure gathers statistics for all fixed objects (dynamic performance tables).

    ( Why do u think then oracle have given this package )?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Re: Re: Insufficient privileges in 10g after conn / as sysdba!

    Originally posted by julian
    I have never run into Insufficient privileges error after logging as sysdba :-)
    Jus check if "Analyze Any Dictionary" Privilage is available to SYS.. Probabaly even for SYS its not default and may have to grant urself with that :-)

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Re: Re: Re: Insufficient privileges in 10g after conn / as sysdba!

    Originally posted by abhaysk
    Jus check if "Analyze Any Dictionary" Privilage is available to SYS.. Probabaly even for SYS its not default and may have to grant urself with that :-)

    Abhay.
    Nope :-))

    SQL> grant Analyze Any Dictionary to sys;

    Grant succeeded.

    SQL> exec dbms_stats.gather_fixed_objects_stats('ALL');
    BEGIN dbms_stats.gather_fixed_objects_stats('ALL'); END;

    *
    ERROR at line 1:
    ORA-20000: Insufficient privileges to analyze an object in Fixed Ob
    ORA-06512: at "SYS.DBMS_STATS", line 11802
    ORA-06512: at "SYS.DBMS_STATS", line 12085
    ORA-06512: at "SYS.DBMS_STATS", line 12599
    ORA-06512: at line 1
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Re: Re: Insufficient privileges in 10g after conn / as sysdba!

    Originally posted by julian
    OK, in 10g Oracle recoomends to analyze them but only once (unless the workload footprint changes)
    Guess u r too optimistic abt CBO.. BTW, where does/ did oracle recomend to have stats on SYS/Fixed Tables? ( Link? )
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  9. #9
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    Originally posted by abhaysk
    zainalj :

    GATHER_FIXED_OBJECTS_STATS Procedure
    This procedure gathers statistics for all fixed objects (dynamic performance tables).

    ( Why do u think then oracle have given this package )?
    i think oracle 10g having a bulk of bug.

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by zainalj
    i think oracle 10g having a bulk of bug.
    Could be, I opened an iTar with metalink. I was told to grant ANALYZE ANY DICTIONARY to me (i.e. SYS) :-) Of course, it did not help...
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

Posting Permissions

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



Click Here to Expand Forum to Full Width