|
|
|
|
|
|
 Re: how to create designer repository in 9i developer suit [message #120773 is a reply to message #118957] |
Mon, 23 May 2005 12:41  |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
This message applies to Oracle 9i - I can't be certain if it is accurate for other versions.
You must install Oracle Developer first
Then, the first step to setting up the repository is to log into the database as the SYS account as SYSDBA
The second step is to set up the account for the new repository owner using SQL*Plus commands. The easiest way to do this is with automated scripts that create a default repository owner called "repos_manager".
The third step is to run the Repository Administration utility, and configure some options for the repository
The fourth step is to run the repository installation (can take a little while)
You are then ready to run Designer, using your repos manager account to log in. Creating a subordinate account for repository use is beyond the scope of my knowledge, so please don't ask. I just use the manager account.
Here is a link to a very useful web document that explains in detail everything i have mentioned above. Pass this link on to other people; it has been very useful for a lot of people I know. I believe this document is supposed to be on the Oracle Developer CD, but it appears to be missing on mine.
http://download-east.oracle.com/otn_hosted_doc/designer/doc_library/des9i_9022/CDOC72/rep_insgde/igrepos_9i.htm
I am using oracle 9i, and I could not use the automatic scripts because of a problem with a dictionary managed REPOS_TEMP table. I created some scripts of my own to make the manual method much easier. Should u want these scripts, please email me privately at sawyeraj@iinet.net.au - keep in mind u will need to adjust them to suit your setup.
hope this helps
cheers
adam
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
