unable to create Repositary in Designer 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: unable to create Repositary in Designer 9i

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    unable to create Repositary in Designer 9i

    hello all

    i downloaded Oracle 9i DEveloper Suite, and installed it. When i try to open Designer, it asks to enter a userid , pwd, and conect string.

    i did create one user 'rbc' on DB 'heat'. so when i enter the stuff, it says, " This user doesnot have an installed repositary. invoke the repositary administrator utility".

    I then, opened the REpositary Administrator utility, and key in the same info like userid ..etc, it gets in.
    Then i click on Install in Install/upgrade/migrate section, it asks me to select Repositary installation options, where only one option is highlighted which is " support for Oracle designer objects". when i select that, and go to next screen, it asks if u want to create any public synonyms, and i said yes, it next gives me a screen to pick the table space.

    here it blows up !!!. it says "ERROR you donot have select privileges on v_$parameter View. This process cannot proceed "


    Can anyone help in creating a repositary for Designer !!!

    Thanks
    Ron

  2. #2
    Join Date
    Jul 2003
    Location
    Sofia, Bulgaria
    Posts
    91
    Log on in the database where the ropository will be as SYS. Then
    GRANT SELECT ON V$PARAMETER TO RBC;
    after that the repository manager will want a select privilege on another view(cant remember its name now), and after you grant select on it too, you will not have problem instaling the repository

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