RE: DB on NT

2001-07-05 Thread Steven Hovington
Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up

RE: DB on NT

2001-07-05 Thread Guy Hammond
Me neither. I've had database 50-70G in size on NT. (Which, in the grand scale of things isn't terribly large, but it's my personal experience and sufficient for this example). Compaq ProLiant servers, Compaq RAID controllers and storage arrays. Very nice equipment, rock solid and very fast. So

RE: DB on NT

2001-07-05 Thread Mercadante, Thomas F
Antje I know there was a saying - put no database larger than 1 GB on a NT machine. The above is nonsense. I have a database that is 200G on NT. I know of no limit regarding database size on NT. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July

RE: DB on NT

2001-07-05 Thread Mercadante, Thomas F
Guy, rantDon't even get me started on Unix, which sucks. Rebooting if you need more file descriptors?! Or shared memory? All operating systems suck. Apart from maybe VMS./rant Isn't saying all operating systems suck a bit harsh? :) Personally, I think they all have their challenges, but they

RE: DB on NT

2001-07-05 Thread Peter McLarty
Perhaps it is confusion with filesize and then it is a whole different ball game and not only for NT but some older unixes and other OS's as well. and then we can start the arguments for using raw or not using raw for files under unix. Peter At 10:45 PM 5/07/2001, you wrote: Antje I know

RE: DB on NT

2001-07-05 Thread Guy Hammond
ALso, what does 1GB actually mean? That much data, if you dumped it all out into a CSV file? A 1GB tablespace to hold all the data (and how is that tablespace organized)? 1GB being the sum of the sizes of all the datafiles? So, even if there were such a saying, it would be meaningless. What I

RE: DB on NT

2001-07-05 Thread JOE TESTA
I tend to leave out the sid in a datafile name, saves me from having to rename it, if i'm doing the transportable tablespace ordeal. joe [EMAIL PROTECTED] 07/05/01 12:03PM ALso, what does "1GB" actually mean? That much data, if you dumped itall out into a CSV file? A 1GB tablespace to

RE: DB shutdown - NT

2001-06-15 Thread Solomon, Saul M.
Michael, Thanks. I hadn't noticed that they changed Metalink so that you click on a different area to get the newest patches. Saul Solomon PPG Industries [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 14, 2001 2:43 PM To: Multiple recipients of list ORACLE-L Try patch

Re: DB shutdown - NT

2001-06-14 Thread A. Bardeen
Sean, As Paul already mentioned 30 seconds is probably not long enough, but even so you're probably hitting bug 1336566. As for the specific versions: 7.3.3.0.0 7.x will never shut down cleanly when stopping the services or the server as the registry entries controlling this weren't

RE: DB shutdown - NT

2001-06-14 Thread O'Neill, Sean
Paul Drake wrote: Please patch 8.1.7.0.0 to at least 8.1.7.0.2, I've been using 8.1.7.1.2 for 6 weeks. Thanx for the patch info Paul. Debbie wrote: It is really hit and miss with Oracle on NT. I have all servers set up the same (including the registry settings) and some will shutdown the

RE: DB shutdown - NT

2001-06-14 Thread Solomon, Saul M.
Paul, But where is this patchset. It's not on Metalink or the ftp sites. Saul Solomon PPG Industries [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 13, 2001 10:06 AM To: Multiple recipients of list ORACLE-L O'Neill, Sean wrote: I'm trying to configure systems to

Re: DB shutdown - NT

2001-06-14 Thread Michael S. Siebert
Try patch 1711240 for getting from 8.1.7.0 to 8.1.7.1 and then patch 1797438 to get from 8.1.7.1 to 8.1.7.1.3. I know I found them on MetaLink, so if I recall the navigation I'll let you know. HTH, Mike Solomon, Saul M. wrote: Paul, But where is this patchset. It's not on Metalink or the

RE: DB shutdown - NT

2001-06-13 Thread IT - Database (Do Not Use)
Sean, It is really hit and miss with Oracle on NT. I have all servers set up the same (including the registry settings) and some will shutdown the database properly others don't. I have bugged Oracle for an answer but they always say that the best thing to do is for you to shut down the

Re: DB shutdown - NT

2001-06-13 Thread Paul Drake
O'Neill, Sean wrote: I'm trying to configure systems to shutdown immediate Oracle when NT server is shutdown. I've followed instructions in Admin manual for registry settings and being trying it on Oracle PE 8.1.7.0.0 but it don't appear to work. Oracle does crash recovery when PC

RE: DB shutdown - NT

2001-06-13 Thread Reardon, Bruce (CALBBAY)
Sean, Added to Paul's good list of registry values. I have used svrmgrl to do a shutdown immediate and then a startup and still seen recovery in the alert log. That is, to me, the presence of Beginning crash recovery in the alert log does not imply the shutdown was not an immediate one. I would