I'm with Alan on this one, take the trouble to get your dbca templates correct and have deployment methods a dba who isn't familiar with the scripts can understand. Same database every time seems like a smart plan to me. I don't agree about tetris though :) On Fri, Dec 2, 2011 at 1:43 PM, Mercadante, Thomas F (LABOR) < Thomas.Mercadante@xxxxxxxxxxxx> wrote: > All, > > I'll do you one even better. > > Use dbca once to create the scripts to create the database. Save/modify > the scripts and run sqlplus on the server to create the database. > > Use these scripts as a template going forward. > > I dislike dbca simply because it creates way to many extra schemas that I > will never use. And dropping those schemas after the fact is too risky. > Not creating them initially is the better way to go for me. > > Of course, this goes to individual preference! > > Tom > > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Guillermo Alan Bort > Sent: Friday, December 02, 2011 7:55 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: creating db using dbca not seeing pop-up screens > > I'll give the unhelpful advice again: > use response files. Even for dbca. > > It'll take you about 10 minutes to modify an existing template (which is > installed automatically with the RDBMS) and you simply run runInstaller > -silent -responseFile <full path to rsp> (you can even use nohup) and go > play tetris for a while. when you come back the database is there. I got > used to this when the speed I got from using either vnc o xming and putty > was so unacceptably slow that it took about 5 minutes for each click. So > the gui dbca or oui were unsuable... also, now I got a copy of every > response file I've ever used and it's much easier to have a standar install > that way. > > hth > cheers > Alan.- > > > -- > //www.freelists.org/webpage/oracle-l > > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l