Posts

Changing Oracle Database ID and Name (nid)

 Getting back into Oracle as a DBA I've been reading up and watching tutorials to try to get the old skills back and update to the new tools, last time I DBAed in anger we were still on Oracle 7 and 8i, 9i had been out a while and 10g was in early versions, but because much of our software was so old we weren't using it much.  I came across a tutorial on how to update the name and ID of a database.  This is useful if you have copied a database and want to rename the copy to stop it being confused with the old, or if you want to have it on the same machine as the old.  The database ID is an internal number used by Oracle to identify the database, it looks like the main reason you'd want to change the ID is if you use RMAN and want to have both in the same repository. PLEASE NOTE: The below is based on a tutorial I watched and has not been tested, errors and omissions are expected.  Before using in production do a few practice runs on sandbox databases.  Proc...
Post a Comment
Read more

SQL*Server Import Export Wizard 2017 vs Office 64 bit

Not Oracle, but since we're having to multi-platform these days, it might be relevant to some. When you install SQL*Server Management Studio on 64-bit Windows, the Management Studio (SSMS, equivalent of SQL*Plus) is 64-bit, but it installs the 32-bit version of Import Export Wizard (SSIS). This is fine if you have the 32-bit version of Office installed or only import and export CSV or other non-Microsoft file types. If you have 64-bit Office and try importing an Excel spreadsheet, you will get an error message: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)" Googling for this error message brings back a range of solutions (many dating back to SQL*Server 2008 and Office 2010), from installing the 64-bit Access Runtime redistributable to setting up a VM in Oracle Virtual Box and putting the SSMS/SSIS software on that, but not any form of Office. When I ran into this error today, we found, after some trial and err...
Post a Comment
Read more

Oracle Midlands User Group May 2014 Meeting

On 20th May 2014 Oracle Midlands User Group will be hosting a couple of talks by Christian Antognini.  For full details see: http://oraclemidlands.com/ The first talk covers adaptive query optimisation in Oracle 12c and how it can be used to ensure that the query optimiser generates better plans more often.  The second talk delves into the internals of row chaining and migration. The venue is: InnovationBirmingham , Faraday Wharf, Holt St, Birmingham B7 4BB 
Post a Comment
Read more

ROWID equivalent in Microsoft SQL*Server

The last few months I've been having to work with Microsoft SQL*Server 2008 R2 for a project I'm on.  I'm not finding it fun for a variety of reasons, including that it doesn't seem as capable as I recall Oracle being and that the source data I'm having to work with is very, very dirty. One of the complicating factors is often there will be exactly, or almost exactly, duplicate rows when each row should be unique.  Obviously I need to have something to uniquely identify the rows for the delete so looked for an equivalent of ROWID (the pseudo-column in Oracle that uniquely identifies a row).  I found a page that talks about this .  The pseudo column is %%physloc%%.
Post a Comment
Read more

Tablet PCs - Why so pricey?

Is touch screen really expensive to do or something. I've been tossing around the idea of getting a tablet PC to stick OneNote on to use for note taking, reading documents and some web surfing (including Gmail) via WiFi. I'm having to attend a lot of meetings/briefings where the ability to take notes and link them to documents and web pages would be incredibly useful. Looking around the web the options seem to be: iPad, around the £500-900 mark but won't multitask or run OneNote and from what I've heard from all but the most ardent Apple worshipper is basically crap (iPhone without the ability to make calls) Tiny and low spec (more of a PDA than PC) around the £400-700 mark Equivalent spec to a, non-touchscreen, laptop that currently retails for about £300-450 but costing £1500-2100 I think I'm stick with pencil and paper with printouts of docs I want to read for now. In terms of specification what I'm looking for is: 10-12 inch screen Run OneNote 2007, Acroba...
Post a Comment
Read more

Oracle aims to secure future of Sparc, Solaris and Sun hardware

Interesting article on ComputerWeekly.com about how Oracle are looking to secure the future of Sparc, Solaris and Sun Hardware . They don't mention it but I wouldn't be surprised if we see 'Database as an Appliance' coming soon with Oracle Database running on Sun Hardware with management taken out of the hands of the local DBA and automated or made accessible only to Oracle themselves. This isn't a 'Death of the DBA' thing, the sort of sites that could go for something like that are probably the ones that don't have a DBA, just a support tech who has a couple of books, the sort of sites that probably run M$ SQLServer now. One thing they mention, as an aside, is that Oracle plan to OpenOffice.org to position it as a competitor to Microsoft Office. If they want to do that then I think the thing they really need to introduce to the suite is a desktop RDBMS to beat Access. Ideally something that can also act as a front end to Oracle with a tool that will...
1 comment
Read more

Oracle to buy Sun

Oracle announced today that they will be buying Sun Microsystems. Their plan is to produce 'pre-integrated' systems where everything from the bare metal, silicon and spinning rust up to the application front end is from themselves. The idea is that customers will save money on systems integration costs but reliability will go up.
1 comment
Read more