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