content top

TROUG Day Ankara 2014

poster_ankara14As Turkish Oracle User Group (TROUG), we will organize our second meeting in Ankara on December 23rd. The event will be held at the Chamber of Electrical Engineers (EMO). The main theme of the meeting is Oracle 12c. There will be 4 sessions about new features of Oracle 12c (Database In-Memory, Active Data Guard, RAC and Flex ASM and Multitenancy). I usually do presentations about Enterprise Manager but this time, I have picked a more popular subject, and will do a presentation about Oracle Database In-Memory. I’ll talk about why memory is faster (so obvious right?), buffer cache, columnar storage technology, competitive products and why Oracle’s in-memory is different.

There will be also interesting sessions about BI/DW, PL/SQL, Database Security and Database Administration.

Read More

Tips and Tricks for Installing Ops Center 12c R2 (PSU2)

In one of my old posts, I wrote a step by step guide to install Ops Center on Linux. I still get questions about installation, mostly about installing repository Database. So I have downloaded latest patch set version if anything has changed about installation, and decided to write tips and tricks to help Ops Center users. If you have read my previous blog, or you are already an Ops Center user, you may remember that Ops Center can create required Oracle users, and install Oracle Database by itself. You can see the Ops Center web site, that you need to follow My Oracle Support Document 1450669.1 to download to obtain Oracle Database 11g for Ops Center, and the MoS document says, you need to download 11.2.0.3 files and put them into “/var/tmp/downloads” folder. I don’t know if these RPMs are still valid, the latest Ops Center seem to support 11.2.0.4. So I recommend you to download Oracle 11.2.0.4 (patch 13390677). You need to put the zips files into /var/tmp/downloads folder. After you copied files, the creation of users and setting up local repository database is totally automated by the Ops Center installer.

I always think that Ops Center is a very smart installer, and it can handle almost everything. On the other hand, instead of dealing errors/warnings while installing, I recommend you to use OCDoctor, a small utility to check prerequisites. Download the latest OCDoctor zip file, extract it and run it:

Read More

How to Backup and Restore PostgreSQL 9.3 Databases

In my previous blog post, I explained how to install PostgreSQL 9.3 on Oracle Linux. As a DBA, one of the first things we want to learn is how we can recover the database in case of a failure. So in this blog post, I’ll show how to backup and restore PostgreSQL databases in a server. We’ll backup PGDATA directory, so it’ll contain all databases in the instance (remember that PostgreSQL is a multitenant database).

PostgreSQL supports Write Ahead Log (WAL) mechanism like Oracle. So everything will be written to (redo)logs before they written into actual datafiles. So we will use a similar method to Oracle. We need to start “the backup mode”, copy the (data) files, and stop the backup mode, and add the archived logs to our backup. There are SQL commands for starting backup mode (pg_start_backup) and for stopping backup mode (pg_stop_backup), and we can copy the files using OS commands. Good thing is, since 9.1, PostgreSQL comes with a backup tool named “pg_basebackup”. It’ll do everything for us.

Read More

How to Install PostgreSQL 9.3 on Oracle Linux

For whom are not familiar with PostgreSQL, it is an open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. Like all other enterprise companies, we use different databases beside Oracle to lower the costs. We prefer PostgreSQL instead of Microsoft SQL Server, because it supports PL/SQL for some degree.

In this blog post, I’ll try to show how to install PostgreSQL using YUM. YUM (Yellowdog Updater, Modified) is an open-source command-line package-management utility for Linux operating systems using the RPM Package Manager. It handles library dependencies, so it’s the easiest and maybe the best way to install any RPMs. In this blog post, I’ll install PostgreSQL on Oracle Linux because I use Oracle Linux when I need a Linux OS, and its support costs are lower than Redhat Enterprise Linux. In next weeks, I’m also gonna blog about backup and replication for PostgreSQL, and maybe (not promising) blog about some key concepts of PostgreSQL such as MVCC, vacuum and vacuum freeze.

I assume that you can install Redhat or Oracle Linux. You may read my old post about installing Oracle Linux, hopefully it would be useful. Anyway, if our Linux server is ready, we can download and install Repository RPM for our server. Visit http://yum.postgresql.org.

postgresdownload

Read More

Simple Query to Check if Your EM12c Plugins Are Uptodate

It’s recommended to use latest plugins with EM12c (to minimize bugs, better support for new releases of target etc), and you probably set notifications to get mails about plugin updates, but sometimes you just ignore them because you don’t have time. So you may want to check if any plugins you use have updates. It’s possible to do it using EM12c web interface. All you need is to go to “self update” page, click on “plugin updates” and then sort the list by plug-in name.

pluginupdates

Read More
Page 1 of 3112345...Last »
content top