Oracle Designer Install Repository

cd C:\prog\DevSuiteHome_1\repadm61\admin
sqlplus /nolog
 
SQL> @ ckqa
 
-- (Optional) If you want to make any changes to the parameter values, edit the file CKPARAMS.TXT, then save and close it. 
SQL> @ ckparams.txt
 
-- Validate the changes by entering the following: 
SQL> @ ckvalqa
 
SQL> @ ckcreate
SQL> exit

* If both Oracle db and dev suite are installed on the same machine, make sure
– ‘ORACLE_HOME’ is set to dev suite home (e.g. C:\prog\DevSuiteHome_1).
– Dev suite ‘tnsnames.ora’ has an entry to repository db (e.g. orcl).
– Env var ‘PATH’ contains dev suite home only.
* Start ‘Repository Administration Utility’
* Login as ‘REPOS_MANAGER/MANAGER@orcl’.

* Click ‘Check Requirements’ button. Make sure all privileges are granted.
* Click ‘Install’ button.
– Check ‘Support for Oracle Designer Objects’.
– click ‘OK’ button.
– Click ‘Yes’ to use public synonyms.
– Select appropriate index and data tablespaces.
– Select repository size (e.g. Medium).
– Click ‘Start’ button.
* When done, click ‘Cancel’ to exit Admin Utility.

* Oracle Designer Repository Installation Guide (comes with Dev Suite install)
* Guide to Oracle Designer: A Student Manual