All Aboard for OpenWorld
September 18, 2008 — fuadarHashtag #oow08 will be used for twitter . For a mostly complete list of Oracle tweeters you can look here. Flickr and all other tagging services can use #openworld08 for tagging blogs and pictures. You can also tweet @oow with your tweet to get into the openworld public timeline with your name. You can find Oracle Ace’s at the OTN Lounge . The Hours are posted here .There are 8 Lounges this year at OpenWorld. All the details can be found at the OpenWorld homepage and OTN night should be real fun. If you are there dont miss to attend some of the UnConference sessions too a list of which can be found here. The Sunday user group session are very interesting and do signup for the exam cram on sunday . This Year its 11g new Features,Signup details are here. OCP’s get a crack with free self test software exams at the OCP Lounge Details here.
There will be a lot of blogging activity over the next couple of days about the various aspects of the Oracle Openworld conference and all the networking opportunities. The Oracle Openwordl Page is being constantly updated with new stuff here.
As Usual the community has come up with all sorts ofways to support Oracle Openworld with the Friendfeed room . Eddie Awad’s Openworld 2008 Aggregator using Yahoo Pipes .Oraclecommunity.net and Oracle Mix are there for all social junkies. Matt Topper has Collok a collborative site to send tweets and sms about your sessions. As usual Orana will be aggregating all the blogs.
Mobile Services from oracle will be available Sat September 20th with details here. Oracle has a Green Initiative This year and there are a lot of sessions about the Green Initiative. Did i mention Michael Phelps is also there. There is a lot more there with the exhibition hall and networking parties all week long.
I dont know how to clone myself to attend all the interestign sessions out there but i hope to see all my fellow tweeters and bloggers over the course of this conference and all aboard for a wonderful conference.
Duplicate in Oracle 10 to a remote server
August 19, 2008 — fuadarAfter we resolved the issue and learned the lesson that a simple mistake can lead to hours of rman frustration . I thought it would be interesting to document .
The problem
Duplicate development database to new development server.
Tool Used
Rman command line
Server
AIX 5.3
After the DBA took the backup and had the backup NFS mounted on the system. He was unable to run duplicate on the new node. All auxialliary setup was complete and had seemed perfect.
An Rman catalog was used and Rman kept complaining that there were no backups to restore.
We tried a couple of things
remounted the NFS with the options rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0
based on Note:424785.1 which we thought didnt work
Looked at Note:356199.1 and set event=”10298 trace name context forever, level 32″
This didnt help either
The duplicate script was simple
connect target test/test@test
connect catalog abc/abc@abc
connect auxiliary aux/aux@aux
run {
duplicate target database to aux
}
The commands were being executed from the auxiliary server and network config was testedto be valid.
The Solution
The problem turned out to be that the dev database was changed to be an archivelog database and the archive logs were not backed up as part of the backup process. Rman kept generating an SCN that was in the archivelogs that it could not find in the catalog at all( I’m guessing since it was connected to the target it got the info from there).
As soon as the archive logs were backed up and made available the duplicate worked like a charm.
Moral of the Story : Rman needs less cryptic messages
Duplicate in Oracle 10 to a remote server
August 19, 2008 — fuadarAfter we resolved the issue and learned the lesson that a simple mistake can lead to hours of rman frustration . I thought it would be interesting to document .
The problem
Duplicate development database to new development server.
Tool Used
Rman command line
Server
AIX 5.3
After the DBA took the backup and had the backup NFS mounted on the system. He was unable to run duplicate on the new node. All auxialliary setup was complete and had seemed perfect.
An Rman catalog was used and Rman kept complaining that there were no backups to restore.
We tried a couple of things
remounted the NFS with the options rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0
based on Note:424785.1 which we thought didnt work
Looked at Note:356199.1 and set event=”10298 trace name context forever, level 32″
This didnt help either
The duplicate script was simple
connect target test/test@test
connect catalog abc/abc@abc
connect auxiliary aux/aux@aux
run {
duplicate target database to aux
}
The commands were being executed from the auxiliary server and network config was testedto be valid.
The Solution
The problem turned out to be that the dev database was changed to be an archivelog database and the archive logs were not backed up as part of the backup process. Rman kept generating an SCN that was in the archivelogs that it could not find in the catalog at all( I’m guessing since it was connected to the target it got the info from there).
As soon as the archive logs were backed up and made available the duplicate worked like a charm.
Moral of the Story : Rman needs less cryptic messages
My First Openworld
August 18, 2008 — fuadarWell thanks to the folks at Oracle I get to go to my First Oracle Openworld. While i have had the opportunity to go to IOUG and Hotsos have never had the chance to make it to Openworld.
Here is a list of the sessions i plan to attend based on my initial run thru of the schedule builder. I’m still hoping to get into the exam cram on sunday and maybe find more sessions of value
My First Openworld
August 18, 2008 — fuadarWell thanks to the folks at Oracle I get to go to my First Oracle Openworld. While i have had the opportunity to go to IOUG and Hotsos have never had the chance to make it to Openworld.
Here is a list of the sessions i plan to attend based on my initial run thru of the schedule builder. I’m still hoping to get into the exam cram on sunday and maybe find more sessions of value
Dataguard 11g – No more same hardware/software requirement(partially)
August 8, 2008 — fuadarWhile trying to look at dataguard as a reporting environment i found a very neat and fundamentally cost saving feature added on to dataguard in Oracle 11.
According to the Docs
“As of Oracle Database 11g, Data Guard provides increased flexibility for Data Guard configurations in which the primary and standby systems may have different CPU architectures, operating systems (for example, Windows & Linux), operating system binaries (32-bit/64-bit), and Oracle database binaries (32-bit/64-bit).
This is very interesting and actually provide a lot of cost savings to companies that have systems using Windows based servers and can purchase cheaper linux boxes and make that available . The problem is based on the matrix in note 413484.1 pretty much only Windows and Linux can live in a mixed environment . AIX and Solaris can only live with the same architecture.
