Posts Categorized: Oracle
Thinking I had something new, I wrote this article about recovering deleted files. However, it turns out Frits Hoogland had already blogged about recovery of deleted files on linux, as Frits pointed out in a comment on my blog, where he also mentioned a metalink note on this matter. The procedure outlined in the note describes how to recover the deleted file and put it in the same location as the deleted file. The problem is that it doesn’t include offlining/onlining the file, so the database ends up with two distinct copies of the file.
So you have accidentally removed a datafile from your production database? First thing, DON’T PANIC! There’s an easy way to recover deleted datafiles, for as long as your database remains up. The procedure, outlined here, works on linux, however this method conceivably can work for other platforms.
After many requests from readers, I’ve put together new, revised version of the Oracle 11g on Ubuntu recipe. This new version is a little different than the first one published: it’s based on a bare-bones install of Ubuntu 7.10 (Gutsy Gibbon) server version instead of the desktop version. As an improvement, I’ve tried to pare down dependencies to a minimal set. Your feedback is more than welcome — it’s the main reason why I wrote a new version of this HOWTO. I’ve also tested and repeated this procedure twice. Even so, it might still have problems, so please let me know so we can improve it 1.
I do realize that for most of you, there may be nothing new about the dbms_sys_sql package knowledge of it has been floating around for quite a while. I myself discovered this package a couplI do realize that for most of you, there may be nothing new about the dbms_sys_sql package knowledge of it has been floating around for quite a while. I myself discovered this package a couple of years ago while playing around with HTMLDB’s (now APEX’s) internals. I’m posting this as a response to a vox populi demand: I often see people who could benefit from dbms_sys_sql, if they only knew about it.e of years ago while playing around with HTMLDB’s (now APEX’s) internals. I’m posting this as a response to a vox populi demand: I often see people who could benefit from dbms_sys_sql, if they only knew about it.
I found some interesting software pieces available for download from Oracle TechNet. “Oracle Outside In Technology” represents a set of SDK’s for various content management operations. Basically, those are excellent building blocks for content management applications and tasks. Here are couple descriptions to heat your interest up.
I didn’t realize that it’s been a month since I got back from Lalandia (it feels like it was yesterday), and I still have something to finish blogging about. Shame on me!
I’ve got notification of new download on OTN. Here is the link to OEM download page with 10.2.0.4 is for Linux x86 and Windows x86. Other platforms should be available upon release on the same page.
I’m not sure how long this has been out there, but there is a new (to me) headline on Oracle’s support website, announcing that next month, they will be phasing out “manual configuration” information for service requests. Customers are now required to download and install something called Oracle Configuration Manager (OCM), which will gather their system/database configuration information automatically, and forward it to Oracle Support on their behalf. I don’t know a lot about this tool. Yet. The OCM page on on Metalink offers the following description…
It looks like the second public platform release for Oracle 11g is (surprise, surprise) Linux x86-64. Downloads are available on OTN.
Dave has been sick these past two days and as a result, we do not have a comprehensive log buffer ready. I had two choices – cancel this week’s log buffer, or try to make it great despite this adversity. Never one to accept defeat easily, I’ll go for the second option. So this week’s log buffer is as follows: we are counting on each and every one of you, our faithful readers, to propose the one article you read in the last week, and include a short paragraph as to why this article was interesting to you and why it should interest us.