Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating DB Manually
Hi Howard,
Thanks for your reply.
I did some research on DBCA and creating DB Manually.
I created the DB Manually using a "plain vanilla" script which ONLY mentions datafiles, loggroups and UNDO Tablespace. It then created "vanilla" DB for me. I then executed the scripts "CATALOG.SQL" and "CATPROC.SQL" to populate the data dictionary.
Here is what I see:
USING DBCA to Create Database:
Also, using DBCA my SYSTEM TBLSPC holds around 400MB space and if I create DB Manually, it holds only 150MB
If you compare the above staticis, you will notice a BIG Difference. So my question is if I create DB Manually, WILL I MISS ANYTHING....? Can I simply IGNORE the "extra" stuff which DBCA Created for me.... by creating DB Manually instead....?
Any related informaiton on this is appreciated.
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<3f5cee7c$0$28120$afc38c87_at_news.optusnet.com.au>...
> "Hari Om" <hari_om_at_hotmail.com> wrote in message
> news:d1d5ebe4.0309080810.5725427_at_posting.google.com...
> > Creating DB Manually
> >
> > Hello,
> >
> > I wanted to create a Database Manually (without using DBCA)
> > I already have a database running called "BILL"
> > I want to creat a database manually called "GATES"
> >
> > Here is what I did:
> >
> > 1) Copied initBILL.ora file (/oracle/data1/admin/bill/pfile/) to
> > initGATES.ora (/oracle/data1/admin/gates/pfile/)
> >
> > 2) Modified the following parametsrs in above file:
> > DB_NAME = GATES
> > background_dump_dest=/oracle/data1/admin/gates/bdump
> > core_dump_dest=/oracle/data1/admin/gates/cdump
> > user_dump_dest=/oracle/data1/admin/gates/udump
> > control_files=("/oracle/data1/gates/control01.ctl",
> > "/oracle/data1/gates/control02.ctl",
> > "/oracle/data2/gates/control03.ctl")
> > instance_name=gates
>
> This has nothing to do with your particular error, which arises simply
> because you haven't logged on a privileged user, but you will run into some
> other errors if you don't sort out a couple of other parameters.
>
> Specifically, your BILL database probably has rollback segments or an undo
> tablespace. In which case, those things will be mentioned in the
> initBILL.ora, and they won't be correct for the new database you're about to
> create. You therefore need to comment out any parameter you see called
> 'ROLLBACK_SEGMENTS=xxxx' or 'UNDO_TABLESPACE=xxxx'.
>
> (You will of course have to add in rollback segments to the new database
> once it's been created, or an undo tablespace, and then you can uncomment
> these lines).
>
> Also, watch out for REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE. If that's there,
> you'll need a new password file created before you start. If you, the user
> Hari, are a member of your Unix box's dba group, then you should change that
> to read REMOTE_LOGIN_PASSWORDFILE=NONE. If you aren't a member of the dba
> group, you will have to use the oradim executable to create a password file
> from scratch, or copy the ''orapwBILL" file to something called
> "orapwdGATES", and leave the parameter set to EXCLUSIVE.
>
> Regards
> HJR
Received on Tue Sep 09 2003 - 15:20:25 CDT