RE: RAT fully backported to 10g and 9iR2...

Date: Wed, 7 Oct 2009 13:12:37 -0400
Message-ID: <>

Of course it's fully backported. *wave of the hand* Oracle wants you to upgrade.... SQL Server is not the RDBMS you're looking for.....

we've looked into it. we've got a 9i DB that needs upgrading and we're considering going to 11g, but it's just expensive. the good thing is that you can 'move the license around' if needed. if one of our BU's purchases it, uses it, no longer needs it (for a project) it can be moved around to another db and so on....

-----Original Message-----
From: [] On Behalf Of Robert Freeman Sent: 07 October, 2009 1:05 PM
Subject: RAT fully backported to 10g and 9iR2...

Anyone use RAT much yet, or is licensing an issue?,289142,sid41_gci1320966,00.html?asrc=SS_OracleD2DBUpgrad

 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles

  • Original Message ---- From: Rich Jesse <> To: Sent: Wed, October 7, 2009 10:32:10 AM Subject: Re: major blunders

> Compiling a list of major blunders to avoid:
> Don't use the number 8 for scripting or ORACLE_SID due to the wild card
> character * above it.
> Don't use rm *.*
> ....
> Anyone else have some to contribute?

Before instance shutdown:

    SELECT * FROM V$INSTANCE to verify what you're shutting down.     SELECT * FROM V$SESSION (or some variant) to see what's connected.

Don't practice recovery on the same server as the recoverable DB.

Use colors in Unix command line prompts -- red for Prod, green for Dev, etc.

Use instance name in SQL prompt.

Make your terminal scrollback very large -- mine's at least 5000 lines.

Before logging off of ANY remote Windows session, repeat several times OUT LOUD your intentions to logoff and NOT shutdown the server before you actually click the buttons (esp important on Win2K servers!).

Clean up your room. Stand up straight. Pick up your feet. Take it like a man. Be nice to your sister. Don't mix beer and wine, ever. Oh yeah: Don't drive on the railroad tracks.

My $.02,


Received on Wed Oct 07 2009 - 12:12:37 CDT

Original text of this message