Install Oracle Designer

Introduction:

This is not strictly a compulsory installation for OWB. However, many clients insist on this as the source of their corporate data dictionary. It also integrates with OWB so it can't hurt.

IMHFO, Designer is not a great piece of software. I find it difficult to use, it often won't let you do something - usually for a very good reason - but won't always tell you why, and it is not very clear as to what you can do in its various components. Still, we are stuck with it and, if I used it a bit more, I would probably figure it out.

Oracle Designer comes as part of the Oracle Developer Suite.

Be warned - this installation sucks!

Aim:

Install and configure Oracle Designer.

Requirements:

An Oracle instance is needed to house the repository. Like most of the other repositories I have on my training system, this one is going into whs.

Procedure:

• Log on to the PC.
• Get the software:
• Go here (OTN - link through here to register), promise that you are not a terrorist, and download the following self-extracting zip files:
• OracleDeveloperSuite10g90401_Disk1.exe
• OracleDeveloperSuite10g90401_Disk2.exe
  
• Install the software:
• Double-click each file name.
  
• Select a folder to extract files to: Pick a folder - probably the same one you downloaded the files to.
• [Next]
• Extraction Complete.
• [Finish]
• This creates normal directories called; Disk1 & Disk2. Burn the entire contents of each directory on to CD.
• Put the CD 'Disk1' in the drive. An auto-run window opens:
• -Install-
• OUI starts:
• Welcome:
• [Next]
• Specify File Locations:
• Name: OraDES10g
  
• Path: C:\oracle\product\9.0.4.6\OraDES10g
• [Next]
• Select a Product to Install:
• Complete
• [Next]
• Provide Outgoing Mail Server Information:
• lisa.steveroach.org
• [Next]
  
• Summary:
• [Install]
• Disk Location:
• Insert Disk2
• [OK]
• End of Installation:
• [Exit]
• Exit:
• [Yes]
• Configure Oracle Network:
• -Start-
• -All Programs-
• -Oracle Developer Suite - OraDES10g-
• -Configuration and Migration Tools-
• -Net Configuration Assistant-
• Net Configuration Assistant:
• Welcome:
• Listener Configuration:
• [Next]
• Listener:
• Add
• [Next]
• Listener Name:
• Listener Name: LISTENER
• [Next]
• Select Protocols:
• Ensure -TCP- is in the 'Selected Protocols' list.
• [Next]
• TCP/IP Protocol:
• Use the standard port number of 1521
• [Next]
• More Listeners?
• No
• [Next]
• Welcome:
• Naming Methods configuration:
• [Next]
• Select Naming Methods:
• Ensure the following are on the 'Selected Naming Methods' list in this order:
• -Local-
• -Directory-
• -Oracle Names-
• -Host Name-
• [Next]
• Host Name:
• [Next]
• Naming Methods Configuration done:
• [Next]
• Welcome:
• Local Net Service Name configuration:
• [Next]
• Net Service Name Configuration, Database Version:
• Oracle8i or later database or service
• [Next]
• Net Service Name Configuration, Service Name:
• Service Name: sta
• [Next]
• Net Service Name Configuration, Select Protocols:
• -TCP-
• [Next]
• Net Service Name Configuration, TCP/IP Protocol:
• Host Name: lisa
• Use the standard port number of 1521
• [Next]
• Net Service Name Configuration, Test
• Yes, perform a test
• [Next]
• Net Service Name Configuration, Connecting:
• Details: Connecting...ORA-28000...
  
• -Change Login-
• Username: system
• Password: *********
• [OK]
• Details: Connecting...Test successful
• [Next]
• Net Service Name Configuration, Net Service Name:
• Net Service Name: sta.steveroach.org
• [Next]
• Net Service Name Configuration, Another Net Service...:
• Yes
• [Next]
• Net Service Name Configuration, Database Version:
• Oracle8i or later database or service
• [Next]
• Net Service Name Configuration, Service Name:
• Service Name: whs
  
• [Next]
• Net Service Name Configuration, Select Protocols:
• -TCP-
• [Next]
• Net Service Name Configuration, TCP/IP Protocol:
• Host Name: lisa
• Use the standard port number of 1521
• [Next]
• Net Service Name Configuration, Test
• Yes, perform a test
• [Next]
• Net Service Name Configuration, Connecting:
• Details: Connecting...ORA-28000... (Only if the system password for sta and whs are different.)
  
• -Change Login-
• Username: system
• Password: *********
• [OK]
• Details: Connecting...Test successful
• [Next]
• Net Service Name Configuration, Net Service Name:
• Net Service Name: whs.steveroach.org
  
• [Next]
• Net Service Name Configuration, Another Net Service...:
• No
  
• [Next]
• Install the Designer Repository Objects:
• -Start-
• -Run...-
• Open: cmd
• DOS Window:
• > cd C:\oracle\product\9.0.4.6\OraDES10g\repadm61\ADMIN
• > sqlplus system@whs
• Enter password: *********
• SQL> connect sys@whs as sysdba
• Enter password: *********
• SQL> @ckqa
• Enter TNS: whs
• Enter password: ********* (the sys password)
• Enter S/M/L: s
• Enter datafile: /u01/app/oracle/oradata/whs/constant_grow_indexes.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/constant_grow_tables.dbf
  
• Enter datafile: /u01/app/oracle/oradata/whs/dependency_indexes.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/dependency_tables.dbf
  
• Enter datafile: /u01/app/oracle/oradata/whs/diagram_indexes.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/diagram_tables.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/lob_data.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/rapid_grow_indexes.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/rapid_grow_tables.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/system_meta_indexes.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/system_meta_tables.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/temporary_indexes.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/temporary_tables.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/version_indexes.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/version_tables.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/repos_rbs.dbf
• Enter datafile: /u01/app/oracle/oradata/whs/repos_temp.dbf
• Enter Choice (Y/N) : y
• Hit enter to Continue with validation process .... [Enter]
• Check the parameters:
• SQL> @ckparams.txt
• Validate the changes:
• SQL> @ckvalqa
• Apply the changes:
• SQL> @ckcreate
• Check the changes:
• SQL> @ckreport
• Exit SQL*PLUS:
• SQL> exit
• Change the Repository Manager's password:
• Open the OEM Console.
• -Databases-
• -WHS-
• -Security-
• -Users-
• Highlight REPOS_MANAGER
• General tab:
• Enter Password: *********
• Confirm Password: *********
• [Apply]
  
• Configure Repository:
• -Start-
• -All Programs-
• -Oracle Developer Suite - OraDes10g-
• -Software Configuration Manager-
• -Repository Administration Utility-
• Connect:
• Username: repos_manager
• Password: *********
• Connect String: whs
• Check Requirements:
• -Check Requirements-
• Check Requirements Utility:
• Expand all elements.
• Check that the following elements have these values:
• HELP72_RAU:
• C:\oracle\product\9.0.4.6\OraDES10g\cdoc72\HELP\CKRAU65.HLP
• EXECUTE_OBJSTAT:
• C:\oracle\product\9.0.4.6\OraDES10g\BIN\CKOS61.EXE
• EXECUTE_REPOSPARAM:
• C:\oracle\product\9.0.4.6\OraDES10g\BIN\CKCR61.EXE
• LOG_DIRECTORY_RAU:
• C:\oracle\product\9.0.4.6\OraDES10g\repadm61\LOGS
• REPADM61:
• C:\oracle\product\9.0.4.6\OraDES10g\repadm61
• EXECUTE_EXPORT:
• C:\oracle\product\9.0.4.6\OraDES10g\BIN\EXP.EXE
• EXECUTE_IMPORT:
• C:\oracle\product\9.0.4.6\OraDES10g\BIN\IMP.EXE
• EXECUTE_PLUS_RAU:
• C:\oracle\product\9.0.4.6\OraDES10g\BIN\SQLPLUS.EXE
• Working Direcory:
• C:\Program Files\Common Files\System\MAPI\1033
• Privileges granted for public access:
• CREATE PUBLIC SYNONYM
• DROP PUBLIC SYNONYM
• Required system privileges:
• ALTER SESSION
• CREATE ANY SYNONYM (Must be granted directly)
• CREATE DATABASE LINK
• CREATE PROCEDURE
• CREATE ROLE
• CREATE SEQUENCE
• CREATE SESSION
• CREATE TABLE
• CREATE TRIGGER
• CREATE TYPE
• CREATE VIEW
• DROP ANY SYNONYM (Must be granted directly)
• Roles granted to user:
• CK_ORACLE_REPOS_OWNER
• CONNECT
• RESOURCE
• Close the Check Requirements Utility.
• Build the Repository:
• -Install-
• Repository Installation Options:
• [OK]
• ckrau61:
• [Yes]
• Install a Repository Instance:
• System Meta-Data:
• Index: SYSTEM_META_INDEXES
  
• Table:SYSTEM_META_TABLES
• Temporary Data:
• Index: TEMPORARY_INDEXES
  
• Table: TEMPORARY_TABLES
• Constant Growth Instance Data:
• Index: CONSTANT_GROWTH_INDEXES
  
• Table: CONSTANT_GROWTH_TABLES
• Rapid Growth Instance:
• Indexes: RAPID_GROWTH_INDEXES
  
• Tables: RAPID_GROWTH_TABLES
• LOB Data:
• Tables: LOB_DATA
• Version Data:
• Indexes: VERSION_INDEXES
  
• Tables:VERSION_TABLES
• Dependency Data:
• Indexes: DEPENDENCY_INDEXES
  
• Tables: DEPENDENCY_TABLES
• Diagram Data:
• Indexes: DIAGRAM_INDEXES
• Tables: DIAGRAM_TABLES
• Repository Size:
• Small
• -Start-
• Warning:
• [Yes]
• This takes a while to run.
  
• Operation Complete:
• [OK]
• -Cancel-
• Create a Designer user:
• Start OEM
• -Databases-
• -WHS-
• -Security-
• Right-click; Users
• -Create-
• Create User:
• General tab:
  
• Name: des
• Enter Password: *********
  
• Confirm Password: *********
• Temporary: -TEMP-
• Role tab - ensure the following roles are assigned:
• CONNECT
• RESOURCE
• SELECT_CATALOG_ROLE
• System tab - ensure the following privileges are assigned:
• ALTER SESSION
• CREATE PROCEDURE
• CREATE SEQUENCE
• CREATE SESSION
• CREATE SYNONYM
• CREATE TABLE
• CREATE VIEW
• UNLIMITED TABLESPACE
• Object tab:
• Expand; SYS
• Expand; Views
• -DBA_ROLLBACK_SEGS- -SELECT-
• -DBA_SEGMENTS- -SELECT-
• [Create]
• User Created Successfully:
• [OK]
• Add user to Designer:
• Repository Administration Utility:
• -Maintain Users-
• User Maintenance:
• -Users-
• Click the '+' button.
• Repository User Properties:
• Oracle User Name: -DES-
• [OK]
• Lift limits on some tablespaces:
• In OEM -whs:
• -Storage-
• -Tablespaces-
• -REPOS_TEMP-
• -Datafiles-
• -/u01/app/oracle/oradata/whs/repos_temp.dbf-
• [Storage] tab
• Automatically extend datafle when full (AUTOEXTEND)
• Increment: 15376
• Maximum size: Unlimited
• [Apply]
  

Testing:

• -Start-
• -All Programs-
• -Oracle Developer Suite - OraDES10g-
• -Designer-
• Might be worth creating a shortcut for the next item...
• -Oracle Designer-
• Connect:
• Username: des
• Password: *********
• Connect String: whs
• [OK]
• Check that you can open a few facilities (e.g. Repository Object Navigator & Design Editor).

Conclusion:

...and breathe!

That installation sucked so much that, were it a bikies girlfriend, it could suck-start a Harley.

There HAS to be a better way of getting this software up and running - I'm pretty sure that a lot of it could be scripted. C'mon Oracle.

'course, I haven't paid a licence fee for this so I'm hardly in a position to bitch. Oh well.