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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s