Posts by Fahd Mirza

Is ADR Really Automatic?

Oracle has consolidated the diagnostic information of database under one umbrella called as Automatic Diagnostic Repository (ADR). This repository is XML-based and that opens up new vistas for future Oracle diagnostic tools to manipulate the hierarchical data.

ORA-00214 and Control File Mismatch

The scenario goes like this: The instance was in nomount stage and was unable to mount the database. Checked the uptime, and found that the server was rebooted some 5 minutes ago, and the instance tried to come up automatically but failed to mount the database. Checked the alert log and found the following error: ORA-214 signaled during: ALTER DATABASE MOUNT…Made a quick searched about ORA-00214 and it was about mismatched control files. It was probably due to the fact that control files got out of sync as the not-so-graceful reboot of the server was done without first cleanly shutting down the database. This is what doc says:

Give Me Reason, Take Me Higher

Pythian, a cluster of passionate DBAs, gives freedom to their DBAs to act. Here, with many companies, and with many databases of a different nature with varying requirements the DBAs are kept on fire. DBAs find reasons to come to their job every day, and when they do and learn new things every day, they rise to new heights. With new heights comes sense of achievements which generates happiness and when the DBAs are happy, databases under them touch new heights of mirth and perform beautifully. That is what Pythian is all about in my opinion.

Log Buffer #202, A Carnival of The Vanities for DBAs

Welcome to Log Buffer, the weekly roundup of database industry news. We’re only a week or so away from Oracle OpenWorld. Everyone is buzzing with activity, promoting their speaking sessions and making last minute plans. For all of you bloggers who will be attending, don’t miss the annual Bloggers Meetup, announced recently by Alex Gorbachev. “Count yourself in” if you’ll be joining the gang so that accurate attendee numbers can be provided to Jillian’s to ensure everyone is well fed and watered ;)

Page 21 of 21« First...10...1718192021