If you attempt to install the Personal Edition of Oracle Designer and Developer on a Windows 95 or Windows 2000 machine, you will likely have few problems with the installation (assuming that you have a spare 1.5 GB+ for the installation).
Windows 98 Patches:
If you are using Windows 98 and are experiencing difficulties, you may find these files useful. The way this works is that you download the installer file and then use it to install Oracle off of your CD (I believe that your CD includes these patches, but use this if it does not work).
This is information and files for the latest version:
This is an older version, but it is known to work on Windows 98:
For either Windows Environment, do the following:
Next Steps: (note, this takes a lot of time and disk space!)
Now you will need to log in and establish several user definitions. To do this, log into the SQL DBMS (i.e., not designer or developer). The userid is Internal and the password is oracle. Once past the login, you will need to create table spaces and user definition. You can call these whatever you want.
At the SQL prompt, enter the following SQL statement to give you the location of the current tablespace datafiles:
select * from dba_data_files;
Following this, you will need to create tablespaces. The general format is:
create tablespace [name] datafile '[filepath]' size [filesize]M default storage (initial 100k next 100k pctincrease 5);
For example:
create tablespace des2 datafile c:\orant\database\des2data.ora size 100M default storage (initial 100k next 100k pctincrease 5);
In many cases you will want to create a table space for the tables and a second for the table indexes. To create the index, do the following:
create tablespace des2_i datafile c:\orant\database\des2_idata.ora size 100M default storage (initial 100k next 100k pctincrease 5);
The filename, des2 can be anything you want as long as you remember what it is.
You will next need to make sure that the system tablespace is big enough to hold the additional overhead of a Designer repository. Use the following:
select tablespace_name, sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;
if the space is less than 60MB, you will need to add another datafile to the tablespace. The following is the general format:
alter tablespace system add datafile '[filepath]' size [filesize]M;
for example:
alter tablespace system add datafile 'c:\orant\database\sys2orcl.ora' size 100M;
Reissue the earlier statement to make sure the tablespace is at least 60MB. Do the following:
select tablespace_name, sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;
Now we are ready to create the owner (Finally!). The following is the general format:
create user [name] identified by [pwd] default tablespace [table_tablespace] temporary tablespace temporary_data;
In this case, [name] is the userid and [pwd] is the account password. For example:
create user rep_owner identified by demo default tablespace des2 temporary tablespace temporary_data;
This will creare user rep_owner with the password demo
Now you will need to grant privileges to to the owner of the repository. You will need to give the user connect and resource privileges. The following is the general format:
grant [right(s)] to [account];
For example:
grant connect, resource to rep_owner;
You will need to make the owner an official owner by creating a role called DES2000_OWNER. Oracle has a script you can run to do this. Enter the following command:
@ c:\orant\repadm20\utl\ckrorole.sql
Once you have completed this, you will have a few more commands to execute. The following is the general format:
grant execute on dbms_lock to [owner_account];
grant execute on dbms_pipe to [owner_account];
grant create session, alter session, create table, create synonym, create sequence to [owner_account];
grant des2000_owner to [owner_account];
For example, do the following:
grant execute on dbms_lock to rep_owner;
grant execute on dbms_pipe to rep_owner;
grant create session, alter session, create table, create synonym, create sequence to rep_owner;
grant des2000_owner to rep_owner;
Now you can log out of SQL. Type Quit at the prompt.
See Notes below for other potential problems:
Logging in to Designer
You will need to log into the designer tool. Log in using your account and password (e.g., rep_owner).
Once in the designer, you should be able to open the repository administration utility. Once in the RAU, click on install. This will install the repository. You should see the name of the tablespaces you created (e.g., des2 and des2_i). The index file should be on the left and the table file on the right. This may take quite some time, so go have lunch.
Once completed, log out.
Creating a User
Log back into the SQL engine using the userid Internal and the password oracle. Now, create the userid for a user.
create tablespace des2_users datafile c:\orant\database\des2users.ora size 50M default storage (initial 100k next 100k pctincrease 5);
You will also need to create repository manager and user accounts. Do the following:
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;
If you want the user account to have unlimited quota on this system, issue the following commands:
grant resource to rep_manager;
grant resource to rep_user;
If you later want to change the quota for the user, you can use the following command:
alter user [account] quota [limit]M on [default tablespace];
Finally, you will need to set account privileges for the users. There are 5 privilege total. Enter the following commands:
grant create session, alter session, create table, create synonym, create sequence to rep_manager;
grant create session, alter session, create table, create synonym, create sequence to rep_user;
Initializing and Reconciling Accounts in Designer
You will now need to log into Designer to set up the repository for the users you have created. Log into Designer with the rep_owner userid. Enter the Repository Administration Utility (RAU). In this system, choose Maintain Users. First select the manager account and add any information about the full name and description that is needed. Repeat this for the user. Then hit reconcile. If there were a lot of users, this would be a good time to go for a walk. But, if you only have a few users it will not take too long (this takes 3-4 hours for the 110 users in 432). Log out when done.
Create and Application
Now you can create an application. To do so, log into Designer using the manager account. You will be presented with the Application System dialog box. Enter the name for your application and the Create button will become highlighted. After entering the application name, click Create to proceed. You should be taken to the Designer/2000 screen.
You can now use the Repository Object Navigator to manage the application. When in the RON, click on Application and then Grant Access by Application. In the box you will see the manager account information. Note that all of the capabilities are granted. You will want to click on Add User. You can add your user account(s). Select the capabilities they should have for this application and then click the Grant button. Click Close when done.
Additional Notes:
Memory Size for Oracle
You may encounter problems with memory allocation for Oracle. If so, do this before you try to do anything in Designer. To fix memory, open the "initorcl.ora", which should be located in the /database directory, in a text editor (e.g., Notepad). Search for the "shared_pool_size" parameter and change its value to 28MB (i.e., 28000000) (its value is probably currently 6000000). You may also need to verify that the following have the values shown below:
db_block_buffers=5000
global_name=false
open_cursors=400
pnoc=100
log buffers=65536
Date Change for Designer
Someone has reported problems with running the Developer Instal (not Designer) unless the date on the computer is changed to a pre-Y2K date. If you encounter problems with Developer, try rolling the date on your computer back to December '99 to see if you can proceed past the install.