| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 10 & freeware (report of my St. Valentines Day)
2) Oracle has finally put "IMMEDIATE" in the dbshut procedure!!!!
There must be at least 50,000 DBA's that have been doing that hack for years. I recall when 8 came out and it simply didn't work with 7.3 databases.
Backing up your customized dbshut was a prereq for upgrade.
Jared
On Sat, 2004-02-14 at 18:17, Mladen Gogala wrote:
> Two more things:
> 1) demobld.sql was renamed to $ORACLE_HOME/rdbms/admin/utlsampl.sql
> I was afraid that my old friend Scott and his cat Tiger were
> gone. Fortunately, I was able to re-create the precious contents
> of my database, all 14 rows of it.
> 2) Oracle has finally put "IMMEDIATE" in the dbshut procedure!!!!
> Mazeltoff!
>
>
>
> On 02/14/2004 08:59:06 PM, Mladen Gogala wrote:
> > I installed Oracle 10g on my RH-9 box, everything went well,
> > but things were much hairier with public domain software.
> > Tora and DBD::Oracle 1.15 had no problems with linking against
> > oracle. PHP-4.3.4, on the other hand, failed entirely and I
> > had to link5 5.0 beta4., which had worked. Unfortunately,
> > Adam von Nieda's fine oracletool no longer works with 10g.
> > It complains about the insufficient privileges, despite the
> > fact that I granted select ant dictionary and select any table
> > directly to the user "SYSTEM". The problem is not with the
> > privileges, but the V$COMPATIBILITY table ceased to exist.
> > Adam is using the table to figure out the database release.
> > As I don't have V$COMPATIBIITY table, I decided to help him
> > out a bit, by putting the following in the code instead of
> > his query:
> > SELECT 10,1 from dual
> >
> >
> > That extremely complicated query fixed the tool and it was working
> > again. Session wait events never returns in his tool, but it does
> > return in tora. I believe that we're in for the oracletool release 3
> > with the 10g. I'll fix the V$COMPATIBILITY query to go against
> > v$version instead of v$compatibility.
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sun Feb 15 2004 - 16:04:16 CST
 |
 |