Re: Installing Designer with PO07

On Mon, 9 Feb 1998 20:29:29 +0100, "Sven Dummert" <sd-news_at_macbish.franken.de> wrote:

>Has anybody a detail descripton on how to install a Repository for Designer?
>
>I've already installed Personal Oracle 7 and Designer 2.0.
>
>But if i want to connect to Designer it says: No application System
>available. Contact your System Admin.
>

Hi Sven,

if you have 1.3, you should be able to find step-by-step instructions in Des2K Online help. On 1.3.2, they took it out, so here's a short description of what to do (assume your ORA_HOME is C:\ORANT, SID is ORCL, as it will be if you have installed the starter database). In any case, if you have data in your DB you wouldn't like to loose in case anything goes wrong, do a DB backup first !

0. Modify init.ora parameters:

    set shared_pool to at least 25 MB, db_block_buffers to 6-10 MB,     global_names=false, open_cursors to 512, processes to 100,     dml_locks to 200 or greater. Shutdown and startup DB. 1. Login as user sys and create two tablespaces,

    say DES_DATA with around 80 MB, and DES_IND with 50-60 MB.     This will give you plenty of space, should be sufficient     for a while:
    CREATE TABLESPACE des_data
    DATAFILE 'C:\ORANT\DATABASE\DES1ORCL.DBF' SIZE 80 M     ONLINE;
    CREATE TABLESPACE des_ind
    DATAFILE 'C:\ORANT\DATABASE\DESIND1ORCL.DBF' SIZE 50 M     ONLINE;
2. Resize your SYSTEM tablespace. If it still is as it was by

    starter database, do:
    ALTER DATABASE DATAFILE 'C:\ORANT\DATABASE\SYS1ORCL.ORA'     RESIZE 100 M;
3. Execute the script CKROROLE.SQL which will create a role

    DES2000_OWNER. It is in C:\REPADM10\UTL. 4. Create a user who will own the repository, let's say we name

    him CASE:
    CREATE USER case
    IDENTIFIED BY manager
    DEFAULT TABLESPACE des_data
    TEMPORARY TABLESPACE des_data; /* better temp tablespace */     GRANT connect, resource, des2000_owner to case;     GRANT EXECUTE ON sys.dbms_lock TO case;     GRANT EXECUTE ON sys.dbms_pipe TO case; 4a. Create an end user to work with the repository:

    CREATE USER sven IDENTIFIED BY sven
    DEFAULT TABLESPACE des_data
    TEMPORAY TABLESPACE des_data; /* see above */     GRANT connect, resource TO sven;
5. Create a directory des2_rep_inst and assign it as working

    directory to your Designer 2000 icon. It will contain the     installation log files later.
6. Startup Designer 2000, login as user case, on dialog 'Choose App

    System', press cancel button.
7. In main menu, start Repository Admin Utility. 8. In Admin Utility, do pre-check and make sure all privileges

    are ok, default and temp tablespace is ok and all RAU     parameters are set.
9. Now you can choose 'Install repository'. Depending on your

    hardware this may take 1-4 hours. Choose des_data for data     tablespace and des_ind for index tablespace. 10. If Installation is through, choose cancel in the 'Start install

    dialog' (weird, but that's how it works!). 11. Goto 'Maintain Users', add user sven/write/manager and do a

    save and then reconcile.
12. Exit Admin tool, startup Repository object navigator.

    Create an application system; goto tools->Grant access and grant     whatever kind of rights you like to user sven. 13. Now try file->change connection. You should be able to login as

    user sven and work with your application system.

Phhh, that's it :) Don't know, if i've got everything correct from top of my head, but this should get you up and working.

BTW, I forgot 14.: Get yourself a copy of the manuals or ask your system administrator :))

HTH
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net