RE: 9i database create script - My, how things have changed
Title: 9i database create script - My, how things have changed Sorry, false alarm. Sometimes us simple folk have a hard time with them pretty pictures. Figgered it out finally. -Original Message-From: Cornio, Georgette Ms USACFSC [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 03, 2002 7:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 9i database create script - My, how things have changed I followed the same procedure as 8.1.7 to make the scripts and modified them What part does not work, no mo ? -Original Message-From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]]Sent: Monday, December 02, 2002 15:54To: Multiple recipients of list ORACLE-LSubject: 9i database create script - My, how things have changed ...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite frequently, and the 8.1.7 *.bat's work quite well for 'em. However, as I'm sure you've all figgered out already, this don't work no mo. I've taken some cursory rambles thru orafaq, but came out more confused than I came in. I don't want to rely on installing perl or Oracle DCA on each machine, as the consultants I'm supporting aren't going to be too keen on having to go from their current "hit the .bat and wait til it says all done" MO. So, I'm sure a solution or twenty has been put together for NT/Windows. Care to share? I'm sure I could re-invent this particular wheel, but my boss keeps hollering at me for stuff that I'm actually supposed to produce, so If'n I can turn this one around in a reasonable time, I'd be much abliged.
RE: 9i database create script - My, how things have changed
Title: 9i database create script - My, how things have changed I followed the same procedure as 8.1.7 to make the scripts and modified them What part does not work, no mo ? -Original Message-From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]]Sent: Monday, December 02, 2002 15:54To: Multiple recipients of list ORACLE-LSubject: 9i database create script - My, how things have changed ...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite frequently, and the 8.1.7 *.bat's work quite well for 'em. However, as I'm sure you've all figgered out already, this don't work no mo. I've taken some cursory rambles thru orafaq, but came out more confused than I came in. I don't want to rely on installing perl or Oracle DCA on each machine, as the consultants I'm supporting aren't going to be too keen on having to go from their current "hit the .bat and wait til it says all done" MO. So, I'm sure a solution or twenty has been put together for NT/Windows. Care to share? I'm sure I could re-invent this particular wheel, but my boss keeps hollering at me for stuff that I'm actually supposed to produce, so If'n I can turn this one around in a reasonable time, I'd be much abliged.
Re: 9i database create script - My, how things have changed
Some simple options: 1) The 9.x installer still gives the option of creating scripts in the old fashioned way. The key is not to choose a "template" database. A little scrubbing and they work fine...but man do they take a while to create a db nowadays. 2) My preferred option is to create a skeleton db with just system/undo/temp/pfile (using the installer or otherwise) and get everything just right. Then zip it up with the text of a "create controlfile" and voila! You have a db ready to go - whenever you need a new one, you just unzip, hack the controlfile to rename it and bingo...super quick and be definition, all your databases have the same basic starting point hth connor --- Jeremy Pulcifer <[EMAIL PROTECTED]> wrote: > ...since 8.1.7. I've always ran the database > creation utility, then swiped > the scripts outta the admin\[sid]\create\ directory, > scrubbed 'em a bit, and > let er rip. My consultants create/install new db's > quite frequently, and the > 8.1.7 *.bat's work quite well for 'em. > > However, as I'm sure you've all figgered out > already, this don't work no mo. > I've taken some cursory rambles thru orafaq, but > came out more confused than > I came in. I don't want to rely on installing perl > or Oracle DCA on each > machine, as the consultants I'm supporting aren't > going to be too keen on > having to go from their current "hit the .bat and > wait til it says all done" > MO. > > So, I'm sure a solution or twenty has been put > together for NT/Windows. Care > to share? I'm sure I could re-invent this particular > wheel, but my boss > keeps hollering at me for stuff that I'm actually > supposed to produce, so > If'n I can turn this one around in a reasonable > time, I'd be much abliged. > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i database create script - My, how things have changed
Would you be interested a set of KSH scripts that generate the SQL scripts to create a database? These are for 8i. I've started to modify for 9i differences, but haven't gotten too far. Not too much work to modify them. Lemme know, Jared Jeremy Pulcifer <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/02/2002 12:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:9i database create script - My, how things have changed ...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite frequently, and the 8.1.7 *.bat's work quite well for 'em. However, as I'm sure you've all figgered out already, this don't work no mo. I've taken some cursory rambles thru orafaq, but came out more confused than I came in. I don't want to rely on installing perl or Oracle DCA on each machine, as the consultants I'm supporting aren't going to be too keen on having to go from their current "hit the .bat and wait til it says all done" MO. So, I'm sure a solution or twenty has been put together for NT/Windows. Care to share? I'm sure I could re-invent this particular wheel, but my boss keeps hollering at me for stuff that I'm actually supposed to produce, so If'n I can turn this one around in a reasonable time, I'd be much abliged. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).