Re: designer2000

Make sure that the database is properly configured in terms of memory. The default database created ( in most of the cases ) never satisfies what ODesigner needs. I got a problem of Max Open Cursors during installation. Also make sure that the SGA avg. requirements are met.

HTH,
xt7302

In article <82kq7r$4f6$1_at_news.vsnl.net.in>,   "Ranjeeb Sarma" <ranjeeb_at_vsnl.com> wrote:
> any body knows how to make a repository to install designer 2000 first
class
> case tool
> pl help
> c:\>svrmgr30<return>
> svrmgr:\>connect internal/oracle
> svrmgr:\>create tablespace REPOS_IDX datafile 'sys:orant\database.ora'
size
> 50Mb default storage (initial 100k next 100k pctincrease 0);
> svrmgr:\>create tablespace REPOS_TAB datafile
'sys:orant\tablespace.ora'
> size 50Mb default storage (initial 100k next 100k pctincrease 50);
> svrmgr:\>alter tablespace SYSTEM add datafile
> 'sys:orant\databases\sg13onet.ora'< ?????,doubt>
> svrmgr:\>create user REPOS identified by <password>;
> sql>grant dba to repos_owner (initorcl.ora?????<doubt>
> svrmgr:\>startup force;
> sql>_at_D:\orant\repos20\utl\ckrorole.sql
> sql>role=>des2000_owner
> sql>grant execute on dbms_lock to repos_owner;
> sql>grant execute on dbms_pipe to repos_owner;
> So the question is should I follow these steps or there's some other
way to
> do so? And what do I do next? Its really confusing. I'd be indebted if
you
> help me out on this.
> Email at ranjeeb_at_yahoo.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 16:55:47 CET