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
Colombo Selenium Meetup

Preview: Colombo Selenium Meetup

It’s that time of year again. Not the T20 World cup. It’s the Colombo Selenium Meetup (CSM), A meetup for automation enthusiasts in the Software Industry.


For the folks who don’t know about CSM, It is an open forum where Selenium users of all skill levels can get together to communicate, learn, network,or just have a good time. This was initiated by 99X Technology in 2012. We have been able to conduct different meetups at different locations since then ( A big thank you to the facilitators including 99XT / WSO2 / Leapset CakeLabs / Netstarter )

Your Investment

Apart from time ( and of course, We can’t forget your transportation cost to the venue! ) there are no additional costs to be a part of this meet up. It’s totally free!

Food tips : For all past meetups facilitators were generous enough to provide refreshments ( Thanks again 🙂 ). We do hope that tradition will continue for future meetups as well.

How can you participate ?

Since there are no entrance tickets, all you need to do is participate. But it is always appreciated If you can RSVP your attendance to the meetup in It would be appreciated by the hosts to make necessary arrangements.

Next meet up

Venue: 99X Technology premises

Time: 02nd of March 2016  – 5.45 p.m onward

Topics : Introduction to Automating UI tests for hybrid applications with Appium by Ruzaik Refai of 99XT


See all you enthusiasts there!

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.



Homebrew is a package manager for OS X. It is designed for installing UNIX tools and other application on MAC OS. No need of drag and drop the .dmg files to the Applications folder.

Homebrew Cask extends the Homebrew capabilities, with this support, it supports to install larger binary files.


Homebrew requires to have Command line tools for XCode on Mac. This can be done by either installing full XCode application from Apple or install only the command line tools, which is the easiest way to do this.

All you need to do is open a terminal and type below command. Then press Enter.

xcode-select –install

Install Homebrew

Type the below command on a terminal & hit Enter.

$(curl -fsSL


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 ( 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.


Hello iOS 9

Update: Apple released another update to the iOS 9 ( iOS 9.1 Public Beta 1 ) on 9th of September

Along with the other Mac operating systems, Apple decided to release another operating system update to iOS devices. Like the El Capitan, this is not officially released to the public. But can access the features through the Apple beta software program.

This is all what you need to know If you are going to update your iPhone to the iOS9

First thing first,

  • You need to have Apple ID – If you don’t have Apple ID, You can easily create a one from here.
  • Archive an iOS backup with iTunes – You are about to install a pre-release operating system. It is always advisory to backup the content. In case, If anything goes wrong, You will be able to restore the backup easily.
Righto, If you are done with above two steps, Proceed to below steps.