- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle process hangs while writing on NFS disk...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2003 08:11 PM
тАО11-15-2003 08:11 PM
Oracle process hangs while writing on NFS disk.
I tried to use NFS disk for oracle backup by rman. But server process hangs after it wrote any file to NFS disk. It doesn't metter what kind of writing I use. It may be rman backup or command "alter database backup controlfile to ..." or utl_file. The result looks similar. File is created but control doesn't return to clients process. However I can read and write any files from shell on this NFS disk and have no problem.
My system is K370 with HP-UX 11.00 and Oracle 8.1.7.4 64 bit.
Does anybody have experience in this problem. I guess some specific options exist for 'right' mounting NFS filesystems for oracle.
Thanks for advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2003 12:47 AM
тАО11-16-2003 12:47 AM
Re: Oracle process hangs while writing on NFS disk.
If its nfs 3, the fileystem itself might not be set of for larrge files.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2003 07:19 AM
тАО11-17-2003 07:19 AM
Re: Oracle process hangs while writing on NFS disk.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2003 07:31 AM
тАО11-17-2003 07:31 AM
Re: Oracle process hangs while writing on NFS disk.
swlist -i
You can browse down to your NFS software and determine the version numbers.
Somewhere in there are the version numbers. nfsstat, if there is no version 3, that explains the issue, since versions below v3 did not support 2 GB and larger filesystems.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2003 07:45 AM
тАО11-19-2003 07:45 AM
Re: Oracle process hangs while writing on NFS disk.
Server rpc:
Connection oriented:
N/A
Connectionless oriented:
calls badcalls nullrecv
0 0 0
badlen xdrcall dupchecks
0 0 0
dupreqs
0
Server nfs:
calls badcalls
0 0
Version 2: (0 calls)
null getattr setattr
0 0% 0 0% 0 0%
root lookup readlink
0 0% 0 0% 0 0%
read wrcache write
0 0% 0 0% 0 0%
create remove rename
0 0% 0 0% 0 0%
link symlink mkdir
0 0% 0 0% 0 0%
rmdir readdir statfs
0 0% 0 0% 0 0%
Version 3: (0 calls)
null getattr setattr
0 0% 0 0% 0 0%
lookup access readlink
0 0% 0 0% 0 0%
read write create
0 0% 0 0% 0 0%
mkdir symlink mknod
0 0% 0 0% 0 0%
remove rmdir rename
0 0% 0 0% 0 0%
link readdir readdir+
0 0% 0 0% 0 0%
fsstat fsinfo pathconf
0 0% 0 0% 0 0%
commit
0 0%
Client rpc:
Connection oriented:
N/A
Connectionless oriented:
calls badcalls retrans
58163 0 0
badxids timeouts waits
0 0 0
newcreds badverfs timers
0 0 5
toobig nomem cantsend
0 0 0
bufulocks
0
Client nfs:
calls badcalls clgets
58163 0 58163
cltoomany
0
Version 2: (0 calls)
null getattr setattr
0 0% 0 0% 0 0%
root lookup readlink
0 0% 0 0% 0 0%
read wrcache write
0 0% 0 0% 0 0%
create remove rename
0 0% 0 0% 0 0%
link symlink mkdir
0 0% 0 0% 0 0%
rmdir readdir statfs
0 0% 0 0% 0 0%
Version 3: (58163 calls)
null getattr setattr
0 0% 160 0% 2 0%
lookup access readlink
19 0% 33 0% 0 0%
read write create
0 0% 57664 99% 1 0%
mkdir symlink mknod
1 0% 0 0% 0 0%
remove rmdir rename
1 0% 0 0% 0 0%
link readdir readdir+
0 0% 0 0% 9 0%
fsstat fsinfo pathconf
68 0% 1 0% 1 0%
commit
203 0%
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2004 05:10 AM
тАО03-17-2004 05:10 AM
Re: Oracle process hangs while writing on NFS disk.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2004 12:04 PM
тАО03-17-2004 12:04 PM
Re: Oracle process hangs while writing on NFS disk.
I would open up a new issue for this, so you have some control over it, but I will bite. I wouldn't use NFS for this, however, have you tried querying the v$session_wait for the sid that you are using and see what it is waiting on.
Looking on metalink, one possible try would be using the "nolock" functionality.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2004 04:02 PM
тАО03-17-2004 04:02 PM
Re: Oracle process hangs while writing on NFS disk.
http://otn.oracle.com/deploy/availability/pdf/oscp_nfs_hi_tests.pdf
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2004 06:03 PM
тАО03-17-2004 06:03 PM
Re: Oracle process hangs while writing on NFS disk.
That should give valuable info.
Also check your syslog.log at /var/adm/syslog.
Revert on this/.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2004 10:40 PM
тАО03-17-2004 10:40 PM
Re: Oracle process hangs while writing on NFS disk.
Which version is used you can see if you use the command "nfsstat -m" on your nfs-client system.
Use hard nfs-mounts for your copy. Then you can be sure that all your backup data is copied to you backup-system.
I recommend you the Patch PHNE_29302 for your System, too.
Roland