How to move or rename Oracle Home If you want to rename Oracle Home you usually need to: 1. uninstall existing Oracle Home 2. reinstall Oracle software to the right directory that will be the new Oracle Home. You cannot just move Oracle Home because… Read More
Creation of Files in UNIX (Session-03). LOGIN IN : As discussed earlier this is one sort of security measure as soon as user switch on the system the user will be prompted for login id.This login id is created by the administrator(#). At the Login: prompt,… Read More
Unix Shell Scripting For DBA’s (PART – 01) reference of this article from : www.orskl.com What is SHELL ? A Shell provides you with an interface to the Unix system. It gathers input from you and executes programs based on that input. When a program finishes executing, it… Read More
Oracle : Scheduling crontab to send EMAIL in Unix $ vi test.bash #!/bin/bash #Script to perform testing ## Environment variables TODAY=`date +%d-%b-%Y-%H:%M:%S` export ORACLE_HOME=’/u01/app/oracle/product/12102′ export ORACLE_SID=’ORCL’ export ORACLE_BASE=’/u01/app/oracle’ export PATH=$PATH:${ORACLE_HOME}/bin export MAILIST=’ktexperts@gmail.com’ export LOG=’/tmp/test_mig.log’ #Function to trigger email function mailog { cat ${LOG} | mailx… Read More
BASIC ARCHITECTURE OF UNIX OPERATING SYSTEM. UNIX operating system is like a layered one we first find H/W block next the heart of an operating system i.e, KERNEL, then SHELL ,and then users hence with this architecture there is something new called shell which we… Read More
Introduction to UNIX. WHAT IS UNIX ? Unix is an multi user operating system designed for high end server applications. The abbreviation of UNIX is UNIPLEX INFORMATION AND COMPUTING SYSTEM. Unix was compiled in 1975 by KEN THOMPSON and DENNIS RITCHIE in C language. WHY… Read More
Configure Postfix to use Gmail as a Mail Relay(UBUNTU Server) If you have a Gmail account, you can configure your Material Transfer Agent (MTA) to relay outgoing mail through Gmail. This gives you the benefit of Gmail’s reliability and robust infrastructure, and provides you with… Read More
IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS (PART -02) IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS. MATERIALIZED VIEW WITH REFRESH FAST : Now that we know how materialized view logs track changes to base tables we can use them to perform fast materialized view refreshes, i.e. refreshes where… Read More
IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS. Materialized views are schema objects that can be used to summarize, compute, replicate, and distribute data. They are suitable in various computing environments such as data warehousing, decision support, and distributed or mobile computing. In data warehouses, materialized… Read More
Tools for Administering the Database The intent of this book is to allow you to quickly and efficiently create an Oracle database, and to provide guidance in basic database administration. The following are some of the products, tools, and utilities you can use in achieving… Read More
