11g Database Creation with DBCA

After successfully completing Oracle 11g on Red Hat Linux(v4), I thought of creating a new database using DBCA utility instead creating manually. While using DBCA utility to create a new database, I have found following three new changes:

1. If no listener is configured, DBCA utility prompts a message to configure a listener first.
2. Security Settings gives the following options:
- Keep the enhanced 11g default security settings(recommended)These settings include
enabling auditing and a new default password profile.
- Revert to pre-11g default security settings
3. Automatic maintenance task tasks
such as optimizer statistics collection and proactive advisor reports.
The default maintenance windows are 10:00 pm to 2:am on weekdays and all weekend long.

When I count records from v$system_event, surprisingly, I found only 77 records? Is it okay?

Jaffar

11g 'hot patching'

One feature which caught my extreme attention while installing 11g was 'hot patching' feature.

Oracle says: ''hot patching,' which improves system availability by allowing database patches to be applied without the need to shut databases down."

For me, it is really hard to digest about upgrading (applying patches) while they are currently running. However, if this is believed to be true, then, definitely this feature going to resolve the hassles of shutting down the production databases while applying patches.


Jaffar

11g Installation

Last night I was able to successfully installed Oracle 11g on Red Hat Linux(v4). The only problem I have faced during the installation stage (the prerequisite check stage) was about missing Red Hat rpms (three) and minimum memory required for installation(I have installed on a virtual machine with 700+M) .

I am very inquisitive to test RMAN enhancements and also Active Standby Database feature.

Jaffar

Oracle 11g Metalink notes

Metalink has couple of new notes/articles about Oracle 11g Active Duplicate Database and DBCA enhancements. Following are the metalinks notes :

11g BDCA New Features / Enhancements - 454631.1
Automatic Memory Management(AMM) on 11g - 443746.1
RMAN 'Duplicate Database' Feature in 11G - 452868.1
Finding alert.log file in 11g - 438148.1

Happy reading,

Jaffar

Celebrating 60th Indian Independence Day

Indian Independence Day

I wish all the Indians across the global a very happy independence day.

God bless all,

Happy Reading,


Jaffar