Oracle an' T'ing

tag:blogger.com,1999:blog-246540432011-12-15T03:10:30.796ZOracle an' T'ingTechnical articles on Oracle administration and development.Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.comBlogger91100tag:blogger.com,1999:blog-24654043.post-69971162583679324252007-06-17T11:20:00.000+01:002007-06-23T21:16:27.880+01:00Advanced Security Option Gotcha

Here is nice little licensing anomaly. Advanced Security Option (ASO) implements, among other things the 'identified globally' clause of 'create user'. It is an Enterprise Edition option, and an EE option generally means big bucks.However it looks as if using 'identified externally' with Windows domain accounts counts as 'identified globally'.select name, currently_used,

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com3tag:blogger.com,1999:blog-24654043.post-41278573604778548412007-02-21T07:41:00.000Z2007-02-21T07:54:04.033ZSymantec releases Veritas Storage Foundation as freeware

Symantec have release a version of Veritas Storage Foundation as freeware. It seems to be aimed at small businesses running small servers as it is limited to creating 4 volumes / file systems and will only run on 2 processor machines.It is available for Solaris 8,9,10 (SPARC), Solaris 10 (x64), AIX 5.2,5.3, RHEL4 (XEON/EM64T/Opteron/Itanium 2), SLES 9,10 (XEON/EM64T/Opteron/Itanium 2) and

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com0tag:blogger.com,1999:blog-24654043.post-1170751231830799312007-02-06T08:32:00.000Z2007-02-06T08:40:31.830ZOTN Single sign-on is forever

I've recently given up an old email address which I no longer used, except as my contact point for OTN. This meant that I also had to give up my OTN account because the security software for OTN does not let you change your email address. It doesn't matter that much, but it means I have lost all my brownie points and my little gold medal for being an active user.It is very annoying however. The

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com0tag:blogger.com,1999:blog-24654043.post-1170750561197803262007-02-06T08:20:00.000Z2007-02-06T08:29:21.206ZFear of 11i

I'm not looking forward to 11i. I'm sure there will be all sorts of exciting new features designed to make me redundant, but the main reason is that I'll have to upgrade my lab machines.Each new version has increased the minumum hardware requirements, but it is usually possible to run Oracle below the minimum requirements if all you are doing is single user experimentation. There are exceptions

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com0tag:blogger.com,1999:blog-24654043.post-1165231065321641502006-12-04T11:16:00.000Z2006-12-04T11:50:21.833ZUsing CVS with SQLDeveloper

This entry describes a very simple implementation of CVS as an external tool in Oracle's SQLDeveloper database ide. Integrated version control is promised for later releases, but until then an external tools implementation is the best that can be done.The external tools interface is new in version 1.1 which is currently going through a preview cycle. There are limitations in the external tools

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com0tag:blogger.com,1999:blog-24654043.post-1164284907581136472006-11-23T12:23:00.000Z2007-06-23T20:40:54.083+01:00What is my database called? (Part 1)

Naming oracle databases - Part 1There are many names which can be considered the database name, depending on the point of view.DBID - system generated database identifierSID - System IDentifierDB_NAME - The real name of the database.GLOBAL_NAME - combination of DNAME and DBDOMAINDB_UNIQUE_NAME - used in data guard to distinguish between copies of the same databaseSERVICE - the 'published' name

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com0tag:blogger.com,1999:blog-24654043.post-1163935628472850402006-11-19T11:26:00.000Z2007-06-23T20:34:53.913+01:00Creating a Schema Owner

What is a schema?A schema is a collection of database objects (tables, views, stored procedures etc) owned by a single user. 10g Concepts Manual defines it here. Typically, all of an applications objects will be in a single schema and application users will access those objects through a combination of grants and synonyms.When to use a schema.As a rule, each application should be in its own

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com3tag:blogger.com,1999:blog-24654043.post-1158314351026925032006-09-15T10:44:00.000+01:002006-09-15T10:59:21.306+01:00Books on a Palm

Alternatively, Books are a Pain.There are a lot of oracle manuals (the 10gR2 database set alone has 225 pdf files), and the only practical way to read them is on a computer. Oracle will sell you hard copy manuals but they are £40 each which makes £9000 for the set. Plus the extension you will have to build to store them - at an average of an inch thick they will occupy almost 20 feet of shelving.

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com0tag:blogger.com,1999:blog-24654043.post-1143360601791395152006-03-26T08:21:00.000+01:002006-03-26T09:10:01.816+01:00

In this blog I will be addressing topics of relevance to Oracle DBAs and, to a lesser extent, developers.

Ponder Stibbonshttp://www.blogger.com/profile/10082265621597404777noreply@blogger.com0