This is to share with you all that Oracle Published my interview in the
peer-topeer column of Oracle Magazine (March - April 2010 Edition).
I have been given with a challenging task to convert one of our critical production databases, which is of 1 TB (Terabyte) in size, to Oracle 10g RAC with ASM storage option. Even though, there are many methods and tools available to perform this activity, I have preferred to use the RCONFIG tool.
We prepared an input XML file required for RCONFIG tool, and run the RCONFIG utility as follows:
$ cd /oracle/ora102/db_1/assistants/rconfig/sampleXMLs
$ rconfig ConverToRAC.xml
When we start the RCONFIG tool to convert the database to RAC, the RCONFIG tool initially moves all the non-ASM database files to (more...)
Today, there was a huge sand storm in Saudi Arabia. This is the first time I have seen such real and live sand storm covering the Riyadh City in Saudi Arabia.
Here are few pics shared in this blog.
Of late, in one of our test unix (Sun Solaris) boxes, a database user is trying to connect to the database, but getting an error “ORA-27123: unable to attach to shared memory segment”
with permission denied issue.
Initially we thought that there might be an issue with SGA memory area or may be an issue with the shared memory segments and semaphores for the instance allocated. But later we found that the permission on ORACLE_HOME directory got changed accidentally with the full permission.Here are our findings:
$ sqlplus testusr/password@testdb
SQL*Plus: Release 10.2.0.2.0 (more...)
I wanna wish you all a very Happy New Year 2009
before being discussed on “How Important Having UNIX OS Knowledge for Oracle DBA?”
The main reason for discussing this topic is to encourage the novice or junior DBAs to have command on Unix/Linux Operating System as part of Database Administration. Because, when they were asked how comfortable they are working as DBA on Unix/Linux environment, then their responses are as following.“They are pretty much comfortable working and administrating the databases on Windows Operating System as they were trained on administrating the database on Windows OS during (more...)
I’m pleased to inform you all that I have received an email from Oracle ACE Program Committee that I have been nominated for the prominent Oracle ACE Award. I’m honored to be the second person working in the Saudi Arabia to be an Oracle ACE.
Hope you are curious to know who the first person is working in the Saudi Arabia to be an Oracle ACE. Well, he is none other than my elder brother & mentor – Mr. Syed Jaffar Hussain
. We are proud to be the Oracle ACE brothers from one family members and I can (more...)
This blog post is for them; those who are desperately looking for free Oracle Certification dumps.
Well, you might be surprised to see the message of the post is irrelevant to the subject. All my intension is to bring your attention towards “How bad it is? Cheating the Oracle Certifications by simply reading the exam dumps”.
Mr. Paul Sorensen, Director of Oracle Certification, and other certification team members have launched the Oracle Certification Blog , where they blog about everything on Oracle Certification. Interestingly, there are a couple of blog posts on “Cheating Hurts the Oracle Certification (more...)
Choosing whether to go for Oracle 10g OCA/OCP or 11g OCA/OCP Certification is becoming complex to the Novice or Newbie DBAs. And also, I have seen a couple of posts asking such similar certification doubts more frequently in the OTN Forums, when they are not really sure or confused.
Well, this is ever been told by everyone that going for latest version certification is good and ideal. But, what I advise is, first go for Oracle 10g OCA and OCP, then upgrade to Oracle 11g OCP.Following are my views on why to go for Oracle 10g OCA/OCP (more...)
Dear My Blog Readers,
It's been two years that I have lanuched and updated my blog by today. The blog originally started on 12-Dec-2006.
During the last year, I wrote and published good articles. I would like to thank all of my blog viewrs who made my blog popular by reading the interesting posts in m blog.
I hope, I would write more and more good articles which my blog viwers definitely like them and definitely get benifit from them.
Feel free to give comments, suggestions, and advices to improve this blog with more articles.
Once again thank you all.
Here is the list of Oracle University Approved Educational Training Partners/Centers, and the certification test taking sites in Saudi Arabia.Oracle University Approved Education Partners - Kingdom of Saudi Arabia
New Horizons Jeddah - Oracle Approved Education Center
P.O. Box : 52171
Telephone : 026642277
Fax : 026642454
Address : Al Rawda St, Jeddah ,KSANew Horizons Khobar - Oracle Approved Education Center
P.O. Box : 2060
Telephone : 038588882
Fax : 038584014
Address : AL Khaleej Blg, Khobar, KSAAl-Khaleej Training and Education Co.(New Horizons Computer Learning Center,KSA)
Al Wallan Building,
Dear Blog Readers,
Even though we use some of the important Data Dictionary Tables
and Dynamic Performance (V$) views
regularly, sometimes we fall short to recall a particular view, i.e. It’s not easy to remember all the dictionary views.
And also, many times, it’s been asked by novice in the OTN Forums thatWhat is the view to find the information about data files, tablespaces, etc.,?
What are the list of Data Dictionary and Dynamic Performance Views in so and so Oracle Version?
Well, I hope all of we know that there is a data dictionary view called (more...)
After a long wait, I have received the Oracle 10g RAC Expert Certification Kit in my hands today, as I have already taken this exam (1Z0-048) in the month of August-2008. More or less it took more than three months to reach in my hands.
Best of luck everyone who is preparing for the Oracle 10g RAC Expert Exam – 1Z0-048.
Check my other blog post on “How to prepare for 1Z0-048 - Oracle 10g RAC Certified Expert Exam.”
Dear Blog Readers,
Every now and then I do receive e-mails from the novice DBAs saying that:“We could not perform well at the interview, as the questions were too technically based on real time requirements”
“Due to not having real time experience, we failed at the interview to explain the steps/approach to resolve the issue asked”
…… and so on
When I asked them how they prepare and practice the DBA Activities, their response is as follows:“We brought the Oracle DBA Books written by so and so authors for reference.”
“We only practiced the scenarios what was (more...)
Here are the list of Oracle Metalink Notes, I do refer regularly. Moreover, these are very informative. So, I thought of sharing those note ids here with you.Note:
You have to have an account in Oracle Metalink
to access notes.Installation
- How to locate the log files and troubleshoot RapidWiz for R12
- How to locate the Rapid Wizard Installation log files for Oracle Applications 11.5.8 and higher
- Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management (more...)
Dear Blog Readers,
I wanted to have a feedback page as a post in my blog where my blog viewers can post their valuable comments and suggestion about my blog and articles.
In order to serve you better with required information in my blog, please leave your comments/suggestions/doubts/questions/requirements/ etc.
Link for comments here - Feedback Page !
Please check the comments submitted in the comments
Thanks & Regards,Sabdar Syed.http://sabdarsyed.blogspot.com/