the 10.2 dbca still leaves much to be desired

One might think that the current version of the database creation assistant
- after being revised in 8.1.7, 9.0.1, 9.2, 10.1 - would be a mature product
in the 10.2 release of the database server software.

Alright, no one that has actually used it would make that (wrongful)
assumption.

What irked me today, was that for a Standard Edition install (do not create
starter database) that the dbca still includes creation scripts for

Label Security
Spatial

Aren't there any loops closed there regarding feedback from customers?
If 10g R2 will need less database administration, why is it that from a
dbca-created database that one would manually have to remove the components
that dbca is too brain-dead to determine require the enterprise edition of
the database server software to be installed?

Anyone that has upgraded a dbca-created standard edition 9.2 database to
10.1 knowns that dba_registry will have stuff in there that isn't needed and
is invalid after the upgrade.

Seeing that the past 2 critical patch updates had a rather larger number of
gaping holes in objects owned by oracle-provided schemas such as mdsys -
wouldn't the Oracle community in general have less vulnerabilities if such
components were not installed by default - escpecially where they cannot
even be leveraged?

I guess that's it for now.

Paul


<sample dbca-generated database create script>

set verify off
PROMPT specify a password for sys as parameter 1;
DEFINE sysPassword = &1
PROMPT specify a password for system as parameter 2;
DEFINE systemPassword = &2
host D:\oracle\product\10.2.0\db_2\bin\orapwd.exe
file=D:\oracle\product\10.2.0\db_2\database\PWDmydb.ora
password=&&sysPassword force=y
@D:\oracle\admin\mydb\dbca\CreateDB.sql
@D:\oracle\admin\mydb\dbca\CreateDBFiles.sql
@D:\oracle\admin\mydb\dbca\CreateDBCatalog.sql
@D:\oracle\admin\mydb\dbca\JServer.sql
@D:\oracle\admin\mydb\dbca\odm.sql
@D:\oracle\admin\mydb\dbca\context.sql
@D:\oracle\admin\mydb\dbca\xdb_protocol.sql
@D:\oracle\admin\mydb\dbca\ordinst.sql
@D:\oracle\admin\mydb\dbca\interMedia.sql
@D:\oracle\admin\mydb\dbca\cwmlite.sql
@D:\oracle\admin\mydb\dbca\spatial.sql
@D:\oracle\admin\mydb\dbca\ultraSearch.sql
@D:\oracle\admin\mydb\dbca\labelSecurity.sql
@D:\oracle\admin\mydb\dbca\ultraSearchCfg.sql
@D:\oracle\admin\mydb\dbca\postDBCreation.sql

Other related posts: