Site search

Categories

Archives

Tags

awr report delete syntax demobld demobld.sql determine oracle db size du find large file ftp script function syntax insert syntax kill oracle process linux du listener listener.log nfs mount instructions oracle constraint oracle database oracle database hosting oracle delete oracle demo build oracle demo setup oracle forein key constraint oracle ftp oracle functions oracle insert oracle process Oracle Scripts oracle select oracle subquery oracle update select syntax solaris sql background sql delete sql functions sql info sql insert sqlplus demo setup sql select sql update subquery syntax Technology Webcasts update syntax vnc tutorial vsftp
RSS
XML RSS
What is this?
AddThis Feed Button

Social
Bookmarking




-- FREE --
IT Magazine
Subscriptions

Oracle Magazine Oracle Magazine Contains technology strategy articles, sample code, tips, Oracle and partner news, how-to articles for developers and DBAs

WebSite Magazine WebSite Magazine Practical advice, helpful tools and insights for website owners

Dr Dobb's Journal Dr Dobb's Journal enables coders to write the most efficient programs and help in daily programming quandaries

DM Review DM Review is recognized as the premier business intelligence, analytics and data warehousing publication
Various other Free IT magazine subscriptions
NoAdware Free Trial

NoAdware Remove
harmful
adware,
spyware,
trojans,
dialers
and worms!
- Featured ebook -

Database Normalization
by Alf Pedersen

Database Normalization ebook Understand and master how to normalize a database using methods richly documented with graphical ERD and server diagram examples



NFS Mount article

NFS Mount is incredibly useful in a corporate unix environment.

You can use it to share disk space amongst servers, so that each server ’sees’ the shared filesystem as if it is local.

If your network is fast enough, you can backup your oracle database to a shared filesystem, or just keep
any required software on the shared filesystem so that you do not need to install the software
numerous times on different servers.

In this example, we are sharing a filesystem called orabackup on server share01.world.com, and then
we will mount that on a database server called prod01.world.com.

Steps to take on share01:

Log in as root.

Add prod01’s IP to /etc/exports
If there is more than one entry, make sure there is a space between IP addresses.

[root@share01 ~]# cat /etc/exports

/orabackup -maproot=root 141.146.8.66

Send a hangup to the mountd process to force it to reread the /etc/exports file.

[root@share01 ~]#kill -s HUP `cat /var/run/mountd.pid`

Steps to take on prod01:

Log in as root.

Create /orabackup

[root@prod01 ~]# mkdir /orabackup

Edit /etc/fstab, add line to the bottom:

[root@prod01 ~]#cat /etc/fstab share01.world.com:/orabackup /orabackup nfs rsize=1024,wsize=1024

Mount the filesystem :

[root@prod01 ~]#mount share01.world.com:/orabackup

Once that is completed, you will be able to access it like a local filesystem.

[root@prod01 ~]#df -h

Filesystem                  Size Used Avail Use% Mounted on
/dev/hda9                  7.6G 6.5G 750M 90% /
/dev/hda1                  99M 8.7M 86M 10%  /boot
none                        237M 0 237M 0%        /dev/shm
/dev/hda7                  12G 5.6G 5.7G 50%   /home
/dev/hda6                   20G 17G 1.7G 91%   /u01
/dev/hda3                   25G 20G 4.3G 82%    /u02
/dev/hda5                   20G 8.5G 11G 46%    /u03
/dev/hda2                   25G 20G 3.5G 86%    /u04
share01.world.com:/orabackup 66G 29G 34G 46% /orabackup