Recent content by GremlinHunter

They are running different jvm versions. The old Oracle 8i DB that is having problems is using 1.2.1. My development station is running 1.5.0_06. Perhaps my workstaion has a more robust version of ZipFile class. If this is the case though it is odd everything worked for several weeks...

For several weeks I have had a bit of code opening zip files and counting specific extensions inside. Now when the routine runs I just get "error in opening zip file" from IOException. The odd thing is that the test code still works fine from my workstation, even when I use the same network...

Do you remember offhand what view to check in sem? The two most likely looking views gv_$instance and gv_$mystat do not seem to have anything like uptime.

Sorry about that. Was not watching what I was typing. Been fighting with backup issues lately and had archive logs on the mind. Actually our alert log's do get to be farily big. I last saved off this databases alert log back on 11-SEP-07. It is at 95MB now. Tiny compared to many of our...

Ah well. With nothing in v$database or v$instance I didn't really have much hope. Thanks for the logic for computing it from the archive logs. I can probably use that with one of our "newer" systems. Sadly the archive logs from the box in question have been deleted over the years for hard...

Is there a way to find out total uptime on a database? I have one turning 7 years old tomorrow and I was curious how much of that was with database online.

We removed a drive set a short while back. What was not known was that the set was a member of a test drive group in the cluster. As a result we can not get either of the cluster nodes to run Cluster Services unless they use the -FixQuorum startup parameter. Fun thing is that the removed disk...

So I gather. When I posted this I was under the impression that split did not create a new partition but redistributed data between existing ones. I know a little better now. At this point in time I am trying to work out how much data is too much to split. I am not keen on creating temp...

I am hoping someone here has an idea on this. We have a number of tables that are index organized tables. Every day as part of a job new partitions are created for several days from now. Problem is that yesterday did not get any partitions created for it but partitions have been created...

Turkbear - That is what I was afraid of. Staying with the same query as the routine seems to give me matching results. So far the only ones that are showing out of order were from new columns added into the tables. That is what had me wondering on the row number thing. I thought I remembered...

Basic question is when does the order of a query return change when no order by is used? I think the DB used the row number as default order but it has been years since I took the class. Reason is we have a routine that dumps daily partitions into csv's for archival. However the routine is...

Try here: http://www.microsoft.com/technet/scriptcenter/scripts/os/services/default.mspx?mfr=true MS Script Center is pretty darn good for this stuff. http://www.microsoft.com/technet/scriptcenter/default.mspx

Ok, making a test user a member of Domain Admins cleared up the Remote Desktop now allowing connections by default. One thing on it does not make sense to me yet. If we are supposed to use the Domain Admins group for administration instead of Administrators group, then why can I not make...

I overlooked the Domain Admins group. I was trying to distinguish between the Local Administrators group on the 2003 server and the Administrators group on the 2000 domain. Interesting, Domain Admins is a member of Administrators on the 2000 domain. As it is none of the admin users on the...

We have several 2003 servers connected to our 2000 domain. Problem I am having is that I can not assign the Domain Administrators Group to anything in 2003. I can find the Local Administrators Group and thats it. Also, under Remote Desktop Users in 2003 there is a note that "Administrators...