Troubleshooting Tips For 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.


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

  1. Restart Oracle database
    Go to Services and restart the service (OracleService)
  2. Now try to log in to DB via sqlplus “/ as sydba” with new password
Tharinda Liynage

Tharinda is working as Associate QA Lead at 99X Technology. He has over 08+ years of Software testing experience.

No Comments

Post a Comment