How to Create a database using oracle database configuration assistant (ODCA)

Ordinarily oracle universal installer (OUI) automatically runs oracle database configuration assistant (ODBCA) during installation unless otherwise stated that only software should be installed.

Note that when you create a new database, the new database typically use the same oracle home directory as the first database but stores database data-files separately from the first one.

Read More

How to Install Oracle 11g Software

During Installation; you are given the option or opportunity to to create a database. If u wish to the OUI (oracle universal installer) automatically starts oracle database configuration assistant (ODCA) to guide you through the process of creating a database.

Before installation process; you must

Read More

ROLES OF AN ORACLE DATABASE ADMINISTRATOR

Oracle database is relational database with markup and extensive language (xml). Data is stored in two dimensional tables consisting of rows and columns. oracle database enables you to store, update and efficiently retrieve it with high degree of performance and reliability. In case you are wondering why I chose to write on oracle database. This is one the many reasons why Database administration is best with oracle database. If you have not read my post, you can take a glance here. I chose it also because its where I specialize.

Read More

Overview of Database Administration

Database Administration is a very interesting yet tedious work to do. It can be very interesting if its something you have passion for and loves doing it everyday of your life aside being a job for you. Hear me, there is a lot of money in there  for grabs as a database administrator but don't rush into it because of the money, but for the love of it else you will get tired and bored with all the jagons. Just like I advice people, "Always go for a job you have passion for and loves doing  everyday of your life. I am not trying to scare you. Don't get me wrong database administration can be very fun and interesting.

Read More