DBCA

Password Device Fun

Friday, August 31st, 2007

Each Oracle database (or ASM instance) can have a password file associated with it to allow users to connect as a privileged user (SYSDBA) through the listener. Even when connecting from the same host running the instance, you will not be able to make a SYSDBA connection through the listener, if a password file […]

Key Metalink Notes

Tuesday, July 31st, 2007

Everyone has their goto places for information on the Internet for Oracle information, and one of the key sites is Oracle’s support site, Metalink. Sometimes it can be difficult to find useful information on there so I thought it might be helpful to list a few notes I use regularly. You will need […]

Use Silent Mode!

Saturday, July 14th, 2007

I simply refuse to do my database provisioning using interactive methods. Just about every Oracle command has an option to have no interactive steps.
These are the only times I think it makes sense to use interactive processes:

When Oracle support tells you to.
When you are learning how to do something.

Excluding those cases, do yourself a […]

Create Databases Using a Seed

Tuesday, June 26th, 2007

Everyone knows that you can create a database by running the perennial CREATE DATABASE or you could use the DBCA to create a database from scratch, which handles all the ancillary tasks as well. There are some cases where a third option would be useful, for instance if you want to create a database that […]