Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NEW DBA trying to Connect Oracle8i w/ Designer/2000 and Developer/2000

Re: NEW DBA trying to Connect Oracle8i w/ Designer/2000 and Developer/2000

From: Van Messner <vmessnerNOvmSPAM_at_discovernet.com.invalid>
Date: 2000/06/01
Message-ID: <0ebd0a20.b917d91a@usw-ex0106-046.remarq.com> 






     I have run Des2K and Dev2K against 8.1.5 databases.  I'm not
sure what your problem is but I've appended some notes below.
These are for Des6 and Dev6 but many of the same considerations
apply to Des2K and Dev2K.



Van



Oracle Designer/Developer 6.0


At this point I installed Oracle Designer.  There are three parts
to this.  First install the client software on a client or on
this machine.  For now I chose a separate client.  Then install
the server software and create a repository database or a

repository schema in a database.  Finally configure the init.ora
parameters and registry entries if any changes are necessary.
Oracle Designer must install into an Oracle home named Orant.

C1	At the client go to control panel services and shut down


any Oracle services.  In my case I shut down two Oracle
WWWListenerADMIN and Oracle WWWListenerwebsvr.  Then put in the
Oracle Designer 6.0 CD-ROM and run an install.  The name of the
Oracle home is DEFAULT_HOME, the location is c:\ORANT.  I chose a
packaged install and selected the following packages: Analysis,
Design and Generation - Generators for Oracle Developer - Object
Extensions. I had to select whether I wanted version 7 or version
8 of SQL*Plus and Import/Export.  I chose version 8.  Then the
installer started.


The install completed and I got a message that to have all the
functionality I needed to install report builder 6.0.5.29.2 and
form builder 6.0.5.29.4.  These were not on the CD-ROM so I did
nothing for the time being.  Finally, I restarted the two
services I had stopped and made sure SQL*Plus still worked and I
could connect to my databases.


C2	On the server I changed the init.ora parameter
open_cursors = 400.  Then I bounced the database.  I
made sure the listener was started.  I started SQL*Plus as sys
and ran this script N:\oracle\ora815\rdbms\admin\catexp7.  Then I
created two tablespaces, one for tables and one for indexes:
create tablespace DEV60_REPOS_TABLES


datafile 'N:\ORACLE\ORADATA\DBAV\DEV60_REPOS_TABLES01.DBF'
size 100M default storage (initial 128K next 128K pctincrease 0);



create tablespace DEV60_REPOS_INDEXES


datafile 'N:\ORACLE\ORADATA\DBAV\DEV60_REPOS_INDEXES01.DBF'
size 100M default storage (initial 128K next 128K pctincrease 0);



I created one large rollback segment for the install:



create tablespace INSTALL_DEV60


datafile 'N:\ORACLE\ORADATA\DBAV\INSTALL_DEV60.DBF'
size 70M default storage (initial 256K next 256K pctincrease 0);



create rollback segment INSTALL_RBS_DEV60
tablespace INSTALL_DEV60


storage (initial 1M next 1M minextents 3 optimal 4M);



alter rollback segment INSTALL_RBS_DEV60 online;



Then I took the other rollback segments offline:



select segment_name, tablespace_name, status from
dba_rollback_segs;


alter rollback segment xxx offline;   (this turned out to be
rollback segments RB0 and RB1)



Then I created a repository owner and granted connect and
resource to him



create user DEV60 identified by DEV60


default tablespace DEV60_REPOS_TABLES


temporary tablespace TEMP;


grant connect, resource to DEV60;



C3	Now I moved back to the client and performed the next set
of steps.  First I logged onto the server from
the client as sys using the SQL*Plus version 8.  I ran


@c:\orant\repadm60\utl\ckrorole.  Then I ran the following

individual SQL statements:



grant execute on dbms_lock to DEV60;


grant execute on dbms_pipe to DEV60;


grant select on dba_rollback_segs to DEV60;
grant select on dba_segments to DEV60;


grant create sequence to DEV60;


grant create synonym to DEV60;


grant create table to DEV60;


grant des2000_owner to DEV60;



I closed SQL*Plus then ran start > programs > oracle designer
r6.0 > repository administration utility.  I
connected as DEV60 / DEV60 / TDBAV.  At this point I followed the
steps starting on page 2.18 of the Designer Installation Guide.
These steps check to see whether you have installed the necessary
pieces successfully.  I had to modify the registry entries for
EXECUTE_IMPORT, EXECUTE_EXPORT and EXECUTE_PLUS_RAU as shown on
page 2.20.  After the checks while in the Install a Designer/2000
Repository Instance dialog box I pressed "Start".  Many objects
were created and actual data was imported from zipped files.  I
look at the log files from the install to see whether all had
gone well.


C4	Finally there are the post-creation steps.  I brought
rollback segments RB0 and RB1 back online.  I left the large
INSTALL_RBS_DEV60 in place until I can find out whether it is
useful.  Then I used the repository administration utility to
view objects and check whether any were disabled, invalid or
missing.  None was.  I changed the init.ora parameter
max_enabled_roles=50 then bounced the database.  I ran two
scripts to enable pinning in the shared pool:


@c:\orant\rdbms80\admin\dbmspool  and

@c:\orant\rdbms80\admin\prvtpool.plb.  Then I granted access to

DEV60:


        grant execute on sys.dbms_shared_pool to DEV60;



I restarted the designer repository administration utility and
checked that pinning worked by pressing the little pin symbol.
All went OK.  Finally, following the instructions on page 2.27 of
the Designer installation manual I created a test application
system.


C5	During the install of Oracle Designer, several pieces of
Oracle Developer are installed.  But not enough.  If you try to
do something as simple as running the Designer tutorial you will
not be able to until you install Developer.  Installing Developer
is a two part process.  First you install whatever pieces you
don't already have from the Developer 6.0 CD-ROM.  Then you
install patches from the Developer 6.0 Patch 1 set CD-ROM.


        These are the pieces I installed from the Developer 6.0
CD-ROM


		JDK Applet Viewer 1.1.7.11o
		Oracle Developer Demos, Addons 6.0.5.1.3
		Oracle Developer Forms 6.0.5.0.2
		Oracle Developer Procedure Builder 6.0.5.0.0
		Oracle Developer Project Builder 6.0.5.7.0
		Oracle Developer Schema Builder 6.0.5.6.0
		Oracle Developer Trans Builder 6.0.3.0.3
		Oracle Developer Reports Express Support
6.0.5.11.0
		Oracle Express Connection Editor 6.2.0.0.1
		Oracle Developer Database Tables 6.0.2.0.0h
		Oracle Developer Graphics Graphics Builder
6.0.5.8.0
		Oracle Developer Graphics Cue Card Sound
6.0.5.6.0
		Oracle Developer Reports Builder 6.0.5.28.0
		Oracle Developer Reports Cue Card Sound Files
6.0.5.6.0  (this failed)		
	These are the pieces I installed from the Developer 6.0
patchset 1 CD-ROM
	GUI Common Files 6.0.5.29.0
	JDK Applet Viewer 1.1.7.15o
	Oracle Developer Database Tables 6.0.5.29.0
	Oracle Developer Forms 6.0.5.29.4  (but not the web
cartridge)
	Oracle Developer Graphics 6.0.5.29.1 (but not graphics
server)
	Oracle Developer Procedure Builder 6.0.5.29.0
	Oracle Developer Reports 6.0.5.29.2 (but not multitier
server and not thin client)
	Oracle Jinitiator 1.1.7.15.1o
	Require Support Files 8.0.5.1.0c
	Tools Utilities 6.0.5.29.2







Received on Thu Jun 01 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US