Hannie
- November 8, 2022
- 0 Comments
Vi editor in Linux
Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi editor tool is an interactive tool as it displays changes…
- February 7, 2018
- 0 Comments
Install PostgreSQL
1. yum install postgresql-server postgresql-contrib 2. su postgresql 3. postgresql-setup initdb 4. vi /var/lib/pgsql/data/pg_hba.conf 5. Find the lines that look like this near the end of the file and change…
- February 5, 2018
- 0 Comments
Monitoring in Postgresql
In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table. They remain present until a VACUUM is done. Therefore it’s necessary to do VACUUM periodically, especially…
- January 31, 2018
- 0 Comments
Restore Oracle DB in Linux
To restore a database from the default directory /backup/rman use the cmd cmd: RESTORE DATABASE; Restore Specific Tablespace: Instead of restoring the full database, you can also restore only specific tablespace…
- January 31, 2018
- 0 Comments
Backup Oracle DB using RMAN in linux
1. View Current RMAN Configuration Before we take the backup, we have to configure certain RMAN parameters. For example, how long you want to reatain the RMAN backup, etc. To…
- January 31, 2018
- 0 Comments
Oracle DBA Roles
A database administrator’s responsibilities can include the following tasks: Installing and upgrading the Oracle Database server and application tools Allocating system storage and planning future storage requirements for the database…
- January 30, 2018
- 0 Comments
Orcale DataBase Set up in Windows
Go to orcale.com Go to downloads as shown in the image and select the compataible version of the system by accepting the license and click on it to download. Provide…
- December 10, 2017
- 0 Comments
Basic Commands in Mysql
-> This is the world’s second most popular and widely used open source database. -> All the database names, table names and table fields name are case sensitive. -> To switch…