I just back to office after a month vacation and going through the back log/pending work. Currently, having an uphill task of upgrading an Oracle 9i data warehouse database (3 TB size) to Oracle 10g and also migrating this database from HP to AIX.
Its been nearly two months that I didn't write anything to my blog also didn't participate in any kind of database forums as I was gearing up for my every first seminar (RMAN). I have successfully delivered my one exclusive RMAN seminars in Sweden and Denmark respectively in September month. Good amount of participants were present, 20 participants in Sweden and 28 participants in Denmark. Although, the seminars went well, I felt still there was a lot room for improvement. I was bit worried about the time constraint to complete the seminar. In the modified RMAN seminar contents, now, more practical examples with 11g RMAN new features and changes are also added.
The first thing which I did was installing 11g on Windows OS in my PC. I am more interested to test RMAN changes and testing Active Standby Database(snapshot database) in 11g database. I am also busy in preparing a new one day exclusive seminar on High Availability Data Guard.
In my next blog, I am going to discuss about my experience with Active Standby Database and findings.
Thank for your time,
Jaffar
Whatever topic has been discussed on this blog is my own finding and views, not necessary match with others. I strongly recommend you to do a test before you implement the piece of advice given at my blog.
Expert Oracle RAC
11.12.2007
8.27.2007
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
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
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
8.26.2007
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
I am very inquisitive to test RMAN enhancements and also Active Standby Database feature.
Jaffar
8.18.2007
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
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
Subscribe to:
Posts (Atom)