Database Administrator Salary

Database Administrator Salary Statistics

The role of database administrator, or DBA, is a highly skilled and specialized one. Because of this the average database administrator salary is higher than most salaries in the I.T. world. Not only this, but average database administrator salaries are showing good year on year increases too. Add to this the nature of the job … Read more

Oracle Case Sensitive Passwords

Oracle Case Sensitive Passwords

Oracle case sensitive passwords were introduced in version 11g of the database. These passwords can include a mixture of special characters and/or multibyte characters. Oracle 11g and later default to case sensitive passwords when you create a new user. The same is true when a user or DBA changes an existing password. Oracle Case Sensitive Passwords … Read more

The Oracle Job Scheduler

Oracle Job Scheduler

Despite the fact that the Oracle job scheduler was introduced back in the 10g version of the database, it seems a lot of people are still using the old job scheduling mechanism – DBMS_JOBS. This is despite the many advantages the job scheduler has in terms of both functionality and ease of use. This article … Read more

Oracle DBA Certification – A Few Thoughts

Oracle DBA Certification

Oracle DBA certification involves a lot of work  and a big time commitment, not to mention the cost. This raises the obvious question as to whether the certification is worth it. If the company you work for is willing to foot the cost and will also allow you the study time in work hours, then … Read more

DBA Career – How To Become A DBA

Oracle DBA Career

If you’re thinking about a DBA career, then it’s worth knowing what you’re getting yourself into! It takes a certain type of person to make the best DBAs in my opinion. DBA Career – What Is A DBA? A DBA, or database administrator, is responsible for keeping databases up and running and stable. Production databases … Read more

Oracle Create Database Link Command

Oracle Create Database Link

If you’ve got two Oracle databases and you want to query the data from one database whilst connected to the other one, you can create a database link between the two. Executing the ‘CREATE DATABASE LINK’ command in the first database will create a schema object in it which allows you to access objects/data in the … Read more

Log File Sync Wait Event

Oracle Log File Sync Wait Event

In the Oracle database, when a user commits or rolls back a transaction, the redo data for the session (that’s currently held in memory) has to be written to the redo log file on disk. The user session tells the LGWR process to write the contents of the log buffer to the redo log file. … Read more

SQL Injection Tutorial

Sql Injection Tutorial

What Is SQL Injection? SQL injection is a technique used by hackers to get access to your data.  It basically involves hackers taking advantage of user inputs on web pages in order to execute SQL statements against your database. If the input isn’t validated properly, the hacker can enter carefully constructed data with the effect … Read more

ORA-12154: TNS Could Not Resolve Service Name

Oracle Error - ORA-12154: TNS Could Not Resolve Service

When you, or more accurately an application program, attempts to establish a connection to an Oracle database, it must look up the connection data for the database service that you are trying to connect to. Where it looks for this connection data depends on how your client is configured; there are several ways you can configure … Read more

ORA-00600 [kcratr_nab_less_than_odr] After Power Failure

Oracle ORA-00600 Database Won't Open Error

A client of mine suffered a power failure the other day and when the power was eventually restored they hit a problem when they tried to restart one of their databases. The opening of the database failed with the following error: ORA-600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [896], [328], [369], [], [], [], [], … Read more