Re: PO7 (beta95) & Designer 2000

From: W. van der Deijl <W.van.der.Deijl_at_inter.nl.net>
Date: 1995/12/01
Message-ID: <DIw98E.Gw0_at_inter.NL.net>#1/1

<.,_at_compuserve.com> wrote:

>What should I do to install Designer on a W'95 system with the beta version of po75?  

>Which scripts should I run, in which order, I just need a list what to do.
>When do I create a owner, run catproc, run which script logged in as internal, etc,etc
>where do I grant which user for, etc, etc

I got Des/2000 running on Personal Oracle for Win95. Because lots of requests how it is done, I've written down the steps I followed. Here they are: (If yuo have any more questions feel free to ask)

BTW Do you have any specific reason not to include your e-mail address. This way people cannot reply to you directly (perhaps a mis-configuration of your newsreader).

###################

### BEGIN PASTE ###

###################

* start Personal Oracle

• start SQL*DBA (\orawin\bin\sqldba72.exe)
• connect sys/change_on_install
• enable procedural option: _at_\orawin\rdbms72\admin\catproc.sql (appr. 15 minutes)
• create some new tablespaces and enlarge existing SYSTEM-tablespace: create tablespace des2 datafile 'c:\orawin\database\des2.ora' size 16M; create tablespace des2_I datafile 'c:\orawin\database\des2_I.ora' size 13M; alter tablespace SYSTEM add datafile 'c:\orawin\database\sys2orcl.ora' size 60M;
• close SQL*DBA (exit)
• start SQL*Plus (\orawin\bin\sqlplus32.exe)
• connect sys/change_on_install;
• create user "DES2000" (he'll be the repository owner) create user des2000 identified by des2000 default tablespace des2 temporary tablespace des2;
• create the role "DES2000_OWNER" using the following script: _at_\orawin\repadm10\utl\ckrorole.sql
• grant some rights to DES2000: grant connect,resource,DES2000_OWNER to DES2000;
• grant execute-rights on two packages to DES2000: grant execute on sys.dbms_pipe to DES2000; grant execute on sys.dbms_lock to DES2000;
• close SQL*Plus (exit)
• shutdown the database
• edit two lines in \orawin\database\initorcl.ora: shared_pool_size = 18000000 db_block_buffers = 1000
• add two lines to \orawin\database\initorcl.ora: global_names = false open_cursors = 200
• processes should be 20 for Designer, but is already at 50 so don't change
• restart the database
• start Designer/2000 Repository Administration Utility
• connect as DES2000 (password=DES2000)
• select DES2_I as index tablespace
• select DES2 as table tablespace
• press the "Execute"-button
• some tables will be imported. When this is done (appr. 1 minute) the button "Close" in the "IMPORT STATUS"-window will become black meaning it's available. If you're satisfied with the import press Close.
• some SQL-scripts will be executed.
• some other tables will be imported. This import will take a bit longer (appr. 10-15 minutes). The first table to be imported contains about 25000 rows and may take a few minutes. So nothing is wrong when no output is written to the "IMPORT STATUS" window. As soon as the Close button is available: press it.
• Now some more SQL-scripts will be executed. These took about two hours, so get a cup of coffee (or two, or three...)
• when everything is finished, you could take a loot at the logfiles: \orawin\bin\*.lis and \orawin\bin\*.log
• you might want to add a user to the repository on the maintain user tab.
• you can close the repository administration utility as you work is done!

If you encounter any problems, you can contact me directly (W.van.der.Deijl_at_inter.nl.net) as Oracle Support won't support the combination of Personal Oracle and Designer/2000....

#################

### END PASTE ###

#################

Bye,
Wilfred
The Netherlands Received on Fri Dec 01 1995 - 00:00:00 CET