Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Oracle 10g Release 2 for Windows Install Note - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on Web, HTML5, Mobile, Xamarin.iOS, Xamarin.Android, and Windows Azure.

News

Visual Studio Magazine Column Personal Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Archives

Oracle 10g Release 2 for Windows Install Note

For those of you that have ever tried to install Oracle and failed, I have shocking news for you regarding the install of Oracle 10g Release 2 for Windows.  I downloaded it, installed it, and..........................it worked.  I was able to bring up the web based management console, which I hated in 10g Release 1.  I am very interested to take a look at 10g R2 for Windows because it has the support for the CLR in the Windows version of the database.

Wally

Comments

anon said:


The CLR does not run in the database process, but in an external CLR agent. Which I believe is an outproc exe.

One would question running the inproc CLR right in the database process itself, making it a great candidate for all sorts of process crashes and security holes.
# September 29, 2005 7:50 AM

Wallym said:

Yes, it runs as an out of proc exe in Oracle. The state is based on the fact that previous versions of Oracle for Windows do not have this capability.

As for running inproc, there are positives and negatives to doing this. As I understand it, the CLR runs inproc with Sql Server 2005, however, there are certain hooks in the clr that allow this functionality and allow Sql Server to host the CLR and control what is happening.
# September 29, 2005 8:12 AM