(Till 12th May 2013)
New Release Environment
(From 13th May 2013 onwards)
Oracle Linux Release 5.4 (64-bit)
Oracle Linux Release 5.4 (32-bit)
Oracle Database Enterprise Edition Release
Oracle Database 11g Enterprise Edition Release 11.2.0. (more...)
Unable to connect to database
ORA-12514: TNS:listener does not currently know of (more...)
Dear Blog Viewers,
It’s been quite a long time that I had updated my blog. I could say, it’s been almost over two years that I haven’t updated my blog. Surely, this has made upset to my regular blog viewers.
Well, there were various reasons why I didn't update my blog.
To fill the huge gap occurred in updating the blog; I have now decided to update my blog with new concepts/my experience/views about Oracle DBA at least every now and then whenever time permits me from my busy schedules.
It’s been quite a long time that I had stopped preparing for (more...)
This is to share with you all that Oracle Published my interview in the
peer-topeer column of Oracle Magazine (March - April 2010 Edition).
How we faster the process of converting a non-ASM single-instance database to RAC database with ASM using 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/sampleXMLsWhen we start the RCONFIG tool to convert the database to RAC, the RCONFIG tool initially moves all the non-ASM database files to (more...)
$ rconfig ConverToRAC.xml
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...)
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 ,KSA
New Horizons Khobar - Oracle Approved Education Center
P.O. Box : 2060
Telephone : 038588882
Fax : 038584014
Address : AL Khaleej Blg, Khobar, KSA
Al-Khaleej Training and Education Co.(New Horizons Computer Learning Center,KSA)
Al Wallan Building,
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 that
What 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.”
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.
Note: 452120.1 - How to locate the log files and troubleshoot RapidWiz for R12
Note: 329985.1 - How to locate the Rapid Wizard Installation log files for Oracle Applications 11.5.8 and higher
Note: 362135.1 - Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management
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 item below.
Thanks & Regards,
I have been looking for the steps/code to prepare my blog with 3 column template, but couldn’t get a proper reference for that. Luckily, today I came across a wonder full blog for “3 Column Templates Step by Step Guides”, which will fit to my blog template.
It’s as easy as simple.
Step -1: Before going to change the original template, I gave a try on the test template by creating a new blogspot for testing perpose ( This Step-1 is optional)
Step -2: Take the backup of template before trying out any customization that requires direct modification of the (more...)
Oracle Database Version: 10g R2 (10.2.0.1)
Application User: APPUSR
Error: ORA-28000: the account is locked
Login as SYSDBA
SQL> conn /as sysdba
Check the APPSUSR account status.
SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPUSR’;
USERNAME ACCOUNT_STATUS PROFILE
-------------------- -------------------- ---------------
APPUSR LOCKED(TIMED) DEFAULT
Here we can see the account status is LOCKED (TIMED) and the default user’s profile is DEFAULT.
Check the resource limits of DEFAULT profile.