Oracle 11g Memory Advisor feature.

Among many dynamic views oracle has added a new view,
V$MEMORY_TARGET_ADVICE. The purpose of this view is 
to give recommendations related to the 
sizing of the memory_target parameter.

Before going further please make sure that memory
management is set to automatic in your database,
otherwise this feature will not work.

Read more >>

SQL*LOADER

This example illustrates how to insert data from a text file to a table in the HR schema using SQL loader.

The data file is named as “records.dat”.
The controlfile file is named as “records.ctl”.
The logfile is named as “records.log”.

1)Connect to the HR schema and create a tables as “TEST”.

Read more >>

How to repair broken MBR in RHEL 6 ?

1) Go to the grub command line when the system boots up.
2) Find the partition which contains the grub.conf file.

grub> root
  (hd0,0): Filesystem type is unknown, partition type 0x8e

3) Reinstall grub on the returned partition.

grub> setup (hd0)

4) The above command should fix your broken MBR, now reboot the system.

grub> reboot

Read more >>

How to enable grouplist in yum : RHEL 6 ?

You may encounter an error in yum if you type the following command :

[root@ora ~]# yum grouplist

Error: No group data available for configured repositories.

Read more >>

How to configure Samba Server in RHEL 6 ?

# 1 Configuring a shared directory which can be accessed by anyone.

Server Settings

[root@ora ~]# yum –y install samba*
[root@ora ~]# mkdir /home/share
[root@ora ~]# chmod 777 /home/share
[root@ora ~]# vi /etc/samba/smb.conf

Read more >>

How to configure PXE Server in RHEL 6 ?

Server IP settings.

IP 192.168.0.70
SUBNET 255.255.255.0
nmcontrolled no
onboot yes
DNS1=192.168.0.1

Read more >>

How to restore Spfile from autobackup ?

Login to your database through RMAN prompt.

[oracle@ora ~]#  export ORACLE_SID=orcl

[oracle@ora ~]#  rman target=/

# Shutdown your database if it is open.

Read more >>