Good Oracle DB Creation Resources

I recently found myself recreating an Oracle 10g database on Red Hat Linux remotely. Long story. I found these two resources to be very helpful:

• Creating an Oracle 10g database from the command line only
• Oracle 10.2 Database CREATE ALTER DROP

Here is what I mostly ended up with (I pieced it back together when I finally got it to work). I've removed paths, passwords, etc. or anything that is specific to the actual database I was working on. This is pretty much a combination of the above resources with a couple changes.

connect / as sysdba
shutdown abort
startup nomount

CREATE DATABASE oradb
controlfile reuse
  MAXINSTANCES 8
  MAXLOGHISTORY 226
  MAXLOGFILES 16
  MAXLOGMEMBERS 4
  MAXDATAFILES 1022
DATAFILE 'system01.dbf'
  SIZE 540M REUSE
  AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'sysaux01.dbf'
  SIZE 350M REUSE
  AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
  DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'temp01.dbf'
  SIZE 25M REUSE
  AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED
  UNDO TABLESPACE "UNDOTBS1"
DATAFILE 'undotbs01.dbf'
  SIZE 100M REUSE
  AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
  CHARACTER SET UTF8
  NATIONAL CHARACTER SET utf8
LOGFILE
  GROUP 1 ('redo01a.log',
  'redo01b.log') SIZE 20M,
  GROUP 2 ('redo02a.log',
  'redo02b.log') SIZE 20M,
  GROUP 3 ('redo03a.log',
  'redo03b.log') SIZE 20M
USER SYS IDENTIFIED BY "password"
USER SYSTEM IDENTIFIED BY "password";


@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql


connect system/password
@?/sqlplus/admin/pupbld

Subject Tags: [Linux] [Database] [Oracle]

Conference Rankings

This is pretty cool. I found a ranking page for the conference sessions.

Currently my You Can't Do That In Visual Studio is tied for 1st in votes. In all I have 3 in the top 10 by vote and 5 in the top 10 by rating. Pretty exciting! Thanks for your votes! It will be interesting to see how this goes between now and August 21st. If you haven't voted yet then be sure to login and vote! If you don't have an account you need to create a new user account first.

I haven't figured how to create a single link so you can vote for my sessions automatically. Somehow Borland always manages to setup a link like that when they are up for reader choice awards. Although since I have 12 sessions, and you get 10 votes, you would still need to pick and choose which sessions to vote for.

Subject Tags: [Programming] [Software] [Mashups] [Delphi] [Development] [VisualStudio] [Cryptography] [Syndication] [Borland] [csharp] [conference] [dotnet]

Vote for the Borland 2006 US Developer Conference

Voting is open for the Borland 2006 US Developer Conference. You can rate them and vote for your Top 10 Favorites through QC. To save you from needing to search for my sessions I have listed them here:

1. You Can't Do That In Visual Studio
2. Coding Competition
3. Generics in Delphi
4. Template Development
5. Mashups - Combining Web Service Api's with Delphi
6. Content Syndication
7. Internet Protocols
8. Advanced Internet Protocols
9. Exceptional Exceptions
10. Implementing Cryptography
11. Understanding Cryptography
12. Oracle at Delphi

Personally, I would really like to attend the Coding Competition session, which is why I submitted it. I think it will be a lot of fun. It would appear my You Can't Do That In Visual Studio session is doing quite well - it has the most votes from what I have seen. That one will be fun as well!

Be sure to login and vote! Rating them is nice, but it would appear voting carries the most weight. If you don't have an account you can create a new user account first. Voting closes August 21st!

See you at the conference!

Subject Tags: [Programming] [Software] [Mashups] [Delphi] [Development] [VisualStudio] [Cryptography] [Syndication] [Borland] [csharp] [conference] [dotnet]

Sessions for 2006 Borland Developers Conference

I submitted 12 sessions for the 2006 Borland Developers Tool Conference. I am sure it will have a shorter name before the conference gets here. Here are my sessions:

1. Internet Protocols
2. Advanced Internet Protocols
3. Coding Competition
4. Exceptional Exceptions
5. Implementing Cryptography
6. Understanding Cryptography
7. Oracle at Delphi
8. Generics in Delphi
9. You Can't Do That In Visual Studio
10. Template Development
11. Mashups - Combining Web Service Api's with Delphi
12. Content Syndication

Once they are published on BDN with details I will provide links. I am really excited about a few of these, especially the Coding Competition. I actually was chatting with Nick Hodges, the new Delphi product manager, about it before the call for papers was published.

Also, it appears I won the abstract submission prize! The reference number assigned to one of my abstracts is 1234! I think that gets me automatic selection as a speaker!

Subject Tags: [Programming] [Software] [Mashups] [Delphi] [Borland] [csharp] [conference] [dotnet]

Borland's Developer Tools Group to get New Owner

I guess I am a bit behind on the news. Dateline June 30th, 2006:

Nick Jackson, managing director of Borland DTG in the Asia-Pacific region, told ZDNet Asia that the company, which announced its intention to divest its developer product lines on Feb. 8, has attracted about 16 qualified bidders so far.

And some doubters were saying they would have a hard time finding anyone interested. 16 qualified bidders means they had more then 16 interested. Those are only the qualified ones. Heck, I was interested, but not really qualified. And the good news is

By the third quarter of this year, Jackson said that Borland's DTG will become a totally independent company after the divestment.

Interestingly 3rd quarter this year is "Fall of 2006" which is the scheduled date of the as yet unnamed 2006 Developers Conference. I'm telling you, they are going to unveil it at the conference. This is the conference you want to attend.

Also, as was predicted:

He added that Borland will continue to have some small part in the new company, be it in the form of a minor equity stake or representation on the board of directors through Borland CEO Tod Nielson.

So it is in Borland's best interest to find a buyer that shares the vision of making DevCo / DTG as profitable as possible.

Subject Tags: [Programming] [Software] [Borland] [Delphi] [Conference]

2006 US Borland Developer Conference -- Call for Papers

Borland’s Developer Tools Group has begun planning for the 2006 US Developer Conference to be in held in the Fall of 2006 in Northern California. The deadline for submitting abstracts is July 17th, 2006.

They are going to let the community vote on the submitted abstracts to determine what sessions will be presented. Be sure to vote on my abstracts. I'll have links up for them once they are available.

Read more at the new improved bdn.borland.com .

I don't have the inside track on any information, but I suspect that if we don't see an annoucement about the spin off of the developer tools group by then, then we will see one at the conference. It was at BorCon 2001 when a gorilla smashed the Inprise facade to reveal the rebirth of the Borland name.

Yes, I am expecting big things, and yes, I plan to be there.

Subject Tags: [Programming] [Langauge] [Delphi] [Software] [Borland] [DevCon] [DotNet]

Brief History of C# and C Langauge Names

Someone wanted to know how to pronounce C# and what it's association was with the other C languages. Here is a little primer for everyone's reference.

The language is pronounced "sea sharp", and it is an ECMA standard. Since most search engines don't index the # symbol, and you rarely see it in a URL you will often see it written C-Sharp online. Although Microsoft invented the language, there are other implementations of it. Visual C# is Microsoft's implementation of the C# language.

It is related to other C languages (C and C++) by the fact that it uses the C syntax. Also Microsoft wants to replace the previous dominate languages of C, C++ and Java (also a C syntax language) with C#, so they gave it a name that made it look like the predecessor to C and C++.

The difference between C and C++ was the move from procedural or functional programming to object orientated programming. The big difference with C# is the removal of pointers and working within the .NET framework. There is no use of C# outside of the .NET CLI (Common Language Infrastructure), which is also an ECMA standard.

Keep in mind that Microsoft isn't the only one to implement that framework though. There is a number of other implementations, with the most notable one being the MONO Project, which is a cross platform open source implementation of the CLI Framework and the C# langauge.

Interestingly, how C++ got its name is that in the C language there is a ++ operator that takes the value of a variable, increases it by one, and then uses that value. So to write C++ is to say C = C + 1. Which means the C++ language takes the C language, improves it, and continues using it.

To get the name C# Microsoft took the double pluses from C++ and they moved the first plus up a little bit, and the second plus down a little bit, then they moved them closer together so they overlapped. If you clean that up then you have the # symbol in C#.

Subject Tags: [Programming] [Langauge] [Trivia] [Software] [Microsoft] [Mono] [ECMA] [Standard] [Java] [CLI] [CSharp]

WinFX renamed .NET 3.0

OK, this is just now hitting the Microsoft blogs.

WinFX has officially been renamed .NET 3.0 See Somas blog for details: http://blogs.msdn.com/somasegar/archive/2006/06/09/624300.aspx

Subject Tags: [Programming] [Software] [Microsoft] [WinFX] [.NET 3.0]

.NET 1.1 in Visual Studio.NET 2005

You did not read that title wrong. Develop .NET 1.1 code using Visual Studio.NET 2005 using MSBee

What is this really? MSBee is an addition to MSBuild (MSBuild handles all of the builds for Visual Studio.NET 2005 whether you realize it or not), that allow you to use the .NET 1.1 compiler instead of the .NET 2.0 compiler. Very cool! So now you can get the cool new features of Visual Studio.NET 2005 (refactoring!) and keep everything in 1.1. Read more here: http://blogs.msdn.com/seshadripv/archive/2006/06/09/623871.aspx

Subject Tags: [Programming] [Software] [Visual Studio.NET] [MSBee]

Office 2007 Beta 2

Just in case you are interested.

Subject Tags: [Software]