DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora-01925 error

  1. #1
    Join Date
    Feb 2001
    Location
    Chennai
    Posts
    17
    Hi DBAs

    I am having the above mentioned error when I am connecting as SYS. this is bcos I run a script that gave lot of rules to sys instead of that user.

    Is it possible to drop SYS and recreate SYS running some scripts

    Help me out and thanks in advance
    Siva Kumar N.V
    PeopleSoft Architect

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    no it si not possible to drop user sys as he owns the data dictonary tables.post your error message and not just the eerrir number

  3. #3
    Join Date
    Feb 2001
    Location
    Chennai
    Posts
    17
    hi

    The actual error is I am exceeding the roles

    THe err no ora-01925 tells maximum of 20 enabled roles exceeded.


    So I can't log into sys. How to solve this problem.

    I know that I cannot remove sys but is there any script to overright the user with prev. / Original rights

    Thanks
    Siva Kumar N.V
    PeopleSoft Architect

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    change the ini.ora parameters your problem would be solved

    hth

  5. #5
    Join Date
    Feb 2001
    Location
    Chennai
    Posts
    17

    Thumbs up

    Hi hth

    I solved the problem by setting the init parameter like this.

    Init.ora

    max_enabled_roles = 50

    Shutdown

    Startup

    Connect sys/*******

    done

    Thanks and Oracle Help also states the same

    Siva Kumar N.V
    PeopleSoft Architect

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828

    Smile

    hi there

    there si one small goof you made hth means hope this helps
    my name is hrishy anyway

    hth

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