Preparation (NT) (95/98)|
Generating a Designer 2000 Repository
Step 1: Log on to Oracle
Step 2: Installation Setup and Pre-Check
Hit the install button. A dialog will pop up asking what tablespaces are to be used in creating the repository (Figure 2.3). The ones on the left are for the indexes, so use the index tablespace (des2_i in the example) for all of the index tablespaces. Make sure the table tablespace(des2 in the example) is selected for each of the ones on the right. If you are the only one using this repository, go with a small size repository, you will see better performance. Hit the 'pre-check' button to make sure all required privileges are met (Figure 2.4). If they are, hit 'OK' and you are ready for installation.
Step 3: Begin the Installation
'Start' will get the process going. What follows is about 2-3 hours (depending on processor) of automated scripting in which you do not need to be in front of your computer (Figure 2.5). (A common error ocurrs here in which the SGA has not been adequately expanded to handle the repository installation. See ORA-04031 - Unable to allocate bytes of shared memory if you receive this error.) WARNING: Do not e xecute any SQL statements during this process... doing so may cause irreparable damage to the repository (Figure 2.6). Wait until the repository generation is complete before moving on to the next step (Figure 2.7).
Step 4: Creating the Manager and User Accounts
Do not use the owner account to access Designer 2000 as a user. At a minimum, create 2 accounts (a manager and a user) for the application systems we will be creating. These users will need tablespace for both permanent tables as well as temporary worki ng tables. Look back at our tablespace listing:
select tablespace_name, sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;notice the tablespace USER_DATA. You could use this as the default tablespace for the manager and user account, but creating a new tablespace for these accounts will provide more flexibility should you need it. Just like you created the des2 and des2_i tablespaces, create one for use as the default user space for the accounts. For example:
create tablespace des2_users datafile 'd:\orant\database\des2users.ora' size 50M default storage (initial 100k next 100k pctincrease 5);will create a 50MB tablespace, plenty of room for tables (Figure 2.8). Similar to the owner account, the statements:
create user rep_manager identified by demo default tablespace des2_users temporary tablespace temporary_data;and
create user rep_user identified by demo default tablespace des2_users temporary tablespace temporary_data;will create the repository manager and user accounts. One important note before granting privileges to the user accounts... when you created the owner account, you issued a grant resource statement on that account. This created an unlimited quota for the user on the default tablespace (des2). Should you want the manager and user accounts to have unlimited quota on their respective default tablespace, go ahead and issue the statements (Figure 2.9):
grant resource to rep_manager;Should you want to put quotas on these user accounts (for instance, if you have multiple user accounts), issue the statement (Figure 2.10):
alter user [account] quota [limit]M on [default tablespace];So for the example, the statements:
alter user rep_user quota 10M on des2_users;and
alter user rep_manager quota 10M on des2_users;would create 10MB quotas on the des2_users tablespace for both accounts.
Step 5: Setting Manager and User Account Privileges
Each account needs 5 privileges to work in Designer 2000, create session, alter session, create table, create synonym, and create sequence. For example:
grant create session, alter session, create table, create synonym, create sequence to rep_manager;and
grant create session, alter session, create table, create synonym, create sequence to rep_user;will grant all required privileges to the accounts (Figure 2.11).
NEXT: Using the Designer 2000 Repository