Troubleshooting Oracle

Are you new to Oracle? Have you been spending tiresome hours troubleshooting Oracle? Well. I would say ‘Yes’, If someone asked me.But I never think that the time has been wasted. Remember – ‘No pain, No gain’ 🙂

Here are things you need to check when using Oracle. Some of these tips may come in handy, If you are struggling with Oracle.

  • Difference of DBA and SYSDBA ?

SYSDBA and DBA are often misunderstood. In short, SYSDBA is a system privilege whereas DBA is a role. The DBA role does not include the SYSDBA or SYSOPER system privileges. SYSDBA and SYSOPER are special administrative privileges that allow an administrator to perform basic database administration tasks, such as creating the database, instance startup and shutdown, drop a database, open and mount a database, place database in archive log mode or remove it from archive log mode.

Control of these privileges is totally outside of the database itself. The SYSDBA and SYSOPER privileges can also be thought of as types of connections that enable you to perform certain database operations for which privileges cannot be granted in any other fashion. For example, if you have the SYSDBA privilege, you can connect to the database by specifying CONNECT AS SYSDBA ( more info )

  • Is your DB server DHCP enabled?

If your server is DHCP enabled, you will get a test failed condition in verification phase. To solve this add a Microsoft loop back adapter

  1. Go to Control panel->Add Hardware
  2. Select Network adapters
  3. Select Microsoft Loop back adapter
  4. Once Installed, configure properties for IPV4 with following static IP values
  • Have you come across a situation where you are in front of the Db server and trying to connect to the database via sqlplus “/ as sydba”, and get the following error ‘ORA-01031: insufficient privileges

One reason might probably be that you have logged in to the DB server not as the administrator.(or probably not as product owner). If that is the case and if you are unable to log in as product owner, and if you still want to log in to database, there is a work around for you.

  1. Delete and recreate a new password file and give password file name and location, and password
    In DOS prompt type
    orapwd file = c:\ora_home\database\pwdfile.ora password=oracle
  2. Restart Oracle database
    Go to Services and restart the service (OracleService)
  3. Now try to log in to DB via sqlplus “/ as sydba” with new password
Image_For_QADummyAbout the Author 
Tharinda Liyanage is an Associate QA lead in 99X Technologies. Tharinda has more than 7+ years of experience, also he has hands on experience on Performance testing. Other than breaking the code, he likes blogging. His personal blog

Test Automation ( Part 1 )

In software industry nowadays, it is a challenge for any company to continuously maintain and improve the quality and efficiency of software systems development. In many software projects, testing is not happening to a sufficient level due to time or cost constraints. This leads to lack of product quality, followed by customer dissatisfaction and this ultimately leads to increase in overall quality costs.

The main reasons for these added costs are primarily due to:

  • Issues in the test strategy
  • Effort of test case generation is not adequately estimated
  • Development delays always cost testing time
  • Subsequent test maintenance cycles

Test automation can improve many areas in a software product life cycle. In addition to the effectiveness of testing, even the accuracy will be higher when comparing with a manual tester. Therefore, by introducing automation the manual testers can focus more on business scenarios and let the automation suite to work on the functional tests.

The automation of tests are initially associated with increased effort most of the time, but the related benefits will pay off. This is called ‘Return on Investment’.


Say bye to (static) screenshots

Screenshots in a bug report always play a big role. It saves lots of explanation and makes developer’s life easier. But sometimes static screenshot won’t be good enough to convey the message. Screen Recording would be good alternative in this case, But when considering the size of the recorded file, it may also not be the ideal solution.

So how about having a screenshot, with all the steps of a bug. Sounds cool, right ?

Say hello to gif

.gif image format is very small in size and can be easily uploaded to the bug tracking softwares in a few minutes.

How to create a .gif easily

First install ImageMagic via Homebrew ( Instructions on installing Homebrew can be found in here)

$ brew install imagemagick

Let’s take a Gmail login as our example. A user goes to the Gmail login and enters the user name. Then clicks on the Next button and enters the password ( Incorrect one in this scenario ) and clicks on the Sign In button. User gets an error message.


Mobile Application Testing – Part 1

How many apps do you use after its initial download? or in other words, have you ever downloaded an app and delete it after few minutes/weeks. Yes, would be the answer from most of us.

Recent study conducted by the 34SP.com ( Full report in PDF ) found out that 20% of people regularly delete apps within just three months of downloading them, while 39% often delete apps because they’ve been ‘useless’.

Here are some of the interesting facts from the survey,

  • 30% of respondents saying their mobile phone is the main device they use to access the internet. With Smartphones now providing instant access to the World Wide Web at the click of a button, we predict this number will be closer to 50% by 2016.
  • A third (32%) of respondents in our survey stated they ‘couldn’t live without’ their mobile phone. A further 36% said they were ‘addicted’ to checking their mobile phones, or know someone who is.

So apparently these numbers would increase in future. But what good would do, If your application is not satisfy the user.

Evolution of Mobile app ( Mobile web vs Mobile app )

Nowadays everyone wants to make a mobile app, even without considering the end goals or the cost. Point is that Mobile app should accomplish a specific target which couldn’t achieve by a mobile browser.

Mobile website should be your first step in making a presence in mobile world. When you get more business, when you get more personalized requirements from customers, then it would be the ideal time for mobile app.