Re: 11.2 CRS with 10g Database

  • From: japplewhite@xxxxxxxxxxxxx
  • To: exriscer@xxxxxxxxx
  • Date: Wed, 18 Apr 2012 13:40:39 -0500

I do both - with each major release:
1.  Use DBCA to create scripts and see what gets put in them.
2.  Modify the "from scratch" scripts I've used for a long time to 
incorporate just the new features I want and remove deprecated / obsolete 
stuff.
Step #2 usually takes time and experimentation, especially going to a 
brand version.  But then I have my scripts to produce repeatable results, 
with no unwanted features / baggage.

Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9250 (wk)  /  512.935.5929 (pager)




From:   Ls Cheng <exriscer@xxxxxxxxx>
To:     niall.litchfield@xxxxxxxxx
Cc:     cicciuxdba@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date:   04/18/2012 02:02 AM
Subject:        Re: 11.2 CRS with 10g Database
Sent by:        oracle-l-bounce@xxxxxxxxxxxxx



IHAC who has been using scripts since Oracle 8
She is still using the same scripts from Oracle 8 until a month ago while 
I
was giving a RAC workshop for them we started taling about DBCA and she
asked me why I used DBCA. I said to her I simply use DBCA to generate the
scripts in Single Instance and I do use DBCA to create RAC Databases). 
When
we looked into the generated scripts and compared with her script she just
noticed how many thing she has missed in her scripts during the last 10
years?

She was still creating dictionary managed system tablespaces.......

Regards


On Wed, Apr 18, 2012 at 8:17 AM, Niall Litchfield <
niall.litchfield@xxxxxxxxx> wrote:

> Hijacking this a bit. Do people generally do as Alan does and use home
> grown scripts rather than dbca and database templates for repeatable
> database creation? Having recently gone through the catalog/catproc etc 
etc
> etc process I was surprised at just how long a db create takes these 
days.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


--
//www.freelists.org/webpage/oracle-l





--
//www.freelists.org/webpage/oracle-l


Other related posts: