Overview for database

OpenProject installation on Ubuntu with Postgresql and Apache / Nginx

In this note, let's do a quick review on the installation of the very popular open source OpenProject software with Postgresql database and Apache/Nginx webservers. Open Project software has plenty of features, needed for managing the entire project life cycle and is offered with the Community Edition and Enterprise licenses.

The openproject installer for ubuntu configures mysql database and apache webserver by default. We will need to do little bit customization in order to use postgresql as the database for the repository and also check the basic configuration needed to get access to the web UI with either apache or the nginx webserver.

Configuration Info

Operating System : Ubuntu 16.04 ( Xenial )
Database : Postgresql 9.15.2
Web Server : Apache / Nginx
Open Project :  Community Edition

Read more

Written by rajkiran on Saturday June 23, 2018

Image: 2018-06/niagara-600.jpg

Oracle 12c - Non-CDB & CDB

In 12c, for the database creation, you have the option to choose either a non-container database (non-CDB --> pre12c architecture) or a Container database (CDB --> 12c multitenancy architecture). You can easily migrate a non-CDB database into a CDB database. However, You will not be able to migrate a CDB database back to the old architecture, non-CDB database.

By default, database will be created in pre12c mode. "Enable Pluggable Database" clause needs to be used inorder to make it as a CDB.

Read more

Written by rajkiran on Monday June 9, 2014

Image: 2018-06/budha-1.jpg

Oracle 12c - Multi Tenancy Architecture

The most exciting feature in 12c is the multi tenancy architecture which will greatly benefit in the database consolidation with reduction in the overhead of resources needed for maintaining multiple instances and easing up lot of DBA administration activities
For backward compatibility, 12c still supports the traditional architecture. You have to explicitly choose the new architecture option when creating new database.

Read more

Written by rajkiran on Sunday June 8, 2014

Image: 2018-06/ripple-2.jpg

Oracle 12c - Oracle Home Cloning

This note is about cloning and configuring an existing Oracle Home to a new location either on the same server or a different server. Cloning is much quicker especially when you are required to setup multiple database installations.

In this example, an existing Oracle Home on the server, 'kirlinc' is cloned to another server, 'kirlinb' with a different Oracle Home directory.

kirlinc: /data/oracle/app/oracle/product/12.1.0 --> kirlinb:/data/oracle/app/oracle/product/12R1

Read more

Written by rajkiran on Sunday June 8, 2014

Image: 2018-06/faucet-1.jpg

Oracle 12c - Multi threaded Model

For the databases running on UNIX and Linux operating sysems, 12c release introduces new multi threaded model for the execution of oracle processes.
By default multiprocess execution model is enabled for the 12c database. In order to switch to the multithreaded model, the following parameter needs to be set

Read more

Written by rajkiran on Sunday June 8, 2014

Image: 2018-06/water-ripple-3.jpg

Dealing with Oracle Inventory corruption

Oracle Inventory corruption is a very common issue that most of the DBAs run into while working with patches and upgrades. In this quick note, let's check to see how we can fix this with attachHome..

Read more

Written by rajkiran on Saturday June 7, 2014

Image: 2018-06/1528503771_maymont-1.jpg